Bulk Import Service Catalog Items along with Approval process,flows or workflows to Servicenow

[vivek72]

Hi,

I have been often asked about below question in some interviews, please help to explain in detail with a possible solution if anyone has implemented it before:

"How to import catalog items in bulk which will also help to import not only variables but also approval process,flows, workflows,MVRS etc attached to respective catalog item from either a csv file or from other ITSM tools like BMC remedy".

Thanks,

Vivek

[Anil Lande · Accepted solution]

It depends what data they are providing in CSV.

We need to create transform maps to load these CSV files into respective table and use correct sequence to load data. Do the transformations through scripts and load data in different target tables through transform maps.

Load data in below sequence:

1. Load all catalogs (in sc_catalog table)

2. Load all Categories

3. Load all Catalog Items

4. Load All variables mapped with each catalog item.

5. Load variable sets and variables and do the mapping throgh script or using Variable set API.

We can only talk about high level architecture but in actual case this is going to be very complex implementation.

Thanks,
Anil Lande

[vivek72]

ok, thanks Anil!

[VaranAwesomenow · Accepted solution]

PF updateset with required data source and transform map for a sample data load file which loads data to catalog item table.

[vivek72]

Thanks @VaranAwesomenow for sharing this information !

[Astha5]

Hi @VaranAwesomenow ,

Can you please share the import template you have used. Also I imported the update set you provided into my PDI, however I cant see a mechanism to import variables, please let me know if there is something for importing variables in your update set.

Thank you,

Astha

Thank you