Is there a way to upload a long list of items for a Choice List?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-15-2016 05:23 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-15-2016 06:22 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-16-2016 12:44 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2016 06:25 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2016 06:31 AM
"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