Sources import

This file defines how PDXpert assigns approved sources to their part records.

Each row in the import file represents a pending home part and a single approved partner source component, which can be pending or released. The row also specifies values such as the preference rank on the parent.

This import file is used for creating parent-child relationships only on a pending parent part. Do not reference any parent part that has a released or canceled iteration.

Refer to the help topic How to report, import & export > Import & update items > Rules for relational imports to learn how to interpret these column definitions.

Do not assign the same child part on more than one row on the parent part's Sources list.

The External Data Importer tool can generate a CSV template file, which can be used to import your data. Select List: Sources from the dropdown list, click the Export button, and save the file to a convenient location.

Column name Data type Assignment if empty Description
Class string Part Part Must be assigned as Part or remain empty.
Owner Organizations home organization Identifies the organization that is primarily responsible for the parent part's specification and which issues the item Number. If not specified, then the home organization is assumed.
Type Part Types default member If not specified, then the parent part is matched against the default Part Types collection member.
Number string row is skipped REQUIRED: Part number. If the value is empty, the row is not imported.
ChildClass string Part Part Must be assigned as Part or remain empty.
ChildOwner Organizations home organization Identifies the organization that is primarily responsible for the child part's specification and which issues the child part Number. If not specified, then the home organization is assumed.
ChildType Part Types default member If not specified, then the child part is matched against the default Part Types collection member.
ChildNumber string row is skipped REQUIRED: Part number. If the value is empty, the row is not imported.
Rank integer ≥ 1  1 This value is assigned to the Rank value, and indicates the child part's standing relative to other approved sources. Duplicate Rank values are permitted among several child parts.
Notes string: length ≤ 32000 characters no value assigned This value is assigned to the source's Notes area.

1211

Learn More
Help Guide Contents [PDF]