This question has been flagged
2967 Views

I exported a csv of BOMs using only blue fields and then I get an error re-importing the unmodified file.

  • I created a database with the demo data. I installed the MRP app. I allowed importing of csv.
  • I went to Manufacturing > Bill of Materials, and selected all the BOMs.
  • I Clicked on the More menu and then Export.
  • I chose "Import compatible", "csv".
  • I went through the entire list of variables, including sub-menus (ex BOM lines), and "added" all blue variables.
  • I exported and saved the csv file.
  • I closed the export window.
  • I clicked on Import.
  • I selected the csv file I just saved.
  • I clicked on Validate
  • I got the following errors:

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

image description

image description

Avatar
Discard