Content Hub

“Content about Content Hub” – EXPORTING and IMPORTING Excel data from/to Content Hub

In continuation of my blog series “Content about Content Hub” in this one, I will share how we can export and import data from Content Hub.

As described in my previous blogs, every asset consists of several custom properties. We can fetch all the associated data into excel by choosing an import/export option which is available under the Manage menu.

Manage Menu – Import / Export option

To achieve the same, we first need the data template to specify the field names that need to be part of the import. The same can be obtained by just exporting sample data from the content hub and customizing it (if required).

Three steps to import and export

Excel import/export consists of the following three steps –

1. Export Profiles

By default, the Content Hub exports all data fields and in certain scenarios we want only specific fields to be exported. So, here comes in picture the Export Profiles. If we don’t use the export profiles, the complete data will be exported without any filtration.

To create any export profile, the fields Name, Definition, Is Default and Settings need to be specified. We can specify properties, relations, and system properties that need to be exported through the Settings which is pictured below in an image.

While exposing Assets e.g. M.Asset and if there is a requirement to export the public links, the publicLinks property should be specified.

2. Enable Excel export

Content Hub provides a Selection Component that facilitates the creation of selections (the fields we want to export) along with custom actions on them. The toggle switch “Enable export to Excel” is provided to enable the export of selected items (that were specified in the export profile).

The following screenshot depicts the settings to be enabled :

NOTE: The export feature will not work if the Selection Component is not enabled.

3. Enable excel import
The Content Hub provides various options to create entities on a page. For e.g. we can use Upload files, New entities, Link items, Paste from Clipboard, and last but not least Import Excel. All these options are available on the Creation component.

Follow the given steps to enable the Creation component –

a. Open Pages portal (Menu Bar -> Manage -> Pages)

b. Create a page, click + Page.

c. On the created page go to Main zone, and click Add component.

d. In Add component dialog box, the option Creation component needs to be selected.

After the Creation component is selected, the following screen will be displayed where we can enable the Import Excel option as displayed on the left side navigation menu.

Creation component

Once you click on the Import Excel option and click on save, you will be presented with the following screen where you can specify the excel file to be imported.

Choose Import Excel from Create page, by clicking on Add button. Choose the file to be uploaded and click on Done. Then the import job gets triggered and the assets are created/modified. The added/modified assets in the overhead process can be verified by visiting the Assets page.

Concluding this now and I hope it was helpful. And if you are looking for the option to programmatically import/export, keep an eye on my next blog. In the meantime, please reach out to me for any

Did you find this useful? If so, please share with your connections.

Leave a Reply

Your email address will not be published. Required fields are marked *