Collect: Problem to import CSV

  • Asked
  • Active
  • Viewed 9475 times
0

Hi all,

I am starting to think, I might be useless, as I can't import my csv file including the sampling point data. Please help! Maybe I just got a tiny detail wrong, nonetheless I can't figure this out. I believe I am doing everything according to the instructions...

This is an extract of my csv file:

level1_code,“x“,“y“,“srs_id“,“province“,“region“,“slope“,“exposition“

1,“358322“,“4654371“,“EPSG:32638“,“Kharagauli“,“Imereti“,,

2,“355919“,“4657187“,“EPSG:32638“,“Kharagauli“,“Imereti“,,

3,“359615“,“4656395“,“EPSG:32638“,“Kharagauli“,“Imereti“,,

4,“360405“,“4656982“,“EPSG:32638“,“Kharagauli“,“Imereti“,,

However, I keep getting this error msg when trying to import: row 1 Missing required columns, required columns are: level1_code,x,y,srs_id

Please help!!

best regards!

0

Accepted answer

Hi, I created a CSV file by copying and pasting the text of your message. I had to replace the double quotes with the correct symbol (") and the import completed successfully. Could it be that the problem? You can even try to import an Excel file, without converting it into CSV.
Thanks.
Open Foris Team

0

Accepted answer

Hi Ricci,

thanks for trying to help. However, I did the same as you (copying my text and replacing the double quotes with "the correct symbol", meaning I copied and pasted the symbol you have given in parentheses ("), to no avail however. I keep getting the same error message.

I would like to know, in what exactly my table/text differs from the sampling-design-import-example.xls?

Thanks again!

0

Accepted answer

Hi again,

I just tried to import the given example file (mentioned above) and I get the same error message. Please clarify if this is a bug or if the problem is on my side.

Thanks

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

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.