Need a fix script to update a excel sheet data into incident table

VIKAS MISHRA · ‎06-08-2021

I have a excel sheet saved in my system, excel sheet is having 2 columns such as "Number" and "Work Notes" and having exactly same data as mentioned below.

Number Work notes

INC0010001 Test comment 1

INC0010001 Test comment 2

INC0010001 Test Comment 3

Please mid the incident number which is same everytime.

Now i want a fix script that will help me to upload all these comments one after another into the mentioned incident's work note in ServiceNow.

This excel sheet is saved in my desktop.

Prasad Pagar · ‎06-08-2021

Hi Vikas,

Then I think GlideExcelParser can be answer to your requirement.

See these posts

https://community.servicenow.com/community?id=community_question&sys_id=56b747e9db1cdbc01dcaf3231f961984

https://developer.servicenow.com/dev.do#!/reference/api/orlando/server/sn_impex-namespace/GlideExcelParserScopedAPI#GEPS-next

https://community.servicenow.com/community?id=community_question&sys_id=d9330be1dbd8dbc01dcaf3231f96195a

https://community.servicenow.com/community?id=community_question&sys_id=95e00560db1dc4d05ed4a851ca961906

Add Awesome video by my friend Oscar

https://community.servicenow.com/community?id=community_article&sys_id=fc63aa4edb81885814d6fb243996196c

Hope this helps

Thank you
Prasad

View solution in original post

Prasad Pagar · ‎06-08-2021

Hi @VIKAS MISHRA

I will suggest to do it with Import sets and Transform Map.

Use Load Data from Navigator to load excel and Create Import set table -> Transform map along with field mapping marking number as Colesce = True this can be done

Thank you
Prasad

VIKAS MISHRA · ‎06-08-2021

Hello Prasad,

what you are saying is correct and that works also, but as per my requirement i need to create fix script within a function and whenever i will call that function that fix script should run and always update the data from that excel sheet to the incident whatever will be mentioned there in the sheet and will update the work notes, is it possible.

Prasad Pagar · ‎06-08-2021

Hi,

It is possible if you are going to store this data in some table or import sets.

Then you can write fix script to pick the date from custom table or import set and update incident table.

Where you going to store excel data?

Thank you
Prasad

VIKAS MISHRA · ‎06-08-2021

Its like some people can come and attach an excel sheet to the already existing incident and that excel sheet is the one i am was talking about, now user needs a new Action button and if he clicks on that action button it should upload all the work notes comments mentioned in the attached sheet to the incident.