Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Missing Columns
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  2 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Tumaini Kilimba  
View profile  
 More options Aug 15 2012, 9:44 am
From: Tumaini Kilimba <tkili...@ihi.or.tz>
Date: Wed, 15 Aug 2012 16:44:57 +0300
Local: Wed, Aug 15 2012 9:44 am
Subject: Missing Columns

Dear all,
After a few weeks of data collection I realised there are a few <instance>
elements in my form that were not appearing in my postgresql "xxxx_CORE"
table. Am not sure as to why this should be the case, has anyone
experienced this before? I have a attached the form I used, and the
elements which do not become columns are:

                                      .........
                                      <grp18>
<sideEffects>0</sideEffects>
<shortPrescriptionDuration>0</shortPrescriptionDuration>
<financial>0</financial>
<stockOut>0</stockOut>
<selfAssessment>0</selfAssessment>
<other>0</other>
</grp18>
                                       ...

Any help greatly appreciated.

Tumaini

  MZIMA03 Sero Surveillance v2.0.xml
307K Download

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
W. Brunette  
View profile  
 More options Aug 15 2012, 7:21 pm
From: "W. Brunette" <wbrune...@gmail.com>
Date: Wed, 15 Aug 2012 16:21:25 -0700
Local: Wed, Aug 15 2012 7:21 pm
Subject: Re: [ODK Community] Missing Columns
Tumaini,

In the future this probably a question that should be posted to
opendatakit-developers list as digging into this could get quite
technical.

My guess is looking at your form it appears to be quite large so the
form may need to be split up into smaller tables to fit the database
requires. Aggregate has a built in algorithm for splitting forms into
separate tables if a single table will be too large for the database
engine.

There is a wiki on the code site that talks about the way Aggregate
structures the database tables:
http://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure

Here are some relevant parts of the text.

"The top-level table for a user-uploaded xform will end with _CORE or
_COREn, where 'n' is a number. The name of the top-level table is
roughly formID + "_" + groupName + "_CORE". But that is all shrunk
down to be less than 64 characters, so if you have a long form id, it
will be compressed into a shorter string. The same compression is done
for column names. If you have an xform with nested non-repeat groups,
the full path of the group is preserved, but similarly compressed.
...
The actual table name may vary from one instance to the next depending
upon the tables defined in the database at the time the form was
uploaded; the server ensures that the table names do not collide and
modifies table names until there are no collisions. Also, because of
column count and row size limitations, larger forms, such as eIMCI
will be split across multiple tables. eIMCI uses more than 6 tables,
for example. The software first attempts to split the xform data
following the groupings within the xform. Consider, for example, an
xform representing a medical record where you have a group describing
the provider, a group describing the patient, and a group describing
the reason for the visit and the treatments proscribed. If this
information cannot fit within one database table, the system will
first attempt to split it into 3 tables, one holding the
characteristics of the provider, one holding the characteristics of
the patient, and one holding the visit information because the xform
had that structure. "

Best,
Waylon


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »