Importing tasks into a CWM space

Jonah Piascik
Tera Expert

Is there an easy way to import tasks into a CWM space (i.e. from a excel spreadsheet) that does not involve platform admin support?

1 ACCEPTED SOLUTION

Sunil B N
ServiceNow Employee

Hi Jonah,
This is on our future roadmap to make it viable for end user without admin support.
If the tasks are repetitive, you can save it as board template and User can create a fresh board out of it.

As of now, the alternative is to import via standard ServiceNow platform process.

Major tables to be populated: sn_cwm_task, sn_cwm_task_custom(linked to task via source id and source table), sn_cwm_board, sn_cwm_columns_usage(if you have new custom columns)

Thanks and Regards,
Sunil B N

View solution in original post

4 REPLIES 4

Dr Atul G- LNG
Tera Patron

Hi @Jonah Piascik 

 

To get the data you can use import /export or send the attachment to ServiceNow and then parse it and move the excel data to required tables and fields.

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

Sunil B N
ServiceNow Employee

Hi Jonah,
This is on our future roadmap to make it viable for end user without admin support.
If the tasks are repetitive, you can save it as board template and User can create a fresh board out of it.

As of now, the alternative is to import via standard ServiceNow platform process.

Major tables to be populated: sn_cwm_task, sn_cwm_task_custom(linked to task via source id and source table), sn_cwm_board, sn_cwm_columns_usage(if you have new custom columns)

Thanks and Regards,
Sunil B N

Thank you @Sunil B N 

@Jonah Piascik - Following up on the import task use case you brought up - We’re planning to introduce an in-product feature within CWM that allows team members to import tasks directly into CWM boards. Would you be interested in meeting to discuss this use case in more detail?