Task Planner data migration

In versions of Service Manager earlier than 9.40, Task Planner data is stored in the changeModel and changePlan tables. However, in Service Manager 9.40, Task Planner data is stored in the changePlan table only. Therefore, two data migration settings are provided to migrate Task Planner data from Service Manager 9.40 and earlier versions.

Migrate legacy change model Task Planner data to new Task Planner

Default settings:

Source table

changeModel

Target Table

changePlan

Query

not null(tasks)

Batch Update

false

Field mapping:

Target field

Source field

fileName

 

number

id

Value mapping:

Target value mapping field

Mapping type

Condition

Target value

fileName

fixedValue

changeModel

Post script:

for(var i=0;i<$sourceTable.tasks.length();i++){
	$targetTable.tasks[i].taskId=$sourceTable.tasks[i].taskId;
	$targetTable.tasks[i].taskCoords=$sourceTable.tasks[i].taskCoords;
	$targetTable.tasks[i].dependentIds=$sourceTable.tasks[i].dependentIds;
	$targetTable.tasks[i].dependentCoords=$sourceTable.tasks[i].dependentCoords;
	$targetTable.tasks[i].taskCategory=$sourceTable.tasks[i].taskCategory;
	$targetTable.tasks[i].taskTemplate=$sourceTable.tasks[i].taskTemplate;
	$targetTable.tasks[i].taskDescription=$sourceTable.tasks[i].taskDescription;
	$targetTable.tasks[i].openInPhase=$sourceTable.tasks[i].openInPhase;
	$targetTable.tasks[i].closeByPhase=$sourceTable.tasks[i].closeByPhase;
	$targetTable.tasks[i].activeCond=$sourceTable.tasks[i].activeCond;
	$targetTable.tasks[i].activeCondXML=$sourceTable.tasks[i].activeCondXML;
	$targetTable.tasks[i].activeCondDesc=$sourceTable.tasks[i].activeCondDesc;
	$targetTable.tasks[i].mandatory=$sourceTable.tasks[i].mandatory;
}
$targetTable.doUpdate();

Migrate legacy change instance Task Planner data to new Task Planner

Default settings:

Source table

changePlan

Target Table

changePlan

Query

null(fileName)

Batch Update

true

Field mapping:

Target field

Source field

fileName

fileName

Value mapping:

Target value mapping field

Mapping type

Condition

Target value

fileName

fixedValue

 

cm3r

Migrate legacy change/task data to new Task Planner

In Service Manager Hybrid, task information is stored in the change’s task plan. Change task information must be migrated to the new Task Planner. To do this, use the “Legacy change/task data to new taskplanner” data migration setting in the data migration tool.

Default settings:

Source table

cm3r

Target Table

changePlan

Query

open=true

Batch Update

 

Field mapping:

Target field

Source field

fileName

 

Number header,number

Value mapping:

Target value mapping field

Mapping type

Condition

Target value

fileName