Is there a way to upload a long list of items for a Choice List?

terrilandau
Kilo Contributor

I have a very long list of items for people to choose in a Choice List. I don't want to spend hours adding them one at a time. Is there a way to add the list in a bulk- type format?

5 REPLIES 5

Patrick DeCarl1
ServiceNow Employee
ServiceNow Employee

Use the load data, create a transfer map to load choice values to the sys_choice table. Make sure to set table, element(field name), language, Label, value and sequence.



If you haven't loaded data before into SN, take a look at wiki page Importing Data Using Import Sets - ServiceNow Wiki  


Ken_Michelson
Kilo Guru

While I agree that you could use Import Sets and transform maps, I would suggest you see if you can achieve this using the "Easy Import" feature first Easy Import - ServiceNow Wiki



That said, the fact that you have a "very long list" of things for the choice table concerns me. A choice list isn't your only option. Consider the usability of the list and your user experience before you go creating choice lists with lots of choices.



-Ken Michelson


bretterickson
Tera Contributor

I had a similar situation. It wasn't a long list but a shorter list that needed to be used in several places.   I ended up creating a table and used a Lookup Select Box in my form.   In your case, you might consider using a reference field instead.


Uncle Rob
Kilo Patron

"Long list" is one of my immediate disqualifiers for choice lists.   As soon as a list of items becomes too long (like 10+) I strongly consider placing the values in a table.   Its never steered me wrong.  



Here's my little rule set for picking between Choice List vs Table.



CHOICE LISTS:


- small number of options


- single dimensional data (I only want one word / concept, and the entries have no other elements I care about)


- list of options unlikely to change



TABLES


- large number of options


- multi-dimensional data (each of the selections might have other properties I care about beside the display name)


- options will change regularly