I'm running ODK Aggregate backed by Postgres, and am poking around the
database structure, and trying to figure out how to run queries against it,
using https://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure
as a reference. One thing I'm missing is where I can find the labels that
go with the corresponding multiple choice keys. Specifically, the table for
a particular multiple choice question will have values based on the "name"
field in a XLSForm, e.g., "pizza_choice_pepperoni". I'd like to join this
to a table to find the original label value from the form, e.g.,
"Pepperoni, please!". Does this live in the database? And if so, where?
Thanks
Matt
We discard that information.
Because the choice labels are often internationalized, and
internationalizing would also involve handling time zones and date formats,
we decided early on to have ODK Aggregate not support internationalized
presentation.
···
On Sat, Apr 11, 2015 at 10:51 AM, Matthew Gordon wrote:
I'm running ODK Aggregate backed by Postgres, and am poking around the
database structure, and trying to figure out how to run queries against it,
using
https://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure as
a reference. One thing I'm missing is where I can find the labels that go
with the corresponding multiple choice keys. Specifically, the table for a
particular multiple choice question will have values based on the "name"
field in a XLSForm, e.g., "pizza_choice_pepperoni". I'd like to join this
to a table to find the original label value from the form, e.g.,
"Pepperoni, please!". Does this live in the database? And if so, where?
Thanks
Matt
--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Thanks Mitch. Isn't the original form XML stored as a blob somewhere?
Could it in theory be backed out of that?
···
On Monday, April 13, 2015 at 11:05:17 AM UTC-7, Mitch wrote:
>
> We discard that information.
>
> Because the choice labels are often internationalized, and
> internationalizing would also involve handling time zones and date formats,
> we decided early on to have ODK Aggregate not support internationalized
> presentation.
>
>
>
>
> On Sat, Apr 11, 2015 at 10:51 AM, Matthew Gordon <inver...@gmail.com > wrote:
>
>> I'm running ODK Aggregate backed by Postgres, and am poking around the
>> database structure, and trying to figure out how to run queries against it,
>> using
>> https://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure as
>> a reference. One thing I'm missing is where I can find the labels that go
>> with the corresponding multiple choice keys. Specifically, the table for a
>> particular multiple choice question will have values based on the "name"
>> field in a XLSForm, e.g., "pizza_choice_pepperoni". I'd like to join this
>> to a table to find the original label value from the form, e.g.,
>> "Pepperoni, please!". Does this live in the database? And if so, where?
>>
>> Thanks
>> Matt
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "ODK Developers" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to opendatakit-developers+unsubscribe@googlegroups.com
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Mitch Sundt
> Software Engineer
> University of Washington
> mitche...@gmail.com
>
Absolutely. Yes, it is stored in the database.
It is probably most easily accessed via the download URLs.
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaAPI
···
On Tue, Apr 14, 2015 at 9:46 PM, Matthew Gordon wrote:
Thanks Mitch. Isn't the original form XML stored as a blob somewhere?
Could it in theory be backed out of that?
On Monday, April 13, 2015 at 11:05:17 AM UTC-7, Mitch wrote:
We discard that information.
Because the choice labels are often internationalized, and
internationalizing would also involve handling time zones and date formats,
we decided early on to have ODK Aggregate not support internationalized
presentation.
On Sat, Apr 11, 2015 at 10:51 AM, Matthew Gordon inver...@gmail.com wrote:
I'm running ODK Aggregate backed by Postgres, and am poking around the
database structure, and trying to figure out how to run queries against it,
using https://code.google.com/p/opendatakit/wiki/
AggregateDatabaseStructure as a reference. One thing I'm missing is
where I can find the labels that go with the corresponding multiple choice
keys. Specifically, the table for a particular multiple choice question
will have values based on the "name" field in a XLSForm, e.g.,
"pizza_choice_pepperoni". I'd like to join this to a table to find the
original label value from the form, e.g., "Pepperoni, please!". Does this
live in the database? And if so, where?
Thanks
Matt
--
You received this message because you are subscribed to the Google
Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com
--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com