Data Management Capabilities > Using Excel to Export and Import Data > About Importing Data from Excel > Considerations for Importing All Data > Considerations for Importing Parts > File Format for Importing Parts
File Format for Importing Parts
The following table describes the format of data in a part 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 Header
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: wt.part.WTPart
• manufacturer parts: com.ptc.windchill.suma.part.ManufacturerPart
• vendor parts: com.ptc.windchill.suma.part.VendorPart
* 
The class types can be defined in the logical identifiers file with an alias. For example, wt.part.WTPART=part. Part, Manufacturer Part, and Vendor part are included in the logical id file.
Name
Yes
Yes
Part name
End Item
No
Yes
Indicates whether the part is an end item
Trace Code
No
Yes
An attribute that defines how a particular copy of a part is identified after it is built. Use the following values:
• untraced: 0
• serial number: S
• lot number: L
• lot/serial number: X
Generic Type
No
Yes
An attribute that identifies the part is used as a placeholder in a product structure to be replaced by a similar, interchangeable part. Use the following values:
• standard
• configurable
• variant
Number
No
If no value is entered, a number is auto-generated.
No
A default value may be auto-generated based on the OIR for the destination location of the part as well as the part type; otherwise, you can enter a number.
* 
If you do not enter a number, a number is auto-generated for new parts.
Assembly Mode
No
Yes
Enter separable, inseparable, or component.
Location
No
No
The folder path to a target container. Default value is the root folder of the container where the action was initiated. Use the following format: /Default/<Folder Name>/
Organization ID
No (for OEM)
Yes (for supplier)
No
If not specified, the owning organization is set to the organization associated with the current container. It determines the organization to which the part is associated.
Revision
No
Yes
If a revision is not specified, the default starting revision is used. For example, for a new part, the revision is A.
* 
A revision other than A may be specified for the initial part creation.
View
Yes
No
The view to which this version is assigned. The default is not to assign a view.
Predecessor View
Yes, when creating new view version
No
When creating a new view version, enter the view of the part from which you are creating the new view version. For more information, see Considerations for Importing Parts.
Predecessor Revision
Yes, when creating new view version
No
When creating a new view version, enter the revision of the part from which you are creating the new view version. For more information, see Considerations for Importing Parts.
State
No
Yes
Life cycle state of the part
Source
No
Yes
Use the following internal values:
• make
• buy
• singlesource
* 
Internal values (not display strings) must be used in the spreadsheet.
Default Unit
No
Yes
Use the following values:
• each: ea
• as needed: as_needed
• kilograms: kg
• meters: m
• liters: l
• square meters: sq_m
• cubic meters: cu_m
* 
Your administrator may have added units other than those listed here. If so, use the internal name, rather than the display name.
Job Authorization Number
No
Yes
Attribute designating the project authorization number used in the Windchill Aerospace & Defense module.
Phase
No
Yes
Captures the phase related to authorization to perform work used in the Windchill Aerospace & Defense module.
Classification Path
Yes (if the exported part is classified)
Yes
The attributes that define the classifications.
For example, the path /Mechanical/Bearing/Radial is displayed as RADIAL in the exported file.
* 
Use the pipe character (|) to assign multiple classifications, for example, RADIAL|PLAIN.
Additional attributes or classification attributes
No
Yes
Any soft attributes (including classification attributes) required for the part. For more information on additional attributes, see Creating a New Attribute.
Currently, only the display name in the 5th row and internal name in the 6th row are needed.
* 
The order in which attributes are listed in the spreadsheet is not important.
Was this helpful?