How to import choices list with Table?

[Andrew_XU]

So how to do it?

[Inactive_Us2231]

Hi Fayu,

Just for your information, it is imperative that you provide the table column as well while importing the data in the choice table, because elements are nothing but

fields/columns of a table. so once you have uploaded the date with the table name, then you will find the new choice value as a dropdown in that element.

for eg :

if you had given incident table

then you would have got a dropdown value 'other' in an incident form on u_category_lvl field.

Hope it helps.

Mark the post correct if it helps!

[Inactive_Us2231]

Hi Fayu,

You can also import the data using XML. This is also one of the best practice while migrating data between different platforms as it keeps consistent sys ids throughout the platforms. You can refer the below link.

Exporting and Importing XML Files - ServiceNow Wiki

However if you are importing the data into the platform for the first time as Antin mentioned you can go with import sets route which will be easier to do.

You can also go through the below link to incorporate some best practices while uploading data.

Import Set Performance Best Practices - ServiceNow Wiki

Please mark helpful if it assists you any way!