Multi-user form access permissions through Aggregate

Hello everyone

Current set up: Using postgres,tomcat,odk

Situation: I currently have a ongoing project form in aggregate and just
recieved another project that will be utilizing odk as well.

Concern: I do not want my client from one project to be able to view a form
I have for another client. Is there anyway to have a Multi-user form access
permissions through Aggregate, keeping certain forms available to certain
logins?

Second Concern: Now that I will be implementing two projects through odk is
there anyway to administer multiple ODK Databases in postgres as opposed
to setting up a separate ODK Aggregate server for each collection project

1 Like

There is no multi-project setup inside Aggregate. The easiest way to
solve this problem is to setup two copies. You can do that with two
individual machines or two virtual machine or two WARs (use different
ports or different war names) pointing to two database schemas (use
different names and different logins).

ยทยทยท On Thu, Dec 20, 2012 at 10:03 AM, Jason Wheatley wrote: > Hello everyone > > Current set up: Using postgres,tomcat,odk > > Situation: I currently have a ongoing project form in aggregate and just > recieved another project that will be utilizing odk as well. > > Concern: I do not want my client from one project to be able to view a form > I have for another client. Is there anyway to have a Multi-user form access > permissions through Aggregate, keeping certain forms available to certain > logins? > > Second Concern: Now that I will be implementing two projects through odk is > there anyway to administer multiple ODK Databases in postgres as opposed > to setting up a separate ODK Aggregate server for each collection project > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en

Jason,

I am not aware of a safe way to effectively host multiple projects/clients
within a single Aggregate instance.

However, I have had some success running multiple Aggregate server
instances side-by-side, by configuring them as separate Tomcat virtual
servers with configuration files that point to different databases. This
kind of set-up, however, may require tuning of Java virtual-machine
settings (for more memory). The tuning parameters were discussed on the ODK
developer's group within the last month or two.

This type of set-up has allowed me to host projects for multiple clients,
and it seems like it can safely scale for many more. It is resource-heavy,
but it has the nice property that different clients are fully sandboxed and
can run different Aggregate versions within their respective sandboxes.

Best,

Chris

ยทยทยท On Thu, Dec 20, 2012 at 5:03 PM, Jason Wheatley wrote:

Hello everyone

Current set up: Using postgres,tomcat,odk

Situation: I currently have a ongoing project form in aggregate and just
recieved another project that will be utilizing odk as well.

Concern: I do not want my client from one project to be able to view a
form I have for another client. Is there anyway to have a Multi-user form
access permissions through Aggregate, keeping certain forms available to
certain logins?

Second Concern: Now that I will be implementing two projects through odk
is there anyway to administer multiple ODK Databases in postgres as
opposed to setting up a separate ODK Aggregate server for each collection
project



--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

I'm wondering if there is an update to this thread, specifically whether
there are plans to make ODK Aggregate accommodate multiple projects.
We had a local install of Formhub which was suiting our needs but opted to
replace it with ODK Aggregate given the moribund nature of Formhub;
but lumping all research data in the same space with no control over who
sees what is really not feasible.
Does anyone have any advice beyond what is contained in this thread?

Wayne

ยทยทยท On Thursday, December 20, 2012 at 10:03:26 AM UTC-5, Jason Wheatley wrote: > > Hello everyone > > Current set up: Using postgres,tomcat,odk > > Situation: I currently have a ongoing project form in aggregate and just > recieved another project that will be utilizing odk as well. > > Concern: I do not want my client from one project to be able to view a > form I have for another client. Is there anyway to have a Multi-user form > access permissions through Aggregate, keeping certain forms available to > certain logins? > > Second Concern: Now that I will be implementing two projects through odk > is there anyway to administer multiple ODK Databases in postgres as > opposed to setting up a separate ODK Aggregate server for each collection > project > >

We had considered per-form permissions management (which you would need to
effectively run isolated environments for multiple clients), but the
complexity it would bring to the Site Admin / Permissions page was deemed
too burdensome for a casual user to administer.

Requiring a system admin to configure and deploy separate WAR files on
their system, pointing to separate databases, provides the isolation you
seek. One benefit of this is that you do not need to drag your existing
customers forward should a new customer need a feature in the
latest-and-greatest server version. Each customer runs in an isolated
independent copy that can be updated separately (or not) baed upon that
customer's requirements for stability and new features.

The separate databases are not much of an issue, except perhaps on Google
AppEngine, since they are still managed through a single management console
(e.g.,pgAdmin III, MySQL Workbench).

Basically, the configuration to support multiple clients moves to the
surrounding tools, virtual machines and environment, and out of the core
ODK Aggregate functionality.

Mitch

ยทยทยท On Thu, Dec 20, 2012 at 7:35 AM, Christopher Robert wrote:

Jason,

I am not aware of a safe way to effectively host multiple projects/clients
within a single Aggregate instance.

However, I have had some success running multiple Aggregate server
instances side-by-side, by configuring them as separate Tomcat virtual
servers with configuration files that point to different databases. This
kind of set-up, however, may require tuning of Java virtual-machine
settings (for more memory). The tuning parameters were discussed on the ODK
developer's group within the last month or two.

This type of set-up has allowed me to host projects for multiple clients,
and it seems like it can safely scale for many more. It is resource-heavy,
but it has the nice property that different clients are fully sandboxed and
can run different Aggregate versions within their respective sandboxes.

Best,

Chris

On Thu, Dec 20, 2012 at 5:03 PM, Jason Wheatley century.gis@gmail.comwrote:

Hello everyone

Current set up: Using postgres,tomcat,odk

Situation: I currently have a ongoing project form in aggregate and just
recieved another project that will be utilizing odk as well.

Concern: I do not want my client from one project to be able to view a
form I have for another client. Is there anyway to have a Multi-user
form access permissions through Aggregate, keeping certain forms
available to certain logins?

Second Concern: Now that I will be implementing two projects through odk
is there anyway to administer multiple ODK Databases in postgres as
opposed to setting up a separate ODK Aggregate server for each collection
project



--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Nope.

Survey CTO and other hosting providers offer this.

ยทยทยท On Wed, May 4, 2016 at 10:16 AM, Wayne Johnston wrote:

I'm wondering if there is an update to this thread, specifically whether
there are plans to make ODK Aggregate accommodate multiple projects.
We had a local install of Formhub which was suiting our needs but opted to
replace it with ODK Aggregate given the moribund nature of Formhub;
but lumping all research data in the same space with no control over who
sees what is really not feasible.
Does anyone have any advice beyond what is contained in this thread?

Wayne

On Thursday, December 20, 2012 at 10:03:26 AM UTC-5, Jason Wheatley wrote:

Hello everyone

Current set up: Using postgres,tomcat,odk

Situation: I currently have a ongoing project form in aggregate and just
recieved another project that will be utilizing odk as well.

Concern: I do not want my client from one project to be able to view a
form I have for another client. Is there anyway to have a Multi-user
form access permissions through Aggregate, keeping certain forms
available to certain logins?

Second Concern: Now that I will be implementing two projects through odk
is there anyway to administer multiple ODK Databases in postgres as
opposed to setting up a separate ODK Aggregate server for each collection
project

--
--
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

Failing that, any other options for a locally-installed data storage platform?
Research Ethics is not comfortable with hosted solutions.

Wayne

Wayne Johnston
University of Guelph Library
wajohnst@uoguelph.ca
519 824 4120 x56900

ยทยทยท ----- Original Message -----

From: "Mitch Sundt" mitchellsundt@gmail.com
To: "ODK Community" opendatakit@googlegroups.com
Sent: Wednesday, May 4, 2016 1:21:49 PM
Subject: Re: [ODK Community] Re: Multi-user form access permissions through Aggregate

Nope.

Survey CTO and other hosting providers offer this.

On Wed, May 4, 2016 at 10:16 AM, Wayne Johnston < wajohnst@uoguelph.ca > wrote:

I'm wondering if there is an update to this thread, specifically whether there are plans to make ODK Aggregate accommodate multiple projects.
We had a local install of Formhub which was suiting our needs but opted to replace it with ODK Aggregate given the moribund nature of Formhub;
but lumping all research data in the same space with no control over who sees what is really not feasible.
Does anyone have any advice beyond what is contained in this thread?

Wayne

On Thursday, December 20, 2012 at 10:03:26 AM UTC-5, Jason Wheatley wrote:

Hello everyone

Current set up: Using postgres,tomcat,odk

Situation: I currently have a ongoing project form in aggregate and just recieved another project that will be utilizing odk as well.

Concern: I do not want my client from one project to be able to view a form I have for another client. Is there anyway to have a Multi-user form access permissions through Aggregate, k eeping certain forms available to certain logins?

Second Concern: Now that I will be implementing two projects through odk is there anyway to administer multiple ODK Databases in postgres as opposed to setting up a separate ODK Aggregate server for each collection project

--

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 .

If you need this, the solution is to run the ODK Aggregate installer
multiple times with different database names, and copy the WAR files onto
your server with different names, as, e.g.,

project1.war (accessing project1 database)
project2.war (accessing project2 database)
...

These will each expand to be under
http://yourserver.org/project1 ,
http://yourserver.org/project2 ,
etc.

Then admin each separately.

The databases would run under one common database server (the MySQL
database server program can expose multiple databases within it).

See other posts for sizing the server that would run all of this.

The assumption here is that a tablet configured to talk to project1 would
not be able to also submit forms to project2 (you would wipe the tablet and
install configuration for project2 when it came time to use it for
project2).
From a data security standpoint, this makes sense -- you would not want the
data collectors for project1 to see the data from project2.

If you don't care about the data collectors seeing all of the data, and you
need them to collect data for both project1 and project2 at the same time,
then you can instead host everything in one ODK Aggregate and set up
publishers to external servers that hold the specific subsets of data that
you want individuals to see. Or you can use ODK Briefcase to download the
data and put CSVs on network shares that researchers with the appropriate
permissions can download.

ยทยทยท On Wed, May 4, 2016 at 10:25 AM, Wayne Johnston wrote:

Failing that, any other options for a locally-installed data storage
platform?
Research Ethics is not comfortable with hosted solutions.

Wayne

Wayne Johnston
University of Guelph Library
wajohnst@uoguelph.ca
519 824 4120 x56900


*From: *"Mitch Sundt" mitchellsundt@gmail.com
*To: *"ODK Community" opendatakit@googlegroups.com
*Sent: *Wednesday, May 4, 2016 1:21:49 PM
*Subject: *Re: [ODK Community] Re: Multi-user form access permissions
through Aggregate

Nope.

Survey CTO and other hosting providers offer this.

On Wed, May 4, 2016 at 10:16 AM, Wayne Johnston wajohnst@uoguelph.ca wrote:

I'm wondering if there is an update to this thread, specifically whether
there are plans to make ODK Aggregate accommodate multiple projects.
We had a local install of Formhub which was suiting our needs but opted
to replace it with ODK Aggregate given the moribund nature of Formhub;
but lumping all research data in the same space with no control over who
sees what is really not feasible.
Does anyone have any advice beyond what is contained in this thread?

Wayne

On Thursday, December 20, 2012 at 10:03:26 AM UTC-5, Jason Wheatley wrote:

Hello everyone

Current set up: Using postgres,tomcat,odk

Situation: I currently have a ongoing project form in aggregate and just
recieved another project that will be utilizing odk as well.

Concern: I do not want my client from one project to be able to view a
form I have for another client. Is there anyway to have a Multi-user
form access permissions through Aggregate, keeping certain forms
available to certain logins?

Second Concern: Now that I will be implementing two projects through odk
is there anyway to administer multiple ODK Databases in postgres as
opposed to setting up a separate ODK Aggregate server for each collection
project

--
--
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.

--

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

1 Like

Thanks, Mitch.
Unfortunately it's an awful lot of overhead to initiate a new instance for every project that comes along with countless instances that would have to be maintained every time there's a new release of the code.
Formhub made it so easy to simply give each project its own discrete account.

Wayne

Wayne Johnston
University of Guelph Library
wajohnst@uoguelph.ca
519 824 4120 x56900

ยทยทยท ----- Original Message -----

From: "Mitch Sundt" mitchellsundt@gmail.com
To: "ODK Community" opendatakit@googlegroups.com
Sent: Wednesday, May 4, 2016 1:57:17 PM
Subject: Re: [ODK Community] Re: Multi-user form access permissions through Aggregate

If you need this, the solution is to run the ODK Aggregate installer multiple times with different database names, and copy the WAR files onto your server with different names, as, e.g.,

project1.war (accessing project1 database)
project2.war (accessing project2 database)
...

These will each expand to be under
http://yourserver.org/project1 ,
http://yourserver.org/project2 ,
etc.

Then admin each separately.

The databases would run under one common database server (the MySQL database server program can expose multiple databases within it).

See other posts for sizing the server that would run all of this.

The assumption here is that a tablet configured to talk to project1 would not be able to also submit forms to project2 (you would wipe the tablet and install configuration for project2 when it came time to use it for project2).
From a data security standpoint, this makes sense -- you would not want the data collectors for project1 to see the data from project2.

If you don't care about the data collectors seeing all of the data, and you need them to collect data for both project1 and project2 at the same time, then you can instead host everything in one ODK Aggregate and set up publishers to external servers that hold the specific subsets of data that you want individuals to see. Or you can use ODK Briefcase to download the data and put CSVs on network shares that researchers with the appropriate permissions can download.

On Wed, May 4, 2016 at 10:25 AM, Wayne Johnston < wajohnst@uoguelph.ca > wrote:

Failing that, any other options for a locally-installed data storage platform?
Research Ethics is not comfortable with hosted solutions.

Wayne

Wayne Johnston
University of Guelph Library
wajohnst@uoguelph.ca
519 824 4120 x56900

From: "Mitch Sundt" < mitchellsundt@gmail.com >
To: "ODK Community" < opendatakit@googlegroups.com >
Sent: Wednesday, May 4, 2016 1:21:49 PM
Subject: Re: [ODK Community] Re: Multi-user form access permissions through Aggregate

Nope.

Survey CTO and other hosting providers offer this.

On Wed, May 4, 2016 at 10:16 AM, Wayne Johnston < wajohnst@uoguelph.ca > wrote:

I'm wondering if there is an update to this thread, specifically whether there are plans to make ODK Aggregate accommodate multiple projects.
We had a local install of Formhub which was suiting our needs but opted to replace it with ODK Aggregate given the moribund nature of Formhub;
but lumping all research data in the same space with no control over who sees what is really not feasible.
Does anyone have any advice beyond what is contained in this thread?

Wayne

On Thursday, December 20, 2012 at 10:03:26 AM UTC-5, Jason Wheatley wrote:

Hello everyone

Current set up: Using postgres,tomcat,odk

Situation: I currently have a ongoing project form in aggregate and just recieved another project that will be utilizing odk as well.

Concern: I do not want my client from one project to be able to view a form I have for another client. Is there anyway to have a Multi-user form access permissions through Aggregate, k eeping certain forms available to certain logins?

Second Concern: Now that I will be implementing two projects through odk is there anyway to administer multiple ODK Databases in postgres as opposed to setting up a separate ODK Aggregate server for each collection project

--

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 .

--

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 .

Then consider SurveyCTO

That's what they do. That's why they are worth the $$s.

If you absolutely need this in ODK Aggregate, the only option is to pay
many $100k's to add it into the codebase.

But, for nearly all needs, SurveyCTO fees will be cheaper than paying
anyone to write the many extra layers of code to accomplish this.

ยทยทยท On Wed, May 4, 2016 at 11:14 AM, Wayne Johnston wrote:

Thanks, Mitch.
Unfortunately it's an awful lot of overhead to initiate a new instance for
every project that comes along with countless instances that would have to
be maintained every time there's a new release of the code.
Formhub made it so easy to simply give each project its own discrete
account.

Wayne

Wayne Johnston
University of Guelph Library
wajohnst@uoguelph.ca
519 824 4120 x56900


*From: *"Mitch Sundt" mitchellsundt@gmail.com
*To: *"ODK Community" opendatakit@googlegroups.com
*Sent: *Wednesday, May 4, 2016 1:57:17 PM

*Subject: *Re: [ODK Community] Re: Multi-user form access permissions
through Aggregate

If you need this, the solution is to run the ODK Aggregate installer
multiple times with different database names, and copy the WAR files onto
your server with different names, as, e.g.,

project1.war (accessing project1 database)
project2.war (accessing project2 database)
...

These will each expand to be under
http://yourserver.org/project1 ,
http://yourserver.org/project2 ,
etc.

Then admin each separately.

The databases would run under one common database server (the MySQL
database server program can expose multiple databases within it).

See other posts for sizing the server that would run all of this.

The assumption here is that a tablet configured to talk to project1 would
not be able to also submit forms to project2 (you would wipe the tablet and
install configuration for project2 when it came time to use it for
project2).
From a data security standpoint, this makes sense -- you would not want
the data collectors for project1 to see the data from project2.

If you don't care about the data collectors seeing all of the data, and
you need them to collect data for both project1 and project2 at the same
time, then you can instead host everything in one ODK Aggregate and set up
publishers to external servers that hold the specific subsets of data that
you want individuals to see. Or you can use ODK Briefcase to download the
data and put CSVs on network shares that researchers with the appropriate
permissions can download.

On Wed, May 4, 2016 at 10:25 AM, Wayne Johnston wajohnst@uoguelph.ca wrote:

Failing that, any other options for a locally-installed data storage
platform?
Research Ethics is not comfortable with hosted solutions.

Wayne

Wayne Johnston
University of Guelph Library
wajohnst@uoguelph.ca
519 824 4120 x56900


*From: *"Mitch Sundt" mitchellsundt@gmail.com
*To: *"ODK Community" opendatakit@googlegroups.com
*Sent: *Wednesday, May 4, 2016 1:21:49 PM
*Subject: *Re: [ODK Community] Re: Multi-user form access permissions
through Aggregate

Nope.

Survey CTO and other hosting providers offer this.

On Wed, May 4, 2016 at 10:16 AM, Wayne Johnston wajohnst@uoguelph.ca wrote:

I'm wondering if there is an update to this thread, specifically whether
there are plans to make ODK Aggregate accommodate multiple projects.
We had a local install of Formhub which was suiting our needs but opted
to replace it with ODK Aggregate given the moribund nature of Formhub;
but lumping all research data in the same space with no control over who
sees what is really not feasible.
Does anyone have any advice beyond what is contained in this thread?

Wayne

On Thursday, December 20, 2012 at 10:03:26 AM UTC-5, Jason Wheatley wrote:

Hello everyone

Current set up: Using postgres,tomcat,odk

Situation: I currently have a ongoing project form in aggregate and
just recieved another project that will be utilizing odk as well.

Concern: I do not want my client from one project to be able to view a
form I have for another client. Is there anyway to have a Multi-user
form access permissions through Aggregate, keeping certain forms
available to certain logins?

Second Concern: Now that I will be implementing two projects through
odk is there anyway to administer multiple ODK Databases in postgres
as opposed to setting up a separate ODK Aggregate server for each
collection project

--
--
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.

--

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.

--

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

Wayne,

I think SurveyCTO charges for each group of forms because they are
separate servers. If you like Formhub, you try Ona.io. Or try spinning
up separate Aggregate VMs on a big VM server. Or maybe try CommcareHQ.

Yaw

ยทยทยท -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Wed, May 4, 2016 at 9:59 PM, Mitch Sundt mitchellsundt@gmail.com wrote:

Then consider SurveyCTO

That's what they do. That's why they are worth the $$s.

If you absolutely need this in ODK Aggregate, the only option is to pay many
$100k's to add it into the codebase.

But, for nearly all needs, SurveyCTO fees will be cheaper than paying anyone
to write the many extra layers of code to accomplish this.

On Wed, May 4, 2016 at 11:14 AM, Wayne Johnston wajohnst@uoguelph.ca wrote:

Thanks, Mitch.
Unfortunately it's an awful lot of overhead to initiate a new instance for
every project that comes along with countless instances that would have to
be maintained every time there's a new release of the code.
Formhub made it so easy to simply give each project its own discrete
account.

Wayne


Wayne Johnston
University of Guelph Library
wajohnst@uoguelph.ca
519 824 4120 x56900


From: "Mitch Sundt" mitchellsundt@gmail.com
To: "ODK Community" opendatakit@googlegroups.com
Sent: Wednesday, May 4, 2016 1:57:17 PM

Subject: Re: [ODK Community] Re: Multi-user form access permissions
through Aggregate

If you need this, the solution is to run the ODK Aggregate installer
multiple times with different database names, and copy the WAR files onto
your server with different names, as, e.g.,

project1.war (accessing project1 database)
project2.war (accessing project2 database)
...

These will each expand to be under
http://yourserver.org/project1 ,
http://yourserver.org/project2 ,
etc.

Then admin each separately.

The databases would run under one common database server (the MySQL
database server program can expose multiple databases within it).

See other posts for sizing the server that would run all of this.

The assumption here is that a tablet configured to talk to project1 would
not be able to also submit forms to project2 (you would wipe the tablet and
install configuration for project2 when it came time to use it for
project2).
From a data security standpoint, this makes sense -- you would not want
the data collectors for project1 to see the data from project2.

If you don't care about the data collectors seeing all of the data, and
you need them to collect data for both project1 and project2 at the same
time, then you can instead host everything in one ODK Aggregate and set up
publishers to external servers that hold the specific subsets of data that
you want individuals to see. Or you can use ODK Briefcase to download the
data and put CSVs on network shares that researchers with the appropriate
permissions can download.

On Wed, May 4, 2016 at 10:25 AM, Wayne Johnston wajohnst@uoguelph.ca wrote:

Failing that, any other options for a locally-installed data storage
platform?
Research Ethics is not comfortable with hosted solutions.

Wayne


Wayne Johnston
University of Guelph Library
wajohnst@uoguelph.ca
519 824 4120 x56900


From: "Mitch Sundt" mitchellsundt@gmail.com
To: "ODK Community" opendatakit@googlegroups.com
Sent: Wednesday, May 4, 2016 1:21:49 PM
Subject: Re: [ODK Community] Re: Multi-user form access permissions
through Aggregate

Nope.

Survey CTO and other hosting providers offer this.

On Wed, May 4, 2016 at 10:16 AM, Wayne Johnston wajohnst@uoguelph.ca wrote:

I'm wondering if there is an update to this thread, specifically whether
there are plans to make ODK Aggregate accommodate multiple projects.
We had a local install of Formhub which was suiting our needs but opted
to replace it with ODK Aggregate given the moribund nature of Formhub;
but lumping all research data in the same space with no control over who
sees what is really not feasible.
Does anyone have any advice beyond what is contained in this thread?

Wayne

On Thursday, December 20, 2012 at 10:03:26 AM UTC-5, Jason Wheatley wrote:

Hello everyone

Current set up: Using postgres,tomcat,odk

Situation: I currently have a ongoing project form in aggregate and
just recieved another project that will be utilizing odk as well.

Concern: I do not want my client from one project to be able to view a
form I have for another client. Is there anyway to have a Multi-user form
access permissions through Aggregate, keeping certain forms available to
certain logins?

Second Concern: Now that I will be implementing two projects through
odk is there anyway to administer multiple ODK Databases in postgres as
opposed to setting up a separate ODK Aggregate server for each collection
project

--

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.

--

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.

--

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.

Any updates on the above. Is there any further development on this?

Hi @vnatraj

You may want to check about ODK Aggregate future plans - #9 by LN.

While you are at it, don't forget to Introduce yourself here! - #248 by iceb85.

Hope it helps.

1 Like