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!

asked 06 May '19, 07:39

Lydia's gravatar image

Lydia
31313
accept rate: 0%


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

permanent link

answered 10 May '19, 09:47

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.7k19
accept rate: 20%

edited 10 May '19, 10:32

Open%20Foris's gravatar image

Open Foris ♦♦
9995714

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×493

question asked: 06 May '19, 07:39

question was seen: 2,020 times

last updated: 10 May '19, 10:32