Viewing submitted data in dev environment (2.0)

Andrew · May 30, 2016, 3:51pm

Good day,

I'm developing 2.0 forms using the Application Designer
While testing calculation fields it would be useful to be able to view the
actual values calculated for each submission.

Where are the submission database files stored, and can I access them for
viewing?

Thanks and regards,
Andrew

clarice_larson · May 31, 2016, 9:10pm

On a Mac, the database file for the Application Designer can be found at
/Users//Library/Application
Support/Google/Chrome/Default/databases/http_localhost_8000.

Clarice

···

On Mon, May 30, 2016 at 8:51 AM, Andrew wrote:

Good day,

I'm developing 2.0 forms using the Application Designer
While testing calculation fields it would be useful to be able to view the
actual values calculated for each submission.

Where are the submission database files stored, and can I access them for
viewing?

Thanks and regards,
Andrew

--

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.

Andrew · June 1, 2016, 4:01pm

Hi Clarice,

Thanks for that.

For others reading this, I found it in Windows at:
C:\Users<YourUsername>\AppData\Local\Google\Chrome\User Data\Default
databases\http_localhost_8000

Note: If you have more than one Chrome user account set up, it might be
somewhere like this:
C:\Users<YourUsername>\AppData\Local\Google\Chrome\User Data*Profile 2*
\databases\http_localhost_8000

In my case it was an extensionless file called "1".
You can view contents using an app like this: http://sqlitebrowser.org/

I did also find that it's possible to view the data within Chrome
https://developer.chrome.com/devtools/docs/resource-panel#web-sql:
Menu -> More Tools -> Developer Tools
Select the Resources tab
Select WebSQL -> odk

I had to fire up the AppDesigner for the odk db to show up.
If you have lots of columns its impossible to see what is going on (no
horizontal scrollbar), but if you type the full column name into the filter
at the bottom you can get the info you're looking for.

Regards,
Andrew

···

On 31 May 2016 at 23:10, clarice larson wrote:

On a Mac, the database file for the Application Designer can be found at
/Users//Library/Application
Support/Google/Chrome/Default/databases/http_localhost_8000.

Clarice

On Mon, May 30, 2016 at 8:51 AM, Andrew acawood777@gmail.com wrote:

Good day,

I'm developing 2.0 forms using the Application Designer
While testing calculation fields it would be useful to be able to view
the actual values calculated for each submission.

Where are the submission database files stored, and can I access them for
viewing?

Thanks and regards,
Andrew

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/A6hquwA9g_Y/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Mitch_S · June 6, 2016, 8:08pm

These are SQLite databases.

You can copy them elsewhere then open them with, e.g., SQLiteBrowser (
http://sqlitebrowser.org/ )
A much nicer experience.

···

On Wed, Jun 1, 2016 at 9:01 AM, Andrew Cawood wrote:

Hi Clarice,

Thanks for that.

For others reading this, I found it in Windows at:
C:\Users<YourUsername>\AppData\Local\Google\Chrome\User Data\Default
databases\http_localhost_8000

Note: If you have more than one Chrome user account set up, it might be
somewhere like this:
C:\Users<YourUsername>\AppData\Local\Google\Chrome\User Data*Profile 2*
\databases\http_localhost_8000

In my case it was an extensionless file called "1".
You can view contents using an app like this: http://sqlitebrowser.org/

I did also find that it's possible to view the data within Chrome
https://developer.chrome.com/devtools/docs/resource-panel#web-sql:
Menu -> More Tools -> Developer Tools
Select the Resources tab
Select WebSQL -> odk

I had to fire up the AppDesigner for the odk db to show up.
If you have lots of columns its impossible to see what is going on (no
horizontal scrollbar), but if you type the full column name into the filter
at the bottom you can get the info you're looking for.

Regards,
Andrew

On 31 May 2016 at 23:10, clarice larson clarlars@gmail.com wrote:

On a Mac, the database file for the Application Designer can be found at
/Users//Library/Application
Support/Google/Chrome/Default/databases/http_localhost_8000.

Clarice

On Mon, May 30, 2016 at 8:51 AM, Andrew acawood777@gmail.com wrote:

Good day,

I'm developing 2.0 forms using the Application Designer
While testing calculation fields it would be useful to be able to view
the actual values calculated for each submission.

Where are the submission database files stored, and can I access them
for viewing?

Thanks and regards,
Andrew

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/A6hquwA9g_Y/unsubscribe.
To unsubscribe from this group and all its topics, 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