File Format for Importing Replacements
The following table describes the format of data in a replacements import spreadsheet. It defines the column header, whether the column is required, and the description of the data that can be entered for each column.
 |
In a spreadsheet, all discrete values (a value that must be one of few fixed values) must be entered as an internal value, not the display value. For example, for the Default Unit attribute, use as_needed (internal), not As Needed (display).
|
|
Column Name
|
Required
|
Editable on reimport
|
Description
|
||
|---|---|---|---|---|---|
|
Action
|
Yes
|
Yes (for deleting)
|
Actions include Add or Delete.
|
||
|
Type
|
Yes
|
No
|
Use one of the following:
• wt.part.WTPartSubstituteLink
• wt.part.WTPartAlternateLink
|
||
|
Replacement Type
|
Yes
|
Yes
|
• substitute: s
• alternate: a
|
||
|
Replacement Part Number
|
Yes
|
No
|
The replacement part number.
|
||
|
Replacement Part Container
|
No
|
No
|
If not specified, the default value of the container from which the import tool was launched.
The following example shows the full path to the container:
/wt.inf.container.OrgContainer=PTC/wt.pdmlink.PDMLinkProduct=Test_Product
where PTC is the name of the organization and the Test_Product is the name of the product.
|
||
|
Parent Part Number
|
Yes
|
No
|
The parent part number.
|
||
|
Parent Part Revision
|
Yes
|
No
|
Specifies which revision of the parent part is getting updated.
|
||
|
Parent Part View
|
No
|
No
|
Specifies which view of the parent part is getting updated. Enter Design or Manufacturing. If you have created a customized view using the View Administrator, it can also be listed as the value.
|
||
|
Parent Part Organization ID
|
No
|
No
|
The owning organization for the parent part. The default value is the organization from the owning container.
|
||
|
Child Part Number
|
Yes
|
No
|
The child part number.
|
||
|
Child Part Revision
|
Yes
|
No
|
Specifies which revision of the child part is getting updated.
|
||
|
Child Part View
|
No
|
No
|
Specifies which view of the child part is getting updated. Enter Design or Manufacturing. If you have created a customized view using the View Administrator, it can also be listed as the value.
|
||
|
Child Part Organization ID
|
No
|
No
|
The owning organization for the child part. The default value is the organization from the owning container.
|
||
|
Substitute Quantity
|
No
|
Yes
|
Defines the number of parts in the assembly. The default value is 1.
|
||
|
Substitute Unit of Measure
|
No
|
Yes
|
Quantity unit for the substitute parts in the assembly. The default value is ea. Other possible values are as follows:
• as needed: as_needed
• kilograms: kg
• meters: m
• liters: l
• square meters: sq_m
• cubic meters: cu_m
|
||
|
Substitute Reference Designators
|
No
|
Yes (but it must be unique)
|
Reference designators specified using shorthand format (for example: R1, R3, or R1-R10).
Use the following syntax rules for specifying reference designators:
• A reference designator consists of an alphanumeric string prefix, followed by a numeric integer suffix. For example: R57, PS1, A66A2.
• The first and last characters in the prefix must be alpha characters. For example: R1, RAX3, R4X5.
• Use a comma to separate sequences of reference designators. For example, R1, R2, R7.
• Reference designators can be specified as a sequence and as a range. For example: R1-R7, R10, R12.
|
||
|
Line Number
|
No
|
Yes
|
Identifies the line number of the replacement part within a manufacturing bill of materials. Also known as position numbers that are used with enterprise resource planning (ERP) systems.
|
||
|
Two Way
|
No
|
Yes
|
If no value is entered, a value of ‘no’ is assumed.
|
||
|
Component ID
|
No
|
No (for an existing usage link)
|
An internal alphanumeric key, typically generated by CAD, uniquely identifies a child part within a parent structure. This value must be left blank for a new part usage. Optionally, it can be used to reference an existing part usage.
|
