Print this page

How to Mass Update User License using Data Loader?

Knowledge Article Number 000199705
Description I would like to mass update user license using Data Loader but User License Field is not available when clicking on Create or Edit a Map.

User License field is not readily available in Mapping Dialog after clicking Create or Edit a Map button. Therefore, instead of using User License, get the Profile ID in which you're assigning the user. Since every Profile is tied up with a License, updating the profile will simultaneously update the license as well.

1. Get the User ID of the user you're updating by following these steps:

Report Tab | New Report Administrative Report | Users | Create | Remove All Columns | Fields from the preview pane | Add User ID and Full name fields to the preview pane | Save 
2. Get the profile ID in which you're assigning the user
Open Data Loader | Export | Check Show all Salesforce Object | Profile | Next | Select Id and Name from the query field | Finish
3. Organize the User ID and Profile ID in a spread sheet and save it as csv 
4. Use Data Loader 
Open Data Loader | Update | Show All Salesforce Objects | User | Choose csv file | Next | OK | Create or Edit a Map | Next | Map Profile ID (column header) with Profile Id and User ID with Id | OK |Select the directory where the success and error files should be saved, then click "Finish".


promote demote