AEM Assets Bulk Metadata Export | Create Date | Community
Skip to main content
Nikhil_Verma
Nikhil_Verma
Level 4
October 14, 2022
Solved

AEM Assets Bulk Metadata Export | Create Date

  • October 14, 2022
  • 1 reply
  • 1147 views
We’re doing metadata update for numerous assets using the bulk metadata export feature in AEM Assets.
 
Apparently, the export doesn’t have any property for when the asset was uploaded/created in AEM. I would expect:
  • jcr:created
  • or dam:created
properties, but they aren’t there in the exported CSV. I’m exporting all properties.
Also, I noticed that the dam:created property is present for some assets but not for all. I believe this property exists as part of the asset file metadata and AEM simply extracted that metadata property. Since this property does not exist for all assets, we can't rely on this property.
 
Anyone used the feature and had a similar use case, or any workarounds?
 
We need the create date as part of the client's business process for updating bulk metadata. (The create date won't be updated, but it will be used to determine the metadata updates that will be made for the assets).
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 krati_garg

@nikhil_verma 

Your usecase might not be achieved with Bulk Metadata Export. 
- jcr:created property resides below Asset Node and not the Metadata Node.

-dam:created property is not a mandatory property which is not going to be populated everytime

There is another OOTB feature - Asset Reports, which exports Asset Data and not particularly Metadata, into CSV format. This encompasses all Asset Properties and gives you a provision to add custom properties as well. Find the link below
https://experienceleague.adobe.com/docs/experience-manager-learn/assets/advanced/asset-reports.html?lang=en


1 reply

krati_garg
Adobe Employee
krati_gargAdobe EmployeeAccepted solution
Adobe Employee
October 14, 2022

@nikhil_verma 

Your usecase might not be achieved with Bulk Metadata Export. 
- jcr:created property resides below Asset Node and not the Metadata Node.

-dam:created property is not a mandatory property which is not going to be populated everytime

There is another OOTB feature - Asset Reports, which exports Asset Data and not particularly Metadata, into CSV format. This encompasses all Asset Properties and gives you a provision to add custom properties as well. Find the link below
https://experienceleague.adobe.com/docs/experience-manager-learn/assets/advanced/asset-reports.html?lang=en


Nikhil_Verma
Nikhil_VermaAuthor
Level 4
October 14, 2022

Awesome idea @krati_garg !

1. I can get the upload report which has the jcr:created property, sort it with path column.

2. Then sort the export sheet with path. Both sheets will now be in same sequence.

3. From here I can copy thejcr:created column from the report sheet to the export sheet and use it for filtering for specific dates for updating metadata in the export sheet.

4. Finally, when all metadata updates are done, I'll remove the jcr:created column from the export sheet before uploading it back again to update metadata.

 

I gave this a quick try as well just now and seems reliable.

Thank you!

Terms & ConditionsAccessibility statement

Loading footer...