Reading a List of Servers from Excel Spreadsheet

[pradeepshokeen]

Hello Everybody,

How could I read the list of servers from the attached excel spreadsheet and add it to the (affected ci table available as a related list in change), the intent is to bulk upload the data of affected CI's from a spread sheet --> verify it --> if available --> relate to affected CI table.

I am assuming there would be some functions to read it from spread sheets, although we can read excel in transform maps but that is something which is a different conversation and not related to Change management process.

any assistance would be highly appreciated.

Thanks,

Pradeep

[arnabdash]

Hi Geoffrey,

Could you elaborate, how you implemented it?

I have a template with multiple worksheets, worksheet 1 has columns whose results are calculated from other worksheets. I need to pick this calculated entry from Excel.

Customer wants us to uplad the template to the form. Using UI Action, can you direct me how to move forward. Any kind of help is appreciated.

[arnabdash]

Hi Gurpreet,

Can you help me with the code to be written in business rule. Also how to trigger scheduled import?

[pradeepshokeen]

Triggering of scheduled import will also be from business rule?

[Gurpreet07]

Yes.

[Gurpreet07]

Hi Arnab,

Write your code in async Business rule. Make sure to put suitable conditions in there.

The code used to trigger scheduled jobs works well with scheduled imports as well.

Creating a Scheduled Job - ServiceNow Wiki