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
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
There is no similar functionality for form definitions.
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
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,
EhsanOn 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.
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:
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,
EhsanOn 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?