AEM CSV Asset Importer

 

AEM CSV Asset Importer

 

Pairing AEM with tools from Adobe Consulting Services (ACS), the ACS AEM Commons helps to upload assets into AEM.

The CSV Asset Importer tool makes it easy to process large numbers of uploads to the DAM. First, you should make the raw assets available to AEM, which might involve copying them to a storage area on the server. This is an important step, because we would like to have minimal latency once we begin importing the assets into AEM. Then provide a CSV file explaining how those assets should be handled.

 

Benefits of migrating assets using CSV Asset importer

·        It makes the bulk upload relatively quick and easy, also has little to no impact on end users.

·        It helps to upload asset of any type i.e. Images, videos, pdf documents

·        It require no coding or any script to run.

·        Uploading csv file directly saves manual efforts of adding title, description, tags or any other details for asset.

·        Developers, authors, and even end users will not experience any other noticeable slowdown or interruption of service, even in a system that is live during the entire process.

 

Steps for AEM Asset upload using csv file:

Step 1: Install ACS AEM commons package

To use ACS tools, first we need to download and install ACS AEM commons package from below URL:

https://github.com/Adobe-Consulting-Services/acs-aem-commons/releases

Download and install latest package in CRX Package manager

Step 2: Creating csv file manually/extracting metadata from AEM to create csv:  

1.     Manual process of creating csv file

 2.     Extracting metadata from AEM to create csv file:

We have to query the AEM repository to extract asset metadata and creating csv file. For this, we have to use CRX API to access Java content repository nodes and store that data into csv.

 

Step 3: Make the raw assets available

This involve copying them to a storage area on the server/local repository.

Step 4: Using ACS AEM tools csv asset importer

Go to below URL:

http://localhost:4502/etc/acs-tools/csv-asset-importer.html

CSV asset Importer has two import strategies:

1.     Full: When selecting Full import strategy, the CSV Asset Importer will complete remove any matching existing assets.

 

2.     Delta: When selecting Delta import strategy, the CSV Asset Importer will attempt to update (and/or re-adjust) any existing asset before creating a net asset.

 

Step 5: Uploading csv file and providing Asset Path

Click Import Assets and check the status:

Step 6: Verify Asset upload

 

We can verify assets upload by going to assets path i.e. /content/dam/<folder-name>

To verify asset metadata upload, we can automate this process by re-creating csv file and comparing it with the file we uploaded earlier or by randomly verifying some assets.

 

Things to keep in mind:

·        There must be required access permissions to query CRX to extract metadata from it.

 

·        We need to check and verify existing asset upload workflows which must be running to upload assets.

 

·        We must have assets server path available where all assets are stored or must have permissions to download asset from AEM.