Using the BOM Bulk Import Utility
A bom_seq value must be specified for each incoming material. If an incoming material does not have a bom_seq value, it is not imported. Existing current materials with a bom_seq that is not on the incoming XML are deleted. Existing current materials with a bom_seq that is on the XML are updated. If an incoming material has a bom_seq not in the current materials, that material is added.
For existing routings, operations are not deleted.
For existing BOMs, materials not in the incoming XML are deleted.
Incoming reference designators are matched to materials using the bom_seq value.
Actions Performed
When you click , the utility processes each XML document in the Bulk Import Logical Folder specified on the BOM Bulk Import Parameters form. For each XML document, this utility performs these actions:
- Reads the document and parses its contents. If a Bulk Archive Logical Folder is specified on the BOM Bulk Import Parameters form, it moves the XML document into this logical folder.
- Loads the data from the XML document into current routing/BOM tables for the top-level item on the XML document.
- Uses the tag definitions as defined on the BOM Bulk Import Parameters form.
- Uses the mapping defined on the BOM Bulk Import Mappings form to map the XML data to the application database tables.
- Uses the conversions defined in the BOM Bulk Import Conversion form to convert data values.
- For top-level items with the Save Current Revision Upon Import check box selected on the Items form, and for an inbound BOM that has a new revision, it makes a copy of the item's current routing/BOM.
- Updates the item's BOM Last Import Date to the current date on the Items form.
Errors
If an error occurs, the utility performs these actions:
- Writes the error to the BOM Bulk Import Errors form for the XML file.
- Sends an email to users associated with the publication named BOMBulkImportError on the Publication Subscribers form.
- Does not process the XML file.