BOM upload Import

paulv · January 11, 2023, 7:51pm

Hi,

I have an issue that keeps cropping up and I want to understand the best practice. We import BOM revision exports every time an Assembly revision occurs but the component revisions sometimes updates and we need to re-import a bom to reflect the correct component revisions. The trouble with this is that if the revision assembly REV already exists and has a BOM and new imported components are the same components but different revisions (or unset revisions), then the old and new revisions will both show up on the BOM after import, causing duplicate entries. The selections on the BOM import API lead me to believe that the data can be removed/updated correctly prior to import but those selections do not seem to affect this particular issue. Can you help me untangle this?

Thanks,
Paul

cetecerp15 · January 13, 2023, 2:18pm

Paul,

Just to verify the steps you are taking when importing: Are you going to Admin > APIs & More > Data Import?

Can you walk me through the steps you are taking/what checkboxes you’re checking, etc.?

Thanks,

The Cetec Team

paulv · January 13, 2023, 3:33pm

Yes, Admin > APIs & More > Data Import, Select BOM from the dropdown, then I select a .csv file that gets autogenerated by my PDM system upon a new revision release. I usually will also select the delete related data checkbox since that sounds like what I want it to do. My .csv file headers are top_level_part_number, top_level_revision, component_part_number, component_revision, component_line_number, and quantity_per_top.