Specifying phase and sequence for task and task group templates in the dataload spreadsheets
To enable the phase management and sequence for tasks in a change template
With the enhancements in the Change_Process_Setup.xlsm spreadsheet, perform the following operations for the task or task group template that is associated with a change template:
- Relate the Review, Business Approval or Implementation phases to the task or task group template.
- Provide a sequence in which the task templates appear in a change form when you apply the change template.
For example, the following three task templates related to a change template are available:
- Task template 1
- Task template 2
- Task template 3
Relate Task template 2 and Task template 3 to the Business Approval phase with the following sequence:
Sequence | Task template |
|---|---|
1 | Task template 3 |
2 | Task template 2 |
When you provide these values for a change template in the spreadsheet and create a change request by applying this change template, the Task Template tab on the change form displays the task or task group templates. There templated are related to the defined phase and in the sequence that is set in the spreadsheet. In this example, when the request moves to the Business Approval phase, Task template 3 will appear first followed by Task template 2.
If you do not provide a sequence for the tasks in the spreadsheet, the system sets the value of task sequence to 1.
Enter a set of values and load the data for a change template by using Data Management.
- Download the Change_Process_Setup.xlsm spreadsheet.
- On the TMS_LoadAssociationTemplate tab:
- In the Phase column, enter the phase to which you want to associate the task or task group template.
- Enter the numbers in the Sequence column to define the sequence for the task template, for example, 1, 2, 3, and so on.
- Save and attach the spreadsheet to the Data Management job and run the job.
To define the sequence of the tasks in a task group template
Provide a sequence to the tasks in a task group template by performing the following steps:
- Download the Task_Process_Setup .xlsm spreadsheet.
- O n the TMS_LoadAssociationTemplate tab, enter the numbers in the Sequence column to define the sequence for the task template, for example, 1, 2, 3, and so on.
- Save and attach the spreadsheet to the Data Management job and run the job.