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
jinkaizhang 21●2●32●35 accept rate: 0%
Accepted answer
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
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
answered
Stefano (OF) ♦♦ 5.7k●1●1●9 accept rate: 19%
Accepted answer
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
answered
jinkaizhang 21●2●32●35 accept rate: 0%
Accepted answer
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
answered
Stefano (OF) ♦♦ 5.7k●1●1●9 accept rate: 19%
Once you sign in you will be able to subscribe for any updates here
