Home My Page Projects OMEGSI
Summary Activity Forums Tracker Lists Tasks Docs News SCM Files

Upload data into the tasks.

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 MS Excel.

Export tasks as a CSV file

Selected CSV Format : Full CSV with headers using ',' as separator. (Change)

Export CSV file

Import tasks using a CSV file

Choose a file in the proper .csv format for uploading.

Notes:

Record Layout

Field NameDescription
project_task_idthis is the ID in gforge database
external_task_idoptional, the equivalent of project_task_id but determined by external application, such as MS Project. Primarily preserved for sorting purposes only.
parent_idthe project_task_id of the parent task, if any
external_parent_idthe equivalent of parent project_task_id but determined by external application, such as MS Project. Primarily preserved for matching purposes only.
titleThe summary or brief description
categoryThe category name (must be defined, only available in full export)
durationDuration in days
workNumber of hours required to complete
start_dateThe start date in MM-DD-YYYY HH:MM:SS format
end_dateThe end date in MM-DD-YYYY HH:MM:SS format
percent_completePercentage of completion
priorityintegers 1 to 5
notesoptional, the details of the task or a comment to add to a task
resource1_unixnameoptional, the unixname or precisely-matched realname of the assignee
resource2_unixnameoptional, same as above
resource3_unixnameoptional, same as above
resource4_unixnameoptional, same as above
resource5_unixnameoptional, same as above
dependenton1_project_task_idoptional, the GForge task_id of a task to be dependent on
dependenton1_external_task_idoptional, the ID used by the external application
dependenton1_linktypeSS, SF, FS, FF, - The same types as MS Project
dependenton2_project_task_idrepetition of dependenton1
dependenton2_external_task_idrepetition of dependenton1
dependenton2_linktyperepetition of dependenton1
dependenton3_project_task_idrepetition of dependenton1
dependenton3_external_task_idrepetition of dependenton1
dependenton3_linktyperepetition of dependenton1
dependenton4_project_task_idrepetition of dependenton1
dependenton4_external_task_idrepetition of dependenton1
dependenton4_linktyperepetition of dependenton1
dependenton5_project_task_idrepetition of dependenton1
dependenton5_external_task_idrepetition of dependenton1
dependenton5_linktyperepetition of dependenton1