function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jonathan Crow 6Jonathan Crow 6 

Inserting Users via Workbench Fails Because ProfileID not Mapped

I am using Workbench to Insert Users. I have the CSV set and ready to go, however when I try to map the ProfileID field in my CSV to the ProfileID field that Salesforce provides I don't see ProfileID on their list anywhere. But after trying to upload I get an error message that: Required Fields Are Missing: [ProfileId]
Best Answer chosen by Jonathan Crow 6
VinayVinay (Salesforce Developers) 
Hi Jonathan,

Try to check below permission on profile.

>> View All Users.
>> API Enabled.

Also try to compare with system admin profile if you still see error once you enable above permissions.

Below are URL for your reference.

https://help.salesforce.com/articleView?id=users_profiles_view_all_mod_all.htm&type=5
https://help.salesforce.com/articleView?language=en_US&type=1&mode=1&id=000332385

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Vinay Kumar

All Answers

VinayVinay (Salesforce Developers) 
Hi Jonathan,

Seems like you are missing to upload mandatory ProfileID in your file.

Please find below attached screenshot which you can see in workbench. Include profile id in your spreadsheet and it should fix the error.

User-added image

Try to execute query in your developer console so that you can get profile id's of user's.

SELECT Id, Name, Email, Profile.Name, UserRole.Name,ProfileId FROM User.

Review below link to have more information on how to 'Insert Users with Data Loader'.

https://help.salesforce.com/articleView?id=000327115&type=1&mode=1 (https://help.salesforce.com/articleView?id=000327115&type=1&mode=1)

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Vinay Kumar
Jonathan Crow 6Jonathan Crow 6
So the ProfileID is included in the CSV file, just not in the list of fields available from SFDC. In working with someone else I suspect I don't have proper permissions and that is the reason I don't see the field. Still working on it...
VinayVinay (Salesforce Developers) 
Hi Jonathan,

Try to check below permission on profile.

>> View All Users.
>> API Enabled.

Also try to compare with system admin profile if you still see error once you enable above permissions.

Below are URL for your reference.

https://help.salesforce.com/articleView?id=users_profiles_view_all_mod_all.htm&type=5
https://help.salesforce.com/articleView?language=en_US&type=1&mode=1&id=000332385

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Vinay Kumar
This was selected as the best answer