Importing data in csv to survey failed

  • Asked
  • Active
  • Viewed 3475 times
0

Dear OF team,

I tried to import data into my current survey and with most of the tables things worked well. At one table, I received the following error: https://drive.google.com/file/d/1sKuj4hDS-zGDQR4JxgAgbrCcXT-HRChO/view?usp=sharing

You can access the respective table via the follwing link: https://drive.google.com/file/d/1YbkH38HKi3FKdSOM2OOYd8H1F1AGkbrg/view?usp=sharing

Kind regards and thanks!

0

Accepted answer

Dear Lydia,
First of all in your CSV file there is character encoding problem... I can see only "?" instead of special characters... How did you generate the file? Modifying CSV files with software like Microsoft Excel can give you this kind of problems. I suggest you to save the file in Excel format and import it in Collect in this format, or modify the CSV file with software like Libre Office Calc. When you open the CSV file that is generated by Collect (or that from Collect Earth) you need to make sure to pick the UTF-8 encoding as this is the character encoding that Open Foris software uses bothfor reading and writing text files (sadly text files don't have this encoding information hard-coded in them so it has to be manually specified)

Another problem is that you have some "empty" rows, where you specified only the plot number and the reference point position but there are no values for the other attributes. This causes Collect to "skip" these rows and leads to a wrong evaluation of the row positioning. You should try to remove this empty rows and import the file again.

Let us know, many thanks.
Open Foris Team

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.