CIS On-Demand Learning Lab: Dead End- Import CMDB Data

Mila Malinova
Tera Contributor

Hi folks, 

 

I am close to desperation :D. I am trying to pass one, one particular lab, which is preventing me to complete the CIS Training. I have to import data to ServiceNow. It contains three fields in Excel- 

Business ServiceServerRouter

 

For some reason, the simulator keeps telling me that I have to upload the servers, because for some reason they were not uploaded. 

Of course, I`ve checked the transform map- - -> I checked the transform table and it seems everything is uploaded. How is this even possible, that the other two are uploaded, for some reason only the Server tab containing - 6 servers are not uploaded. 

 

Any advise or someone who passed it, will be beneficial. 

 

Thanks in advance, 

Mila

2 ACCEPTED SOLUTIONS

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Mila Malinova 

 

Don't be sad or depressed, I think the excel contains 3 sheet named as 

Business Service Server Router

 

As per SN, Server is class and you need to upload data in Server class. If you provide instruction screenshot that wil lbe good. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

Hi @Mila Malinova 

 

AGLearnNGrow_0-1712220439456.png

 

This error is valid. What you can do

after creating the import set table, instead of doing 1-1 mapping ,use this 

AGLearnNGrow_1-1712220487654.png

 

It will map excel fields with Target table.

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

7 REPLIES 7

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Mila Malinova 

 

Don't be sad or depressed, I think the excel contains 3 sheet named as 

Business Service Server Router

 

As per SN, Server is class and you need to upload data in Server class. If you provide instruction screenshot that wil lbe good. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Screenshot 2024-04-02 224801.png

Hi @Mila Malinova 

 

AGLearnNGrow_0-1712220439456.png

 

This error is valid. What you can do

after creating the import set table, instead of doing 1-1 mapping ,use this 

AGLearnNGrow_1-1712220487654.png

 

It will map excel fields with Target table.

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Thanks a lot, Atul. You rock. How is that you know everything. ;D