task-data-export.py
Tasks, as a component, is no longer supported and was completely removed from TeamForge 20.1 and later. However, if you have been using Tasks, you can use the task-data-export.py script to export the Tasks data to Excel files, which you can later import into one of the TeamForge trackers.
Usage
[RUNTIME_DIR]/scripts/task-data-export.py [--rows|-r] | [--path|-p] | [--help|-h]
Parameters
The following parameters are available for the tasks-data-export.py script.
| Parameter | Description |
|---|---|
| -r | --rows | The maximum number of rows to export to an Excel file. Ignoring this option allows a maximum of 4500 rows exported to an Excel file. |
| -p | --path | The path to the location where the Excel files (with Tasks data) are stored. |
| -h | --help | Provides a list of all available options for this script. |
Usage Example 1: The following command exports the Tasks data to as many Excel files as required with no more than 400 rows in each Excel file. For example, if you have 900 records, the following command exports 400 records to the first two Excel files and the remaining 100 records to a third Excel file.
./task-data-export.py -r 400 -p /tmp/TaskExport/
Usage Example 2: The following command exports the Tasks data to as many Excel files as required with a maximum of 4500 rows per Excel file. For example, if you have 9000 records, the following command exports the data to two excel files with 4500 records per file.
/task-data-export.py -p /tmp/TaskExport/
Importing Tasks Data to a TeamForge Tracker
You can create a new Tasks tracker and mass import the data that you exported as discussed earlier using the tasks-data-export.py script.
However, the new tracker you create must comply with the following field structure. The following table lists the fields (both fixed and flex fields) and their values, if any, as expected in the new Tasks tracker that you create.
| Artifact ID | Field Values | Type |
|---|---|---|
| Title | Fixed Field | |
| Description | Fixed Field | |
| Assigned To | Fixed Field | |
| Team | Fixed Field | |
| Status | Pre-configured values of Task Alert, OK, Warning, NotStarted, Complete | Fixed Field |
| Priority | None 1 - Highest 2 - High 3 - Medium 4 - Low 5 - Lowest | Fixed Field |
| Category | Fixed Field | |
| Start Date | Text-Flex Fields | |
| End Date | Text-Flex Fields | |
| Percent Complete | Text-Flex Fields | |
| Estimated Hours | Text-Flex Fields | |
| Created Date | Text-Flex Fields | |
| Task Created By | Text-Flex Fields | |
| Planned | Text-Flex Fields | |
| Accomplishments | Text-Flex Fields | |
| Issues | Text-Flex Fields | |
| Actual Hours | Text-Flex Fields | |
| Task Calendar | Text-Flex Fields | |
| Task Associations | Text-Flex Fields | |
| Task Successor | Text-Flex Fields | |
| Task Id | Text-Flex Fields | |
| Folder Hierarchy | Text-Flex Fields | |
| Task Predecessor | Text-Flex Fields |