Using PostgreSQL DB schema created with Collect for storing Collect Earth interpretations

  • Asked
  • Active
  • Viewed 5608 times
0

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.

0

Accepted answer

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

0

Accepted answer

Hi,

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)?
0

Accepted answer

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.

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.