Migrate skills to the Task Skill table

[deepikag0508]

I referred the below servicenow docs.

https://docs.servicenow.com/bundle/washingtondc-field-service-management/page/product/field-service-...

I want to migrate the skills that are entered in the work order task table (wm_task) to task skills table (task_m2m_skill). I created this property com.snc.skills_management.wm_task_migrate_skills. I ran the Migrate Skills to Task Skill M2M fix script. But skills are not mapping to the task skills table. Kindly let me know what the issue is and how to resolve it.

Thank you.

[Abhishek_Soni37]

Hi, 

Set the value of the value field of this property to true. And make sure that this sys prop -> com.snc.skills_management.task_skill_migrated_tables doesn't have wm_task in it. 

Run the fix script now, once execution is finished you'll find the skills in task_m2m_skill table.

Hope this helps.

[DeepG]

Hi @Abhishek_Soni37,

Thank you very much for your assistance. I have noted that the work order tasks are being updated in the task skills table.
However, I’ve observed that the property com.snc.skills_management.task_skill_migrated_tables automatically changes its value to wm_task after the fix script is executed.

1. How can we ensure that the value of this property remains empty at all times?
2. Is it necessary to run the fix script each time we want to transfer work order task skills to the task skills table?
3. If a skill in the work order task is deleted, will the corresponding task skill record also be deleted?

Thank you!

[Abhishek_Soni37]

Hi @deepikag0508 ,

I would like to suggest you to go through both of these doc articles.

1 > Doc-1

2 > Doc-2

Process of using mandatory skills: Imagine as of now the normal skills are being used and there are already 100 WO are created in the system. So the mandatory skills field will be empty at this time. Now if you decide to go with the mandatory skills, you need to run the migration script so that for the existing WOTs, it'll transfer all the skills that are associated with each WOT to task_m2m_skill. 

Answers to your questions:
1> Since you've already run the migration script to move skills to the task skill table for the existing WOTs, there is no need to run the fix script again. It's a one time thing, so there is no need to remove the wm_task table name from this property.

2> As I mentioned above, its a one time thing! Now if you add a new skill to the mandatory skill field on the WOT, it'll automatically create a new entry in the task_m2m_skill table.

3> Yes, if you remove a skill from the mandatory skill field, the skill record form the task_m2m_skill will be removed.

You'll have to add this view on the WOT form:

Cheers,

Abhishek