Asset Metadata CSV Import Failing

[harsingh91]

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,

[diksha_mishra · Accepted solution]

@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.

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.

[harsingh91]

@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]

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

[harsingh91]

@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]

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