PxC to Customer Item Mapping

cxE supports the use and storage of customer-specific item numbers. This allows you to map your own item numbers to PxC item numbers and use them consistently throughout the engineering process.

The mappings between the original PxC item numbers and the customer-specific item numbers are managed on the Options > Customer item number list page in the backstage area. You can either enter a customer-specific item number directly for each available PxC item in the item number table (see below) or create the mapping list in Microsoft Excel and import it into cxE.

A maximum of five mapping lists can be maintained in parallel. Each mapping list can be assigned to a different project template on the Options > Project settings page, enabling the use of different customer numbering schemes for different customers or projects.

Assignment of a mapping list in the Options > Project settings section:

Working with mapping lists

The tabs at the top of the Customer item number list page represent the available mapping lists. Up to five mapping lists can be defined. Use the Search field to find items within the currently selected mapping list.

To... Do the following...

Create a mapping list

Click the plus icon next on the right of the existing tabs to create a new mapping list, or select an existing list and click the copy button on the top right.

Edit the default name if required. The name of the mapping list must be unique.

Click the Save button at the bottom right of the page.

Delete a mapping list Select the mapping list (tab), and then click the Delete button at the bottom left of the page.

Edit a mapping list manually

Locate the required PxC item in the table or use the search field.

Enter the corresponding customer item number in the Customer item number column.

Repeat the process for all required items.

Click Save.

Import a mapping list from Excel

Prepare an Excel file containing the item number mappings (see below for the format of the Excel file).

Select the mapping list (tab) into which you want to import the data.

Click the Import button on the top right.

Select the Excel file.

Click Save.

Export a mapping list to Excel Select the mapping list (tab) you want to export and click the Export button on the top right.

To...	Do the following...
Create a mapping list	Click the plus icon next on the right of the existing tabs to create a new mapping list, or select an existing list and click the copy button on the top right. Edit the default name if required. The name of the mapping list must be unique. Click the Save button at the bottom right of the page.
Delete a mapping list	Select the mapping list (tab), and then click the Delete button at the bottom left of the page.
Edit a mapping list manually	Locate the required PxC item in the table or use the search field. Enter the corresponding customer item number in the Customer item number column. Repeat the process for all required items. Click Save.
Import a mapping list from Excel	Prepare an Excel file containing the item number mappings (see below for the format of the Excel file). Select the mapping list (tab) into which you want to import the data. Click the Import button on the top right. Select the Excel file. Click Save.
Export a mapping list to Excel	Select the mapping list (tab) you want to export and click the Export button on the top right.

Excel import/export format

The Excel list contains two columns, "article" and "customerItemName". The first column contains the original PxC item number (article number), while the second contains the corresponding customer-specific item number.

Example:

Notes:

PxC item numbers (article numbers) and customer item numbers must be unique.
PxC item numbers that are not included in the Excel file remain unmapped.
Existing mappings in the selected mapping list will be overwritten during import.