Forum Discussion
Solved
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)...
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!
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!