How to bulk update metadata in AEM assets

[girishb83316758]

Hello Team,

I want to update metadata for 10, 000 assets in AEM

What is the best way to update metadata for bulk no. Of assets at once or in batch wise?

Thanks

[krati_garg]

@girishb83316758 Assuming that you are on AEMaaCS, then

Bulk Import Tool is the best way to go. However, it has a limitation of Batch Size of 100 that needs to be figured out.

https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/assets/admin/metada...

Another way is to use Assets HTTP API, creating a mapping file, writing a script to automate the metadata update:

https://experienceleague.adobe.com/docs/experience-manager-65/assets/extending/mac-api-assets.html?l...

https://github.com/leachuk/aem-asset-upload

However, if it is AEM On Prem, consider using ACS Commons CSV Importer

https://adobe-consulting-services.github.io/acs-aem-tools/features/csv-asset-importer/index.html

[digarg · Accepted solution]

for AEM Cloud - You would need to use AEMaaCS OOTB Bulk Importer or use aem-upload npm module

. Bulk importer should work fine if you can manually export and update metadata in the csv and re-import metadata using OOTB feature.

node based aem-upload library - if you want to do it programmatically or need to push this from an external source/script.

https://experienceleague.adobe.com/docs/experience-manager-learn/assets/metadata/metadata-import-exp...

https://www.npmjs.com/package/@adobe/aem-upload

for AEM Onpremise/AMS - use Data importer ACS AEM Commons

under AEM MCP tools.

Though CSV importer is also an option but that is mostly replaced by ACS AEM Commons Data Importer  as stated in ACS public docs.

[girishb83316758]

I got the solution from 

https://experienceleague.adobe.com/docs/experience-manager-64/assets/administer/metadata-import-expo...

First exported metadata of all assets in folder. Select the folder which has assets. From toolbar select metadata export. It gives CSV file.

Secondly, I edited CSV file with metadata required. And imported this file in asset.

It processed 100 files in a batch.

Thanks

[HetalJoshi]

Your original message said that you wanted to update 10,000 assets. Bulk CSV importer lets you import only 100 in a batch. How did you update all 10,000? 

[svpix]

Our customer tried to integrate the assets using bulk import. Unfortunately, the limitation is very limited and it takes a long time for the data to be uploaded.

In any case, the customer has a total of 100,000 assets, mainly images and a few documents.

The alternative solution was to upload using the Adobe Experience Manager Desktop App. Unfortunately, there is no way to include the metadata like with bulk import.

So my question now is, is it possible to add the metadata for the assets afterwards? The data is in a csv or xml.

I also looked at the import here https://experienceleague.adobe.com/en/docs/experience-manager-learn/assets/metadata/metadata-import-...
But that would mean that all of my csv data from the old system would have to be adjusted, or is there another option?

[diksha_mishra]

@svpix please post this as a new question in the Assets community for better tracking and answer purposes.