excel sheet service catalog mrvs

[keshav77]

Hi All,

I  have a Requirement  where I need to place the data in mrvs  which will update the data in cmdb_ci_api table and other  cmdb tables as well depended upon unique key values. 

But some user having 1000 of record in that case we want to use excel sheet We want to place that excel sheet in catalog that excel sheet contains headers of the filed where user place the data accordingly.  then that excel sheet update the data in the cmdb required tables. how can we achieve that.

[J Siva]

Hi @keshav77 
You can acheive this using Data source and Transform map.
PFB the link to community post which gives you some on idea on how to configure this.

https://www.servicenow.com/community/developer-forum/is-there-any-way-to-run-transform-map-automatic...

Reagrds,
Siva

[Ankur Bawiskar]

@keshav77 

you can refer my blog on how to load data via catalog item, you can enhance it as per your requirement

Data load and transform via Catalog Item 

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

[Ankur Bawiskar · Accepted solution]

@keshav77 

Hope you are doing good.

Did my reply answer your question?

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

[keshav77]

@Ankur Bawiskar  I want to update multiple tables through Service catalog