File Format for Importing Documents
The following table describes the format of data in a document 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:
For documents or its subtypes such as Agenda or Plan, the value is always wt.document.WTDocument.
Name
Yes
Yes
Document name
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 document as well as the document type; otherwise, you can enter a number.
* 
If you do not enter a number, a number is auto-generated for new document.
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
No
If not specified, the owning organization is set to the organization associated with the current container. It determines the organization to which the document is associated.
Revision
No
Yes
If a revision is not specified, the default starting revision is used. For example, for a new document, the revision is A.
* 
A revision other than A may be specified for the initial document creation.
State
No
Yes
Life cycle state of the document.
Was this helpful?