I've set up a few forms that are working well now in ODK 2.0. The tables
work, with collected data showing in maps, spreadsheet and list views.
What I cannot figure out now is how to get the data out of the Aggregate
and into a spreadsheet and the photos that are attached into a folder. Even
if the folders are only available by hyperlink to a web address (within the
Aggregate) I can write an Excel macro to pull them out if those hyperlinks
can be exported into a csv file.
With ODK Collect all the there are tools within ODK Aggregate that allow
for exporting and for publishing, as well as the very helpful Map
visualization. The ODK 2.0 data that is synced doesn't show up under the
Submissions tab in the Aggregate so I have not export option.
I've tried ODK Briefcase also but that wouldn't allow me to select the SD
card on my android device - when I select to pull data from Mounted Android
SD Card, then select Choose, then Refresh - the SD card never shows up.
However I can see the Android phone and SD card via Windows Explorer. If it
matters, this is a Nexus 4 with no removable SD card so I'm trying to pull
data from the device memory.
Correct. This is yet another work item we have not gotten around to.
At the current time, the process is:
In your office, set up a device to sync to your server.
Sync it.
Launch Tables.
Navigate to the list of tables screen. If you have a custom home screen,
you can get there via the icon on the action bar of that screen.
Choose the icon that looks like "=>".
You can then export the data from each of the tables into a CSV file on the
device.
The images and CSV files will be written to the
/sdcard/opendatakit/tables/output directory.
Zip those up and copy them onto your desktop.
···
===============
If you are a Java developer, we have code written for a specific deployment
that would be the starting point for an ODK Briefcase-like data-downloading
app for the 2.0 datasets. It is not generic and would need to be either
made generic or customized for your specific needs.
I've set up a few forms that are working well now in ODK 2.0. The tables
work, with collected data showing in maps, spreadsheet and list views.
What I cannot figure out now is how to get the data out of the Aggregate
and into a spreadsheet and the photos that are attached into a folder. Even
if the folders are only available by hyperlink to a web address (within the
Aggregate) I can write an Excel macro to pull them out if those hyperlinks
can be exported into a csv file.
With ODK Collect all the there are tools within ODK Aggregate that allow
for exporting and for publishing, as well as the very helpful Map
visualization. The ODK 2.0 data that is synced doesn't show up under the
Submissions tab in the Aggregate so I have not export option.
I've tried ODK Briefcase also but that wouldn't allow me to select the SD
card on my android device - when I select to pull data from Mounted Android
SD Card, then select Choose, then Refresh - the SD card never shows up.
However I can see the Android phone and SD card via Windows Explorer. If it
matters, this is a Nexus 4 with no removable SD card so I'm trying to pull
data from the device memory.
This worked and exported the geotagger.csv, geotagger.definitions.csv and
geotagger.propertiese.csv files.
Two issues I've found though:
There is no folder with actual pictures. The geotagger.csv does list
the picture file name, but no files. The _id column contains the uuid that
is the same as the folder names found in instances folder. Is the best path
to get the pictures to simply download the instances folder along with the
csv files?
In data entry fields that have text, if a comma is used, it throws of
the column that the data is stored to. I've attached a downloaded data file
that shows this in rows 7, 8 and 9.
The second issue above is very serious if users are not aware that they
cannot use commas.
The images are not copied when exporting on rev 126, and the file paths are
not altered, so you will want to pull the /sdcard/opendatakit/tables/tables
tree, as all the image files are referenced relative to that. I.e., in
the csv, you will see:
Would this be a simple change to the formDef.json to have any 'text' fields
surrounded by a pipe, or quotes so that that could be used as a text
qualifier when importing to Excel?
I unfortunately am not a programmer and have searched for an answer but
really don't know how to search for this. If it really is complicated don't
hesitate to say "just wait for a future update".
and it looks like you can export individual tables to CSVs.
I haven't tried this myself.
···
On Tue, Dec 8, 2015 at 11:53 AM, Che Geiser wrote:
Would this be a simple change to the formDef.json to have any 'text'
fields surrounded by a pipe, or quotes so that that could be used as a text
qualifier when importing to Excel?
I unfortunately am not a programmer and have searched for an answer but
really don't know how to search for this. If it really is complicated don't
hesitate to say "just wait for a future update".