# Relational Databases and ODK

**URL:** <https://forum.getodk.org/t/relational-databases-and-odk/5047>\
**Category:** Support\
**Created:** [December 1, 2015, 3:28pm UTC](https://forum.getodk.org/t/relational-databases-and-odk/5047 "2015-12-01T15:28:07Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![Senyo\_Aborgah](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/senyo_aborgah/32/6397_2.png) [@Senyo\_Aborgah](https://forum.getodk.org/u/Senyo_Aborgah)\
**Post date:** [January 18, 2016, 8:28am UTC](https://forum.getodk.org/t/relational-databases-and-odk/5047/8 "2016-01-18T08:28:07Z")

</div>

i mean, after filling the form on odk collect n sending it to the Aggregate  
database(POSTGRESQL) it goes as a single file(view capture 1 image,file  
name BUILD\_PARLIAMENT\_DATA\_1452855084\_CORE). what i want is for the record  
to store into the existing tables in Capture2  
like sect\_agriculture,tbl\_beneficiary,tbl\_funding,tbl\_project(these tables  
are linked to each other with primary and foreign key constraints)

_\__\* \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_  
\_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \_ \*  
_Senyo Aborgah_  
_GIS Database Analyst/IT Support Officer_  
_eMapping and Innovations Coordinator_  
_Center for Remote Sensing and Geographic Information Services (CERSGIS)_  
_University of Ghana, Legon_  
_Accra - Ghana_

_[www.cersgis.org](http://www.cersgis.org)_ [http://www.cersgis.org/](http://www.cersgis.org/)

 ![image](https://getodk.b-cdn.net/uploads/default/original/2X/e/ebfd2def94778292e1858640fabf6b469e005ada.PNG)

 ![image](https://getodk.b-cdn.net/uploads/default/original/2X/e/e12b792ebb556ea0768dc436ae74abc31b7aaf2a.PNG)

> **···**
>
> On Fri, Jan 15, 2016 at 7:14 PM, Mitch Sundt wrote:
> 
> > I don't understand:  
> > "what i want is for the sent file to go into the database linking to  
> > each relational data table inside the table"
> > 
> > If you want the data stored as XML files and not parsed and broken out  
> > into columns, look at ona, formhub or other server implementations that use  
> > a document store.
> > 
> > On Fri, Jan 15, 2016 at 6:32 AM, [senyoab@gmail.com](mailto:senyoab@gmail.com) wrote:
> > 
> > > i have a successful ODK Aggregate linked to my postgresql database. The  
> > > problem i have is that after filling the form using ODK collect and sending  
> > > it to the database, the sent file goes into the database as a table. what i  
> > > want is for the sent file to go into the database linking to each  
> > > relational data table inside the table
> > > 
> > > ## --
> > > 
> > > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com)  
> > > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com)  
> > > Options: [http://groups.google.com/group/opendatakit?hl=en](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](mailto:opendatakit+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > 
> > --  
> > Mitch Sundt  
> > Software Engineer  
> > University of Washington  
> > [mitchellsundt@gmail.com](mailto:mitchellsundt@gmail.com)
> > 
> > ## --
> > 
> > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com)  
> > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com)  
> > Options: [http://groups.google.com/group/opendatakit?hl=en](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/v3OkMdnzNqA/unsubscribe](https://groups.google.com/d/topic/opendatakit/v3OkMdnzNqA/unsubscribe).  
> > To unsubscribe from this group and all its topics, send an email to  
> > [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

_[View the full topic](https://forum.getodk.org/t/relational-databases-and-odk/5047)._