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?

[GlideFather]

Hi @SimonAJudge,

you will need a transform map and table to load the data and then move them to Task table.

However, is there any specific reason why would you import tasks from excel?? 

Remember if you will do the load to one environment (let's say DEV) and later to another (TEST or PROD), it will always have different sys ID... so it's good to do the import in one env and then move it as XML..

[SimonAJudge]

Defining the data source and transform map is not the issue, given the structure of CWM tasks that use customised columns, field mapping is not as straight forward as would be normally. A customised column has the field name 'Column nnn' format (where nnn is in the range of 000-100).