How to import and supplement existing data

Dear Openforis Team

I have some questions about importing existing records: 1.) An existing dataset (excel file) contains information about plots(ID, coordinates...). How can I import this file and add additional columns (e.g. "Date")? 2.) A dataset (excel file) contains trees on different plots. Is it possible to import the list and add new trees on the same plots? The original tree ID and plot ID should be retained. New trees should automatically get an ID. 3.) Can already registered trees be identified with a plausibility check? Example: The current DHB must not be larger than the DHB measured 10 years ago.

Thanks for your support!

collect

asked 26 Mar '19, 11:37

Sabrina
63●7●34
accept rate: 0%

3 Answers:

active answers oldest answers newest answers popular answers

Dear Sabrina,
Have you tried to generate a "CSV data export/import template" from the Survey Designer? You can access this feature from the top right gear button.

csv data import/export template generation

It will generate a zip file containing empty CSV files that you can use as a template for the data import.
If you still have problems, we will contact you to your private email address.

As I already said, in order to solve the second issue you need to have some kind of validation rule that accesses records outside of the record being edited, and it's not available at the moment.
Many thanks.
Open Foris Team

permanent link

answered 28 Mar '19, 14:29

Stefano (OF) ♦♦
4.8k●1●1●9
accept rate: 19%

Dear Sabrina,
Let me answer in order:

In order to import an external dataset, you need first to define in your survey (in the entity where you will insert the new data) some new attributes with the same name as the name of the columns of the dataset, modify the dataset column values to be compatible with Collect (e.g. dates will have to be splitted in 3 colums, year, month and date, codes must be valid codes defined in the code list associated to the code attribute, and so on), then just import the file from Data Management / Import / From CSV (Excel)
yes, the import of the data does not overwrite existing records, unless you use identifiers for plots and trees that have been already used in the existing records
what do you mean exactly? Do you want to validate the trees against values contained in different records? Now you cannot perform such a validation in Collect, but we can think about it.

Many thanks,
Open Foris Team

permanent link

answered 27 Mar '19, 09:25

Stefano (OF) ♦♦
4.8k●1●1●9
accept rate: 19%

Dear Open Foris Team

Thanks for your support. I could insert data in a prepared schema, so point one and two is almost solved. But when I created an 1:N entity in the schema i got an error message, that I have to rename the columns in the excel file. An other error was, that the field names did not contain valid values. I tried to rename the column names but it still didn't work. To point 3: Trees that have already been recorded are visited again and measured. In order to identify them, a plausibility check should be carried out. If the BHD from 10 years ago has increased by more than 20 cm, it cannot be the right tree. Can this value be selected as a plausibility check?

permanent link

answered 28 Mar '19, 08:56

Sabrina
63●7●34
accept rate: 0%

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 ×494

question asked: 26 Mar '19, 11:37

question was seen: 2,702 times

last updated: 28 Mar '19, 14:29

How to import and supplement existing data

Follow this question

Related questions