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

asked 22 Feb, 01:14

jinkaizhang's gravatar image

jinkaizhang
111
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, 09:45

OF%20Collect's gravatar image

OF Collect ♦♦
1.0k4
accept rate: 14%

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, 01:11

jinkaizhang's gravatar image

jinkaizhang
111
accept rate: 0%

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, 12:45

OF%20Collect's gravatar image

OF Collect ♦♦
1.0k4
accept rate: 14%

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:

×165

question asked: 22 Feb, 01:14

question was seen: 276 times

last updated: 23 Feb, 12:45

Open Foris Support - 2014