credativ team mailing list archive

["Olivier Dony \(OpenERP\)" <909494@xxxxxxxxxxxxxxxxxx>]

Hello Kyle,

It might be an issue with the matching of product IDs at import, but it is quite difficult to be sure without reproducing your situation exactly, especially if it does not seem to happen all the time.
For all bug reports, and particularly those that seem to depend on specific states or data in the system, it is important to provide as much information as possible in the description.

As you can imagine, the CSV import system is doing the same thing from 100 or 1000 records, so there is no reason to think the size of the CSV would matter in the matching of products. Perhaps only one the records triggers the problem, and it is not among the first 100 records? Have you tried bisecting the CSV file to see if that could be the case? (i.e. you split the CSV file in 2 and import the 2 parts separately, then split them again in 2, and so on until you find the smallest subset that triggers the problem?)
Also note that doing it manually uses different matching rules, for example you're not entering the products based on the database IDs.

In order to confirm and proceed further, could you provide a little bit more details, such as:
 - what version of OpenERP you are reporting this for? 6.0 or trunk/6.1, and if possible, which revision number?
 - what is the layout of the CSV file you are importing: i.e. column headers, sample values
 - if you are doing any manual selection of columns when you import the CSV file (if some are not automatically recognized)
 - Ideally, we'd love to see a scenario with a complete CSV file that triggers the problem, starting with a newly created demo database. If the issue happens with your customer's data, it should happen with demo data too.

Well, any further info along those lines would be helpful in order to
reproduce, analyze and fix the issue.

Thanks!

** Changed in: openobject-addons
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of OpenERP
Framework Experts, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/909494

Title:
  Import inventory via csv product id matching fails

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  In a larger database with many products I try and import for a
  customer a csv file with a periodical inventory. The file was
  generated directly from the database. When I import the data I key off
  of the database ID directly. I am 100% sure the data is accuarate.

  For some reason it fails to find the product, citing product does not
  exist. If I manually go into periodical inventory and enter the data
  it works just fine. This is very frustrating for anyone that relies on
  this functionality to work. Please confirm

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/909494/+subscriptions