Hi, we would like to connect Aggregate with a relational database (everything is currently in excel) can anyone recommend a good (free or cheap) realtional database that we can link to, or easily automate transfer data to? We would like to build queries and run calculations based on the data.
Thanks!
Google Fusion Tables https://support.google.com/fusiontables/answer/2571232
is a relational database that is provided by Google and is free or largely
free.
You can set up a publisher in ODK Aggregate to publish data into Google
Fusion Tables. https://opendatakit.org/use/aggregate/data-transfer/
If you need to keep your data private and not potentially visible to Google
(e.g., HIPPA rules), then you would need to host your ODK Aggregate or
other collection server somewhere other than Google AppEngine or use
encrypted forms. If you use encrypted forms (or not), ODK Briefcase can
export CSV files of your data, which you can then upload into most any
database system.
w.r.t. databases -- if you don't already know the names of the leading free
databases, then you probably will have a difficult time installing and
running one yourself. If you do want to run your own database, MySQL and
PostgreSQL are both free, or have "community editions" that are free.
Hi, we would like to connect Aggregate with a relational database
(everything is currently in excel) can anyone recommend a good (free or
cheap) realtional database that we can link to, or easily automate transfer
data to? We would like to build queries and run calculations based on the
data.Thanks!
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Hello,
We had the same requirement, and found the best bet was to
You can also look at hosting Aggregate not on App Engine and then
connect to the underlying MySQL/PostgreSQL DB and use reporting tools
like Periscope, Pentaho, etc.
Yaw
On Wed, Dec 2, 2015 at 12:19 AM, Mitch Sundt mitchellsundt@gmail.com wrote:
Google Fusion Tables https://support.google.com/fusiontables/answer/2571232
is a relational database that is provided by Google and is free or largely
free.You can set up a publisher in ODK Aggregate to publish data into Google
Fusion Tables. https://opendatakit.org/use/aggregate/data-transfer/If you need to keep your data private and not potentially visible to Google
(e.g., HIPPA rules), then you would need to host your ODK Aggregate or other
collection server somewhere other than Google AppEngine or use encrypted
forms. If you use encrypted forms (or not), ODK Briefcase can export CSV
files of your data, which you can then upload into most any database system.w.r.t. databases -- if you don't already know the names of the leading free
databases, then you probably will have a difficult time installing and
running one yourself. If you do want to run your own database, MySQL and
PostgreSQL are both free, or have "community editions" that are free.On Tue, Dec 1, 2015 at 7:28 AM, bvodkdemo@gmail.com wrote:
Hi, we would like to connect Aggregate with a relational database
(everything is currently in excel) can anyone recommend a good (free or
cheap) realtional database that we can link to, or easily automate transfer
data to? We would like to build queries and run calculations based on the
data.Thanks!
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Please can I have a look at a sample trigger statement that sends data into
the relational database tables from the ODK Aggregate submitted form.
Hello,
We had the same requirement, and found the best bet was to
- host our own aggregate server using Postgres as the backend database
- write triggers on the Aggregate tables to post data from submitted
forms directly to the relational structureOn Tuesday, 1 December 2015 17:28:12 UTC+2, bvod...@gmail.com wrote:
Hi, we would like to connect Aggregate with a relational database
(everything is currently in excel) can anyone recommend a good (free or
cheap) realtional database that we can link to, or easily automate transfer
data to? We would like to build queries and run calculations based on the
data.Thanks!
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/v3OkMdnzNqA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
i have a successful ODK Aggregate linked to my postgresql database. The problem i have is that after filling the form using ODK collect and sending it to the database, the sent file goes into the database as a table. what i want is for the sent file to go into the database linking to each relational data table inside the table
I don't understand:
"what i want is for the sent file to go into the database linking to each
relational data table inside the table"
If you want the data stored as XML files and not parsed and broken out into
columns, look at ona, formhub or other server implementations that use a
document store.
i have a successful ODK Aggregate linked to my postgresql database. The
problem i have is that after filling the form using ODK collect and sending
it to the database, the sent file goes into the database as a table. what i
want is for the sent file to go into the database linking to each
relational data table inside the table--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
i mean, after filling the form on odk collect n sending it to the Aggregate
database(POSTGRESQL) it goes as a single file(view capture 1 image,file
name BUILD_PARLIAMENT_DATA_1452855084_CORE). what i want is for the record
to store into the existing tables in Capture2
like sect_agriculture,tbl_beneficiary,tbl_funding,tbl_project(these tables
are linked to each other with primary and foreign key constraints)
_* _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ *
Senyo Aborgah
GIS Database Analyst/IT Support Officer
eMapping and Innovations Coordinator
Center for Remote Sensing and Geographic Information Services (CERSGIS)
University of Ghana, Legon
Accra - Ghana
www.cersgis.org http://www.cersgis.org/
I don't understand:
"what i want is for the sent file to go into the database linking to
each relational data table inside the table"If you want the data stored as XML files and not parsed and broken out
into columns, look at ona, formhub or other server implementations that use
a document store.On Fri, Jan 15, 2016 at 6:32 AM, senyoab@gmail.com wrote:
i have a successful ODK Aggregate linked to my postgresql database. The
problem i have is that after filling the form using ODK collect and sending
it to the database, the sent file goes into the database as a table. what i
want is for the sent file to go into the database linking to each
relational data table inside the table--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/v3OkMdnzNqA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Aggregate does not have mechanisms to write data into tables other than the
ones that it creates and maintains.
Database triggers, or periodic database scripts, can be used to write data
from the ODK Aggregate tables into other tables that you maintain.
Sorry for the confusion. I find it useful to use Google Translate
https://translate.google.com/ when writing a question or answer. Translate
it. Then take the translation and re-translate it back into your native
language, and re-write your question until the double-translation makes
sense.
i mean, after filling the form on odk collect n sending it to the
Aggregate database(POSTGRESQL) it goes as a single file(view capture 1
image,file name BUILD_PARLIAMENT_DATA_1452855084_CORE). what i want is for
the record to store into the existing tables in Capture2
like sect_agriculture,tbl_beneficiary,tbl_funding,tbl_project(these tables
are linked to each other with primary and foreign key constraints)_* _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ *
Senyo Aborgah
GIS Database Analyst/IT Support Officer
eMapping and Innovations Coordinator
Center for Remote Sensing and Geographic Information Services (CERSGIS)
University of Ghana, Legon
Accra - Ghanawww.cersgis.org http://www.cersgis.org/
On Fri, Jan 15, 2016 at 7:14 PM, Mitch Sundt mitchellsundt@gmail.com wrote:
I don't understand:
"what i want is for the sent file to go into the database linking to
each relational data table inside the table"If you want the data stored as XML files and not parsed and broken out
into columns, look at ona, formhub or other server implementations that use
a document store.On Fri, Jan 15, 2016 at 6:32 AM, senyoab@gmail.com wrote:
i have a successful ODK Aggregate linked to my postgresql database. The
problem i have is that after filling the form using ODK collect and sending
it to the database, the sent file goes into the database as a table. what i
want is for the sent file to go into the database linking to each
relational data table inside the table--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/v3OkMdnzNqA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
