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

How to apply tag to multiple assets in one go

  • May 22, 2023
  • 2 replies
  • 2323 views

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.
Best answer by ShubhanshuSi2

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 

2 replies

D
Adobe Employee
digarg17Adobe Employee
Adobe 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.

    S
    Community Advisor
    ShubhanshuSi2Community AdvisorAccepted solution
    Community Advisor
    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 

      Terms & ConditionsAccessibility statement

      Loading footer...