Hi Everyone!

I tried to use PostgreSQL instead of SQLite to manage my collect database. I made all the necessary changes to the configuration xml and connected collect to my PostgreSQL server running on localhost. Everything went smooth up to here. My question is Why I am not able to find any database table of survey data in that Schema ("collect" in postgresql )? I got many (around 28) database tables in that schema but I did not find tables of any data I have entered from the published Survey in collect? Doesn't collect start to create database tables as soon as we start entering data from collect desktop? Does anyone have better idea on this?

Pardon me if this is too dumb question to be asked!!

Thanks on advance Milan

asked 23 Aug '16, 16:57

dhunganamilan's gravatar image

accept rate: 0%

Hi Milan,
The table you are looking for is called ofc_record (the prefix ofc stays for Open Foris Collect...), under the schema Collect. Every record (a cluster or a plot, depending on your survey...) corresponds to a row in that table. You can see different interesting columns... key1, key2, key3 contain the values of the key attributes and will help you to find a record. Data1 and data2 contain the actual collected data. They are binary columns and the only way to read the real data is to use Collect. This can be seen as a limit, because the only way to read and modify the data is to use the application, but it makes the process of reading and writing of the records very fast... even if we cannot guarantee that we won't change the way the data is stored into the database soon... This fact of having the data in a sort of "black box" sometimes makes the things more difficult to manage even for us.
If you need to see and work with the raw data, you can use Collect to export it to CSV or to a relational database.
I hope that now everything looks a bit clearer.
For more information about the structure of the database, please have a look to the documentation we have on GitHub.
Many thanks,
Open Foris Team

permanent link

answered 23 Aug '16, 17:13

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
accept rate: 20%

Hello Stefano,

Thank you for a clear explanation. I hope this 'black box' kind of thing will be changed soon.


permanent link

answered 24 Aug '16, 09:42

dhunganamilan's gravatar image

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



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:


question asked: 23 Aug '16, 16:57

question was seen: 4,964 times

last updated: 24 Aug '16, 09:42