Importing content into DAM

on
The content hub offers a couple of ways to import content into the system. One of them is the upload by hand. A faster way is creating an import sheet with Excel.

Before you can use this feature it must be manually enabled in the configuration.
  1. Go to your Content Hub instance with a super user account.
  2. Go to the Management portal and select Pages
  3. Find the "Create" page and select the "Creation" component
  4. Flip the switch on "Import Excel" feature.
  5. Click on "SAVE AND CLOSE
It's now possible to select "Import Excel" on the creation page. Before you can start using your awesome import sheet, you'll need the know the rules.

  • The name of the sheet with the info must be called "M.Asset"
  • The following fields are required:
    • File
    • Title
    • FinalLifeCycleStatusToAsset
    • ContentRepositoryToAsset
  • The file contains a public accessible Uri to the file that you want to upload. It's important to note, that for every value that you use, the identifier should be used. The name of the value is not always the identifier of the value. This is especially the case when using taxonomy values, for example the lifecycle status. The identifier of the value "UnderReview" is "M.Final.LifeCycle.Status.UnderReview". This identifier must be used in the Excel sheet.
  • The table headers in green are not required fields. These fields are your custom fields that can be filled by the system.
Keep in mind that for each row a job is created to set the properties and fetch the image. After the image has been fetched the renditions executed in the background. It can take a couple of minutes for the image to show.

In the jobs overview you can find your import job and it status. When a row contains invalid information that can't be mapped for instance, the error message can be found in this log. Select the import job and open the log by click on the "i". An example error could be:
Error:
· Error processing row '4' for sheet M.Asset, error: 'SocialMediaChannel - Could not find option with identifier 'SocialMediaChannel.Facebook' in option list 'SocialMediaChannel'.'</br></br>
This means that the value of row 4 for the header "SocialMedialChannel" could not be mapped. You can manaully fix the error or remove the content and start over again.


Location: Hoofddorp, Nederland