Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

Asset Metadata CSV Import Failing

Avatar

Level 3

Hello Team,

 

When I am trying to import new asset metadata CSV, it is always failing with - Job failed due to an exception(Required column assetPath not present in the sheet).

To make sure all the fields are correct, first I exported the CSV, opened it, changed a field then trying to import the same CSV.

It always failing with the same error.

 

What can be the reason for it ?

 

Thanks in advance,

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@harsingh91 I faced this issue once, as the file extension was causing confusion for AEM.

There are multiple extensions available while saving the updated CSV file, make sure you check carefully and retry upload.

 

csv-format.png

 

If you still face any issues, refer to this help doc for header info: https://experienceleague.adobe.com/docs/experience-manager-64/assets/administer/metadata-import-expo... 

 

Hope this helps.

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

@harsingh91 I faced this issue once, as the file extension was causing confusion for AEM.

There are multiple extensions available while saving the updated CSV file, make sure you check carefully and retry upload.

 

csv-format.png

 

If you still face any issues, refer to this help doc for header info: https://experienceleague.adobe.com/docs/experience-manager-64/assets/administer/metadata-import-expo... 

 

Hope this helps.

Avatar

Level 3

@diksha_mishra , I specially taking care of that to have correct extension, even changed the text editor to make sure. But still CSV failing every time with the same error

Avatar

Community Advisor
Can you please share the sample file so that I can test? you can inbox me.

Avatar

Level 3

@diksha_mishra , just tried to sent you the message but got an error message "Message Sending Limit reached". Please confirm if you get it. Also I didn't find a way to attach a file in message

Avatar

Community Advisor
As discussed, here's the solution: the metadata headers were not marked in individual columns. Please mark this answer correct @harsingh