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

[Gurpreet07]

Hi Pradeep,

Refer below link

http://wiki.servicenow.com/index.php?title=Importing_Data_Using_Import_Sets#gsc.tab=0

[pradeepshokeen]

Thanks Gurpreet for the Link!!! I am assuming this link would explain how we can use Imports set tables to load the data from excel sheet, here my series of actions are different.

1. Change Requester would mentione the litst of CI's in a specific formatted excel sheet (that's gonna be affected by this change) and upload it as an attachment into a change record.

2. All these CI would be checked in the CMDB, if they are available it is going to be related to this change in the affected CI table.

Also I may be incorrect here but I am assuming I would have to leverage the sys_attachment or sys_attachment_doc tables to read the attachments but I am still looking for functions that I can use to fetch/read the data from excel columns.

Thanks,

Pradeep

[Gurpreet07]

Hi Pradeep,

Here's the possible solution for this.

1. The attachment should have a fixed template and have details of change request number in it.Header names should not be different in future attachments.

2. Create a data source and scheduled import for this data source.

3. Create a transform map where all the logic resides to relate Change with a record entry from excel.... target table should be task_ci.

3. From change request record, in a business rule or ui action ... write a script to copy attachment to data source.

4. Trigger the scheduled import.

[Geoffrey2]

I have implemented exactly this solution for a client about 4 months ago, and it works well.