How can I import tasks from excel into a board

[SimonAJudge]

From testing I know that I can define a data source, attach a workbook and define a transform map/field mapping to create or update tasks in a board however when using a custom column I see no easy way of determining the correct target field given that they have a non-descript name with a 'Column nnn' format (where nnn is in the range of 000-100).

Rather than populating all custom fields and running a report to map them manually, is there an easier way?

[Sunil B N]

Hi Simon,
Unfortunately there is no automated mapping process. This is very specific behaviour to CWM as we have enabled end users to create custom columns without admin intervention.
Nevertheless, you could have an API to map the respective column. 
How - Based on incoming space Id/board Id you can find the relevant column in this usage table and map the value. 
Let me know if you have further queries. We are happy to help!
Best Regards,
Sunil B N

[SimonAJudge]

Thank you for the feedback Sunil. I don't have any experience of the API mapping approach you're describing, is there any reference material that describes this solution, or do you have any examples?

[Sunil B N]

Hi Simon
Please make use of script to map.
https://www.servicenow.com/docs/bundle/zurich-integrate-applications/page/script/server-scripting/co...

As mentioned above use sn_cwm_columns_usage table and query the relevant column based on your data. And map accordingly.

Thanks and regards,
Sunil B N