ODK MySQL TABLES

My ODK form produces many tables in the sql database. Is there a way I can
change this so that I only get one table for the form submissions?

Thanks in advance.

Hi there,

The short answer is no. The long answer is yes, if you are willing to
write a ton of code.

My guess is that you don't, so your options are to try to build some
DB view on top of the existing tables or send the data to an external
system whose data structures you are more comfortable with.


describes the Aggregate DB structure.
https://opendatakit.org/use/aggregate/data-transfer/ describes the way
you can send the data to another system.

Yaw

ยทยทยท On Fri, Sep 30, 2016 at 10:17 AM, Ayuka Phanuel wrote: > > My ODK form produces many tables in the sql database. Is there a way I can > change this so that I only get one table for the form submissions? > > > Thanks in advance. > > -- > -- > 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.
1 Like

Thanks for the answer Yaw.
I can write the code but am not sure of what specific part or protocol
of the ODK I will change. Which parts will I specifically change to
come up with one table or I can create the table in prior so that the
submissions will just be submitted to the already created table?

Thanks,
Phanuel Ayuka.
Computer Science Student,
University of Nairobi.

ยทยทยท On Fri, Sep 30, 2016 at 2:26 PM, Yaw Anokwa wrote: > Hi there, > > The short answer is no. The long answer is yes, if you are willing to > write a ton of code. > > My guess is that you don't, so your options are to try to build some > DB view on top of the existing tables or send the data to an external > system whose data structures you are more comfortable with. > > https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure > describes the Aggregate DB structure. > https://opendatakit.org/use/aggregate/data-transfer/ describes the way > you can send the data to another system. > > Yaw > > On Fri, Sep 30, 2016 at 10:17 AM, Ayuka Phanuel wrote: >> >> My ODK form produces many tables in the sql database. Is there a way I can >> change this so that I only get one table for the form submissions? >> >> >> Thanks in advance. >> >> -- >> -- >> 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 a topic in the Google Groups "ODK Community" group. > To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit/9AGG5ifFHYY/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.

Hi Phanuel,

I worry that you are going about this the wrong way. What high-level
problem are you trying to solve?

Yaw

ยทยทยท On Fri, Sep 30, 2016 at 11:08 AM, Ayuka Phanuel wrote: > Thanks for the answer Yaw. > I can write the code but am not sure of what specific part or protocol > of the ODK I will change. Which parts will I specifically change to > come up with one table or I can create the table in prior so that the > submissions will just be submitted to the already created table? > > Thanks, > Phanuel Ayuka. > Computer Science Student, > University of Nairobi. > > On Fri, Sep 30, 2016 at 2:26 PM, Yaw Anokwa wrote: >> Hi there, >> >> The short answer is no. The long answer is yes, if you are willing to >> write a ton of code. >> >> My guess is that you don't, so your options are to try to build some >> DB view on top of the existing tables or send the data to an external >> system whose data structures you are more comfortable with. >> >> https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure >> describes the Aggregate DB structure. >> https://opendatakit.org/use/aggregate/data-transfer/ describes the way >> you can send the data to another system. >> >> Yaw >> >> On Fri, Sep 30, 2016 at 10:17 AM, Ayuka Phanuel wrote: >>> >>> My ODK form produces many tables in the sql database. Is there a way I can >>> change this so that I only get one table for the form submissions? >>> >>> >>> Thanks in advance. >>> >>> -- >>> -- >>> 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 a topic in the Google Groups "ODK Community" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit/9AGG5ifFHYY/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.

Thanks Yaw, you have been very helpful.
I want run a survey offline and then send the data to the ODK
Aggregate which I am already hosting on my server.
I will then create a website interface for the survey. The web
interface ( a website) will be specifically for reports meaning that
I will have to run some SQL queries which will fetch the survey data
from the SQL database in my server.

The aggregate forms the SQL table yes but I have realized that the
table is divided into many core tables with no particular link e.g
primary and foreign keys which would help me run the queries. The data
is also not ordered such that I cannot know which particular range of
questions' responses are stored in which particular table which will
make the query even more complex to write.

Due to the above encountered problems, am searching for a solution to
come up with one table for the form or any other solution which will
help me do the reports on the planned web interface.

Thanks,
Phanuel Ayuka.
Computer Science Student,
University of Nairobi.

ยทยทยท On Fri, Sep 30, 2016 at 8:01 PM, Yaw Anokwa wrote: > Hi Phanuel, > > I worry that you are going about this the wrong way. What high-level > problem are you trying to solve? > > Yaw > > On Fri, Sep 30, 2016 at 11:08 AM, Ayuka Phanuel wrote: >> Thanks for the answer Yaw. >> I can write the code but am not sure of what specific part or protocol >> of the ODK I will change. Which parts will I specifically change to >> come up with one table or I can create the table in prior so that the >> submissions will just be submitted to the already created table? >> >> Thanks, >> Phanuel Ayuka. >> Computer Science Student, >> University of Nairobi. >> >> On Fri, Sep 30, 2016 at 2:26 PM, Yaw Anokwa wrote: >>> Hi there, >>> >>> The short answer is no. The long answer is yes, if you are willing to >>> write a ton of code. >>> >>> My guess is that you don't, so your options are to try to build some >>> DB view on top of the existing tables or send the data to an external >>> system whose data structures you are more comfortable with. >>> >>> https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure >>> describes the Aggregate DB structure. >>> https://opendatakit.org/use/aggregate/data-transfer/ describes the way >>> you can send the data to another system. >>> >>> Yaw >>> >>> On Fri, Sep 30, 2016 at 10:17 AM, Ayuka Phanuel wrote: >>>> >>>> My ODK form produces many tables in the sql database. Is there a way I can >>>> change this so that I only get one table for the form submissions? >>>> >>>> >>>> Thanks in advance. >>>> >>>> -- >>>> -- >>>> 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 a topic in the Google Groups "ODK Community" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit/9AGG5ifFHYY/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. > > -- > -- > 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/9AGG5ifFHYY/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.

A description of the database structure is here:

ยทยทยท On Sat, Oct 1, 2016 at 12:11 AM, Ayuka Phanuel wrote:

Thanks Yaw, you have been very helpful.
I want run a survey offline and then send the data to the ODK
Aggregate which I am already hosting on my server.
I will then create a website interface for the survey. The web
interface ( a website) will be specifically for reports meaning that
I will have to run some SQL queries which will fetch the survey data
from the SQL database in my server.

The aggregate forms the SQL table yes but I have realized that the
table is divided into many core tables with no particular link e.g
primary and foreign keys which would help me run the queries. The data
is also not ordered such that I cannot know which particular range of
questions' responses are stored in which particular table which will
make the query even more complex to write.

Due to the above encountered problems, am searching for a solution to
come up with one table for the form or any other solution which will
help me do the reports on the planned web interface.

Thanks,
Phanuel Ayuka.
Computer Science Student,
University of Nairobi.

On Fri, Sep 30, 2016 at 8:01 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Phanuel,

I worry that you are going about this the wrong way. What high-level
problem are you trying to solve?

Yaw

On Fri, Sep 30, 2016 at 11:08 AM, Ayuka Phanuel ayukaphanuel@gmail.com wrote:

Thanks for the answer Yaw.
I can write the code but am not sure of what specific part or protocol
of the ODK I will change. Which parts will I specifically change to
come up with one table or I can create the table in prior so that the
submissions will just be submitted to the already created table?

Thanks,
Phanuel Ayuka.
Computer Science Student,
University of Nairobi.

On Fri, Sep 30, 2016 at 2:26 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi there,

The short answer is no. The long answer is yes, if you are willing to
write a ton of code.

My guess is that you don't, so your options are to try to build some
DB view on top of the existing tables or send the data to an external
system whose data structures you are more comfortable with.

https://github.com/opendatakit/opendatakit/wiki/
Aggregate-Database-Structure

describes the Aggregate DB structure.
https://opendatakit.org/use/aggregate/data-transfer/ describes the way
you can send the data to another system.

Yaw

On Fri, Sep 30, 2016 at 10:17 AM, Ayuka Phanuel < ayukaphanuel@gmail.com> wrote:

My ODK form produces many tables in the sql database. Is there a way
I can

change this so that I only get one table for the form submissions?

Thanks in advance.

--

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 a topic in the
Google Groups "ODK Community" group.

To unsubscribe from this topic, visit https://groups.google.com/d/
topic/opendatakit/9AGG5ifFHYY/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.

--

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/9AGG5ifFHYY/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

Mitch's recommendation is the correct approach. The alternative is to
stream the data to Fusion Tables where you have a flatter view of the
data, and write your code to interact with Fusion Tables.

Yaw

ยทยทยท On Tue, Oct 4, 2016 at 7:21 PM, Mitch Sundt wrote: > A description of the database structure is here: > > https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure > > On Sat, Oct 1, 2016 at 12:11 AM, Ayuka Phanuel wrote: >> >> Thanks Yaw, you have been very helpful. >> I want run a survey offline and then send the data to the ODK >> Aggregate which I am already hosting on my server. >> I will then create a website interface for the survey. The web >> interface ( a website) will be specifically for reports meaning that >> I will have to run some SQL queries which will fetch the survey data >> from the SQL database in my server. >> >> The aggregate forms the SQL table yes but I have realized that the >> table is divided into many core tables with no particular link e.g >> primary and foreign keys which would help me run the queries. The data >> is also not ordered such that I cannot know which particular range of >> questions' responses are stored in which particular table which will >> make the query even more complex to write. >> >> Due to the above encountered problems, am searching for a solution to >> come up with one table for the form or any other solution which will >> help me do the reports on the planned web interface. >> >> Thanks, >> Phanuel Ayuka. >> Computer Science Student, >> University of Nairobi. >> >> On Fri, Sep 30, 2016 at 8:01 PM, Yaw Anokwa wrote: >> > Hi Phanuel, >> > >> > I worry that you are going about this the wrong way. What high-level >> > problem are you trying to solve? >> > >> > Yaw >> > >> > On Fri, Sep 30, 2016 at 11:08 AM, Ayuka Phanuel wrote: >> >> Thanks for the answer Yaw. >> >> I can write the code but am not sure of what specific part or protocol >> >> of the ODK I will change. Which parts will I specifically change to >> >> come up with one table or I can create the table in prior so that the >> >> submissions will just be submitted to the already created table? >> >> >> >> Thanks, >> >> Phanuel Ayuka. >> >> Computer Science Student, >> >> University of Nairobi. >> >> >> >> On Fri, Sep 30, 2016 at 2:26 PM, Yaw Anokwa wrote: >> >>> Hi there, >> >>> >> >>> The short answer is no. The long answer is yes, if you are willing to >> >>> write a ton of code. >> >>> >> >>> My guess is that you don't, so your options are to try to build some >> >>> DB view on top of the existing tables or send the data to an external >> >>> system whose data structures you are more comfortable with. >> >>> >> >>> >> >>> https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure >> >>> describes the Aggregate DB structure. >> >>> https://opendatakit.org/use/aggregate/data-transfer/ describes the way >> >>> you can send the data to another system. >> >>> >> >>> Yaw >> >>> >> >>> On Fri, Sep 30, 2016 at 10:17 AM, Ayuka Phanuel wrote: >> >>>> >> >>>> My ODK form produces many tables in the sql database. Is there a way >> >>>> I can >> >>>> change this so that I only get one table for the form submissions? >> >>>> >> >>>> >> >>>> Thanks in advance. >> >>>> >> >>>> -- >> >>>> -- >> >>>> 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 a topic in the >> >>> Google Groups "ODK Community" group. >> >>> To unsubscribe from this topic, visit >> >>> https://groups.google.com/d/topic/opendatakit/9AGG5ifFHYY/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. >> > >> > -- >> > -- >> > 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/9AGG5ifFHYY/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 > > -- > -- > 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.

Thank you Mitch and Yaw....I highly appreciate your assistance.

ยทยทยท On Wed, Oct 5, 2016 at 3:56 PM, Yaw Anokwa wrote: > Mitch's recommendation is the correct approach. The alternative is to > stream the data to Fusion Tables where you have a flatter view of the > data, and write your code to interact with Fusion Tables. > > Yaw > > On Tue, Oct 4, 2016 at 7:21 PM, Mitch Sundt wrote: >> A description of the database structure is here: >> >> https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure >> >> On Sat, Oct 1, 2016 at 12:11 AM, Ayuka Phanuel wrote: >>> >>> Thanks Yaw, you have been very helpful. >>> I want run a survey offline and then send the data to the ODK >>> Aggregate which I am already hosting on my server. >>> I will then create a website interface for the survey. The web >>> interface ( a website) will be specifically for reports meaning that >>> I will have to run some SQL queries which will fetch the survey data >>> from the SQL database in my server. >>> >>> The aggregate forms the SQL table yes but I have realized that the >>> table is divided into many core tables with no particular link e.g >>> primary and foreign keys which would help me run the queries. The data >>> is also not ordered such that I cannot know which particular range of >>> questions' responses are stored in which particular table which will >>> make the query even more complex to write. >>> >>> Due to the above encountered problems, am searching for a solution to >>> come up with one table for the form or any other solution which will >>> help me do the reports on the planned web interface. >>> >>> Thanks, >>> Phanuel Ayuka. >>> Computer Science Student, >>> University of Nairobi. >>> >>> On Fri, Sep 30, 2016 at 8:01 PM, Yaw Anokwa wrote: >>> > Hi Phanuel, >>> > >>> > I worry that you are going about this the wrong way. What high-level >>> > problem are you trying to solve? >>> > >>> > Yaw >>> > >>> > On Fri, Sep 30, 2016 at 11:08 AM, Ayuka Phanuel wrote: >>> >> Thanks for the answer Yaw. >>> >> I can write the code but am not sure of what specific part or protocol >>> >> of the ODK I will change. Which parts will I specifically change to >>> >> come up with one table or I can create the table in prior so that the >>> >> submissions will just be submitted to the already created table? >>> >> >>> >> Thanks, >>> >> Phanuel Ayuka. >>> >> Computer Science Student, >>> >> University of Nairobi. >>> >> >>> >> On Fri, Sep 30, 2016 at 2:26 PM, Yaw Anokwa wrote: >>> >>> Hi there, >>> >>> >>> >>> The short answer is no. The long answer is yes, if you are willing to >>> >>> write a ton of code. >>> >>> >>> >>> My guess is that you don't, so your options are to try to build some >>> >>> DB view on top of the existing tables or send the data to an external >>> >>> system whose data structures you are more comfortable with. >>> >>> >>> >>> >>> >>> https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure >>> >>> describes the Aggregate DB structure. >>> >>> https://opendatakit.org/use/aggregate/data-transfer/ describes the way >>> >>> you can send the data to another system. >>> >>> >>> >>> Yaw >>> >>> >>> >>> On Fri, Sep 30, 2016 at 10:17 AM, Ayuka Phanuel wrote: >>> >>>> >>> >>>> My ODK form produces many tables in the sql database. Is there a way >>> >>>> I can >>> >>>> change this so that I only get one table for the form submissions? >>> >>>> >>> >>>> >>> >>>> Thanks in advance. >>> >>>> >>> >>>> -- >>> >>>> -- >>> >>>> 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 a topic in the >>> >>> Google Groups "ODK Community" group. >>> >>> To unsubscribe from this topic, visit >>> >>> https://groups.google.com/d/topic/opendatakit/9AGG5ifFHYY/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. >>> > >>> > -- >>> > -- >>> > 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/9AGG5ifFHYY/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 >> >> -- >> -- >> 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 a topic in the Google Groups "ODK Community" group. > To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit/9AGG5ifFHYY/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.

Dear Ayuka, did you success to organize/import your data to a proper MySQL database? Thanks for your feedback.