Hello everyone!
And thank you for taking the time to read my post.
So I have ODK Aggregate set up with PostgreSQL as my DBMS.
I have also developed some php scripts that I use to append my forms data at a go as opposed to downloading individual data sets through Aggregate (my organization has several offices that use the same ODK form templates albeit with some differences in options so downloading individual data sets can be quite time consuming hence the need for the php appending scripts).
However, I recently noticed that the scripts were not accruing comprehensively. Some tables (forms data) were missing from the master data set the scripts would generate.
At first, I thought the problem was within the php coding - however, when I checked the database with pgAdmin III, I discovered that some tables were missing from my schema. These missing tables were the same culprits that my scripts was not seeing.
I'm stumped as to what the problem is - since these forms are visible on Aggregate and their data can be downloaded from there properly, but they are missing when I search for them through pgAdmin III.
Where could my forms be and why can't I see their tables through pgAdmin III but only through Aggregate? I've searched all through the data base through pgAdmin III, but I just can't find them.
Your help will greatly be appreciated.
Thank you
Ramadhan
(This topic is more appropriate for the opendatakit-developers@ list; in
the future, please ask similar questions on that list).
Note that the table names are generated dynamically when a form is first
uploaded.
If you deleted a form from the server, then added it back in, it could
generate a different name for the tables that are used to store that form.
This is particularly true across ODK Aggregate versions, as we have had
many very subtle issues with forms with 1000's of fields and mapping all of
those fields into data tables.
My first guess is that this is what is causing the mismatch. You set up
your php scripts for the specific names of tables in the original form
upload, then deleted the form, uploaded it again (perhaps after an ODK
Aggregate upgrade), and a new, different, set of table names were used.
The definitive set of table names and the mapping of field names to
database columns is maintained in the _form_data_model table. The
_form_info_submission_association table and _form_info tables provide the
mapping from a form id to the value to use to filter the contents of the
data model table to obtain the storage description for that form id.
See
ยทยทยท
On Wed, Mar 30, 2016 at 6:37 AM, wrote:
Hello everyone!
And thank you for taking the time to read my post.
So I have ODK Aggregate set up with PostgreSQL as my DBMS.
I have also developed some php scripts that I use to append my forms data
at a go as opposed to downloading individual data sets through Aggregate
(my organization has several offices that use the same ODK form templates
albeit with some differences in options so downloading individual data sets
can be quite time consuming hence the need for the php appending scripts).
However, I recently noticed that the scripts were not accruing
comprehensively. Some tables (forms data) were missing from the master data
set the scripts would generate.
At first, I thought the problem was within the php coding - however, when
I checked the database with pgAdmin III, I discovered that some tables were
missing from my schema. These missing tables were the same culprits that my
scripts was not seeing.
I'm stumped as to what the problem is - since these forms are visible on
Aggregate and their data can be downloaded from there properly, but they
are missing when I search for them through pgAdmin III.
Where could my forms be and why can't I see their tables through pgAdmin
III but only through Aggregate? I've searched all through the data base
through pgAdmin III, but I just can't find them.
Your help will greatly be appreciated.
Thank you
Ramadhan
--
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