Forum Discussion
Sophie_Bruehl
Apr 07, 2023Iron Contributor
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 🙂
- Tarot_resolutionCopper ContributorHello 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! - Sophie_BruehlIron Contributor
I solved the issue by converting the csv-file into a tsv-file 🙂