Level 3

Solved

How to bulk update metadata in AEM assets

Forum|Forum|2 years ago
February 10, 2023
3 replies
6251 views

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

Best answer by digarg17

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-export.html?lang=en

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.

krati_garg

Adobe Employee

@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/metadata-import-export.html?lang=en#

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?lang=en#update-asset-metadata

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

D

digarg17

Accepted solution

Adobe Employee

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-export.html?lang=en

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.

P

PovEim

Level 3

Hi,

I am dealing with a similar challenge of updating (creating metadata) for multiple assets. I am currently batching assets with similar description and visual references to folders. It will make it easier to batch update. Then I am exporting CSV with required to update properties. All would be kind of well but the problem is that the order of the list of assets in the CSV does not match the order list on AEM DAM. So I am unable to go down the list side by side - there is no match no matter how I sort the rows in CSV. That is a major slowdown in the process as I have to manually search for the asset of each row to enter the metadata based on visual references...

Data Importer - haven't tried it yet, but just like everything else in AEM DAM a simple process turns into a process that requires a degree in IT :D.

Has anyone developed a simple convenient method for batch editing the metadata (and by "developing" I do not mean "writing a script" as a dev 🙂 ).

Thanks

G

girishb83316758Author

Level 3

I got the solution from

https://experienceleague.adobe.com/docs/experience-manager-64/assets/administer/metadata-import-export.html?lang=en

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

H

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-export
But that would mean that all of my csv data from the old system would have to be adjusted, or is there another option?