Export User Profile in Sitecore Content Hub

We are aware of the export of the Content and Asset entities in Content Hub, but no such OOTB option is available to export the User profiles. This requires customization. In this blog post, I explain how we can export the User profiles in Sitecore Content Hub. 

Step 1: Create a Custom Export Profile

See the blog post about the detailed steps on How you can create a Custom Export Profile in Sitecore Content Hub, Refer to the Export Profile Section.

For exporting the user profile use the following export Profile script:

In the above example, I am exporting ID, Identifier, Username, UserGroup, Module, and System Properties. You can customize it as per your requirements.

Step 2: Create a Custom Export Page:

1. Click on the Manage icon and choose the Pages option.
2. Click on the Plus icon and create a new blank page.
3. Provide a name, leave other fields as it is, and click on save.

Step 3: Add the component to the Page:

1. Click on the Export User Profile Page in the left panel.
2. In the right panel, click on the “+ component” to add the Selection and Search components, and make sure to set the visible property to true. 

Step 4: Set Selection component Properties:

1. Click on the Selection component to set the properties.
2. On the “General setting” tab enable the “Enable export to Excel” properties to activate this tab.
3. On the “Operations” tab add “User” to the definition.
4. On the “Export Excel settings” tab add the “User” definition and add a custom export profile i.e. “User Profile”.
5. Click the save and close button.

Step 5: Set Search component Properties:

1. Click on the Search component to set the properties.
2. On the “Filters” tab add “User” to the definition.

3. On the “Functionality” tab choose the “Sorting”, “Paging” and “Selection” options to activate it.
4. On the “Selection” tab choose the selection pool drop-down and create a new selection pool, I named it “ExportUserProfiles”.
5. On the Output tab, enable the Table option and disable the Grid option. In the Table option select the TableNoImage option in the right panel and add the following fields in the fields section in the right panel.

6. Click the save and close button.

Step 6: Browe the Page and export user profiles:

1. Go to the Pages, click on three dots, and choose the View page option.

2. Choose Selection All, click on Export to Excel, and download the exported user profiles.

Happy Sitecoreing 😊