Forum Discussion

Sophie_Bruehl's avatar
Sophie_Bruehl
Iron Contributor
Apr 07, 2023

Error uploading file with sample data (EDM)

I am in the process of creating an EDM. However, I always get an error at step 2 "Define Schema" "Upload the sample file".

"First row must be the header row (containing column names). Column (field) names must start with a letter, be at least three characters long, and consist of only alphanumeric characters (A-Z, a-z, 0-9) and can't include spaces, underscores or other special characters."

This is despite the fact that my file should meet the requirements (see attachment). Can anyone help me?

Thank you in advance, Sophie 🙂 

  • I solved the issue by converting the csv-file into a tsv-file 🙂 

  • Hello Sophie

    It seems that you are trying to create an EDM and you are getting an error at step 2 "Define Schema" "Upload the sample file". The error message says "First row must be the header row (containing column names). Column (field) names must start with a letter, be at least three characters long, and consist of only alphanumeric characters (A-Z, a-z, 0-9) and can't include spaces, underscores or other special characters."²

    This error message indicates that the first row of your sample file must contain column names and that these column names must start with a letter, be at least three characters long, and consist of only alphanumeric characters (A-Z, a-z, 0-9) and can't include spaces, underscores or other special characters.

    If you have already done this and still get an error message, you can try running a validation against your CSV file before uploading it by running: EdmUploadAgent.exe /ValidateData /DataFile [data file] /Schema [schema file]³

    I hope this helps!
  • I solved the issue by converting the csv-file into a tsv-file 🙂 

Resources