Columns in CSV do not match survey

  • Asked
  • Active
  • Viewed 7409 times
0

Hello,

I was trying to import plot data into Collect Earth (using the Collect Earth options panel). I always got the error saying "Columns in CSV do not match survey". Even though i got the error, the plot data can still be imported into Collect Earth. I am not sure what the issue is .

here is a portion of the csv file:

id,ycoord,xcoord,ele,slop,aspect 0,56.58899,-113.76972,108.43495,0.75489,0 1,56.58899,-113.66972,296.56506,1.06752,0 2,56.58899,-113.56972,108.43495,0.75489,0 3,56.58899,-113.46972,90,0.47745,0 4,56.58899,-113.36972,-9999,0,0 5,56.58899,-113.26972,78.69007,1.21712,0 6,56.58899,-113.16972,78.69007,1.21712,0 7,56.58899,-113.06972,239.03624,1.39176,0 8,56.58899,-112.96972,135,0.33761,0 9,56.58899,-112.86972,135,5.38598,0 10,56.48899,-113.76972,291.03751,3.32143,0 11,56.48899,-113.66972,63.43495,1.06752,0 12,56.48899,-113.56972,-9999,0,0 13,56.48899,-113.46972,18.43495,3.01696,0 14,56.48899,-113.36972,78.69007,1.21712,0 15,56.48899,-113.26972,225,0.33761,0 16,56.48899,-113.16972,225,0.33761,0 17,56.48899,-113.06972,63.43495,1.06752,0 18,56.48899,-112.96972,326.30994,1.72101,0

thanks,

Jinkai

asked

jinkaizhang 21●2●32●35 accept rate: 0%

0

Accepted answer

Dear Jinkai,
You can try to generate the "template" for the CSV data import from the Survey Designer (you can find this function among the Advanced Functions in the top right corner of the survey edit page):
alt text
You can compare the template with the file you are trying to import and check if there are any differences (please not that you have to respect the same column names that are in the template).
Thanks,
Open Foris Team

permanent link

answered

Stefano (OF) ♦♦ 5.6k●1●1●9 accept rate: 18%

0

Accepted answer

In this specific case, after reviewing, it seems that the column names (the first line in the CSV) do not match the names of the variables in the survey.

id,ycoord,xcoord,ele,slop,aspect

Probably ele should be elevation and slop should have been slope.

If there are no columns names then the check is not performed.

permanent link

answered

Open Foris ♦♦ 1.1k●5●7●14 accept rate: 10%

0

Accepted answer

Thanks. After i changed column names to id,YCoordinate,XCoordinate,elevation,slope,aspect, it worked fine.

Good Day,

Jinkai

permanent link

answered

jinkaizhang 21●2●32●35 accept rate: 0%

Your answer

Insert an image

Say what the image shows, for people who can't see it.
At least 50 characters

Powered by the Open Foris edition of OSQA Content licensed under CC BY-SA 3.0

This Q&A software is free and open source (GPL). Any organisation can run it for its own community: get the code and instructions at github.com/openforis/osqa.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.