Data Management Capabilities > Using Excel to Export and Import Product Data > About Importing Product Data from Excel > About Importing Redline Product Data from Excel > Considerations for Importing Redline Product Data > Considerations for Importing Redline Replacements > File Format for Importing Redline Replacements
File Format for Importing Redline Replacements
The following table describes the format of data in a redline 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)
Includes Add or Delete.
Type
Yes
No
Use wt.part.WTPartSubstituteLink
Replacement Type
Yes
Yes
Use the value s for substitute.
* 
If the value changes on reimport, ensure all related columns have applicable data.
Replacement Part Number
Yes
No
The replacement part number.
Replacement Part Organization ID
Yes
No
If not specified, the owning organization is set to the organization associated with the change notice. It determines the organization to which the part is associated.
Replacement Part Container
No
No
If not specified, the default value of the container associated with the change notice from where 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.
* 
The parent part for a substitute link must have an open redline associated with the change.
Parent Part Revision
Yes
No
Specifies the redline revision of the parent part being updated.
* 
When the column is omitted or a value is not defined for it, the redline version is used as a value for a part master that exists with an open redline on the change.
Parent Part View
No
No
Specifies the view of the parent part being updated.
Enter Design or Manufacturing.
If you have created a customized view using the View Administrator, it can also be listed as the value.
* 
When the column is omitted or a value is not defined for it, the value is empty for a part master that exists with an open redline on the change.
Parent Part OrganizationID
No
No
The owning organization for the change notice. The default value is the organization from the owning container. If not available, the value is the organization of the change notice.
* 
Organization ID is required if you want to import parts that do not belong to the target organization.
Child Part Number
Yes
No
The child part number.
* 
The child part for a substitute link may or may not have an open redline associated with the change.
Child Part Revision
Yes
No
Specifies the revision of the child part being updated.
* 
When the column is omitted or a value is not defined for it, the redline version is used as a value for a part master that exists with an open redline on the change.
Child Part View
No
No
Specifies the view of the child part being updated.
Enter Design or Manufacturing.
If you have created a customized view using the View Administrator, it can also be listed as the value.
* 
When the column is omitted or a value is not defined for it, the value is empty for a part master that exists with an open redline on the change.
Child Part Organization ID
No
No
The owning organization for the change notice. The default value is the organization from the owning container. If not available, the value is the organization of the change notice.
* 
Organization ID is required if you want to import parts that do not belong to the target organization.
Substitute Quantity
No
Yes
Defines the number of substitute 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 a replacement part within a manufacturing bill of materials. Also known as position numbers that are used with Enterprise Resource Planning systems.
Component Id
No
No (for an existing usage link)
An alphanumeric key representing an existing usage link. Each of the usage links specified has a unique alphanumeric key.
The value is empty for a new usage link.
* 
Use the Component Id column to accurately match substitute parts when importing replacement spreadsheets. For alternates, include the column if needed but it gets ignored if left blank.
IBAs (soft attributes supported by the spreadsheet)
No
Yes
Attribute constraints and relationship constraints.
Was this helpful?