Export image data

Forum|Forum|1 year ago
March 22, 2024
3 replies
2075 views

I want to export a list of image file names and their corresponding UUID values. Is there a way to do this in AEM? Thank you.

Best answer by Adilos-Cantuerk

Hi @frameexpert , just to be save - I wanted to @you to make sure you see the reply 😄

Adilos-Cantuerk

New Participant

The simplest way I have found was:
Go to the report functionality - in tools:assets:reports -
Then create a "files" report that includes assetpath - and a custom property.
In the custom property you can choose jcr:uuid.

from assetpath, you can extract the filename - and the custom property will contain the UUID.

Adilos-CantuerkAccepted solution

New Participant

Hi @frameexpert , just to be save - I wanted to @you to make sure you see the reply 😄

frameexpertAuthor

New Participant

Yes, thank you. I am waiting for my client to run some tests. I will follow up afterwards. Thank you.

Kamal_Kishor

New Participant

@frameexpert : Another little tedious way is by means of a query. This could be useful when we have to perform filtering (for images only for eg.) of assets or some operation on those dam assets programmatically.

You can run below query on your AEM instance and it will give you assets from we-retail dam path (you can change the path and properties etc. as per your need obviously). This will give you a json response, which you can view in your browser or copy into a file for further analysis.

http://localhost:4502/bin/querybuilder.json?path=/content/dam/we-retail&type=dam:Asset&p.hits=selective&p.properties=jcr:uuid%20jcr:content/metadata/dc:title&p.limit=-1

You can customize it further to filter by specifying the property name and their values. For eg: below query will return dam:Asset which has mime-type of image/png or image/jpeg

http://localhost:4502/bin/querybuilder.json?path=/content/dam/we-retail&type=dam:Asset&property=jcr:content/metadata/dam:MIMEtype&property.1_value=image/png&property.2_value=image/jpeg&p.hits=selective&p.properties=jcr:uuid%20jcr:content/metadata/dc:title&p.limit=-1

Please refer the documentation from Adobe for more details-

thanks.