Using the BOM Bulk Import Utility

The BOM Bulk Import utility processes all XML files within the BOM Bulk Import logical folder. Each XML document contains the current BOM for a single item, so the BOM contained in the XML document is loaded into the current routing/BOM for the top-level item in the BOM XML.

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 Process, 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.
Related topics
BOM Bulk Import Forms Overview