Export/Backup Companies and Users

[Carlos52]

Hi everyone,

I need to backup all the users and companies in my instance, due to some changes that might modify/delete some of them.

I assumed the best way would be to export the user/company list, however the excel file does not have all the necessary info  (like the sys_id of the users or the groups of the users) - so when I change something and try to import if fails.

If I export to an xml file I saves more info, but I'm not able to import it due to the type of file.

Am I suposed to do this another way? Could you help me understand it?

Thanks in advance for you help.

[Mark Roethof]

Hi there,

"If I export to an xml file I saves more info, but I'm not able to import it due to the type of file."

Can you explain this a bit more? Normally you should just be able to import an XML.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Abhay Kumar1 · Accepted solution]

Hi Carlos, Best way is to export XML and import xml. I believe you are navigating to 'System Imports sets-> load data' where you can use only CSV,XLS & XLSX file.

please follow this , Open any list view of any table and right click on any column and select import xml (refer attachment as an example) & import.

Yes for user data you will be needed to take xml of sys_user, sys_user_group & sys_user_has_role tables.

Hope this will help you.