BOM upload automation
Newbie here. Please move the post if it’s not under the correct category.
My typical agile use is for uploading boms and looking up part numbers.
The upload process is repetitive. Is there a way of automating this?
A command line interface maybe?
Htsh, Have you tried simply using the Import feature under the Tools menu. You can create an XLS file with some minimum required fields and create both new items and their BOMs. Exactly how much information you provide in the Excel sheet may depend on what your organization requires and if the attributes are change controlled or not. Are you creating new items in addition to adding components to their BOMs or just adding BOMs to existing items? If both, it may go smoother if done in 2 steps… do one import just to create the items, and then another to add components to their BOMs. I was able to do both at the same time. I did get one error, but in the end it still did what I needed. Here’s a sample of what your spreadsheet might need to contain. Your requires will obviously vary some, such as subclass names and Master Item Type (MIT). It doesn’t really matter what you name the columns as long as you map the values properly in the import.
| ITEM_NUMBER | SUBCLASS | DESCRIPTION | MIT | COMPONENT | FIND_NUM | QTY |
| TESTASSY1 | Design Part | Test Assembly One | Phantom Assembly-PHASSY | COMPPART1 | 1 | 2 |
| COMPPART1 | Design Part | Test Component One | Make Part-MP |
Hope this helps,
Steve