Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Asset Metadata CSV Import Failing

harsingh91
Level 3
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,

AEM 6.5 AEM Assets Asset Metadata Asset Metadata. Assets
1 Accepted Solution
diksha_mishra
Correct answer by
Community Advisor
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
diksha_mishra
Correct answer by
Community Advisor
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

harsingh91
Level 3
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

diksha_mishra
Community Advisor
Community Advisor
Can you please share the sample file so that I can test? you can inbox me.
harsingh91
Level 3
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

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