Hello all,
I have a problem of which I could not find any other post.
I have pulled about 2500 instances from odk briefcase using custom path to
ODK directory, which I have done before with other datasets and without any
issues at that time. This time, however, the output files contain much
misplaced data when I import them (import text file from external data)
into excel or spss. It seems to occasionally cut text variables in half and
proceed in the next row (where there is no comma or anything whatsoever).
Opening the csv file in notepad does not show anything extraordinary.
I am checking with those who conducted the field work if they have made
changes to the form over the course of data collection, could that be
potential cause of this problem?
Thanks in advance!
Sivan
Hi Sivan,
Trace the problem. Start with the XML data on the SD card of the phone
(use an on-device file explorer), then try pulling into Briefcase and
looking at the files in the Briefcase storage location, then export to
CSV from Briefcase and see what happens. My guess is that the problem
is with your importing into Excel/SPSS.
Yaw
···
--
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.
On Sun, Jan 31, 2016 at 2:44 PM, Sivan van Leerzem sivanvanleerzem@gmail.com wrote:
Hello all,
I have a problem of which I could not find any other post.
I have pulled about 2500 instances from odk briefcase using custom path to
ODK directory, which I have done before with other datasets and without any
issues at that time. This time, however, the output files contain much
misplaced data when I import them (import text file from external data) into
excel or spss. It seems to occasionally cut text variables in half and
proceed in the next row (where there is no comma or anything whatsoever).
Opening the csv file in notepad does not show anything extraordinary.
I am checking with those who conducted the field work if they have made
changes to the form over the course of data collection, could that be
potential cause of this problem?
Thanks in advance!
Sivan
--
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.
Thank you Yaw, indeed the problem was with importing. When I did it using
STATA while switching 'quote binding' to 'strict', the problem disappeared.
Sivan
···
Op dinsdag 9 februari 2016 14:41:57 UTC+1 schreef Yaw Anokwa:
>
> Hi Sivan,
>
> Trace the problem. Start with the XML data on the SD card of the phone
> (use an on-device file explorer), then try pulling into Briefcase and
> looking at the files in the Briefcase storage location, then export to
> CSV from Briefcase and see what happens. My guess is that the problem
> is with your importing into Excel/SPSS.
>
> Yaw
> --
> Need ODK consultants? Nafundi provides form design, server setup,
> in-field training, and software development for ODK. Go to
> https://nafundi.com to get started.
>
> On Sun, Jan 31, 2016 at 2:44 PM, Sivan van Leerzem <sivanva...@gmail.com > wrote:
> > Hello all,
> >
> > I have a problem of which I could not find any other post.
> >
> > I have pulled about 2500 instances from odk briefcase using custom path
> to
> > ODK directory, which I have done before with other datasets and without
> any
> > issues at that time. This time, however, the output files contain much
> > misplaced data when I import them (import text file from external data)
> into
> > excel or spss. It seems to occasionally cut text variables in half and
> > proceed in the next row (where there is no comma or anything
> whatsoever).
> > Opening the csv file in notepad does not show anything extraordinary.
> >
> > I am checking with those who conducted the field work if they have made
> > changes to the form over the course of data collection, could that be
> > potential cause of this problem?
> >
> > Thanks in advance!
> > Sivan
> >
> >
> > --
> > --
> > 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.
>