How can we create variable in service catalog using transform map importing data from excel

[is_12]

Hello Community,

I need to automate the variable creation of the catalog item

If anyone know the refer video or the wiki, please share, it would be helpful 

Thanks,

[Ankur Bawiskar]

@is_12 

who will send the data for the variable name, type etc?

what's your actual business requirement?

Why to create variables via transform map?

check this and enhance as per what comes in your import set table from 3rd party

Transform Script for Variable Set and Catalog Items 

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

[is_12]

Hi @Ankur Bawiskar,

As per the requirement there will be more catalog item per sprint to develop, Per sprint we will be having 20 items where one catalog item contains the 70-80 variables and also there will be the min 10-15 Ui policies as well. So I'm planning to automate this monotonous thing where I can reduce the creation if I automate Catalog item excel sheet.

and for the link which you have sent, is for adding the variableset to the catalog item

if there are wiki pages for creating variables using the transform Map, Can you please share

Thanks in Advance !!

[Ankur Bawiskar · Accepted solution]

@is_12 

In that case you can have 1 excel with multiple columns and have 1 transform map and handle everything via onBefore transform script

1) in that transform script, create catalog item, create variables and link with your catalog item

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

[is_12]

@Ankur Bawiskar, Can you help me with the script & the guide me with script.

Thanks