How to apply tag to multiple assets in one go | Community
Skip to main content
Vani1012
Level 6
May 22, 2023
Solved

How to apply tag to multiple assets in one go

Hi All,

I have 10000 plus assets under "/content/dam/xxx", I want to apply a tag to all these assets.

Can anyone tell me the procedure?

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ShubhanshuSi2Accepted solution
New Participant
May 24, 2023

Hi @vani1012 , 
1. Write a query to fetch the desired assets. Example:

 

select * from [dam:Asset] as a where isdescendantnode(a, '/content/dam/xxx')

 

2. If you don't have any services implemented to get all asset paths in CSV try to utilize ACS AEM Commons Report Builder
and use the above query to fetch asset paths. Execute and Download the Report.
3. Now you may utilize the downloaded CSV in Metadata Import Tool, by providing appropriate headers and correct values in the tag property.

Alternatively, you can create a Job that uses keyset paginated queries to iterate over search results and apply tags to asset and commit in batches.

Resources:
Metadata Import Tool: Using Metadata Import and Export in AEM Assets | Adobe Experience Manager
Key Set Pagination: https://jackrabbit.apache.org/oak/docs/query/query-engine.html#keyset-pagination 

View reply

2 replies

ShubhanshuSi2Accepted solution
New Participant
May 24, 2023

Hi @vani1012 , 
1. Write a query to fetch the desired assets. Example:

 

select * from [dam:Asset] as a where isdescendantnode(a, '/content/dam/xxx')

 

2. If you don't have any services implemented to get all asset paths in CSV try to utilize ACS AEM Commons Report Builder
and use the above query to fetch asset paths. Execute and Download the Report.
3. Now you may utilize the downloaded CSV in Metadata Import Tool, by providing appropriate headers and correct values in the tag property.

Alternatively, you can create a Job that uses keyset paginated queries to iterate over search results and apply tags to asset and commit in batches.

Resources:
Metadata Import Tool: Using Metadata Import and Export in AEM Assets | Adobe Experience Manager
Key Set Pagination: https://jackrabbit.apache.org/oak/docs/query/query-engine.html#keyset-pagination 

Translate
    digarg17
    Employee
    May 22, 2023

    You can use metadata profile add that as a default tag and apply to your folder.

    Alternatively , export metadata excel of cq:tag , and your tag in excel for all rows and import it back.

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...