Ability to Upload Bulk CI's from SPREADSHEET / CSV FILE in a Change Request ?

[gargharshdeep]

System should have the ability to   Upload Bulk CI's from SPREADSHEET / CSV FILE in a Change Request ?

• Provide preformatted spreadsheet template for user to populate and allow CIs to be loaded via SS / CSV file

• Pop up message to note how many CIs were matched against CMDB and loaded to the list (only load CIs that are in the CMDB)

• Would be nice if somehow the user could find out which CIs on their SS/CSV file didn't load.

[PeterWiles]

Hi there,

ServiceNow can't read the contents of attachments on the form view. Off the top of my head, I would suggest:

1. Create a script to create a new data source and copy the attachment to the data source. Then run the transform. You would then be able to use the transform output to confirm any failures.

2. Why not create a form on the portal to add the change details instead of the spreadsheet. This will ensure the user can only select CIs in the system already.

3. Take advantage of the proposed change options when adding CIs to the change request. The requester can enter the amendments directly on the CI. These can then be approved by the change manager/co-ord allowing audit of changes and saving any manual labor.   https://wiki.servicenow.com/index.php?title=Managing_CI_Changes

Of course, it all depends your processes and what the end goal is.

Pete

[gargharshdeep]

Hello Pete,

Thank you so much for your response. They want to upload the data from CSV file only. Do you have script for it ? Thanks

[PeterWiles]

No, that was just a thought so you would need to piece it together.

I know on the wiki there is a script that shows you how to move an attachment to another record. Then running a transform against that data to the required table. You would need to get your code hat on to do the rest.

Pete