View Subprojects | DrawGeo | Gantt Chart | Import/Export CSV
This page allows you to export or import all the tasks using a CSV (Comma Separated Values) File. This format can be used to view tasks using Microsoft Excel.
Export tasks as a CSV file
Selected CSV Format: Full CSV with headers using ',' as separator. (Change)Import tasks using a CSV file
Notes
- If project_task_id is empty, then a new task will be created.
- If project_task_id is present, then the corresponding task will be updated.
Record Layout
Field Name | Description |
---|---|
project_task_id | this is the ID in database |
external_task_id | optional, the equivalent of project_task_id but determined by external application, such as Microsoft Project. Primarily preserved for sorting purposes only. |
parent_id | the project_task_id of the parent task, if any |
external_parent_id | the equivalent of parent project_task_id but determined by external application, such as Microsoft Project. Primarily preserved for matching purposes only. |
title | The summary or brief description |
category | The category name (must be defined, only available in full export) |
duration | Duration in days |
work | Number of hours required to complete |
start_date | The start date in YYYY-MM-DD HH:MM:SS format |
end_date | The end date in YYYY-MM-DD HH:MM:SS format |
percent_complete | Percentage of completion |
priority | integers 1 to 5 |
notes | optional, the details of the task or a comment to add to a task |
resource1_unixname | optional, the unixname or precisely-matched realname of the assignee |
resource2_unixname | optional, same as above |
resource3_unixname | optional, same as above |
resource4_unixname | optional, same as above |
resource5_unixname | optional, same as above |
dependenton1_project_task_id | optional, the task_id of a task to be dependent on |
dependenton1_external_task_id | optional, the ID used by the external application |
dependenton1_linktype | SS, SF, FS, FF, - The same types as Microsoft Project |
dependenton2_project_task_id | repetition of dependenton1 |
dependenton2_external_task_id | repetition of dependenton1 |
dependenton2_linktype | repetition of dependenton1 |
dependenton3_project_task_id | repetition of dependenton1 |
dependenton3_external_task_id | repetition of dependenton1 |
dependenton3_linktype | repetition of dependenton1 |
dependenton4_project_task_id | repetition of dependenton1 |
dependenton4_external_task_id | repetition of dependenton1 |
dependenton4_linktype | repetition of dependenton1 |
dependenton5_project_task_id | repetition of dependenton1 |
dependenton5_external_task_id | repetition of dependenton1 |
dependenton5_linktype | repetition of dependenton1 |