Hi openforis, When we enter the data from collect desktop and collect mobile, actually where the data exist? I found sqlite db files in C:\Users\user\OpenForis\Collect\data\rdb. These data were generated by saiku. It is not the main data location. I want to know where the actual data exist thus it can be used for other purpose, if possible from my side. we can connect collect to postgress database. It was not human readable format in previous version. Is it possible now? Thank you very much.

asked 17 Dec '17, 11:34

Rajkumar's gravatar image

accept rate: 2%

Hi Rajkumar,
The db files under the rdb folder are not created by Saiku, but are created FOR Saiku by Collect from the Saiku section.
That DB files can be used even for other purposes because they have a standard relational structure.
With the default configuration of Collect the data is stored in a SQLite database located in: C:\Users\user\OpenForis\Collect\data\collect.db. In this version of Collect it's still in a not in a human readabale format, but in a binary one readable only by Collect. We started to work on a different system to store the data and it will be available soon early next year.
Many thanks,
Open Foris Team

permanent link

answered 17 Dec '17, 19:40

OF%20Collect's gravatar image

OF Collect ♦♦
accept rate: 23%

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: 17 Dec '17, 11:34

question was seen: 993 times

last updated: 17 Dec '17, 19:40