Dear Open Foris Community,

We struggle with the following problem regarding Collect and later the data analysis of the collected data. We have a code list for habitat features of our trees and the field teams can choose up to 10 variables at the same time. The problem at the moment is that they are transferred into the database in the order they were clicked on in the field and not chronologically into the columns with the applicable numbers. Is there any easy solution to this? We just thought that it would be easier if we didn’t have to do this manually during the cleansing phase. This is what we would wish for it to look like. (see table 1) https://drive.google.com/drive/folders/0B1GL4ASXM8jjYmRYQVFzZGlTZ0E

At the moment it looks like this: (see table 2) https://drive.google.com/drive/folders/0B1GL4ASXM8jjYmRYQVFzZGlTZ0E

But of course we are open to other ideas to solve this issue, we assume others have struggled with similar attributes. Possibly our approach is overcomplicating the whole process.

Thank you for your help!

asked 14 Jun, 09:05

beka's gravatar image

beka
785
accept rate: 0%


Hi Beka!
In the exported csv file, a multiple code attribute is exported into several columns, each column corresponding to the position of the selected values (e.g. tree_habitat1 = first selected value, tree_habitat[2] = second selected value, tree_habitat[N] = Nth selected value...).
If you want to see the values in a different way, you can select among the Additional options of the CSV export Expand code attributes (add boolean columns for each code value).
The result will be a csv file with additional columns, one per each value of tree_habitat (e.g tree_habitat_1, tree_habitat_2) and true or false if the value has been selected or not.
csv data export additional options Thanks,
Open Foris Team

permanent link

answered 14 Jun, 11:48

OF%20Collect's gravatar image

OF Collect ♦♦
2.0k5
accept rate: 19%

Hello Beka,

I offer another solution. I assume that in your code list for habitat features there are more than 10 options. Anyway, create 10 (code) attributes for your entity, hab1..hab10. Set them as Not required, and add custom checks for hab2..hab10, as follows

alt text

alt text

alt text

I am missing the custom error message in this example but that you can add as needed.

This is not giving from Collect exactly that table what you are looking for, but in the data analysis you can get frequencies for categories in hab1..hab10 as necessary.

Regards, Lauri

permanent link

answered 14 Jun, 14:42

LauriV's gravatar image

LauriV
1912210
accept rate: 12%

Still as a comment: solution above is clumsy from the data entry point of view! It is lacking the advantage doing multiple selections at one time.

(14 Jun, 14:52) LauriV LauriV's gravatar image

Beka, OF Team programmer can help in that question regarding error message. I have - again - a bit different solution: add habitat selections into a calculated text field. This additional text field (Dist_txt below) can be set invisible (deselect Show in entry form). Use function shown below

alt text

alt text

When exporting the data into CSV, all selections goes into one field, which requires parsing in R or Excel.

-Lauri

permanent link

answered 14 Jun, 16:27

LauriV's gravatar image

LauriV
1912210
accept rate: 12%

Dear OF team, Thanks for your help. I tried to follow the instruction you sent and I faced on the following problem (see the link): https://drive.google.com/drive/folders/0B1GL4ASXM8jjYmRYQVFzZGlTZ0E

Thanks again, Best, Beka

permanent link

answered 14 Jun, 15:44

beka's gravatar image

beka
785
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

Question tags:

×272

question asked: 14 Jun, 09:05

question was seen: 220 times

last updated: 14 Jun, 16:27