You can use a wizard to create a CSV mapping file to import an external part list.
Open the Preferences dialog box.
Click 3DEXPERIENCEBOM Management in the contents pane.
Click External Partlist.
Click Start Wizard.
The wizard displays the Template Selection dialog box.
From the list, select the template to use as a master definition to define the rows that display in the BOM Editor.
Click Next.
The wizard displays the Source Selection dialog box.
Select one of the initial mapping files:
Option
Description
An empty definition
Start with an empty CSV file. You then need to enter all column definitions.
Header of CSV File
Click Browse to select an existing CSV file. The selected file becomes a reference to the master definition. The file does not need to contain any data, but it does need column definitions.
Existing importer/exporter
From the list, select an existing mapping template.
Click Next.
The wizard displays the CSV Mapping Configuration dialog box. If you selected either Header of CSV Fileor Existing importer/exporter, the columns defined for the selected option are loaded into the CSV column name column in the dialog box.
The first column contains BOM attributes determined by the template you selected in Step 5. The second column contains a list of the columns from the CSV file.
For each attribute, select the CSV column that maps to that attribute. If you started with an empty definition, enter the column name.
Each list includes <auto> and <ignore> options. Select <auto> to map that attribute to an empty field, and select <ignore> to ignore that attribute.
For attributes set to <auto>, the BOM Editor tries to match the attribute to a column in the CSV file. For example, if the CSV file contains a column titled Name, the BOM Editor matches that column to the Name attribute.
Click Next.
The wizard displays the Importer Definition dialog box.
Provide a name for the mapping file. You can use an existing name from the list, but the new name overwrites the previous mapping name.