Importing values into a choice list for a Catalog Item

[Cupcake]

Good evening all,

        I submitted this question once, and a discussion got started but was never concluded; therefore, I am resubmitting the question again.

        I submitted a question about how to import values from an Excel spreadsheet into a choice list for a Catalog Item. I received the following advise:

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)

I did those steps and that was fine, but when I went to import the excel spreadsheet into the table I received an error that I am not sure about. Can anyone tell me what this means. And if i proceed, what will happen.

This error was received while I was trying to import from excel.

Thanks,

Karen

[Michael Ritchie · Accepted solution]

Karen, is there a reason you are wanting to create a list of 120 choices?   To me that is an extremely long list and not user friendly.   I would suggest creating a custom table with your choice selection and change the variable to a reference instead.   In your custom table you can add a price column and use that for the price calculation:

http://wiki.servicenow.com/index.php?title=Service_Catalog_Variable_Pricing#Reference

[Cupcake]

Michael thank you so very much. Didn't even think about that option.

You just made my day. Works like a charm. Kudos to you.