Hi,
After I uploaded a .csv-file together with a specific form, where can I retrieve the .csv file (or its data) in MySQL in order to review it.
I can't seem to find it.
Thnx!
Media attachments are stored as an ordered sequence of BLOB (64kB) objects.
The easiest way to access them is through the access URL for the file --
the same URL used by ODK Collect to download the file.
To do that, the easiest way is to access the manifest URL of the formId
that you want to access, e.g.,:
https://opendatakit.appspot.com/xformsManifest?formId=NewWidgets
And parse that to locate the CSV of interest.
Unless the anonymous user has Data Collector privileges, these URLs require
authentication using Digest Auth.
The underlying database tables are described here:
https://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure
···
On Tue, May 26, 2015 at 1:18 PM, wrote:Hi,
After I uploaded a .csv-file together with a specific form, where can I
retrieve the .csv file (or its data) in MySQL in order to review it.I can't seem to find it.
Thnx!
--
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
Media attachments are stored as an ordered sequence of BLOB (64kB) objects.
The easiest way to access them is through the access URL for the file -- the same URL used by ODK Collect to download the file.
To do that, the easiest way is to access the manifest URL of the formId that you want to access, e.g.,:
https://opendatakit.appspot.com/xformsManifest?formId=NewWidgets
And parse that to locate the CSV of interest.
Unless the anonymous user has Data Collector privileges, these URLs require authentication using Digest Auth.
The underlying database tables are described here: https://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure
Hi,
After I uploaded a .csv-file together with a specific form, where can I retrieve the .csv file (or its data) in MySQL in order to review it.
I can't seem to find it.
Thnx!
--
--
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
Thank you Mitch
···
On Tuesday, May 26, 2015 at 10:59:45 PM UTC+2, Mitch Sundt wrote: > On Tue, May 26, 2015 at 1:18 PM, wrote:Media attachments are stored as an ordered sequence of BLOB (64kB) objects.
The easiest way to access them is through the access URL for the file -- the same URL used by ODK Collect to download the file.
To do that, the easiest way is to access the manifest URL of the formId that you want to access, e.g.,:
https://opendatakit.appspot.com/xformsManifest?formId=NewWidgets
And parse that to locate the CSV of interest.
Unless the anonymous user has Data Collector privileges, these URLs require authentication using Digest Auth.
The underlying database tables are described here: https://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure
Hi,
After I uploaded a .csv-file together with a specific form, where can I retrieve the .csv file (or its data) in MySQL in order to review it.
I can't seem to find it.
Thnx!
--
--
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.comThank you Mitch
Speaking about .csv-files, is it possible to allocate an universal .csv-file (dataset) to more than one form which relies on the data in the .csv-file?
Hence, once change is brought to the specific .csv-file, all its respective forms are automatically updated with the latest data.
Thank you
···
On Wednesday, May 27, 2015 at 1:11:34 AM UTC+2, toffie...@gmail.com wrote: > On Tuesday, May 26, 2015 at 10:59:45 PM UTC+2, Mitch Sundt wrote: > > On Tue, May 26, 2015 at 1:18 PM, wrote:No. The CSV file is loaded into a database table.
Issue 959 was fixed in rev 1045. Prior to that, the CSV itemsets were
shared across forms. This caused problems when the common itemset was
shared between form A and form B, and you deleted form B, it would delete
the common dataset, causing form A to fail.
The ODK 2.0 tools do allow sharing and richer relationships among data
tables.
With ODK 1.0, each form is isolated and separate from any other form.
With ODK 2.0, the collection of data and forms comprise a user-defined
'application'.
···
On Tue, May 26, 2015 at 4:21 PM, wrote:On Wednesday, May 27, 2015 at 1:11:34 AM UTC+2, toffie...@gmail.com wrote:
On Tuesday, May 26, 2015 at 10:59:45 PM UTC+2, Mitch Sundt wrote:
Media attachments are stored as an ordered sequence of BLOB (64kB)
objects.The easiest way to access them is through the access URL for the file
-- the same URL used by ODK Collect to download the file.To do that, the easiest way is to access the manifest URL of the
formId that you want to access, e.g.,:https://opendatakit.appspot.com/xformsManifest?formId=NewWidgets
And parse that to locate the CSV of interest.
Unless the anonymous user has Data Collector privileges, these URLs
require authentication using Digest Auth.The underlying database tables are described here:
https://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructureOn Tue, May 26, 2015 at 1:18 PM, toffie...@gmail.com wrote:
Hi,After I uploaded a .csv-file together with a specific form, where can
I retrieve the .csv file (or its data) in MySQL in order to review it.I can't seem to find it.
Thnx!
--
--
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.comThank you Mitch
Speaking about .csv-files, is it possible to allocate an universal
.csv-file (dataset) to more than one form which relies on the data in the
.csv-file?Hence, once change is brought to the specific .csv-file, all its
respective forms are automatically updated with the latest data.Thank you
--
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