← Back to team overview

openerp-india team mailing list archive

[Bug 1289050] [NEW] BOM import of import-compatible csv fails

 

Public bug reported:

Export a csv of BOMs using only blue fields and then re-import the
unmodified file. This fails.

OpenERP v7, Ubuntu 12.04

1) Create a database with the demo data. Install the MRP app. Allow importing of csv.
2) Manufacturing > Bill of Materials, select all the BOMs.
3) Click on the More menu and then Export.
4) Choose "Import compatible", "csv".
5) Go through the entire list of variables, including sub-menus (ex BOM lines), and "add" all blue variables.
6) Export and save the csv file.
7) Close the export window.
8) Click on Import.
9) Select the csv file that was just saved.
10) Click on Validate

The following errors are generated:
No matching record found for name 'Bill of Materia...' in field 'Messages' at row 2 Value '15" LCD Monitor ,Computer Case-1,RAM DDR 512MB,Mouse, Laser,USB Keyboard, QWERTY' not found in selection field 'BoM Lines' at row 2 Value '17" LCD Monitor,Computer Case-2,Mouse, Laser,USB Keyboard, QWERTY,RAM DDR 512MB' not found in selection field 'BoM Lines' at row 3 Value '15" LCD Monitor ,Computer Case-1,Mouse, Laser,USB Keyboard, QWERTY,RAM DDR2 1GB' not found in selection field 'BoM Lines' at row 4 Value 'Windows 7 Professional,USB Keyboard, QWERTY,Mouse, Wireless' not found in selection field 'BoM Lines' at row 5 Here are the possible values: Value 'HDD 500GB' not found in selection field 'BoM Lines' at row 6 Value '320GB HDD' not found in selection field 'BoM Lines' at row 7 Value 'Processesor AMD 8-Core,Motherboard I9P57,HDD 320GB' not found in selection field 'BoM Lines' at row 8 Value 'Processor Core i5 2.70 Ghz,Motherboard A20Z7,HDD 500GB,Graphics Card' not found in selection field 'BoM Lines' at row 9 Value 'Windows 7 Professional,USB Keyboard, AZERTY,Mouse, Laser' not found in selection field 'BoM Lines' at row 11

** Affects: openobject-addons
     Importance: Undecided
         Status: New

** Attachment added: "List of variables."
   https://bugs.launchpad.net/bugs/1289050/+attachment/4010585/+files/BomAllBlues1.jpg

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

Title:
  BOM import of import-compatible csv fails

Status in OpenERP Addons (modules):
  New

Bug description:
  Export a csv of BOMs using only blue fields and then re-import the
  unmodified file. This fails.

  OpenERP v7, Ubuntu 12.04

  1) Create a database with the demo data. Install the MRP app. Allow importing of csv.
  2) Manufacturing > Bill of Materials, select all the BOMs.
  3) Click on the More menu and then Export.
  4) Choose "Import compatible", "csv".
  5) Go through the entire list of variables, including sub-menus (ex BOM lines), and "add" all blue variables.
  6) Export and save the csv file.
  7) Close the export window.
  8) Click on Import.
  9) Select the csv file that was just saved.
  10) Click on Validate

  The following errors are generated:
  No matching record found for name 'Bill of Materia...' in field 'Messages' at row 2 Value '15" LCD Monitor ,Computer Case-1,RAM DDR 512MB,Mouse, Laser,USB Keyboard, QWERTY' not found in selection field 'BoM Lines' at row 2 Value '17" LCD Monitor,Computer Case-2,Mouse, Laser,USB Keyboard, QWERTY,RAM DDR 512MB' not found in selection field 'BoM Lines' at row 3 Value '15" LCD Monitor ,Computer Case-1,Mouse, Laser,USB Keyboard, QWERTY,RAM DDR2 1GB' not found in selection field 'BoM Lines' at row 4 Value 'Windows 7 Professional,USB Keyboard, QWERTY,Mouse, Wireless' not found in selection field 'BoM Lines' at row 5 Here are the possible values: Value 'HDD 500GB' not found in selection field 'BoM Lines' at row 6 Value '320GB HDD' not found in selection field 'BoM Lines' at row 7 Value 'Processesor AMD 8-Core,Motherboard I9P57,HDD 320GB' not found in selection field 'BoM Lines' at row 8 Value 'Processor Core i5 2.70 Ghz,Motherboard A20Z7,HDD 500GB,Graphics Card' not found in selection field 'BoM Lines' at row 9 Value 'Windows 7 Professional,USB Keyboard, AZERTY,Mouse, Laser' not found in selection field 'BoM Lines' at row 11

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


Follow ups

References