Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Are there special rules for importing a csv of BOMs?

By
Gilles Lehoux
on 3/6/14, 3:18 PM 861 views

I exported a csv of BOMs using only blue fields and then I get an error re-importing the unmodified file. This procedure usually works elsewhere in OpenERP, outside of BOMs. Is there something special about BOMs?

  • 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 3/6/14, 3:18 PM
Seen: 861 times
Last updated: 3/16/15, 8:10 AM