Importing data to Collect

Do you have an example to demonstrate how the data can be imported into a existing Survey? I know the .csv file is only option, but i am not clear about how to format the csv file, especially when the survey has multiple entities/tables.

i checked the previous post "Best practice for importing large sets of inventory data", but it didn't help much.

Thanks

Jinkai

collect

asked 22 Feb '17, 01:14

jinkaizhang
21●25●35
accept rate: 0%

3 Answers:

active answers oldest answers newest answers popular answers

Hi Jinkai,
You can import the data one entity per time (starting from the root entity (the sampling unit) and then continue by importing data related to nested entities (e.g. if you have a structure like cluster -> plot -> tree you can start to import cluster.csv, then plot.csv and then tree.csv).
Otherwise you can put all the csv files you want to import and add them to a zip file to be imported into Collect: Collect will import every csv file following the hierarchy defined in the Schema).
Many thanks,
Open Foris Team

permanent link

answered 23 Feb '17, 12:45

Stefano (OF) ♦♦
4.7k●1●9
accept rate: 20%

Hello,

I just did one test. i exported the template as directed in your previous email. The ZIP file generated has 3 CSV files like cluster.csv, plot.csv and tree.csv. Do i need to import three times? Or Can I import just once if i can somehow construct one CSV file to include all the attributes from 3 CSV files?

Thanks,

Jinkai

permanent link

answered 23 Feb '17, 01:11

jinkaizhang
21●25●35
accept rate: 0%

Hi Jinkai,
When you are editing your survey in the Survey Designer, you have the possibility to generate a template for the CSV data import:
- click on the small gear button in the top right corner
- select Export CSV data import/export template
alt text
It will generate a ZIP file containing a template for every entity data you will need to import into Collect. The column names in this files will depend on the names of the attributes in your entities.
Many thanks,
Open Foris Team

permanent link

answered 22 Feb '17, 09:45

Stefano (OF) ♦♦
4.7k●1●9
accept rate: 20%

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

learn more about Markdown

Question tags:

collect ×493

question asked: 22 Feb '17, 01:14

question was seen: 3,854 times

last updated: 23 Feb '17, 12:45

Importing data to Collect

Follow this question

Related questions