Import Set

Rooma1
Tera Contributor

Hi All,

 

How can we update the user's manager as well when we are importing user data via import set? how can we map the User's manager with the user in the table?

 

Thanks,

Rooma

8 REPLIES 8

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Rooma1 

 

I tried this way 

- Downloaded the table field from list view

- Where iget all fields including manager

- Add the record in excel

- Loaded data

- Run transform map

(make sure manager value exits in User table)

 

LearnNGrowAtul_0-1708089266646.png

 

*************************************************************************************************************
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]

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

@Dr Atul G- LNG Thanks for the answer, but if the Manager field is having the userID then?

HI @Rooma1 

 

OOTB it take name, not user ID

 

I tried at here is error:

 

LearnNGrowAtul_0-1708089687210.png

 

*************************************************************************************************************
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]

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

@Dr Atul G- LNG I have uploaded the excel with the userID in the manager column and the Manager field got updated in the sys_user table. It didn't throw error for me.

 

Rooma1_0-1708091817141.png