Merging XML Data

Hello Community,
For some reasons, i want to sumbit XML data from instances folder of my
Phone into GAE aggregate server. It is proving tiresome to upload one
submission after another. Is there a solution I can use to merge the XML
data into a single file to submit just once. (All data is using the same
form id)

··· -- Gichure Paul Regards.

merging them all won't work.

you should be able to select all the submissions in collect (don't
remember if it's in 1.1.5 or if it was added to 1.1.7) and post that
way. or write a script to loop through the instances and upload.

we are working on a desktop tool that will make this process easier,
but it's not ready for release.

··· On Tue, Aug 30, 2011 at 12:08, Gichure wrote: > Hello Community, > For some reasons, i want to sumbit XML data from instances folder of my > Phone into GAE aggregate server. It is proving tiresome to upload one > submission after another. Is there a solution I can use to merge the XML > data into a single file to submit just once. (All data is using the same > form id) > > -- > Gichure Paul > Regards. > > >

The data had earlier been submitted to a different server and thus the
option to select all is not available(I think its only available when doing
a first submission).

··· On Tue, Aug 30, 2011 at 12:17 PM, Yaw Anokwa wrote:

merging them all won't work.

you should be able to select all the submissions in collect (don't
remember if it's in 1.1.5 or if it was added to 1.1.7) and post that
way. or write a script to loop through the instances and upload.

we are working on a desktop tool that will make this process easier,
but it's not ready for release.

On Tue, Aug 30, 2011 at 12:08, Gichure gichurepaul@gmail.com wrote:

Hello Community,
For some reasons, i want to sumbit XML data from instances folder of my
Phone into GAE aggregate server. It is proving tiresome to upload one
submission after another. Is there a solution I can use to merge the XML
data into a single file to submit just once. (All data is using the same
form id)

--
Gichure Paul
Regards.

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

--
Gichure Paul
Regards.

if you didn't wipe phone, the data is still there -- just hidden from
the user interface. you will need to use a sqlite db editor to change
the instance state from submitted to complete.
http://groups.google.com/group/opendatakit/browse_thread/thread/5b1c638ac5722d4a
should offer some guidance.

··· On Tue, Aug 30, 2011 at 12:28, Gichure wrote: > The data had earlier been submitted to a different server and thus the > option to select all is not available(I think its only available when doing > a first submission). > > On Tue, Aug 30, 2011 at 12:17 PM, Yaw Anokwa wrote: >> >> merging them all won't work. >> >> you should be able to select all the submissions in collect (don't >> remember if it's in 1.1.5 or if it was added to 1.1.7) and post that >> way. or write a script to loop through the instances and upload. >> >> we are working on a desktop tool that will make this process easier, >> but it's not ready for release. >> >> On Tue, Aug 30, 2011 at 12:08, Gichure wrote: >> > Hello Community, >> > For some reasons, i want to sumbit XML data from instances folder of my >> > Phone into GAE aggregate server. It is proving tiresome to upload one >> > submission after another. Is there a solution I can use to merge the XML >> > data into a single file to submit just once. (All data is using the same >> > form id) >> > >> > -- >> > Gichure Paul >> > Regards. >> > >> > >> > >> >> -- >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en > > > > -- > Gichure Paul > Regards. > > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >

I also have the same problem as stated above and its tiresome
uploading one submision after the other. How can I change the instance
state.
Thanks

··· On Aug 30, 12:45 pm, Yaw Anokwa wrote: > if you didn't wipe phone, the data is still there -- just hidden from > the user interface. you will need to use a sqlite db editor to change > the instance state from submitted to complete.http://groups.google.com/group/opendatakit/browse_thread/thread/5b1c6... > should offer some guidance. > > > > > > > > On Tue, Aug 30, 2011 at 12:28, Gichure wrote: > > The data had earlier been submitted to a different server and thus the > > option to select all is not available(I think its only available when doing > > a first submission). > > > On Tue, Aug 30, 2011 at 12:17 PM, Yaw Anokwa wrote: > > >> merging them all won't work. > > >> you should be able to select all the submissions in collect (don't > >> remember if it's in 1.1.5 or if it was added to 1.1.7) and post that > >> way. or write a script to loop through the instances and upload. > > >> we are working on a desktop tool that will make this process easier, > >> but it's not ready for release. > > >> On Tue, Aug 30, 2011 at 12:08, Gichure wrote: > >> > Hello Community, > >> > For some reasons, i want to sumbit XML data from instances folder of my > >> > Phone into GAE aggregate server. It is proving tiresome to upload one > >> > submission after another. Is there a solution I can use to merge the XML > >> > data into a single file to submit just once. (All data is using the same > >> > form id) > > >> > -- > >> > Gichure Paul > >> > Regards. > > >> -- > >> Post: opendatakit@googlegroups.com > >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com > >> Options:http://groups.google.com/group/opendatakit?hl=en > > > -- > > Gichure Paul > > Regards. > > > -- > > Post: opendatakit@googlegroups.com > > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > > Options:http://groups.google.com/group/opendatakit?hl=en

get a sqlite3 db manager (try base on the mac or
http://stackoverflow.com/questions/1507506/what-are-good-open-source-gui-sqlite-database-managers).

you'll find the odk databases in /sdcard/odk/metadata. the changes to
the instance records you need to make should be fairly intuitive.

··· On Tue, Aug 30, 2011 at 15:18, Keniajin wrote: > I also have the same problem as stated above and its tiresome > uploading one submision after the other. How can I change the instance > state. > Thanks > > On Aug 30, 12:45 pm, Yaw Anokwa wrote: >> if you didn't wipe phone, the data is still there -- just hidden from >> the user interface. you will need to use a sqlite db editor to change >> the instance state from submitted to complete.http://groups.google.com/group/opendatakit/browse_thread/thread/5b1c6... >> should offer some guidance. >> >> >> >> >> >> >> >> On Tue, Aug 30, 2011 at 12:28, Gichure wrote: >> > The data had earlier been submitted to a different server and thus the >> > option to select all is not available(I think its only available when doing >> > a first submission). >> >> > On Tue, Aug 30, 2011 at 12:17 PM, Yaw Anokwa wrote: >> >> >> merging them all won't work. >> >> >> you should be able to select all the submissions in collect (don't >> >> remember if it's in 1.1.5 or if it was added to 1.1.7) and post that >> >> way. or write a script to loop through the instances and upload. >> >> >> we are working on a desktop tool that will make this process easier, >> >> but it's not ready for release. >> >> >> On Tue, Aug 30, 2011 at 12:08, Gichure wrote: >> >> > Hello Community, >> >> > For some reasons, i want to sumbit XML data from instances folder of my >> >> > Phone into GAE aggregate server. It is proving tiresome to upload one >> >> > submission after another. Is there a solution I can use to merge the XML >> >> > data into a single file to submit just once. (All data is using the same >> >> > form id) >> >> >> > -- >> >> > Gichure Paul >> >> > Regards. >> >> >> -- >> >> Post: opendatakit@googlegroups.com >> >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> >> Options:http://groups.google.com/group/opendatakit?hl=en >> >> > -- >> > Gichure Paul >> > Regards. >> >> > -- >> > 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 >