File Format for Importing Redline Parts
The following table describes the format of data in a redline parts 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
|
||
|---|---|---|---|---|---|
|
Type
|
Yes
|
No (class type cannot be changed for existing parts.)
|
Class type, logical identifier, or an external type ID. For example, see the following values:
• OEM parts: WCTYPE|wt.part.WTPart
• manufacturer parts: WCTYPE|com.ptc.windchill.suma.part.ManufacturerPart
• vendor parts: WCTYPE|com.ptc.windchill.suma.part.VendorPart
|
||
|
Number
|
Yes
|
No
|
The part number.
|
||
|
Name
|
Yes
|
Yes
|
The part name.
|
||
|
Assembly Mode
|
No
|
Yes
|
Use the values separable, inseparable, or component.
|
||
|
Organization ID
|
No (for OEM)
Yes (for supplier)
|
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.
|
||
|
Revision
|
No
|
Yes
|
Specifies which redline revision of the part is being updated. If not specified, the version of the open redline on the change notice will be used.
|
||
|
View
|
Yes
|
No
|
The view of the redline revision of the part. If not specified, the view of the open redline on the change notice will be used.
|
||
|
Source
|
No
|
Yes
|
Use the following internal values:
• make
• buy
• singlesource
|
||
|
Additional soft attributes
|
No
|
Yes
|
Any soft attributes required for the redline part. For more information on additional attributes, see Creating a New Attribute.
Currently, only the display name in row 5 and the internal name in row 6 are needed.
|