Importing data into a List type field

JLeong · ‎06-02-2016

Hi All,

Could someone please assist on how to import data (xls file) into a List type field.

Thank you in advance.

top_tanti · ‎06-02-2016

Chuck is correct. Transform map will be needed. However, I just tried a simple import/transform and did not need to translate into sys ID. Here's what my import file looked like:

And my transform map:

View solution in original post

top_tanti · ‎06-02-2016

Have you tried comma delimited format?

Pradeep Sharma · ‎06-02-2016

Hi Top,

Please refer.

More than one user or email address to the Watch List in a data import - transform

https://community.servicenow.com/external-link.jspa?url=http://wiki.servicenow.com/?title=Transform_...

JLeong · ‎06-02-2016

Yes, I have, didnt work.

Chuck Tomasi · ‎06-02-2016

Hi Jocelyn,

The list field holds comma separate sys_ids.

It might be the easiest method (someone usually tells me there's an easier way later) - I'd use the transform script to do this. If your spreadsheet has a cell with five names, comma separated, it can be scripted to convert those names to sys_ids and populate that field.

Transform Map Scripts - ServiceNow Wiki