How to import data from CSV file source to create a catalog item?

[ishaanvohra]

Hi,

I want to import bulk data from CSV file source to create a new catalog items and want to have the attributes in my file to be the variables of the catalog item.

For this, I have created an import set and have also created a source table from which data will transform into my target table.I have also created a transform map.I want to add variable,category and catalog in the catalog item.And I also want to add the deafult values in the variables.As for each catalog items the variables will be same but their default values will be different.

So I want to run a script in the transform map.How can I do that with a script so that a new catalog item will get generate and variable set,categories will get provided to   it.

How can this be done with the help of the script.How can I bulk import data to create new catalog items?

[DilipKumar DJ]

Hi Ishaan,

We had a similar requirement and we implemented as below:

https://www.servicenowguru.com/system-definition/exporting-service-catalog-items-step/

[ishaanvohra]

Hi Dilip,

I want to import data to create a catalog item.This link tells about to   export the catalog item in XML format.I want to import data to create a new catalog item and add variables in it.

[DilipKumar DJ]

Hi Ishaan,

The exported XML can be imported to create a new Catalog item. If you need to perform any changes related to catalog name or description, you can very well edit the XML.

[ishaanvohra]

Hi Dilip,

I have CSV file which has some attributes in it.

I want to import this file to create a new catalog item from that which will contain attributes present in the file as variables of catalog items.

How can I do that?