Lost some data on Aggregate server - how to get it again from the phones?

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been.
Today we had an issue where a database error occured and forced us to
restore our database from a backup, losing data submitted during
approximately 12 hours. We know the phones which have send the data and
those phones that submitted the data will still have that data on the sd
card, so, I wanted to see what the best and easiest method is to get that
missing data off the phones and to the server.

Thanks!!

Alex

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

··· On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck wrote: > Hello all. We have successfully deployed ODK to 16 countries now and > couldn't be happier with how simple and reliable the system has been. Today > we had an issue where a database error occured and forced us to restore our > database from a backup, losing data submitted during approximately 12 hours. > We know the phones which have send the data and those phones that submitted > the data will still have that data on the sd card, so, I wanted to see what > the best and easiest method is to get that missing data off the phones and > to the server. > > Thanks!! > > Alex > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets the job
done.

Thanks again!
Alex

··· On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote: > > Hooking the phones up to a PC and using Briefcase to upload the > submissions from the phone to Aggregate could work. However, I am not > sure if you can specify which ones to upload as you don't want to > upload all submissions again I am guessing. > > Mitch do you have an idea? > > Waylon > > On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck wrote: > > Hello all. We have successfully deployed ODK to 16 countries now and > > couldn't be happier with how simple and reliable the system has been. > Today > > we had an issue where a database error occured and forced us to restore > our > > database from a backup, losing data submitted during approximately 12 > hours. > > We know the phones which have send the data and those phones that > submitted > > the data will still have that data on the sd card, so, I wanted to see > what > > the best and easiest method is to get that missing data off the phones > and > > to the server. > > > > Thanks!! > > > > Alex > > > > -- > > Post: opendatakit@googlegroups.com > > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > > Options: http://groups.google.com/group/opendatakit?hl=en >

Waylon that is an excellent idea....as it is one that me and my team had to
revert to getting the data off the phone to the server in Guyana, South
America...However, Alex this is a time consuming procedure, but if you can
open the kml/xml file on the computer you will then have an idea which file
need uploading to the server and which do not...again, it is a very time
consuming procedure...

best of luck

R.

··· On Thu, May 3, 2012 at 3:29 AM, W. Brunette wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been.
Today
we had an issue where a database error occured and forced us to restore
our
database from a backup, losing data submitted during approximately 12
hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to see
what
the best and easiest method is to get that missing data off the phones
and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Play it forward and Have a good one!

"Like a camera I use the negative to develop..uDig"
"Success is the ability to go from one failure to another with no loss of
enthusiasm"
---------------------------------------------------------------------------------------------------------->
OutSourceRox*
*
Roxroy K. Bollers
GIS and IT Consultant
tel. 592.685.2737
.........................................................
Follow Us On
Facebook http://www.facebook.com/OutSourceRox
Google+ https://plus.google.com/114064153117817313312
Web http://twitinternational.com/outsourcerox.htm

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ), and
if you have the bandwidth to the server available, your field teams can
just resubmit all forms from the time of the crash to the present. The
Aggregate server will do the de-duplication work itself -- ensuring that
only a single copy of any one submission is recorded on the server.

Mitch

··· On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck wrote:

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets the job
done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been.
Today
we had an issue where a database error occured and forced us to restore
our
database from a backup, losing data submitted during approximately 12
hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to see
what
the best and easiest method is to get that missing data off the phones
and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@**googlegroups.comopendatakit%2Bunsubscribe@googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Or, rather, from the time before the start of the restore image....

··· On Thu, May 3, 2012 at 8:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ),
and if you have the bandwidth to the server available, your field teams can
just resubmit all forms from the time of the crash to the present. The
Aggregate server will do the de-duplication work itself -- ensuring that
only a single copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets the job
done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been.
Today
we had an issue where a database error occured and forced us to
restore our
database from a backup, losing data submitted during approximately 12
hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to see
what
the best and easiest method is to get that missing data off the phones
and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@**googlegroups.comopendatakit%2Bunsubscribe@googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Can they resubmit from the phones or does it require briefcase?

··· On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID ( https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ), and if you have the bandwidth to the server available, your field teams can just resubmit all forms from the time of the crash to the present. The Aggregate server will do the de-duplication work itself -- ensuring that only a single copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck <apavluck@taskforce.org (mailto:apavluck@taskforce.org)> wrote:

Thanks, everyone. Yeah, that is the process I did in the past and it worked fine. It is a little rough on the field teams but it gets the job done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck <apavluck@taskforce.org (mailto:apavluck@taskforce.org)> wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been. Today
we had an issue where a database error occured and forced us to restore our
database from a backup, losing data submitted during approximately 12 hours.
We know the phones which have send the data and those phones that submitted
the data will still have that data on the sd card, so, I wanted to see what
the best and easiest method is to get that missing data off the phones and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com (mailto:opendatakit@googlegroups.com)
Unsubscribe: opendatakit+unsubscribe@googlegroups.com (mailto:opendatakit%2Bunsubscribe@googlegroups.com)
Options: http://groups.google.com/group/opendatakit?hl=en
--
Post: opendatakit@googlegroups.com (mailto:opendatakit@googlegroups.com)
Unsubscribe: opendatakit+unsubscribe@googlegroups.com (mailto:opendatakit%2Bunsubscribe@googlegroups.com)
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com (mailto:mitchellsundt@gmail.com)

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

They can resubmit from the phones.

Mitch

··· On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck wrote:

Can they resubmit from the phones or does it require briefcase?

On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ),
and if you have the bandwidth to the server available, your field teams can
just resubmit all forms from the time of the crash to the present. The
Aggregate server will do the de-duplication work itself -- ensuring that
only a single copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets the job
done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been.
Today
we had an issue where a database error occured and forced us to restore
our
database from a backup, losing data submitted during approximately 12
hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to see
what
the best and easiest method is to get that missing data off the phones
and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@**googlegroups.comopendatakit%2Bunsubscribe@googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Excellent back end work there...

··· On Thu, May 3, 2012 at 11:52 AM, Mitch S wrote:

Or, rather, from the time before the start of the restore image....

On Thu, May 3, 2012 at 8:51 AM, Mitch S mitchellsundt@gmail.com wrote:

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ),
and if you have the bandwidth to the server available, your field teams can
just resubmit all forms from the time of the crash to the present. The
Aggregate server will do the de-duplication work itself -- ensuring that
only a single copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets the job
done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been.
Today
we had an issue where a database error occured and forced us to
restore our
database from a backup, losing data submitted during approximately 12
hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to
see what
the best and easiest method is to get that missing data off the
phones and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@**googlegroups.comopendatakit%2Bunsubscribe@googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

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

--
Play it forward and Have a good one!

"Like a camera I use the negative to develop..uDig"
"Success is the ability to go from one failure to another with no loss of
enthusiasm"
---------------------------------------------------------------------------------------------------------->
OutSourceRox*
*
Roxroy K. Bollers
GIS and IT Consultant
tel. 592.685.2737
.........................................................
Follow Us On
Facebook http://www.facebook.com/OutSourceRox
Google+ https://plus.google.com/114064153117817313312
Web http://twitinternational.com/outsourcerox.htm

Wow, great. Last question...how? There is nothing listed in send finalized data.

··· On Thursday, May 3, 2012 at 12:04 PM, Mitch S wrote:

They can resubmit from the phones.

Mitch

On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck <apavluck@taskforce.org (mailto:apavluck@taskforce.org)> wrote:

Can they resubmit from the phones or does it require briefcase?

On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID ( https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ), and if you have the bandwidth to the server available, your field teams can just resubmit all forms from the time of the crash to the present. The Aggregate server will do the de-duplication work itself -- ensuring that only a single copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck <apavluck@taskforce.org (mailto:apavluck@taskforce.org)> wrote:

Thanks, everyone. Yeah, that is the process I did in the past and it worked fine. It is a little rough on the field teams but it gets the job done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck <apavluck@taskforce.org (mailto:apavluck@taskforce.org)> wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been. Today
we had an issue where a database error occured and forced us to restore our
database from a backup, losing data submitted during approximately 12 hours.
We know the phones which have send the data and those phones that submitted
the data will still have that data on the sd card, so, I wanted to see what
the best and easiest method is to get that missing data off the phones and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com (mailto:opendatakit@googlegroups.com)
Unsubscribe: opendatakit+unsubscribe@googlegroups.com (mailto:opendatakit%2Bunsubscribe@googlegroups.com)
Options: http://groups.google.com/group/opendatakit?hl=en
--
Post: opendatakit@googlegroups.com (mailto:opendatakit@googlegroups.com)
Unsubscribe: opendatakit+unsubscribe@googlegroups.com (mailto:opendatakit%2Bunsubscribe@googlegroups.com)
Options: http://groups.google.com/group/opendatakit?hl=en

--
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%2Bunsubscribe@googlegroups.com)
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com (mailto:opendatakit@googlegroups.com)
Unsubscribe: opendatakit+unsubscribe@googlegroups.com (mailto:opendatakit%2Bunsubscribe@googlegroups.com)
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com (mailto:mitchellsundt@gmail.com)

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

Argh... let me check. It might not be possible to change the status of the
already-sent files...

Mitch

··· On Thu, May 3, 2012 at 9:08 AM, Alex Pavluck wrote:

Wow, great. Last question...how? There is nothing listed in send
finalized data.

On Thursday, May 3, 2012 at 12:04 PM, Mitch S wrote:

They can resubmit from the phones.

Mitch

On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Can they resubmit from the phones or does it require briefcase?

On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ),
and if you have the bandwidth to the server available, your field teams can
just resubmit all forms from the time of the crash to the present. The
Aggregate server will do the de-duplication work itself -- ensuring that
only a single copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets the job
done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been.
Today
we had an issue where a database error occured and forced us to restore
our
database from a backup, losing data submitted during approximately 12
hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to see
what
the best and easiest method is to get that missing data off the phones
and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@**googlegroups.comopendatakit%2Bunsubscribe@googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Oops. Sorry. ODK Collect doesn't allow you to choose previously-sent forms.

Created a feature request: *
http://code.google.com/p/opendatakit/issues/detail?id=570

··· * Star that request to vote for it. I'll see what I can do for ODK Collect 1.2.

Mitch

On Thu, May 3, 2012 at 9:28 AM, Mitch S mitchellsundt@gmail.com wrote:

Argh... let me check. It might not be possible to change the status of
the already-sent files...

Mitch

On Thu, May 3, 2012 at 9:08 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Wow, great. Last question...how? There is nothing listed in send
finalized data.

On Thursday, May 3, 2012 at 12:04 PM, Mitch S wrote:

They can resubmit from the phones.

Mitch

On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Can they resubmit from the phones or does it require briefcase?

On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ),
and if you have the bandwidth to the server available, your field teams can
just resubmit all forms from the time of the crash to the present. The
Aggregate server will do the de-duplication work itself -- ensuring that
only a single copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets the job
done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been.
Today
we had an issue where a database error occured and forced us to restore
our
database from a backup, losing data submitted during approximately 12
hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to see
what
the best and easiest method is to get that missing data off the phones
and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@**googlegroups.comopendatakit%2Bunsubscribe@googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Thanks, Mitch! Still being able to resend with briefcase and have the
Aggregate parser identify the dups is a great feature!

Thanks to the team for all the hard work.

Alex Pavluck*, MPH*
Lymphatic Filariasis Support Center
& International Trachoma Initiative
The Task Force for Global Health
325 Swanton Way, Decatur, GA 30030
Cell: (404)647-4904 Fax: (404)371-1138
apavluck@taskforce.org apavluck@taskforce.org

··· On Thu, May 3, 2012 at 12:35 PM, Mitch S wrote:

Oops. Sorry. ODK Collect doesn't allow you to choose previously-sent
forms.

Created a feature request: *
http://code.google.com/p/opendatakit/issues/detail?id=570
*
Star that request to vote for it. I'll see what I can do for ODK Collect
1.2.

Mitch

On Thu, May 3, 2012 at 9:28 AM, Mitch S mitchellsundt@gmail.com wrote:

Argh... let me check. It might not be possible to change the status of
the already-sent files...

Mitch

On Thu, May 3, 2012 at 9:08 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Wow, great. Last question...how? There is nothing listed in send
finalized data.

On Thursday, May 3, 2012 at 12:04 PM, Mitch S wrote:

They can resubmit from the phones.

Mitch

On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Can they resubmit from the phones or does it require briefcase?

On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ),
and if you have the bandwidth to the server available, your field teams can
just resubmit all forms from the time of the crash to the present. The
Aggregate server will do the de-duplication work itself -- ensuring that
only a single copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck apavluck@taskforce.orgwrote:

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets the job
done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now and
couldn't be happier with how simple and reliable the system has been.
Today
we had an issue where a database error occured and forced us to
restore our
database from a backup, losing data submitted during approximately 12
hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to see
what
the best and easiest method is to get that missing data off the phones
and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@**googlegroups.comopendatakit%2Bunsubscribe@googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

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

Alex,

Another (potentially more difficult) option is to edit the on-phone
database to change the instance status to complete (and thus not
submitted). See
https://groups.google.com/group/opendatakit/browse_thread/thread/5b1c638ac5722d4a
for more.

Yaw

··· On Thu, May 3, 2012 at 9:40 AM, Pavluck, Alex wrote: > Thanks, Mitch! Still being able to resend with briefcase and have the > Aggregate parser identify the dups is a great feature! > > Thanks to the team for all the hard work. > > > Alex Pavluck, MPH > Lymphatic Filariasis Support Center > & International Trachoma Initiative > The Task Force for Global Health > 325 Swanton Way, Decatur, GA 30030 > Cell: (404)647-4904 Fax: (404)371-1138 > apavluck@taskforce.org > > > > On Thu, May 3, 2012 at 12:35 PM, Mitch S wrote: >> >> Oops. Sorry. ODK Collect doesn't allow you to choose previously-sent >> forms. >> >> Created a feature request: >> http://code.google.com/p/opendatakit/issues/detail?id=570 >> >> Star that request to vote for it. I'll see what I can do for ODK Collect >> 1.2. >> >> Mitch >> >> >> On Thu, May 3, 2012 at 9:28 AM, Mitch S wrote: >>> >>> Argh... let me check. It might not be possible to change the status of >>> the already-sent files... >>> >>> Mitch >>> >>> >>> On Thu, May 3, 2012 at 9:08 AM, Alex Pavluck wrote: >>>> >>>> Wow, great. Last question...how? There is nothing listed in send >>>> finalized data. >>>> >>>> On Thursday, May 3, 2012 at 12:04 PM, Mitch S wrote: >>>> >>>> They can resubmit from the phones. >>>> >>>> Mitch >>>> >>>> On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck wrote: >>>> >>>> Can they resubmit from the phones or does it require briefcase? >>>> >>>> On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote: >>>> >>>> As long as your forms have an OpenRosa InstanceID ( >>>> https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema ), and >>>> if you have the bandwidth to the server available, your field teams can just >>>> resubmit all forms from the time of the crash to the present. The Aggregate >>>> server will do the de-duplication work itself -- ensuring that only a single >>>> copy of any one submission is recorded on the server. >>>> >>>> Mitch >>>> >>>> On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck wrote: >>>> >>>> Thanks, everyone. Yeah, that is the process I did in the past and it >>>> worked fine. It is a little rough on the field teams but it gets the job >>>> done. >>>> >>>> Thanks again! >>>> Alex >>>> >>>> >>>> On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote: >>>> >>>> Hooking the phones up to a PC and using Briefcase to upload the >>>> submissions from the phone to Aggregate could work. However, I am not >>>> sure if you can specify which ones to upload as you don't want to >>>> upload all submissions again I am guessing. >>>> >>>> Mitch do you have an idea? >>>> >>>> Waylon >>>> >>>> On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck wrote: >>>> > Hello all. We have successfully deployed ODK to 16 countries now and >>>> > couldn't be happier with how simple and reliable the system has been. >>>> > Today >>>> > we had an issue where a database error occured and forced us to >>>> > restore our >>>> > database from a backup, losing data submitted during approximately 12 >>>> > hours. >>>> > We know the phones which have send the data and those phones that >>>> > submitted >>>> > the data will still have that data on the sd card, so, I wanted to see >>>> > what >>>> > the best and easiest method is to get that missing data off the phones >>>> > and >>>> > to the server. >>>> > >>>> > Thanks!! >>>> > >>>> > Alex >>>> > >>>> > -- >>>> > Post: opendatakit@googlegroups.com >>>> > Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>>> > Options: http://groups.google.com/group/opendatakit?hl=en >>>> >>>> -- >>>> Post: opendatakit@googlegroups.com >>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>>> Options: http://groups.google.com/group/opendatakit?hl=en >>>> >>>> >>>> >>>> >>>> -- >>>> 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 >>>> >>>> >>>> -- >>>> Post: opendatakit@googlegroups.com >>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>>> Options: http://groups.google.com/group/opendatakit?hl=en >>>> >>>> >>>> >>>> >>>> -- >>>> 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 >>>> >>>> >>>> -- >>>> Post: opendatakit@googlegroups.com >>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>>> Options: http://groups.google.com/group/opendatakit?hl=en >>> >>> >>> >>> >>> -- >>> Mitch Sundt >>> Software Engineer >>> University of Washington >>> mitchellsundt@gmail.com >> >> >> >> >> -- >> 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 > > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en

Here is what I ended up doing and I think it was a pretty good solution.

··· * *Based on Mitch's comment about the Aggregate server identifying the dups, I took the odk directory from all the phones and put them on a new phone. When I opened ODK Collect the Send Finalized Forms showed all the data again as new. I was then able to re-send all the data to the server. It appears that it worked.

On Thu, May 3, 2012 at 3:15 PM, Yaw Anokwa yanokwa@gmail.com wrote:

Alex,

Another (potentially more difficult) option is to edit the on-phone
database to change the instance status to complete (and thus not
submitted). See

https://groups.google.com/group/opendatakit/browse_thread/thread/5b1c638ac5722d4a
for more.

Yaw

On Thu, May 3, 2012 at 9:40 AM, Pavluck, Alex apavluck@taskforce.org wrote:

Thanks, Mitch! Still being able to resend with briefcase and have the
Aggregate parser identify the dups is a great feature!

Thanks to the team for all the hard work.

Alex Pavluck, MPH
Lymphatic Filariasis Support Center
& International Trachoma Initiative
The Task Force for Global Health
325 Swanton Way, Decatur, GA 30030
Cell: (404)647-4904 Fax: (404)371-1138
apavluck@taskforce.org

On Thu, May 3, 2012 at 12:35 PM, Mitch S mitchellsundt@gmail.com wrote:

Oops. Sorry. ODK Collect doesn't allow you to choose previously-sent
forms.

Created a feature request:
http://code.google.com/p/opendatakit/issues/detail?id=570

Star that request to vote for it. I'll see what I can do for ODK Collect
1.2.

Mitch

On Thu, May 3, 2012 at 9:28 AM, Mitch S mitchellsundt@gmail.com wrote:

Argh... let me check. It might not be possible to change the status of
the already-sent files...

Mitch

On Thu, May 3, 2012 at 9:08 AM, Alex Pavluck apavluck@taskforce.org wrote:

Wow, great. Last question...how? There is nothing listed in send
finalized data.

On Thursday, May 3, 2012 at 12:04 PM, Mitch S wrote:

They can resubmit from the phones.

Mitch

On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck apavluck@taskforce.org wrote:

Can they resubmit from the phones or does it require briefcase?

On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema), and
if you have the bandwidth to the server available, your field teams
can just

resubmit all forms from the time of the crash to the present. The
Aggregate

server will do the de-duplication work itself -- ensuring that only a
single

copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck apavluck@taskforce.org wrote:

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets the
job

done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now
and

couldn't be happier with how simple and reliable the system has
been.

Today
we had an issue where a database error occured and forced us to
restore our
database from a backup, losing data submitted during approximately
12

hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to
see

what
the best and easiest method is to get that missing data off the
phones

and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

Hmmm. I don't understand why this would work. Are you using 1.1.7 ?

Mitch

··· On Thu, May 3, 2012 at 12:41 PM, Pavluck, Alex wrote:

Here is what I ended up doing and I think it was a pretty good solution.
*
*Based on Mitch's comment about the Aggregate server identifying the
dups, I took the odk directory from all the phones and put them on a new
phone. When I opened ODK Collect the Send Finalized Forms showed all the
data again as new. I was then able to re-send all the data to the server.
It appears that it worked.

On Thu, May 3, 2012 at 3:15 PM, Yaw Anokwa yanokwa@gmail.com wrote:

Alex,

Another (potentially more difficult) option is to edit the on-phone
database to change the instance status to complete (and thus not
submitted). See

https://groups.google.com/group/opendatakit/browse_thread/thread/5b1c638ac5722d4a
for more.

Yaw

On Thu, May 3, 2012 at 9:40 AM, Pavluck, Alex apavluck@taskforce.org wrote:

Thanks, Mitch! Still being able to resend with briefcase and have the
Aggregate parser identify the dups is a great feature!

Thanks to the team for all the hard work.

Alex Pavluck, MPH
Lymphatic Filariasis Support Center
& International Trachoma Initiative
The Task Force for Global Health
325 Swanton Way, Decatur, GA 30030
Cell: (404)647-4904 Fax: (404)371-1138
apavluck@taskforce.org

On Thu, May 3, 2012 at 12:35 PM, Mitch S mitchellsundt@gmail.com wrote:

Oops. Sorry. ODK Collect doesn't allow you to choose previously-sent
forms.

Created a feature request:
http://code.google.com/p/opendatakit/issues/detail?id=570

Star that request to vote for it. I'll see what I can do for ODK
Collect

1.2.

Mitch

On Thu, May 3, 2012 at 9:28 AM, Mitch S mitchellsundt@gmail.com wrote:

Argh... let me check. It might not be possible to change the status
of

the already-sent files...

Mitch

On Thu, May 3, 2012 at 9:08 AM, Alex Pavluck apavluck@taskforce.org wrote:

Wow, great. Last question...how? There is nothing listed in send
finalized data.

On Thursday, May 3, 2012 at 12:04 PM, Mitch S wrote:

They can resubmit from the phones.

Mitch

On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck <apavluck@taskforce.org wrote:

Can they resubmit from the phones or does it require briefcase?

On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema), and
if you have the bandwidth to the server available, your field teams
can just

resubmit all forms from the time of the crash to the present. The
Aggregate

server will do the de-duplication work itself -- ensuring that only
a single

copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck <apavluck@taskforce.org wrote:

Thanks, everyone. Yeah, that is the process I did in the past and it
worked fine. It is a little rough on the field teams but it gets
the job

done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am not
sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck <apavluck@taskforce.org wrote:

Hello all. We have successfully deployed ODK to 16 countries now
and

couldn't be happier with how simple and reliable the system has
been.

Today
we had an issue where a database error occured and forced us to
restore our
database from a backup, losing data submitted during approximately
12

hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted to
see

what
the best and easiest method is to get that missing data off the
phones

and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Yeah, 1.1.7 on all phones.

Alex Pavluck*, MPH*
Lymphatic Filariasis Support Center
& International Trachoma Initiative
The Task Force for Global Health
325 Swanton Way, Decatur, GA 30030
Cell: (404)647-4904 Fax: (404)371-1138
apavluck@taskforce.org apavluck@taskforce.org

··· On Thu, May 3, 2012 at 5:18 PM, Mitch S wrote:

Hmmm. I don't understand why this would work. Are you using 1.1.7 ?

Mitch

On Thu, May 3, 2012 at 12:41 PM, Pavluck, Alex apavluck@taskforce.orgwrote:

Here is what I ended up doing and I think it was a pretty good solution.
*
*Based on Mitch's comment about the Aggregate server identifying the
dups, I took the odk directory from all the phones and put them on a new
phone. When I opened ODK Collect the Send Finalized Forms showed all the
data again as new. I was then able to re-send all the data to the server.
It appears that it worked.

On Thu, May 3, 2012 at 3:15 PM, Yaw Anokwa yanokwa@gmail.com wrote:

Alex,

Another (potentially more difficult) option is to edit the on-phone
database to change the instance status to complete (and thus not
submitted). See

https://groups.google.com/group/opendatakit/browse_thread/thread/5b1c638ac5722d4a
for more.

Yaw

On Thu, May 3, 2012 at 9:40 AM, Pavluck, Alex apavluck@taskforce.org wrote:

Thanks, Mitch! Still being able to resend with briefcase and have the
Aggregate parser identify the dups is a great feature!

Thanks to the team for all the hard work.

Alex Pavluck, MPH
Lymphatic Filariasis Support Center
& International Trachoma Initiative
The Task Force for Global Health
325 Swanton Way, Decatur, GA 30030
Cell: (404)647-4904 Fax: (404)371-1138
apavluck@taskforce.org

On Thu, May 3, 2012 at 12:35 PM, Mitch S mitchellsundt@gmail.com wrote:

Oops. Sorry. ODK Collect doesn't allow you to choose previously-sent
forms.

Created a feature request:
http://code.google.com/p/opendatakit/issues/detail?id=570

Star that request to vote for it. I'll see what I can do for ODK
Collect

1.2.

Mitch

On Thu, May 3, 2012 at 9:28 AM, Mitch S mitchellsundt@gmail.com wrote:

Argh... let me check. It might not be possible to change the status
of

the already-sent files...

Mitch

On Thu, May 3, 2012 at 9:08 AM, Alex Pavluck <apavluck@taskforce.org wrote:

Wow, great. Last question...how? There is nothing listed in send
finalized data.

On Thursday, May 3, 2012 at 12:04 PM, Mitch S wrote:

They can resubmit from the phones.

Mitch

On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck < apavluck@taskforce.org> wrote:

Can they resubmit from the phones or does it require briefcase?

On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote:

As long as your forms have an OpenRosa InstanceID (
https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema), and
if you have the bandwidth to the server available, your field teams
can just

resubmit all forms from the time of the crash to the present. The
Aggregate

server will do the de-duplication work itself -- ensuring that only
a single

copy of any one submission is recorded on the server.

Mitch

On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck < apavluck@taskforce.org> wrote:

Thanks, everyone. Yeah, that is the process I did in the past and
it

worked fine. It is a little rough on the field teams but it gets
the job

done.

Thanks again!
Alex

On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote:

Hooking the phones up to a PC and using Briefcase to upload the
submissions from the phone to Aggregate could work. However, I am
not

sure if you can specify which ones to upload as you don't want to
upload all submissions again I am guessing.

Mitch do you have an idea?

Waylon

On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck < apavluck@taskforce.org> wrote:

Hello all. We have successfully deployed ODK to 16 countries now
and

couldn't be happier with how simple and reliable the system has
been.

Today
we had an issue where a database error occured and forced us to
restore our
database from a backup, losing data submitted during
approximately 12

hours.
We know the phones which have send the data and those phones that
submitted
the data will still have that data on the sd card, so, I wanted
to see

what
the best and easiest method is to get that missing data off the
phones

and
to the server.

Thanks!!

Alex

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

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

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

Mitch,
This made me concerned and upon further inspection, you are right, it
actually didn't work. The whole process looked like it was working as I
described, however, no data was added to the server. I used briefcase to
upload the data and that worked as expected.

Thanks again,
Alex

··· On Thursday, May 3, 2012 5:18:54 PM UTC-4, Mitch wrote: > > Hmmm. I don't understand why this would work. Are you using 1.1.7 ? > > Mitch > > On Thu, May 3, 2012 at 12:41 PM, Pavluck, Alex wrote: > >> Here is what I ended up doing and I think it was a pretty good solution. >> * >> *Based on Mitch's comment about the Aggregate server identifying the >> dups, I took the odk directory from all the phones and put them on a new >> phone. When I opened ODK Collect the Send Finalized Forms showed all the >> data again as new. I was then able to re-send all the data to the server. >> It appears that it worked. >> >> >> >> >> On Thu, May 3, 2012 at 3:15 PM, Yaw Anokwa wrote: >> >>> Alex, >>> >>> Another (potentially more difficult) option is to edit the on-phone >>> database to change the instance status to complete (and thus not >>> submitted). See >>> >>> https://groups.google.com/group/opendatakit/browse_thread/thread/5b1c638ac5722d4a >>> for more. >>> >>> Yaw >>> >>> On Thu, May 3, 2012 at 9:40 AM, Pavluck, Alex wrote: >>> > Thanks, Mitch! Still being able to resend with briefcase and have the >>> > Aggregate parser identify the dups is a great feature! >>> > >>> > Thanks to the team for all the hard work. >>> > >>> > >>> > Alex Pavluck, MPH >>> > Lymphatic Filariasis Support Center >>> > & International Trachoma Initiative >>> > The Task Force for Global Health >>> > 325 Swanton Way, Decatur, GA 30030 >>> > Cell: (404)647-4904 Fax: (404)371-1138 >>> > apavluck@taskforce.org >>> > >>> > >>> > >>> > On Thu, May 3, 2012 at 12:35 PM, Mitch S wrote: >>> >> >>> >> Oops. Sorry. ODK Collect doesn't allow you to choose previously-sent >>> >> forms. >>> >> >>> >> Created a feature request: >>> >> http://code.google.com/p/opendatakit/issues/detail?id=570 >>> >> >>> >> Star that request to vote for it. I'll see what I can do for ODK >>> Collect >>> >> 1.2. >>> >> >>> >> Mitch >>> >> >>> >> >>> >> On Thu, May 3, 2012 at 9:28 AM, Mitch S wrote: >>> >>> >>> >>> Argh... let me check. It might not be possible to change the status >>> of >>> >>> the already-sent files... >>> >>> >>> >>> Mitch >>> >>> >>> >>> >>> >>> On Thu, May 3, 2012 at 9:08 AM, Alex Pavluck >> >>>> >>> >>>> Wow, great. Last question...how? There is nothing listed in send >>> >>>> finalized data. >>> >>>> >>> >>>> On Thursday, May 3, 2012 at 12:04 PM, Mitch S wrote: >>> >>>> >>> >>>> They can resubmit from the phones. >>> >>>> >>> >>>> Mitch >>> >>>> >>> >>>> On Thu, May 3, 2012 at 9:03 AM, Alex Pavluck < apavluck@taskforce.org> wrote: >>> >>>> >>> >>>> Can they resubmit from the phones or does it require briefcase? >>> >>>> >>> >>>> On Thursday, May 3, 2012 at 11:51 AM, Mitch S wrote: >>> >>>> >>> >>>> As long as your forms have an OpenRosa InstanceID ( >>> >>>> https://bitbucket.org/javarosa/javarosa/wiki/OpenRosaMetaDataSchema), and >>> >>>> if you have the bandwidth to the server available, your field teams >>> can just >>> >>>> resubmit all forms from the time of the crash to the present. The >>> Aggregate >>> >>>> server will do the de-duplication work itself -- ensuring that only >>> a single >>> >>>> copy of any one submission is recorded on the server. >>> >>>> >>> >>>> Mitch >>> >>>> >>> >>>> On Thu, May 3, 2012 at 8:26 AM, Alex Pavluck < apavluck@taskforce.org> wrote: >>> >>>> >>> >>>> Thanks, everyone. Yeah, that is the process I did in the past and >>> it >>> >>>> worked fine. It is a little rough on the field teams but it gets >>> the job >>> >>>> done. >>> >>>> >>> >>>> Thanks again! >>> >>>> Alex >>> >>>> >>> >>>> >>> >>>> On Thursday, May 3, 2012 3:29:42 AM UTC-4, waylon wrote: >>> >>>> >>> >>>> Hooking the phones up to a PC and using Briefcase to upload the >>> >>>> submissions from the phone to Aggregate could work. However, I am >>> not >>> >>>> sure if you can specify which ones to upload as you don't want to >>> >>>> upload all submissions again I am guessing. >>> >>>> >>> >>>> Mitch do you have an idea? >>> >>>> >>> >>>> Waylon >>> >>>> >>> >>>> On Wed, May 2, 2012 at 9:54 PM, Alex Pavluck < apavluck@taskforce.org> wrote: >>> >>>> > Hello all. We have successfully deployed ODK to 16 countries now >>> and >>> >>>> > couldn't be happier with how simple and reliable the system has >>> been. >>> >>>> > Today >>> >>>> > we had an issue where a database error occured and forced us to >>> >>>> > restore our >>> >>>> > database from a backup, losing data submitted during >>> approximately 12 >>> >>>> > hours. >>> >>>> > We know the phones which have send the data and those phones that >>> >>>> > submitted >>> >>>> > the data will still have that data on the sd card, so, I wanted >>> to see >>> >>>> > what >>> >>>> > the best and easiest method is to get that missing data off the >>> phones >>> >>>> > and >>> >>>> > to the server. >>> >>>> > >>> >>>> > Thanks!! >>> >>>> > >>> >>>> > Alex >>> >>>> > >>> >>>> > -- >>> >>>> > Post: opendatakit@googlegroups.com >>> >>>> > Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> >>>> > Options: http://groups.google.com/group/opendatakit?hl=en >>> >>>> >>> >>>> -- >>> >>>> Post: opendatakit@googlegroups.com >>> >>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> >>>> Options: http://groups.google.com/group/opendatakit?hl=en >>> >>>> >>> >>>> >>> >>>> >>> >>>> >>> >>>> -- >>> >>>> 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 >>> >>>> >>> >>>> >>> >>>> -- >>> >>>> Post: opendatakit@googlegroups.com >>> >>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> >>>> Options: http://groups.google.com/group/opendatakit?hl=en >>> >>>> >>> >>>> >>> >>>> >>> >>>> >>> >>>> -- >>> >>>> 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 >>> >>>> >>> >>>> >>> >>>> -- >>> >>>> Post: opendatakit@googlegroups.com >>> >>>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> >>>> Options: http://groups.google.com/group/opendatakit?hl=en >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> -- >>> >>> Mitch Sundt >>> >>> Software Engineer >>> >>> University of Washington >>> >>> mitchellsundt@gmail.com >>> >> >>> >> >>> >> >>> >> >>> >> -- >>> >> 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 >>> > >>> > >>> > -- >>> > Post: opendatakit@googlegroups.com >>> > Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> > Options: http://groups.google.com/group/opendatakit?hl=en >>> >>> -- >>> Post: opendatakit@googlegroups.com >>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >>> Options: http://groups.google.com/group/opendatakit?hl=en >>> >> >> -- >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitchellsundt@gmail.com >