I was wondering, whether it would be possible to use DB schema “collect” created with application Collect connected to PostgreSQL, directly for storing Collect Earth interpretations? It seems that both DB schemes (created by Collect and Collect Earth) have the same structure.

asked 15 May '18, 07:08

jurafejfar's gravatar image

accept rate: 0%

edited 15 May '18, 07:09

The answer is: yes. Collect and Collect Earth use the same database schema.
Open Foris Team

permanent link

answered 17 May '18, 09:49

OF%20Collect's gravatar image

OF Collect ♦♦
accept rate: 23%


thank you very much, that sounds great! Is this covered by any manual? I found and tested only separate functionality:

synchronizing the survey project through .cep file. If both applications can share the same DB, it should be possible to:

  1. Install Collect and connect it to PostgreSQL according to the manual. This will create DB with schema collect.
  2. Develop survey project using Collect GUI. Changes in survey project will be stored in the database. I will not export survey to .cep.
  3. Install Collect Earth and set up connection to the existing DB? This will not create its own DB on start? I will not import survey from .cep.
  4. Do CE interpretation of plots, which will be saved into DB created in step 1. Is it necessary to somehow set privileges (looks like collect is handling user roles in application not using DB users)?
permanent link

answered 17 May '18, 10:13

jurafejfar's gravatar image

accept rate: 0%

edited 17 May '18, 10:16

I have personally not tested this approach ut it should work.

Collect Earth does not create a DB or schema, they should have been previously created.

You should import the survey in Collect Earth, otherwise it will not know "what to do"

You should not need to create any special privileges...

Let us know if it works.

permanent link

answered 19 May '18, 09:10

collectearth's gravatar image

collectearth ♦
accept rate: 18%

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: 15 May '18, 07:08

question was seen: 1,616 times

last updated: 19 May '18, 09:10