Update manually by adding new records lines in a repeat_group table

Development
1

Hello Community.

As a new comer developer on ODK, I've used Briefcase to push data into my Aggregate Local instance (running on Tomcat with MySQL Database in background).

Once I have all my data, I have a Table which contains a repeat part of my survey, with different Number values per period, simply like this schema.
Table_Records(
_URI,
PARENT_AURI,
_CREATOR_URI_USER,
_CREATION_DATE,
_ORDINAL_NUMBER,
_TOP_LEVEL_AURI,
Period,
Number)

My question is that I want to manually update the related Table "Table_Records" with new values by adding new entries. Which values should I put in the update query for ODK Generated fiels
(_URI,
PARENT_AURI,
_CREATOR_URI_USER,
_CREATION_DATE,
_ORDINAL_NUMBER,
_TOP_LEVEL_AURI,) ?

I only know the ordinal number of the entry in the repeat, and the parent key value "PARENT_AURI", and my values (Period,Number).

How can I get a generator which will provide a new " _URI" value for my data?

Thanks.

2

This is probably a bad idea because you risk corrupting your data.
What high-level problem are you trying to solve?

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Mon, Feb 29, 2016 at 9:04 PM, jannesquin@gmail.com wrote:

Hello Community.

As a new comer developer on ODK, I've used Briefcase to push data into my Aggregate Local instance (running on Tomcat with MySQL Database in background).

Once I have all my data, I have a Table which contains a repeat part of my survey, with different Number values per period, simply like this schema.
Table_Records(
_URI,
PARENT_AURI,
_CREATOR_URI_USER,
_CREATION_DATE,
_ORDINAL_NUMBER,
_TOP_LEVEL_AURI,
Period,
Number)

My question is that I want to manually update the related Table "Table_Records" with new values by adding new entries. Which values should I put in the update query for ODK Generated fiels
(_URI,
PARENT_AURI,
_CREATOR_URI_USER,
_CREATION_DATE,
_ORDINAL_NUMBER,
_TOP_LEVEL_AURI,) ?

I only know the ordinal number of the entry in the repeat, and the parent key value "PARENT_AURI", and my values (Period,Number).

How can I get a generator which will provide a new " _URI" value for my data?

Thanks.

--
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.

3

I believe this is also a re-post...

··· On Thu, Mar 10, 2016 at 8:52 PM, Yaw Anokwa wrote:

This is probably a bad idea because you risk corrupting your data.
What high-level problem are you trying to solve?

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Mon, Feb 29, 2016 at 9:04 PM, jannesquin@gmail.com wrote:

Hello Community.

As a new comer developer on ODK, I've used Briefcase to push data into
my Aggregate Local instance (running on Tomcat with MySQL Database in
background).

Once I have all my data, I have a Table which contains a repeat part of
my survey, with different Number values per period, simply like this schema.
Table_Records(
_URI,
PARENT_AURI,
_CREATOR_URI_USER,
_CREATION_DATE,
_ORDINAL_NUMBER,
_TOP_LEVEL_AURI,
Period,
Number)

My question is that I want to manually update the related Table
"Table_Records" with new values by adding new entries. Which values should
I put in the update query for ODK Generated fiels
(_URI,
PARENT_AURI,
_CREATOR_URI_USER,
_CREATION_DATE,
_ORDINAL_NUMBER,
_TOP_LEVEL_AURI,) ?

I only know the ordinal number of the entry in the repeat, and the
parent key value "PARENT_AURI", and my values (Period,Number).

How can I get a generator which will provide a new " _URI" value for my
data?

Thanks.

--
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.

--
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