---
schema_version: "1"
id: b6444ec6bf16bb4c547a20b0c0d505cec9a6dfef4d97c39f676ab4a824adcc66
title: Migrate Community Users Between Licenses
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/networks_migrate_users_between_licenses.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.networks_migrate_users_between_licenses.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 5a662a6fec95c70e5a08d290160f29c4232099f56c744768fdb9e40b384b9e39
description: You can move community users between certain licenses using Data Loader. For example, you can migrate users between the Customer Community Member and Customer Community Login licenses. Before moving a user to another license, set up a profile for the new license type you are moving the user to.
products:
  - Security
  - Salesforce Platform
release: "264"
---
# Migrate Community Users Between Licenses

You can move community users between certain licenses using Data Loader. For example, you can migrate users between the Customer Community Member and Customer Community Login licenses. Before moving a user to another license, set up a profile for the new license type you are moving the user to.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

Migrating users to different licenses applies to the following scenarios.

- Between the Customer or Partner Community and Customer Community Login or Partner Community Login licenses
- Between the Customer Portal or Partner Portal and Customer Community or Partner Community licenses
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-access-264-0-0-production-enus/a92be132-3cbc-412a-9262-130636120c14/images/icon_note.png)
    
    Note Making this change results in admin work and requires the creation of a new user record.
- Between the Customer Community and Customer Community Plus licenses
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-access-264-0-0-production-enus/a92be132-3cbc-412a-9262-130636120c14/images/icon_note.png)
    
    Note Make sure that you want to give Customer Community users the more advanced sharing options available to Customer Community Plus users.

Step 1: Export the User Report

1. Log in to Data Loader.
2. Click **Export**.
3. Click **Next**.
4. Select the **User (User)** object.
5. For the extraction target, enter users.csv.
6. Click **Next**.
7. Select the query fields **Id** and **ProfileId**.
    1. For Fields, select **IsActive**.
    2. For Operator, enter equals.
    3. For Value, enter true.
    4. Click **Add Condition**.
8. Add another condition.
    1. For Fields, select **AccountId**.
    2. For Operator, enter not equals.
    3. Leave Value blank.
    4. Click **Add Condition**.
9. The generated query is `Select Id, ProfileId FROM User WHERE IsActive = true AND AccountId != 'null'`.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-access-264-0-0-production-enus/a92be132-3cbc-412a-9262-130636120c14/images/icon_note.png)
    
    Note You can copy and paste the query from this step.
10. Click **Finish**.
11. Click **Yes**.

Step 2: Query Permission Set IDs

1. In Data Loader, click **Export**.
2. Click **Next**.
3. Select **Show all Salesforce Objects**.
4. Select the **Permission Set (PermissionSet)** object.
5. For the extraction target, enter permissionsets.csv.
6. Click **Next**.
7. Choose the query fields **Label** and **Id**.
8. The generated query is `SELECT Label,Id FROM PermissionSet`.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-access-264-0-0-production-enus/a92be132-3cbc-412a-9262-130636120c14/images/icon_note.png)
    
    Note You can copy and paste the query from this step.
9. Click **Extract**.
10. Click **OK**.

Step 3: Query the Permission Set Assignments

1. In Data Loader, click **Export**.
2. Click **Next**.
3. Select **Show all Salesforce Objects**.
4. Click **Next**.
5. Select the **Permission Set Assignments (PermissionSetAssignment)** object.
6. For the extraction target, enter permissionsetassignment.csv.
7. Click **Next**.
8. Copy the following query from this Help topic and paste it into the generated query box: `SELECT AssigneeId,Id,PermissionSetId FROM PermissionSetAssignment WHERE Assignee.UserType IN ( 'PowerPartner','PowerCustomerSuccess','CspLitePortal')`.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-access-264-0-0-production-enus/a92be132-3cbc-412a-9262-130636120c14/images/icon_note.png)
    
    Note PowerPartner is the Partner Community license, PowerCustomerSuccess is the Customer Community Plus license, and CspLitePortal is the Customer Community license. Add or remove the licenses based on your query needs.
9. Click **Finish**.
10. Click **Yes**.

Step 4: Query Profile IDs

1. In Data Loader, click **Export**.
2. Click **Next**.
3. Select **Show all Salesforce Objects**.
4. Click **Next**.
5. Select the **Profile (Profile)** object.
6. For the extraction target, enter profiles.csv.
7. Click **Next**.
8. Copy the following query into the generated query box: `SELECT Name,UserLicense.Name,Id FROM Profile WHERE UserType IN ( 'PowerPartner','PowerCustomerSuccess','CspLitePortal')`.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-access-264-0-0-production-enus/a92be132-3cbc-412a-9262-130636120c14/images/icon_note.png)
    
    Note PowerPartner is the Partner Community license, PowerCustomerSuccess is the Customer Community Plus license, and CspLitePortal is the Customer Community license. Add or remove the licenses based on your needs.
9. Click **Finish**.
10. Click **Yes**.

Step 5: Update User Profiles

1. Open the users.csv file you created.
2. Rename the ProfileID column to OldProfileId.
3. Add a column named ProfileID.
4. In the new ProfileID column, add the profile ID that you want to move the user to using the profiles.csv file as your guide.
5. Save the users.csv file.
6. Open Data Loader, and click **Update**.
7. Select the **User (User)** Salesforce object.
8. Select the **users.csv** file.
9. Click **Next**.
10. Map the ProfileId field to the Profile ID column, and map the Id field to the User ID column.
    
    ![Mapping](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-access-264-0-0-production-enus/a92be132-3cbc-412a-9262-130636120c14/access/images/networks_mapping.png)
    
    ![Warning](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-access-264-0-0-production-enus/a92be132-3cbc-412a-9262-130636120c14/images/icon_warning.png)
    
    Warning This step deletes all permission set assignments for these users. Before performing these updates, make sure that you’ve saved the permissions to the permissionsetassignment.csv file. Otherwise, you lose all history of which permission sets your site users had.
11. Click **Next**.
12. Click **Finish**.

Step 5: Insert Permission Set Assignments

1. Open the permissionsetassignment.csv file.
2. Rename the PermissionSetId column to OldPermissionSetId.
3. Add a column named PermissionSetId.
4. In the new PermissionSetId column, add the permission set ID that you want to move the user to using the permissionsetassignment.csv file as your guide.
5. Save the permissionsetassignment.csv file.
6. Open Data Loader, and click **Insert**.
7. Select the **Permission Set Assignment (PermissionSetAssignment)** Salesforce object.
8. Select the **permissionsetassignment.csv** file.
9. Click **Next**.
10. Map the PermissionSetId field to the PermissionSetId column, and map the Id field to the User ID column.
11. Click **Next**.
12. Click **Finish**.