ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Form LabelField NameMandatory
for Insert		Mandatory
for Update		ImportableDetailsRange Values
2
Project #ProjectNumberNoThis field is not used for import. We use the ProjectName field to track which project the task belongs to.
3
ProjectProjectNameYesYesYes
4
NumberNumberNoYesYesOptional for task creation (auto-generated if one not provided). It is required in updating existing tasks.An integer or decimal value, greater than or equal to zero.
5
SummarySummaryYesNoYesMandatory when the task is created only.75 characters including spaces
6
DetailsDetailsYesThis field may contain an unlimited number of characters.
7
CreatorCreatorYesOnly used during task creation. If not provided, the username of the importer will be used. If provided for an update, this field will be ignored. The value must be the exact username of an existing user.
8
Date CreatedCreatedYesOnly used during task creation. If not provided, the today's date will be used. If provided for an update, this field will be ignored.
9
Last UpdateUpdatedYesOnly used during task creation. If not provided, the today's date will be used. If provided for an update, this field will be ignored.
10
Last Updated ByLastUpdateByYesOnly used during task creation. If not provided, the username of the importer will be used. If provided for an update, this field will be ignored. The value must be the exact username of an existing user.
11
StatusStatusYesIf not provided, the default task status will be used. The value must be the exact name of an existing status. If the imported status represents a completed status, the "EstimatedPercDone" value will be set to 100% automatically. A task cannot be In Progress / Completed before its predecessors are completed and their lag time has passed.
12
% DoneEstimatedPercDoneYesIf not provided, the default value will be zero. This value will be set to 100% automatically if the imported status represents a "completed" status. If the imported status type is "waiting", the value must be zero.0, 10, 20, 30, 40, 50, 60, 70, 80, 90, 100
13
GroupGroupYesIf not provided, the default project's task group will be used. The value must be the exact name of an existing group.
14
TypeTypeYesIf not provided, the default project's task type will be used. The value must be the exact name of an existing type.
15
PrioriyPriorityYesIf not provided, the default project's task priority will be used. The value must be the exact name of an existing priority.
16
Estimated Start DateEstimatedStartDateYesA task Estimated Start Date must be lower than or equal to the project's Estimated End Date. An Estimated Start Date must be greater than the project's Estimated Start Date. The Estimated Start Date must be the equal to or after all its predecessor’s Estimated Start Date, and respect their lag time.The Estimated Start Date must be less than or equal to the Estimated End Date.
17
Estimated End DateEstimatedEndDateYesA task's estimated end date must be greater than or equal to the Project's Estimated Start Date. A task's Estimated End Date must be lower than or equal to the project's Estimated End Date. If a task is linked with other tasks, it must have an Estimated Start Date and an Estimated End Date.The Estimated End Date must be greater than or equal to the Estimated Start Date.
18
Weekends AllowedWeekendsAllowedYesIf the containing project is set to "Including Weekends", "Weekends Allowed" will automatically be set to "Yes". If the containing project is set to "Excluding Weekends", the default value for "Weekends Allowed" will be "No".
19
Estimated HoursEstimatedHoursYesIf not provided, the default value will be zero. Estimated Hours will be divided evenly among the assigned hours.An integer or decimal value, greater than or equal to zero.
20
Estimated ExpensesEstimatedExpensesYesIf not provided, the default value will be zero.An integer or decimal value, greater than or equal to zero.
21
Actual Start DateActualStartDateYesThe Actual Start Date must be less than or equal to the Actual End Date.
22
Actual End DateActualDueDateYesThe Actual End Date must be greater than or equal to the Actual Start Date.
23
Actual HoursActualHoursNoThis field cannot be imported because it is computed one.
24
Actual ExpensesActualExpensesNoThis field cannot be imported because it is a computed one.
25
My Actual ExpensesMyActualExpensesNoThis field cannot be imported because it is a computed one.
26
Assigned User(s)AssignedYesIf not provided on task creation, there will be no user assignment unless a user(s) is already set as auto-assigned on the project. To assign multiple users, simply separate each username with a comma. Each value must be the exact username of an existing user.
27
Reviewer(s)ReviewerYesIf not provided on task creation, there will be no user assignment unless a user(s) is already set as auto-assigned as reviewer on the project. To assign multiple users, simply separate each username with a comma. Each value must be the exact username of an existing user.
28
Comment ThreadCommentThreadNoThis field cannot be imported. If provided, this field will be ignored.
29
PredecessorsPredecessorsNoThis field cannot be imported. If provided, this field will be ignored.
30
SuccessorsSuccessorsNoThis field cannot be imported. If provided, this field will be ignored.
31
Actual % DoneActualPercDoneNoThis field cannot be imported. If provided, this field will be ignored.
32
Ready to StartReadytoStartNoThis field cannot be imported. If provided, this field will be ignored.
33
Marked TaskMarkedTaskNoThis field cannot be imported. If provided, this field will be ignored.
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100