Project Import

Project

Field Name Required Field Unique? Field Type Field Description Possible Values
Project No No Project
Name* Yes Yes string(255) The Tag's name
Project ID No No integer System generated Project ID for existing project
Status No No string(25) Status of the project
Content Groups No No BusinessGroup Content Group list for the project
Description No No text The Tagging's description
Allow anyone to join No No boolean If this project open to everyone to join or not
Who can view members No No integer Who can view members of the project. Owners or anyone with access to the project anyone_with_access_to_this_project, project_owners_only
Project Owners No No Owner/s of the project
Project Members No No Member/s of the project
Start Date Yes No datetime Start Date of the task
End Date Yes No datetime End Date of the project
External Ref Number No No string(255) External Ref Number of the project
Commodity No No Commodity of the project
Category Yes No Category of the project
Department No No Department of the project
Show Sourcing Tab No No Enable Sourcing tab or not
Show Contracts Tab No No Enable Contracts tab or not
Show Suppliers Tab No No Enable Suppliers tab or not
Show Sourcing Calculated Fields No No boolean Enable Sourcing calculated fields or not
Show Contracts Calculated Fields No No boolean Enable Contracts calculated fields or not
Show Suppliers Calculated Fields No No boolean Enable Suppliers calculated fields or not
Additional Planned Savings No No decimal(32,4) Additional Planned Savings of the project
Additional Negotiated Savings No No decimal(32,4) Additional Negotiated Savings of the project
Additional Realized Savings No No decimal(32,4) Additional Realized Savings of the project
Task No No Task
Title* Yes No Title of the task
Task ID No No System generated Task ID for the task
Assign To No No Owner's login of the task for the project
Due Date No No Due Date of the task
Original Estimate No No Original Estimate of the task in days
Task completion % No No Percentage of the task completion
Linked Object No No Linked Object
Object Type* Yes No Type of the linked object
Object ID No No ID of the linked object
Object Name No No Name of the linked object
Tag No No Tag
System Tag No No System Tag, defaults to false if not specified

Task

Column Name Description Req'd Unique Type Allowable Values
Task Describes the type of header row No No task
Title* Title of the task Yes No
Task ID System generated Task ID for the task No No
Assign To Owner's login of the task for the project No No
Due Date Due Date of the task No No
Original Estimate Original Estimate of the task in days No No
Task completion % Percentage of the task completion No No

Linked Object

Column Name Description Req'd Unique Type Allowable Values
Linked Object Describes the type of header row No No linked_object
Object Type* Type of the linked object Yes No
Object ID ID of the linked object No No
Object Name Name of the linked object No No

Tag

Column Name Description Req'd Unique Type Allowable Values
Tag Describes the type of header row No No tag
System Tag System Tag, defaults to false if not specified No No Must be an existing tag