How do I import values into a choice list for a Catalog Request?

[Wayne Richmond]

Hi everyone. I am creating a Catalog Request form that has a select box on it. I need to import 125 options - how do I do this?

[santoshsahoonis]

Hello Wayne,

The easiest way would be to import them using an excel.

Step1 :

Create an excel with minimum 4 columns with headers as shown, i.e,: Order, Question, Text, Value, Price, Recurring Price

Step 2:

Fill the excel sheet with your 120 choice. For all rows for column 'Question', use the variable name(Select box in catalog item)

Step 3: Follow the link below and import the excel to ''Question Choice" table

Importing Data Using Import Sets - ServiceNow Wiki

Hope that helps.

[Brad Tilton]

Agree with Santosh, but you can make the process a little easier on yourself by adding 1 choice, then going to the choice list and doing an export to excel of that list and filling in the values. That way you know the headers will match up correctly and be formatted.

[pathat]

Hello.

What if I wanted to present the user with a list of choices that are retrieved dynamically via a web service call to an external data source? How does one do this in ServiceNow?

-- New to ServiceNow

[Les1]

i tried this method as well as just creating an import template from the "do you want to create a template" and in both cases servicenow doesn't seem to want to accept the Text field or sys_name (display name) field. 

trying to import leaves these fields blank