How to update records from Excel sheet

Sunny45 · ‎05-21-2021

Hello Team,

I have some 12K records which needs to be updated on cmdb_ci_computer table. They belong to various classes (e.g. Servers, Desktops, Laptops). I have host name, and status (Status Needs to be updated) in Excel. What is my best option to update these records?

Can this be done using script?

Please advise with all steps.

Thanks.

Prasad Dhumal · ‎05-21-2021

I Will suggest you to execute this on 10-15 Records first, to see that you are getting your perfect output or not. DO NOT PERFORM THIS ON 12K RECORDS DIRECTLY.

1) Navigate to System Import Sets > Load Date. Create Staging Table and Upload Excel sheet > Submit

2) Navigate to "Create Transform Map"

3) Select Target table is Computer[cmdb_ci_computer] and save. So you will get option for Field Mapping.

4) Make sure you are mapping fields correctly, Use Field Maps

5) Run Script should be checked

6) Configure the script according to your requirement. Refer the script which I've provided.

7) Click on Transform

Please tell us if you face any issues.

Thanks

View solution in original post

Sunny45 · ‎05-23-2021

Excellent solution Prasad. That really worked well.

Thanks a ton. 🙂

Sunny.

Prasad Dhumal · ‎05-23-2021

Glad to help 🙂

Sweety5 · ‎05-25-2021

Hi ,

Can you please attach screenshot of your excel sheet .

Thanks

Sunny45 · ‎05-27-2021

Hi Sweety,

Here it is.