Hi
Is there any way to automate the export of survey results?. I would like to
have each days submissions exported to a csv file via a cron or the likes.
Thanks
Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.
If someone writes and contributes the code for this, we will fold it into
the main source tree....
Note that FormUploader is an example of an extra 'main' within the same
source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.
Mitch
···
On Tue, Oct 23, 2012 at 6:58 AM, Bashir Jahed wrote:Hi
Is there any way to automate the export of survey results?. I would like
to have each days submissions exported to a csv file via a cron or the
likes.Thanks
--
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,
What about the idea of scripting this "cron" action in Google spreadsheets,
since data can be pushed there? Just a thought.
Curtis
···
Le 23 oct. 2012 18:58, "Mitch S" a écrit :Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold it into
the main source tree....Note that FormUploader is an example of an extra 'main' within the same
source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
On Tue, Oct 23, 2012 at 6:58 AM, Bashir Jahed admin@osilab.net wrote:
Hi
Is there any way to automate the export of survey results?. I would like
to have each days submissions exported to a csv file via a cron or the
likes.Thanks
--
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
"If someone writes and contributes the code for this, we will fold it into
the main source tree...."
That would be brilliant. I'd thought about code which could review form
data that had already been downloaded and only download items which had
been added since it was last run. Thus if you have 23 items on the server
and have previously downloaded 20 of them - when you re-run the download
program it would only fetch the missing 3.
Thanks
Kirby
···
On Tuesday, 23 October 2012 17:58:10 UTC+1, Mitch wrote: > > Not currently. This would best be done by adding a non-graphical > command-line 'main' to ODK Briefcase so that it can be called directly from > a cron stript to download submissions, and, then, to export those to a CSV. > > If someone writes and contributes the code for this, we will fold it into > the main source tree.... > > Note that FormUploader is an example of an extra 'main' within the same > source tree launching a different look for the ODK Briefcase code. It > should be fairly straightforward to write a new "BriefcaseCmdLine" class > that parses command line arguments and performs the download or the export > of data. > > Mitch > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >Yes! Thank you Curtis.
You can set up ODK Aggregate to publish data to Google Spreadsheets as it
comes in.
Then, within Google Spreadsheets, you can define a script and have it run
periodically. Here is a tutorial showing some of the capabilities of this
feature: https://developers.google.com/apps-script/articles/gmail-stats
Mitch
···
On Tue, Oct 23, 2012 at 10:07 AM, Curtis Broderick < c.broderick@epiconcept.fr> wrote:Mitch,
What about the idea of scripting this "cron" action in Google
spreadsheets, since data can be pushed there? Just a thought.
Curtis
Le 23 oct. 2012 18:58, "Mitch S" mitchellsundt@gmail.com a écrit :Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold it into
the main source tree....Note that FormUploader is an example of an extra 'main' within the same
source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
On Tue, Oct 23, 2012 at 6:58 AM, Bashir Jahed admin@osilab.net wrote:
Hi
Is there any way to automate the export of survey results?. I would like
to have each days submissions exported to a csv file via a cron or the
likes.Thanks
--
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
It would be great is we could publish all data to spreadsheets. any
documentation on how to accomplish this functionality?
···
On Tue, Oct 23, 2012 at 7:20 PM, Mitch S wrote:Yes! Thank you Curtis.
You can set up ODK Aggregate to publish data to Google Spreadsheets as it
comes in.
Then, within Google Spreadsheets, you can define a script and have it run
periodically. Here is a tutorial showing some of the capabilities of this
feature: https://developers.google.com/apps-script/articles/gmail-statsMitch
On Tue, Oct 23, 2012 at 10:07 AM, Curtis Broderick < c.broderick@epiconcept.fr> wrote:
Mitch,
What about the idea of scripting this "cron" action in Google
spreadsheets, since data can be pushed there? Just a thought.
Curtis
Le 23 oct. 2012 18:58, "Mitch S" mitchellsundt@gmail.com a écrit :Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold it
into the main source tree....Note that FormUploader is an example of an extra 'main' within the same
source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
On Tue, Oct 23, 2012 at 6:58 AM, Bashir Jahed admin@osilab.net wrote:
Hi
Is there any way to automate the export of survey results?. I would
like to have each days submissions exported to a csv file via a cron or the
likes.Thanks
--
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
I think most ODK users would find this useful. Now if only I could code or
had the cash to pay for it to happen!
···
On Thu, Oct 25, 2012 at 9:08 AM, KirbyJames wrote:"If someone writes and contributes the code for this, we will fold it
into the main source tree...."That would be brilliant. I'd thought about code which could review form
data that had already been downloaded and only download items which had
been added since it was last run. Thus if you have 23 items on the server
and have previously downloaded 20 of them - when you re-run the download
program it would only fetch the missing 3.Thanks
Kirby
On Tuesday, 23 October 2012 17:58:10 UTC+1, Mitch wrote:
Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold it into
the main source tree....Note that FormUploader is an example of an extra 'main' within the same
source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
On either the 'Submissions' tab or the 'Form Management' tab, click on
'Publish =>'
Choose Publish To: 'Google Spreadsheets'
Choose Data to Publish: 'BOTH ...'
Enter a workbook name.
Choose 'Publish =>'
and proceed with authentication/setup steps.
Data that you already have and data that will come into Aggregate in the
future will be published to the specified workbook and available on Google
Drive.
Mitch
···
On Tue, Oct 23, 2012 at 11:48 AM, Bashir Jahed wrote:It would be great is we could publish all data to spreadsheets. any
documentation on how to accomplish this functionality?On Tue, Oct 23, 2012 at 7:20 PM, Mitch S mitchellsundt@gmail.com wrote:
Yes! Thank you Curtis.
You can set up ODK Aggregate to publish data to Google Spreadsheets as it
comes in.
Then, within Google Spreadsheets, you can define a script and have it run
periodically. Here is a tutorial showing some of the capabilities of this
feature: https://developers.google.com/apps-script/articles/gmail-statsMitch
On Tue, Oct 23, 2012 at 10:07 AM, Curtis Broderick < c.broderick@epiconcept.fr> wrote:
Mitch,
What about the idea of scripting this "cron" action in Google
spreadsheets, since data can be pushed there? Just a thought.
Curtis
Le 23 oct. 2012 18:58, "Mitch S" mitchellsundt@gmail.com a écrit :Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold it
into the main source tree....Note that FormUploader is an example of an extra 'main' within the same
source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
On Tue, Oct 23, 2012 at 6:58 AM, Bashir Jahed admin@osilab.net wrote:
Hi
Is there any way to automate the export of survey results?. I would
like to have each days submissions exported to a csv file via a cron or the
likes.Thanks
--
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
I tried this with limited success.
the spreadsheet is created in google drive but the spreadsheet is empty.
Any advise
Bash
···
On Wed, Oct 24, 2012 at 12:09 AM, Mitch S wrote:On either the 'Submissions' tab or the 'Form Management' tab, click on
'Publish =>'Choose Publish To: 'Google Spreadsheets'
Choose Data to Publish: 'BOTH ...'
Enter a workbook name.
Choose 'Publish =>'
and proceed with authentication/setup steps.Data that you already have and data that will come into Aggregate in the
future will be published to the specified workbook and available on Google
Drive.Mitch
On Tue, Oct 23, 2012 at 11:48 AM, Bashir Jahed admin@osilab.net wrote:
It would be great is we could publish all data to spreadsheets. any
documentation on how to accomplish this functionality?On Tue, Oct 23, 2012 at 7:20 PM, Mitch S mitchellsundt@gmail.com wrote:
Yes! Thank you Curtis.
You can set up ODK Aggregate to publish data to Google Spreadsheets as
it comes in.
Then, within Google Spreadsheets, you can define a script and have it
run periodically. Here is a tutorial showing some of the capabilities of
this feature:
https://developers.google.com/apps-script/articles/gmail-statsMitch
On Tue, Oct 23, 2012 at 10:07 AM, Curtis Broderick < c.broderick@epiconcept.fr> wrote:
Mitch,
What about the idea of scripting this "cron" action in Google
spreadsheets, since data can be pushed there? Just a thought.
Curtis
Le 23 oct. 2012 18:58, "Mitch S" mitchellsundt@gmail.com a écrit :Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold it
into the main source tree....Note that FormUploader is an example of an extra 'main' within the
same source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
On Tue, Oct 23, 2012 at 6:58 AM, Bashir Jahed admin@osilab.netwrote:
Hi
Is there any way to automate the export of survey results?. I would
like to have each days submissions exported to a csv file via a cron or the
likes.Thanks
--
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--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
Note also that ODK Briefcase already has logic in it to only download new
records from the server.
So if you wanted to just export data that was newly received, you have at
least some of the information you'd need to do that.
Mitch
···
On Thu, Oct 25, 2012 at 12:19 AM, Bashir Jahed wrote:I think most ODK users would find this useful. Now if only I could code or
had the cash to pay for it to happen!On Thu, Oct 25, 2012 at 9:08 AM, KirbyJames kirby.james@gmail.com wrote:
"If someone writes and contributes the code for this, we will fold it
into the main source tree...."That would be brilliant. I'd thought about code which could review form
data that had already been downloaded and only download items which had
been added since it was last run. Thus if you have 23 items on the server
and have previously downloaded 20 of them - when you re-run the download
program it would only fetch the missing 3.Thanks
Kirby
On Tuesday, 23 October 2012 17:58:10 UTC+1, Mitch wrote:
Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold it
into the main source tree....Note that FormUploader is an example of an extra 'main' within the same
source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
--
Mitch Sundt
Software Engineer
University of Washington
mitche...@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
Keep in mind that it can take up to 60 seconds for a newly-submitted data
record to propagate through to Google Spreadsheets. This delay is inserted
to better utilize the free quota on the AppEngine.
If data is simply not ever being publised, to investigate this issue, you
can look at your AppEngine logs:
code.google.com/p/opendatakit/wiki/AppEngineTroubleshooting
Mitch
···
On Tue, Oct 23, 2012 at 3:44 PM, Bashir Jahed wrote:I tried this with limited success.
the spreadsheet is created in google drive but the spreadsheet is empty.
Any advise
Bash
On Wed, Oct 24, 2012 at 12:09 AM, Mitch S mitchellsundt@gmail.com wrote:
On either the 'Submissions' tab or the 'Form Management' tab, click on
'Publish =>'Choose Publish To: 'Google Spreadsheets'
Choose Data to Publish: 'BOTH ...'
Enter a workbook name.
Choose 'Publish =>'
and proceed with authentication/setup steps.Data that you already have and data that will come into Aggregate in the
future will be published to the specified workbook and available on Google
Drive.Mitch
On Tue, Oct 23, 2012 at 11:48 AM, Bashir Jahed admin@osilab.net wrote:
It would be great is we could publish all data to spreadsheets. any
documentation on how to accomplish this functionality?On Tue, Oct 23, 2012 at 7:20 PM, Mitch S mitchellsundt@gmail.comwrote:
Yes! Thank you Curtis.
You can set up ODK Aggregate to publish data to Google Spreadsheets as
it comes in.
Then, within Google Spreadsheets, you can define a script and have it
run periodically. Here is a tutorial showing some of the capabilities of
this feature:
https://developers.google.com/apps-script/articles/gmail-statsMitch
On Tue, Oct 23, 2012 at 10:07 AM, Curtis Broderick < c.broderick@epiconcept.fr> wrote:
Mitch,
What about the idea of scripting this "cron" action in Google
spreadsheets, since data can be pushed there? Just a thought.
Curtis
Le 23 oct. 2012 18:58, "Mitch S" mitchellsundt@gmail.com a écrit :Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold it
into the main source tree....Note that FormUploader is an example of an extra 'main' within the
same source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
On Tue, Oct 23, 2012 at 6:58 AM, Bashir Jahed admin@osilab.netwrote:
Hi
Is there any way to automate the export of survey results?. I would
like to have each days submissions exported to a csv file via a cron or the
likes.Thanks
--
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--
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
Hi
I am not using appengine, i am hosting on a dedicated tomcat server. would
this make a difference?
Bash
···
On Wed, Oct 24, 2012 at 2:00 AM, Mitch S wrote:Keep in mind that it can take up to 60 seconds for a newly-submitted data
record to propagate through to Google Spreadsheets. This delay is inserted
to better utilize the free quota on the AppEngine.If data is simply not ever being publised, to investigate this issue, you
can look at your AppEngine logs:
code.google.com/p/opendatakit/wiki/AppEngineTroubleshootingMitch
On Tue, Oct 23, 2012 at 3:44 PM, Bashir Jahed admin@osilab.net wrote:
I tried this with limited success.
the spreadsheet is created in google drive but the spreadsheet is empty.
Any advise
Bash
On Wed, Oct 24, 2012 at 12:09 AM, Mitch S mitchellsundt@gmail.comwrote:
On either the 'Submissions' tab or the 'Form Management' tab, click on
'Publish =>'Choose Publish To: 'Google Spreadsheets'
Choose Data to Publish: 'BOTH ...'
Enter a workbook name.
Choose 'Publish =>'
and proceed with authentication/setup steps.Data that you already have and data that will come into Aggregate in the
future will be published to the specified workbook and available on Google
Drive.Mitch
On Tue, Oct 23, 2012 at 11:48 AM, Bashir Jahed admin@osilab.net wrote:
It would be great is we could publish all data to spreadsheets. any
documentation on how to accomplish this functionality?On Tue, Oct 23, 2012 at 7:20 PM, Mitch S mitchellsundt@gmail.comwrote:
Yes! Thank you Curtis.
You can set up ODK Aggregate to publish data to Google Spreadsheets as
it comes in.
Then, within Google Spreadsheets, you can define a script and have it
run periodically. Here is a tutorial showing some of the capabilities of
this feature:
https://developers.google.com/apps-script/articles/gmail-statsMitch
On Tue, Oct 23, 2012 at 10:07 AM, Curtis Broderick < c.broderick@epiconcept.fr> wrote:
Mitch,
What about the idea of scripting this "cron" action in Google
spreadsheets, since data can be pushed there? Just a thought.
Curtis
Le 23 oct. 2012 18:58, "Mitch S" mitchellsundt@gmail.com a écrit :Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold it
into the main source tree....Note that FormUploader is an example of an extra 'main' within the
same source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
On Tue, Oct 23, 2012 at 6:58 AM, Bashir Jahed admin@osilab.netwrote:
Hi
Is there any way to automate the export of survey results?. I would
like to have each days submissions exported to a csv file via a cron or the
likes.Thanks
--
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--
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
It shouldn't. I assume you used the Installer to build the war file?
Look in the catalina.log for any errors.
···
On Tue, Oct 23, 2012 at 5:40 PM, Bashir Jahed wrote:Hi
I am not using appengine, i am hosting on a dedicated tomcat server. would
this make a difference?Bash
On Wed, Oct 24, 2012 at 2:00 AM, Mitch S mitchellsundt@gmail.com wrote:
Keep in mind that it can take up to 60 seconds for a newly-submitted data
record to propagate through to Google Spreadsheets. This delay is inserted
to better utilize the free quota on the AppEngine.If data is simply not ever being publised, to investigate this issue, you
can look at your AppEngine logs:
code.google.com/p/opendatakit/wiki/AppEngineTroubleshootingMitch
On Tue, Oct 23, 2012 at 3:44 PM, Bashir Jahed admin@osilab.net wrote:
I tried this with limited success.
the spreadsheet is created in google drive but the spreadsheet is empty.
Any advise
Bash
On Wed, Oct 24, 2012 at 12:09 AM, Mitch S mitchellsundt@gmail.comwrote:
On either the 'Submissions' tab or the 'Form Management' tab, click on
'Publish =>'Choose Publish To: 'Google Spreadsheets'
Choose Data to Publish: 'BOTH ...'
Enter a workbook name.
Choose 'Publish =>'
and proceed with authentication/setup steps.Data that you already have and data that will come into Aggregate in
the future will be published to the specified workbook and available on
Google Drive.Mitch
On Tue, Oct 23, 2012 at 11:48 AM, Bashir Jahed admin@osilab.netwrote:
It would be great is we could publish all data to spreadsheets. any
documentation on how to accomplish this functionality?On Tue, Oct 23, 2012 at 7:20 PM, Mitch S mitchellsundt@gmail.comwrote:
Yes! Thank you Curtis.
You can set up ODK Aggregate to publish data to Google Spreadsheets
as it comes in.
Then, within Google Spreadsheets, you can define a script and have it
run periodically. Here is a tutorial showing some of the capabilities of
this feature:
https://developers.google.com/apps-script/articles/gmail-statsMitch
On Tue, Oct 23, 2012 at 10:07 AM, Curtis Broderick < c.broderick@epiconcept.fr> wrote:
Mitch,
What about the idea of scripting this "cron" action in Google
spreadsheets, since data can be pushed there? Just a thought.
Curtis
Le 23 oct. 2012 18:58, "Mitch S" mitchellsundt@gmail.com a écrit :Not currently. This would best be done by adding a non-graphical
command-line 'main' to ODK Briefcase so that it can be called directly from
a cron stript to download submissions, and, then, to export those to a CSV.If someone writes and contributes the code for this, we will fold
it into the main source tree....Note that FormUploader is an example of an extra 'main' within the
same source tree launching a different look for the ODK Briefcase code. It
should be fairly straightforward to write a new "BriefcaseCmdLine" class
that parses command line arguments and performs the download or the export
of data.Mitch
On Tue, Oct 23, 2012 at 6:58 AM, Bashir Jahed admin@osilab.netwrote:
Hi
Is there any way to automate the export of survey results?. I
would like to have each days submissions exported to a csv file via a cron
or the likes.Thanks
--
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--
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