Import and export asset metadata in bulk
Adobe Experience Manager Assets lets you import asset metadata in bulk using a CSV file. You can do bulk updates for the recently uploaded assets or the existing assets by importing a CSV file. You can also ingest asset metadata in bulk from third-party system in CSV format.
The metadata import is asynchronous and does not impede system performance. Simultaneous update of the metadata for multiple assets can be resource-intensive because of XMP writeback activity if workflow flag is checked. Plan such an import during lean server usage so that performance for other users is not impacted.
To import metadata on custom namespaces, first register the namespaces.
- Navigate to the Assets user interface, and click Create from the toolbar.
- From the menu, select Metadata .
- In the Metadata Import page, click Select File . Select the CSV file with the metadata.
- Specify the following parameters. See a sample CSV file at metadata-import-sample-file.csv .Metadata import parametersDescriptionBatch SizeNumber of assets in a batch for which metadata is to be imported. Default value is 50. Maximum value is 100.Field SeparatorDefault value is , (a comma). You can specify any other character.Multi Value DelimiterSeparator for metadata values. Default value is | .Launch WorkflowsFalse by default. When set to true and default Launcher settings are in effect for the DAM Metadata WriteBack workflow (that writes metadata to the binary XMP data). Enabling launch workflows slows the system down.Asset Path Column NameDefines the column name for the CSV file with assets.
- Click Import from the toolbar. After the metadata is imported, a notification is displayed in Notification inbox.
- To verify correct import, navigate to an asset's Properties page and verify the values in the fields.
To add date and timestamp when importing metadata, use YYYY-MM-DDThh:mm:ss.fff-00:00 format for date and time. Date and time are separated by T , hh is hours in 24-hour format, fff is nanoseconds, and -00:00 is timezone offset. For example, 2020-03-26T11:26:00.000-07:00 is March 26, 2020 at 11:26:00.000 AM PST time.
If the date format does not match YYYY-MM-DDThh:mm:ss.fff-00:00 , the date values are not set. The date formats of exported metadata CSV file is in the format YYYY-MM-DDThh:mm:ss-00:00 . If you want to import it, convert it to the acceptable format by adding the nanoseconds value denoted by fff .
You can export metadata for multiple assets in a CSV format. The metadata is exported asynchronously and does not impact the performance of the system. To export metadata, Experience Manager traverses through the properties of the asset node jcr:content/metadata and its child nodes and exports the metadata properties in a CSV file.
A few use cases for exporting metadata in bulk are:
- Import the metadata in a third-party system when migrating assets.
- Share asset metadata with a wider project team.
- Test or audit the metadata for compliance.
- Externalize the metadata to localize it separately.
- Select the asset folder that contains assets for which you want to export metadata. From the toolbar, select Export metadata .
- In the Metadata Export dialog, specify a name for the CSV file. To export metadata for assets in subfolders, select Include assets in subfolders .
- Select the desired options. Provide a filename and if necessary a date.
- In the Properties to be exported field, specify whether you want to export all or specific properties. If you choose Selective properties to be exported, add the desired properties.
- From the toolbar, click Export . A message confirms that the metadata is exported. Close the message.
- Open the inbox notification for the export job. Select the job and click Open from the toolbar. To download the CSV file with the metadata, click CSV Download from the toolbar. Click Close .Figure: Dialog to download the CSV file containing metadata exported in bulk.
Best practices, limitations, and tips
- The CSV file for importing assets metadata is in a very specific format. To save effort and time and to avoid unintended errors, you can start creating the CSV using the format of an exported CSV file.
- When importing metadata using a CSV file, the required date date format is YYYY-MM-DDThh:mm:ss.fff-00:00 . If any other format is used, then the date values are not set. The date formats of exported metadata CSV file is in the format YYYY-MM-DDThh:mm:ss-00:00 . If you want to import it, convert it to the acceptable format by adding the nanoseconds value denoted by fff .
- To import metadata on custom namespaces, first register the namespaces.
- Property Picker displays properties that are used in schema editors and search forms. Property Picker does not pick metadata properties from an asset.