PDXpert PLM Software
Application Notes
Importing a CAD bill of materials into PDXpert 7.x
This application note applies only to PDXpert 7.4 and earlier.
See Importing a CAD BOM for information about releases published after November 2012.
PDXpert product lifecycle management software uses XML/XSLT to provide a very flexible means for importing bill of materials (BOM) files formatted as XML, CSV, Microsoft® Excel®, or other structured text. Most CAD applications can export a bill of materials directly, usually in a convenient plain text format called "comma-separated values" (CSV). We'll describe the general approach to importing a CAD bill of materials file from a standard CSV file into a PDXpert assembly's bill of materials (BOM) list, called the structure.
A BOM import can be performed only within the structure's Markup list, and only before the pending assembly revision is approved and released.
Each CAD application exports its data (typically find or row ID, part number, quantity, units, perhaps reference designators or notes) in its own preferred file format (such as Excel, CSV, tab-delimited, XML). The selected importData Transformations member tells PDXpert how to interpret the import file format.
When you have your structure file ready to be imported, create a new part record or revision, or open an existing pending revision. Select the part's Structure tab'sMarkup list.
Within the Markup area, open the context menu, select the Import Markup from File command, and select the appropriate import Data Transformations template. The Import Markup from File dialog opens.
Browse to your import file, and then click the Open button. Your file will be imported into the Markup list.
If you discover an error after you accept the import, you can modify the records that you've imported, or replace all of your changes on the markup by importing a new file. If you import a new file, the current structure markup is first cleared; all of your previous manual and imported changes will be discarded.
The current PDXpert software release includes a more flexible standardized import format that replaces this PDXpert 7.x import format.
Required
Data type: integer ≥ 0
Empty cell: Invalid import file
A set of Find values is typically sequentially-assigned, although they are not required to be consecutive.
Optional
Data type: string, length ≤ 50 characters
Empty cell: Organization Abbreviation is used for match
This column may contain an Organizations member Name value. If the value is empty, then the Owner Abbreviation column will be used to identify match; if Owner Abbreviation is also empty, then the home organization collection member will be assigned. If neither is empty, but no match is found, then a new Organizations collection member will be created.
Optional
Data type: string, length ≤ 10 characters
Empty cell: Organization Name is used for match
This column may contain an Organizations member Display name value. If the value is empty, then the Owner Name column will be used to identify match; if Owner Name is also empty, then the home organization collection member will be assigned. If neither is empty, but no match is found, then a newOrganizations collection member will be created.
Optional
Data type: string of value "Part" or "Document"
Empty cell: derived from Type, or default to "Part"
If not specified, the Class is derived from a match of the Type Name. If the Type cannot be matched, then theClass is assigned to be a part.
Optional
Data type: string, length ≤ 50 characters
Empty cell: Type Abbreviation is used for match
This column may contain a Part Types member or Document Types memberName value. If the value is empty, then theType Abbreviation column will be used to identify match; if Type Abbreviation is also empty, then the default Part Types member or Document Types collection member will be assigned. If neither is empty, but no match is found, then a new collection member will be created according to the Class.
Optional
Data type: string, length ≤ 10 characters
Empty cell: Type Name is used for match
This column may contain a Part Types member or Document Types memberAbbreviation value. If the value is empty, then the Type Name column will be used to identify match; if Type Name is also empty, then the default member of the Part Types or Document Types collection (as determined by the Class) will be assigned. If neither is empty, but no match is found, then a new collection member will be created according to the Class.
The imported item's Class and Type cannot be changed after it's been created. Before you begin importing new items always ensure that the default Type will be appropriate for unmatched items or that the Type is specified in the file.
Required
Data type: string, 1 ≤ length ≤ 50 characters
Empty cell: Invalid import file
The Number is used, along with the specified or default Class,Owner and Type, to match an existing document or part. If the item cannot be matched, then this value is imported as the new part or document number.
Optional
Data type: string, length ≤ 50 characters
Empty cell: derived from Class
This may contain a revision value. If the value is empty, then the default revision will be assigned according to the specified or derived Class value.
Optional
Data type: string, length ≤ 200 characters
Empty cell: ignored
If item has been matched to an existing item, this value is ignored. If the item cannot be matched, then this value is imported as the new Part name orDocument title value.
Optional
Data type: real ≥ 0
Empty cell: imported as 1
Specifies the quantity of items used to create or assemble the parent assembly. Set as blank (empty) if itemClass is Document.
Optional
Data type: string, length ≤ 4 characters
Empty cell: assigned the default Unit of Measure
The Unit column, if empty, will be assigned theDefault unit of measure value from the specified or derived Part Type.
Optional
Data type: string, length ≤ 2000 characters
Empty cell: ignored
Any characters may be imported into PDXpert'sRefDes structure attribute. The Reference Designators value is ignored if the row does not contain a part.
Optional
Data type: string, length ≤ 2000 characters
Empty cell: ignored
Any characters may be imported into PDXpert'sNotes structure attribute.
This application note was relevant to the PDXpert software release that was current at time of publication. Product changes since that time may affect its utility. We'd be happy to assist you in assessing the applicability of this note to your situation.