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

[VIKAS MISHRA]

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 · Accepted solution]

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

[VIKAS MISHRA]

Thanks for all the help now i will check all the script mentioned in above link provided by you