Importing Metadata Failure | Community
Skip to main content
NormHadad31
NormHadad31
Level 2
July 31, 2024
Solved

Importing Metadata Failure

  • July 31, 2024
  • 1 reply
  • 920 views

I have been trying to add a .csv file to AEM DAM and I keep getting a failure due to "Job failed due to an exception(Required column assetPath not present in the sheet)." I looked at other posts and did what was suggested but it will NOT work. I've added a photo of what the document looks like. Do not understand the problem. I also have 166 lines and the max is 100. How do I get the other 66 to upload. 

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 diksha_mishra

@normhadad31  Please check the following:

1. The assets mentioned in the sheet are present in AEM DAM already. 

2. You are saving the file as CSV using below highlighted format only: 

I faced a similar issue because I was using CSV UTF-8 by mistake.

Please let me know if this helps.

 

1 reply

diksha_mishra
Community Advisor
diksha_mishraCommunity AdvisorAccepted solution
Community Advisor
August 1, 2024

@normhadad31  Please check the following:

1. The assets mentioned in the sheet are present in AEM DAM already. 

2. You are saving the file as CSV using below highlighted format only: 

I faced a similar issue because I was using CSV UTF-8 by mistake.

Please let me know if this helps.

 

    NormHadad31
    NormHadad31Author
    Level 2
    August 2, 2024

    I figured out the issue. Your direction was perfect. I did not see the file extension you mentioned because I am on a Mac. The format needed for Mac is Comma Separated Values (.csv). Mac assumes the (Comma Delimited) part of that file extension. I was able to upload the metadata successfully. Thank you for your direction.

     

      Terms & ConditionsAccessibility statement

      Loading footer...