Is there an easy way to delete all the data from the aggregate server

I am setting up a system where the project manager downloads all the data
from Aggregate every night and then I pull the CSV into Access and
manipulate it into an Access database.

After reading the data into Access, I want to get all the existing data out
of Aggregate. It seems like this should be an easy task but I have not seen
a way to do it.

We'll have 40 users submitting 20 or 30 forms a day so deleting them one by
one is not a good solution.

Mike,

Use ODK Briefcase's command line interface to download the data,
export the specific date ranges you need to CSV, and pull those CSVs
into Access. https://opendatakit.org/use/briefcase has more info.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Fri, Mar 27, 2015 at 5:00 PM, Mike Miller oei.cloud.server@gmail.com wrote:

I am setting up a system where the project manager downloads all the data
from Aggregate every night and then I pull the CSV into Access and
manipulate it into an Access database.

After reading the data into Access, I want to get all the existing data out
of Aggregate. It seems like this should be an easy task but I have not seen
a way to do it.

We'll have 40 users submitting 20 or 30 forms a day so deleting them one by
one is not a good solution.

--

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.

The data is encrypted, so you will no be able to get to know the dates or
so. You will get rubbish data for each record. So it is better to download
the data first, and then delete the form, and upload it again. I sometimes
do this to save some of our daily quota.

The data is encrypted, so you will no be able to get to know the dates or
so. You will get rubbish data for each record. So it is better to download
the data first, and then delete the form, and upload it again. I sometimes
do this to save some of our daily quota.

I was looking for the same way out. Using ODK briefcase data can be pulled
to csv files but those data will still be available on the server. However,
for the better management of server memory we should delete the data from
server in regular intervals. Can briefcase do that? Or is there ant other
way to do so?

Thanks,
Ehsan

··· On Saturday, March 28, 2015 at 6:42:45 AM UTC+6, Yaw Anokwa wrote: > > Mike, > > Use ODK Briefcase's command line interface to download the data, > export the specific date ranges you need to CSV, and pull those CSVs > into Access. https://opendatakit.org/use/briefcase has more info. > > Yaw > -- > Need ODK services? http://nafundi.com provides form design, server > setup, professional support, and software development for ODK. > > On Fri, Mar 27, 2015 at 5:00 PM, Mike Miller <oei.clou...@gmail.com > wrote: > > I am setting up a system where the project manager downloads all the > data > > from Aggregate every night and then I pull the CSV into Access and > > manipulate it into an Access database. > > > > After reading the data into Access, I want to get all the existing data > out > > of Aggregate. It seems like this should be an easy task but I have not > seen > > a way to do it. > > > > We'll have 40 users submitting 20 or 30 forms a day so deleting them one > by > > one is not a good solution. > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@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...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >

There is no similar functionality for form definitions.

··· On Wed, Oct 21, 2015 at 1:47 AM, Hanan Aqilan wrote:

The data is encrypted, so you will no be able to get to know the dates or
so. You will get rubbish data for each record. So it is better to download
the data first, and then delete the form, and upload it again. I sometimes
do this to save some of our daily quota.

--

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

Hi Ehsan,

There is no programmatic way to delete data in Aggregate. Sounds like
a good thing that someone in the community could add.

Yaw

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

On Tue, Oct 20, 2015 at 3:24 PM, Ehsan Haque ehuqtamal@gmail.com wrote:

I was looking for the same way out. Using ODK briefcase data can be pulled
to csv files but those data will still be available on the server. However,
for the better management of server memory we should delete the data from
server in regular intervals. Can briefcase do that? Or is there ant other
way to do so?

Thanks,
Ehsan

On Saturday, March 28, 2015 at 6:42:45 AM UTC+6, Yaw Anokwa wrote:

Mike,

Use ODK Briefcase's command line interface to download the data,
export the specific date ranges you need to CSV, and pull those CSVs
into Access. https://opendatakit.org/use/briefcase has more info.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Fri, Mar 27, 2015 at 5:00 PM, Mike Miller oei.clou...@gmail.com wrote:

I am setting up a system where the project manager downloads all the
data
from Aggregate every night and then I pull the CSV into Access and
manipulate it into an Access database.

After reading the data into Access, I want to get all the existing data
out
of Aggregate. It seems like this should be an easy task but I have not
seen
a way to do it.

We'll have 40 users submitting 20 or 30 forms a day so deleting them one
by
one is not a good solution.

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@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.

Keep in mind that deleting form definitions deletes all the data tables
associated with them, which can take substantial time and quota.

In some cases, it may be cheaper to leave the forms on the server and
abandon it; switching your devices to use a new AppEngine application id
and then mark the older server for destruction. Then, at least, Google
assumes the cost of removal of the data, and not you.

··· On Wed, Oct 21, 2015 at 10:49 AM, Mitch Sundt wrote:

There is no similar functionality for form definitions.

On Wed, Oct 21, 2015 at 1:47 AM, Hanan Aqilan hjameelq@gmail.com wrote:

The data is encrypted, so you will no be able to get to know the dates or
so. You will get rubbish data for each record. So it is better to download
the data first, and then delete the form, and upload it again. I sometimes
do this to save some of our daily quota.

--

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 Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

The manual way to do this is to:

  1. log onto your ODK Aggregate instance with a username with Forms
    Management permissions,
  2. navigate to the Forms Management / Submission Admin sub-tab
  3. click Purge Submission Data
  4. choose a date before the date you ran ODK Briefcase.
··· On Tue, Oct 20, 2015 at 3:16 AM, Yaw Anokwa wrote:

Hi Ehsan,

There is no programmatic way to delete data in Aggregate. Sounds like
a good thing that someone in the community could add.

Yaw

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

On Tue, Oct 20, 2015 at 3:24 PM, Ehsan Haque ehuqtamal@gmail.com wrote:

I was looking for the same way out. Using ODK briefcase data can be
pulled
to csv files but those data will still be available on the server.
However,
for the better management of server memory we should delete the data from
server in regular intervals. Can briefcase do that? Or is there ant other
way to do so?

Thanks,
Ehsan

On Saturday, March 28, 2015 at 6:42:45 AM UTC+6, Yaw Anokwa wrote:

Mike,

Use ODK Briefcase's command line interface to download the data,
export the specific date ranges you need to CSV, and pull those CSVs
into Access. https://opendatakit.org/use/briefcase has more info.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Fri, Mar 27, 2015 at 5:00 PM, Mike Miller oei.clou...@gmail.com wrote:

I am setting up a system where the project manager downloads all the
data
from Aggregate every night and then I pull the CSV into Access and
manipulate it into an Access database.

After reading the data into Access, I want to get all the existing
data

out
of Aggregate. It seems like this should be an easy task but I have not
seen
a way to do it.

We'll have 40 users submitting 20 or 30 forms a day so deleting them
one

by
one is not a good solution.

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@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 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

Thanks Mitch. Its really helpful. Is there a similar way to delete form
definitions form the aggregate server upto certain date?

··· On Tuesday, October 20, 2015 at 10:19:53 PM UTC+6, Mitch Sundt wrote: > > The manual way to do this is to: > > 1. log onto your ODK Aggregate instance with a username with Forms > Management permissions, > 2. navigate to the Forms Management / Submission Admin sub-tab > 3. click Purge Submission Data > 4. choose a date before the date you ran ODK Briefcase. > > > On Tue, Oct 20, 2015 at 3:16 AM, Yaw Anokwa <yan...@nafundi.com > wrote: > >> Hi Ehsan, >> >> There is no programmatic way to delete data in Aggregate. Sounds like >> a good thing that someone in the community could add. >> >> Yaw >> -- >> Need ODK consultants? https://nafundi.com provides form design, server >> setup, in-field training, and software development for ODK. >> >> On Tue, Oct 20, 2015 at 3:24 PM, Ehsan Haque <ehuq...@gmail.com > wrote: >> > I was looking for the same way out. Using ODK briefcase data can be >> pulled >> > to csv files but those data will still be available on the server. >> However, >> > for the better management of server memory we should delete the data >> from >> > server in regular intervals. Can briefcase do that? Or is there ant >> other >> > way to do so? >> > >> > Thanks, >> > Ehsan >> > >> > >> > On Saturday, March 28, 2015 at 6:42:45 AM UTC+6, Yaw Anokwa wrote: >> >> >> >> Mike, >> >> >> >> Use ODK Briefcase's command line interface to download the data, >> >> export the specific date ranges you need to CSV, and pull those CSVs >> >> into Access. https://opendatakit.org/use/briefcase has more info. >> >> >> >> Yaw >> >> -- >> >> Need ODK services? http://nafundi.com provides form design, server >> >> setup, professional support, and software development for ODK. >> >> >> >> On Fri, Mar 27, 2015 at 5:00 PM, Mike Miller wrote: >> >> > I am setting up a system where the project manager downloads all the >> >> > data >> >> > from Aggregate every night and then I pull the CSV into Access and >> >> > manipulate it into an Access database. >> >> > >> >> > After reading the data into Access, I want to get all the existing >> data >> >> > out >> >> > of Aggregate. It seems like this should be an easy task but I have >> not >> >> > seen >> >> > a way to do it. >> >> > >> >> > We'll have 40 users submitting 20 or 30 forms a day so deleting them >> one >> >> > by >> >> > one is not a good solution. >> >> > >> >> > -- >> >> > -- >> >> > Post: opend...@googlegroups.com >> >> > Unsubscribe: opendatakit...@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...@googlegroups.com. >> >> > For more options, visit https://groups.google.com/d/optout. >> > >> > -- >> > -- >> > Post: opend...@googlegroups.com >> > Unsubscribe: opendatakit...@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...@googlegroups.com . >> > For more options, visit https://groups.google.com/d/optout. >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@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...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >