Custom Export Profile in Sitecore Content Hub

By default, in Sitecore Content Hub when we export the Content Entity, the exported Excel file includes all the fields. It's quite confusing when we want to read, analyze, and perform any operation on the data.

The whole process uses Export Profile in the background. To export only specific fields into the Excel files we need to create a custom Export profile into Sitecore and Sitecore provides this functionality OOTB to create Custom Export profile.

The following steps describe how to create a custom export profile for Content Entity and enable that particular export profile on the selection component of the search page.

Create Export Profile:

1. Click on the manage icon, in the top right corner and choose the Export Profile option.

custom-export-profile-sc-ch-1

2. On the Export profile page, click on "+ Export Profile" and in the Export profile popup fill in the details:

custom-export-profile-sc-ch-2
  • Name: Name of the Export Profile
  • Definition: Entity Definition used for the Export Profile, I am selecting Content(M.Content)
  • Is Default: It makes it the default export profile. I am not selecting, as we enable it on the selection component of the search page on demand.
  • Settings: Define the properties, relations, and system properties to include in the export.

Example of an export profile:

To get the details of all the properties, Relations, and system properties, you can browse the entities by https://{your-content-hub-url}/api/entities/{entity-id} URL.

Set Custom Profile on Search Page:

1. Click on the manage icon, in the top right corner and choose the Profile option.

custom-export-profile-sc-ch-3

2. Go to the Search page and choose the Selection component.

custom-export-profile-sc-ch-4

3. On the Selection component page, click on the Export Excel setting tab, select "Add export profile", choose your custom export profile, and save.

custom-export-profile-sc-ch-5

4. Now when you export the entities from the search page it will export only the selected fields you defined into your custom export profile.

custom-export-profile-sc-ch-6

Happy Sitecoreing ðŸ˜Š

Comments

Popular posts from this blog

Sitecore Installation Error: Failed to Start Service 'Sitecore Marketing Automation Engine'

Import CSV Data in Sitecore Using PowerShell: Part-3

Sitecore : The database principal owns a schema in the database, and cannot be dropped message