Hello Open Foris team,

I have a CSV file with data from a previous survey and I would like to create a Collect survey from it.

I would like to import the data from the CSV in order to be able to analyse it through Saiku, it is a great product for analysis! Also I would like to use Collect for the second round of data collection for this survey

Is there an easy way to do this or do I need to manually create the survey??

Thanks!

asked 13 Oct '16, 23:55

collector's gravatar image

collector
2671626
accept rate: 0%


In the Survey Designer it's possible to generate a survey starting from a CSV or Excel file.

First you have to create a new blank survey, then start to edit it and got to the top right corner where the Advanced functions are and select Import attributes from Excel/CSV file; you will be asked to specify in which entity you want to define the new attributes. The column names of the CSV file will be used to define the attribute names and Collect will try to guess the attribute type according to the content of the columns (you can convert later every attribute to a different type if needed).

alt text

alt text

Optionally you can define attribute labels in the second row of the CSV file and select the option Labels in second row before starting the import!!! This way the first row will contain the names of the attributes and the second will contain the labels (what you see in the forms)

IMPORTANT:

if you have 3 CSV files like cluster.csv, plot.csv and tree.csv that correspond to a hierarchical structure of entities cluster/plot/tree, first you have to define the entities cluster (sampling unit), plot and tree, then you can import the attributes in each of these entities.
EXAMPLE:

id,region,land_use,distance
"ID of plot","Region", "Land Use in the center of the plot", "Distance to road"
1,Umbria,Forest,10
2,Lazio,Forest,1
...

Thanks,
Open Foris Team

permanent link

answered 14 Oct '16, 09:39

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

Stefano (OF) ♦♦
4.8k119
accept rate: 19%

edited 14 Oct '16, 10:13

Open%20Foris's gravatar image

Open Foris ♦♦
1.0k5714

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:

×494
×42

question asked: 13 Oct '16, 23:55

question was seen: 10,698 times

last updated: 14 Oct '16, 10:13