Project Import
The Object Translation integration loader uses only a single set of header columns.
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Project | Describes the type of header row | No | No | project | |
| Name* | The Tag's name | Yes | Yes | string(255) | |
| Project ID | System generated Project ID for existing project | No | No | integer | |
| Status | Status of the project | No | No | string(25) | |
| Content Groups | Content Group list for the project | No | No | ||
| Description | The Tagging's description | No | No | text | |
| Allow anyone to join | If this project open to everyone to join or not | No | No | boolean | |
| Who can view members | Who can view members of the project. Owners or anyone with access to the project | No | No | integer | anyone_with_access_to_this_project, project_owners_only |
| Project Owners | Owner/s of the project | No | No | User | Must be active Coupa users |
| Project Members | Member/s of the project | No | No | User | Must be active Coupa users |
| Start Date | Start Date of the task | No | No | datetime | |
| End Date | End Date of the project | No | No | datetime | |
| External Ref Number | External Ref Number of the project | No | No | string(255) | |
| Commodity | Commodity of the project | No | No | string(255) | Must already exist in Coupa |
| Category | Category of the project | No | No | string(255) | Must already exist in Coupa |
| Department | Department of the project | No | No | ||
| Show Sourcing Tab | Enable Sourcing tab or not | No | No | boolean | |
| Show Contracts Tab | Enable Contracts tab or not | No | No | boolean | |
| Show Suppliers Tab | Enable Suppliers tab or not | No | No | boolean | |
| Show Sourcing Calculated Fields | Enable Sourcing calculated fields or not | No | No | boolean | |
| Show Contracts Calculated Fields | Enable Contracts calculated fields or not | No | No | boolean | |
| Show Suppliers Calculated Fields | Enable Suppliers calculated fields or not | No | No | boolean | |
| Additional Planned Savings | Additional Planned Savings of the project | No | No | decimal(32,4) | |
| Additional Negotiated Savings | Additional Negotiated Savings of the project | No | No | decimal(32,4) | |
| Additional Realized Savings | Additional Realized Savings of the project | No | No | decimal(32,4) |
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 |