Home Button  Buy Button 

Topic:   Importing Multi Level Assemblies v5

By: StephenPosted on: Sep 18 2019 at 07:28:16 AM
For Version 5, what is the file format and how does it work? I need to import multi level assemblies and I am not having much success.
Is there a document somewhere?

By: StephenPosted on: Sep 18 2019 at 08:47:55 AM
What I just learned:
********************

The Level column needs to be a number. (It can ignore dots)

At Level 1 you can have a sub-assembly1 (PARENT) and directly below that at level 2 are the contained parts (CHILDREN). The fact that they're at level 2 directly below sub-assembly1 shows that those level 2 items are contained 'inside' it (CHILDERN of).

Then below the parts you can add sub-assembly2 at level 1 and then, directly below it put the parts contained in it (CHILDREN) at level 2.

I am told that this layout is a common layout.

If that is how the .CSV file is structured, then MiniMRP should have no problem importing it.

BONUS - You can export to Excel an Indented BOM, modify it there, save as .csv, and minimrp will re-import.

By: SupportPosted on: Sep 18 2019 at 08:55:20 AM
This page in the user guide

Indented BOM

shows how MiniMRP displays a multilevel BOM. If the BOM was exported to CSV then the CSV would have the same columns. That is also the format that MiniMRP can Import. So any assembies, parts lists, multi-level BOMs etc that you need to import then that is the format of the CSV file. The level is a number, Level 1, Level 2, Level 3 etc.

By: StephenPosted on: Sep 18 2019 at 09:11:50 AM
Works perfectly now that I got the file sorted out with Support's help!

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Importing Multi Level Assemblies v5


Enter the numbers.

Your name here is optional