Merging multiple xml files from briefcase - working offline

I needed a quick way to collect data for a pilot study in India - (only 200
observations). While it is clear that Aggregate will be best for the
larger study (~4500 observations - interviews), we did not have time or
know-how to set up the server.
This leaves me with 200 single observation xml files, plus its
corresponding audio-file for open ended responses.My question to the group
is this:

How do I efficiently merge the 200 xml files into one dataset with 200
observations, and then, how do I import the full xml dataset into excel
while preserving the variable names (xml schema)?
My current option is one by one - I know, not smart.

Just so you know who are are working with, I am not a programmer, know
nothing about xml, and basically have excel and STATA to work with. The
good news is, as a non-technically oriented person, I was able to build a
long questionnaire, upload and test on the tablets and smart phones, and
now the data are comming in. Just need some help with this pesky step.

Thanks
Sharon

Hi Sharon,

One option is to use Nafundi's ODK Aggregate VM at
https://gumroad.com/l/odk-aggregate-vm. It is a fully-configured copy
of ODK Aggregate that runs offline and requires virtually no setup.

The alternative is to use ODK Briefcase
(https://opendatakit.org/use/briefcase/) to pull the data from the SD
card of each device and export all 200 records to a single CSV.

Yaw

··· -- Need ODK services? http://nafundi.com/services provides form design, server setup, professional support, and software development for ODK.

On Wed, Mar 18, 2015 at 11:54 PM, Sharon Talboys stalboys11@gmail.com wrote:

I needed a quick way to collect data for a pilot study in India - (only 200
observations). While it is clear that Aggregate will be best for the larger
study (~4500 observations - interviews), we did not have time or know-how to
set up the server.
This leaves me with 200 single observation xml files, plus its corresponding
audio-file for open ended responses.My question to the group is this:

How do I efficiently merge the 200 xml files into one dataset with 200
observations, and then, how do I import the full xml dataset into excel
while preserving the variable names (xml schema)?
My current option is one by one - I know, not smart.

Just so you know who are are working with, I am not a programmer, know
nothing about xml, and basically have excel and STATA to work with. The
good news is, as a non-technically oriented person, I was able to build a
long questionnaire, upload and test on the tablets and smart phones, and now
the data are comming in. Just need some help with this pesky step.

Thanks
Sharon

--

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.

Hi Yaw,

I need same help, I tried with Briefcase but there is no option to import xml files directly. I have xml files zipped into one folder

··· On Thursday, March 19, 2015 at 4:21:55 AM UTC+5:30, Yaw Anokwa wrote: > Hi Sharon, > > One option is to use Nafundi's ODK Aggregate VM at > https://gumroad.com/l/odk-aggregate-vm. It is a fully-configured copy > of ODK Aggregate that runs offline and requires virtually no setup. > > The alternative is to use ODK Briefcase > (https://opendatakit.org/use/briefcase/) to pull the data from the SD > card of each device and export all 200 records to a single CSV. > > Yaw > -- > Need ODK services? http://nafundi.com/services provides form design, > server setup, professional support, and software development for ODK. > > > On Wed, Mar 18, 2015 at 11:54 PM, Sharon Talboys wrote: > > I needed a quick way to collect data for a pilot study in India - (only 200 > > observations). While it is clear that Aggregate will be best for the larger > > study (~4500 observations - interviews), we did not have time or know-how to > > set up the server. > > This leaves me with 200 single observation xml files, plus its corresponding > > audio-file for open ended responses.My question to the group is this: > > > > How do I efficiently merge the 200 xml files into one dataset with 200 > > observations, and then, how do I import the full xml dataset into excel > > while preserving the variable names (xml schema)? > > My current option is one by one - I know, not smart. > > > > Just so you know who are are working with, I am not a programmer, know > > nothing about xml, and basically have excel and STATA to work with. The > > good news is, as a non-technically oriented person, I was able to build a > > long questionnaire, upload and test on the tablets and smart phones, and now > > the data are comming in. Just need some help with this pesky step. > > > > Thanks > > Sharon > > > > > > -- > > -- > > 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.

--
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and
delete this e-mail from your system. If you are not the intended recipient
you are notified that disclosing, copying, distributing or taking any
action in reliance on the contents of this information is strictly
prohibited.

I believe this is stated elsewhere...

ODK Briefcase will import XML files provided they are stored in a directory
structure that mimics the structure on the phone, including the form
definition used to create those XML files. Start with a zip off a device
that had an ODK Collect configured with just the form definition of
interest and a filled-in submission. Then mimic how the submission files
(under instances folder) are stored.

··· On Wed, May 25, 2016 at 4:36 AM, wrote:

Hi Yaw,

I need same help, I tried with Briefcase but there is no option to import
xml files directly. I have xml files zipped into one folder

On Thursday, March 19, 2015 at 4:21:55 AM UTC+5:30, Yaw Anokwa wrote:

Hi Sharon,

One option is to use Nafundi's ODK Aggregate VM at
https://gumroad.com/l/odk-aggregate-vm. It is a fully-configured copy
of ODK Aggregate that runs offline and requires virtually no setup.

The alternative is to use ODK Briefcase
(https://opendatakit.org/use/briefcase/) to pull the data from the SD
card of each device and export all 200 records to a single CSV.

Yaw

Need ODK services? http://nafundi.com/services provides form design,
server setup, professional support, and software development for ODK.

On Wed, Mar 18, 2015 at 11:54 PM, Sharon Talboys stalboys11@gmail.com wrote:

I needed a quick way to collect data for a pilot study in India -
(only 200

observations). While it is clear that Aggregate will be best for the
larger

study (~4500 observations - interviews), we did not have time or
know-how to

set up the server.
This leaves me with 200 single observation xml files, plus its
corresponding

audio-file for open ended responses.My question to the group is this:

How do I efficiently merge the 200 xml files into one dataset with 200
observations, and then, how do I import the full xml dataset into excel
while preserving the variable names (xml schema)?
My current option is one by one - I know, not smart.

Just so you know who are are working with, I am not a programmer, know
nothing about xml, and basically have excel and STATA to work with.
The

good news is, as a non-technically oriented person, I was able to
build a

long questionnaire, upload and test on the tablets and smart phones,
and now

the data are comming in. Just need some help with this pesky step.

Thanks
Sharon

--

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.

--
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and
delete this e-mail from your system. If you are not the intended recipient
you are notified that disclosing, copying, distributing or taking any
action in reliance on the contents of this information is strictly
prohibited.

--

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