Quick question - does anyone know if kobo transfers over partially completed surveys off the phone or only fully completed ones. We need to be able to extract all xforms created on the phone.
Thanks,
Matt
···
On Jun 16, 2011, at 9:34 AM, Yaw Anokwa wrote:
I've put together a rudimentary utility script that sniffs for an android
device connected to the PC, looks for the odk folder and generates a list of
forms available to grab. It can copy forms to the PC, create and load the
forms as CSV files into Excel and delete forms on the android device.
(Delete just removes the form folders from the instance folder. I'm not sure
if that's kosher.) Optionally it can also split the forms into daily
summaries. It doesn't do anything fancy like look in the sqlite database to
look for completion status but just looks at the "instance" folder to see
what's there. If anyone is interested in playing with it let me know and
you can have it.
-steve-
···
On Thu, Jun 16, 2011 at 6:34 AM, Yaw Anokwa wrote:
external apps can't tell if a saved instance is complete or not, so
i'm assuming kobo grabs everything.
···
On Thu, Jun 16, 2011 at 19:03, Matt Berg wrote:
> Yaw thank you. Looks great.
>
> Quick question - does anyone know if kobo transfers over partially completed surveys off the phone or only fully completed ones. We need to be able to extract all xforms created on the phone.
>
> Thanks,
>
> Matt
>
> On Jun 16, 2011, at 9:34 AM, Yaw Anokwa wrote:
>
>> you can try kobo post processor. http://www.koboproject.org/
>>
>> the alternative is to write a quick script that polls for a mounted drive and then grabs the files.
>>
>> On Jun 16, 2011, at 4:25 PM, Matt Berg wrote:
>>
>>> Are there any good window apps for automating the process of downloading xforms off a phone?
>>>
>>> Thanks,
>>>
>>> Matt
>>>
>>> --
>>> 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
>
> --
> Post: opendatakit@googlegroups.com
> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
> Options: http://groups.google.com/group/opendatakit?hl=en
>
In 1.1.7, that db is replaced by two in that same directory: forms.db
and instances.db.
In instances.db you can determine if a form was marked completed there.
ODK Briefcase will take care of this eventually, it should be out near
end of summer.
···
On Thu, Jun 16, 2011 at 1:48 PM, Andrew Marder wrote:
> Hi Yaw,
>
> Here is some code that uses sqlalchemy to open up the sqlite database
> in /odk/metadata/data to mark which xml files are complete.
>
> https://github.com/mvpdev/xform_manager/blob/develop/import_tools.py
>
> From looking at the kobo code I think, but am not sure, that it pulls
> all the surveys on the phone.
>
> Andrew
>
> On Thu, Jun 16, 2011 at 4:41 PM, Yaw Anokwa wrote:
>> external apps can't tell if a saved instance is complete or not, so
>> i'm assuming kobo grabs everything.
>>
>> On Thu, Jun 16, 2011 at 19:03, Matt Berg wrote:
>>> Yaw thank you. Looks great.
>>>
>>> Quick question - does anyone know if kobo transfers over partially completed surveys off the phone or only fully completed ones. We need to be able to extract all xforms created on the phone.
>>>
>>> Thanks,
>>>
>>> Matt
>>>
>>> On Jun 16, 2011, at 9:34 AM, Yaw Anokwa wrote:
>>>
>>>> you can try kobo post processor. http://www.koboproject.org/
>>>>
>>>> the alternative is to write a quick script that polls for a mounted drive and then grabs the files.
>>>>
>>>> On Jun 16, 2011, at 4:25 PM, Matt Berg wrote:
>>>>
>>>>> Are there any good window apps for automating the process of downloading xforms off a phone?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Matt
>>>>>
>>>>> --
>>>>> 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
>>>
>>> --
>>> 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
>>
>
> --
> Post: opendatakit@googlegroups.com
> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
> Options: http://groups.google.com/group/opendatakit?hl=en
>
Here is some code that uses sqlalchemy to open up the sqlite database
in /odk/metadata/data to mark which xml files are complete.
From looking at the kobo code I think, but am not sure, that it pulls
all the surveys on the phone.
Andrew
···
On Thu, Jun 16, 2011 at 4:41 PM, Yaw Anokwa wrote:
> external apps can't tell if a saved instance is complete or not, so
> i'm assuming kobo grabs everything.
>
> On Thu, Jun 16, 2011 at 19:03, Matt Berg wrote:
>> Yaw thank you. Looks great.
>>
>> Quick question - does anyone know if kobo transfers over partially completed surveys off the phone or only fully completed ones. We need to be able to extract all xforms created on the phone.
>>
>> Thanks,
>>
>> Matt
>>
>> On Jun 16, 2011, at 9:34 AM, Yaw Anokwa wrote:
>>
>>> you can try kobo post processor. http://www.koboproject.org/
>>>
>>> the alternative is to write a quick script that polls for a mounted drive and then grabs the files.
>>>
>>> On Jun 16, 2011, at 4:25 PM, Matt Berg wrote:
>>>
>>>> Are there any good window apps for automating the process of downloading xforms off a phone?
>>>>
>>>> Thanks,
>>>>
>>>> Matt
>>>>
>>>> --
>>>> 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
>>
>> --
>> 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
>