+ Start a Discussion
Ikram Momin 16Ikram Momin 16 

I have a question regarding user migration from one org to other org. How Can I migration user from one tenant to other tenant using import /export wizard?

I have two Salesforce tenant, one has thousands of recodrs and other one is having few users. I wants to migration users from tenant1 to tenant 2 (All users active and inactive as well). I have exported users from tenant1 in csv file when trying to import this CSV it is asking to do mapping for accounts and contacts, what is the relation of users, accounts and contacts as I can see different CSV files in exported data? How to import user.csv directly using import wizard?

Following ellaboration might help:
  1. I have exported users from org1 (user.csv) which contains thousands of records.
  2. Now I am trying to import these users in Org2. 
  3. On Org2, in Data Import wizard when I am trying to import this user.csv. I am geeting option to import accounts and contacts by default. Please refer attached image.Default view for Import wizard
  4. I tried with this default option available and imported user.csv. But I see see accounts getting created in org2 but not users. 
  5. Where can I get option to import user insated of accounts and contacts? Importing users should dsiplay all imported users under manage Users page.
SwethaSwetha (Salesforce Developers) 
HI Ikram,

The Data Import Wizard only supports these standard Salesforce objects:  accounts, contacts, leads, solutions, campaign members, and person accounts. Users object is not listed here.(You can confirm this from the screenshot you shared too)

Reference: https://help.salesforce.com/articleView?id=data_import_wizard.htm&type=5

You can use DataLoader to import and export.
Please see: 
https://trailhead.salesforce.com/en/content/learn/projects/import-and-export-with-data-management-tools/use-data-loader-to-export-data
 
Hope this helps you. Please mark this answer as best so that others facing the
same issue will find this information useful.
 
Thank you
Ikram Momin 16Ikram Momin 16
Hi Swetha,

Thanks for your reply, that helps.

Thank you.
Ikram Momin 16Ikram Momin 16
Hi Swetha,

If we use datalaoder to import user.csv, does it import the users with same id as mentioned in user.csv or it will create diffrent unique Id for each user. Also user.csv conatisn Ids for Profileid and userRoleId; does it create recodrs for those roles and profiles as well?

Thanks in advance!!!
SwethaSwetha (Salesforce Developers) 
HI Ikram,
A new unique record Id will be created in the new Org for each user. The 

First, you will need to create the profiles and roles in the new Org and then map the Ids in the user.csv to import them. The profileid and userRoleId would also be unique in the new org.

Note: You'll need to import the records in a particular order to establish their relationships to one another. Record relationships are stored in Salesforce or defined by their IDs so you'll need to populate your import files with any newly created record's Salesforce Ids from the target org. The easiest way to do this is using Excel's VLOOKUP function to add the new record Ids to your files for import.

I would recommend you to review https://help.salesforce.com/articleView?id=000322219&language=en_US&type=1&mode=1 

https://help.salesforce.com/articleView?id=000326326&type=1&mode=1 
 
Hope this helps you. Please mark this answer as best so that others facing the
same issue will find this information useful.
 
Thank you
SwethaSwetha (Salesforce Developers) 
HI Ikram,
Have you been able to migrate the records? Do you have any follow-up queries based on information mentioned above. Thanks