Topic: CSV Assembly/BOM file with hundreds of BOM's
Posted on: May 7 2021 at 01:47:27 PM
I am trying to import a single CSV file with hundreds of BOM's in it using Assembly Import without any luck. Is this possible or do the BOM's have to be imported one at a time? If it is possible is there a particular delimiter needed to designate the End of one BOM and start of the next BOM in the file? The BOM's have no sub-assemblies. I have already imported the components with no issues. I am using the trial software and like the looks of MiniMrp but just have to get past this hurdle. Thank You!
Posted on: May 8 2021 at 08:33:30 AM
Yes. MiniMRP can import multiple BOMs in a single CSV on the assumption that they're all Sub Assemblies of a higher level parent that already exists.
So, in theory you could create one dummy top level assembly. Then go to the list of assemblies. Right click that new dummy assembly and select the option to:-
"Read PartsList/BOM from CSV".
There is no need for an 'End of BOM' delimiter in the CSV. The CSV needs to be an indented BOM and it's the Level Column that indicates how the parts sit inside the assemblies.
Does your CSV have a 'Level' column?
See this picture to see what I mean by the Level Column. The level/indents indicate which parts are contained inside which assemblies/sub assemblies. This is pretty much an industry wide standard for indented multilevel BOMs and is the layout it would need for importing from CSV.
If you want you can send us a copy, or an excerpt, of your CSV and we'll come back to you with suggestions on how best to import it.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.