Where can I download the audit.csv in ONA platform?

75 views
Skip to first unread message

Dimitris Kar

unread,
Aug 5, 2020, 9:17:50 AM8/5/20
to Ona Community
I have built a xls form using the audit type in order to track the GPS location of the enumerators as described here.

Although the form works well, when I review the data in ONA platform, I can not find how to download the audit.csv file.

Where is this located?

Jane from Ona

unread,
Aug 5, 2020, 9:33:16 AM8/5/20
to ona-co...@googlegroups.com

This message was sent to the following 2 people: Dimitris Karakostis, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Dimitris,

To access the audit.csv file, you will need to export the form submissions to csv using ODK Briefcase as explained in this guide. Kindly note that before exporting to csv, you will need to first pull the form submissions as explained in this guide. Take a look at this guide for more information on viewing the audit logs.

Let us know if you have further questions.

Regards,
Jane

See our community forum & help site for more information!

Jane Jane from Ona
--
Collect, Analyze and Share Data - https://ona.io/
---
You received this message because you are subscribed to the Google Groups "Ona Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/9c8cb193-b18d-4351-bce1-f91d952a9cben%40googlegroups.com.
intercom

Dimitris Kar

unread,
Aug 7, 2020, 2:48:27 AM8/7/20
to ona-co...@googlegroups.com
Hello Jane,

Thank you very much. I followed your instructions and success! I have one more question please. I download the audit CSV file and I can see the coordinates but there are no headers for lat and lon.
I read in the link you sent: "If both location tracking and change tracking are enabled in the log, the CSV will look like this:audit.csv"

How or where do I enable this?
I also attach the CSV here.

Thank you.
Best
Dimitris



--
Dimitris Karakostis
United Nations World Food Programme
Technical Manager - GIS Officer
www.linkedin.com/in/dkarakostis
Road Access - audit.csv

Brian from Ona

unread,
Aug 7, 2020, 4:01:17 AM8/7/20
to ona-co...@googlegroups.com

This message was sent to the following 2 people: Dimitris Karakostis, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Dimitris,

You can enable this in the parameters column of the form. You may add the location of events to the log you can also enable change tracking so that old answers and new answers will be added to the question events. Please have a look at this guide for more information on how to set your parameters. This table illustrates how to set the location tracking and this one on how to track changes.

Regards,
Brian

See our community forum & help site for more information!

Brian Brian from Ona
On Fri, Aug 7, 2020 at 09:48 AM, "Dimitris Karakostis" <dkara...@gmail.com> wrote:

Hello Jane,


Thank you very much. I followed your instructions and success! I have one more question please. I download the audit CSV file and I can see the coordinates but there are no headers for lat and lon.

I read in the link you sent: "If both location tracking and change tracking are enabled in the log, the CSV will look like this:audit.csv"


How or where do I enable this?

I also attach the CSV here.


Thank you.

Best

Dimitris

On Wed, Aug 5, 2020 at 04:33 PM, "Jane Mesi" <jane...@ona.intercom-mail.com> wrote:

Hello Dimitris,

To access the audit.csv file, you will need to export the form submissions to csv using ODK Briefcase as explained in this guide. Kindly note that before exporting to csv, you will need to first pull the form submissions as explained in this guide. Take a look at this guide for more information on viewing the audit logs.

Let us know if you have further questions.

Regards,
Jane

See our community forum & help site for more information!

On Wed, Aug 5, 2020 at 04:18 PM, "Dimitris Karakostis" <dkara...@gmail.com> wrote:

I have built a xls form using the audit type in order to track the GPS location of the enumerators as described here.

Although the form works well, when I review the data in ONA platform, I can not find how to download the audit.csv file.

Where is this located?

--
Collect, Analyze and Share Data - https://ona.io/
---
You received this message because you are subscribed to the Google Groups "Ona Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/9c8cb193-b18d-4351-bce1-f91d952a9cben%40googlegroups.com.
intercom
Reply all
Reply to author
Forward
0 new messages