Creating choices for any question through excel

[sanket16]

When working with Catalog items, we often get variables that needs choices. a normal count like 10 choices are ok to create manually. but if we have a need to create 200+ choices and the feed is a excel then its a headache.

Transform map is a good solution to handle it but we need to maintain the template for it.

So for ease created a catalog item that takes Excel as input and gives JSON as an output which we can use as input to any of the Server script. also additionally you can create choices to any variable from that RITM itself.

Way of using it: (refer the screenshot for terms)
In catalog item, attach the sheet that have choices.

once you click the generate JSON with proper sheet selected, it will populate the headers and JSON of that choice payload.

If data conversion was the motto, then we are here.

If you wish to have choices of that data, you can check the create choice checkbox and select item name and variable where that choices need to be created. 

Once submitted ...you have your desired choices with minimum efforts!!!

attaching the update set XML as well for reference.
Any inputs for improvements are welcome...

[Ankur Bawiskar]

@sanket16 

So what's your question?

If this for sharing information then having more than 10 choices in drop down is not a good user experience.

Instead we should use a custom table and use a reference variable for this.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[sanket16]

Thanks Ankur.
 yes, custom table is also a solution for this