Dear Team,
I created an XLS form for a baseline household survey and successfully
converted to XML in 2013. This year we want to conduct a mid-line survey
with few edits to the form, unfortunately I misplaced the original XLS
file. I what I have managed to trace is the XML file that was used to
collect data.
Is it possible, using the ODK or any other software to convert this XML
file back to XLS for me to do the new edits? Or else, could it be possible
to do the edits in the actual XML?
Please assist
···
--
HUMPHREYS KABOTA
ALTERNATE EMAIL: humphkabota@gmail.com
MOBILE PHONE: +265 999 340648
SKYPE: humphkabota
"Whenever you find you are on the side of the majority, it is time to
pause and reflect."
--Mark Twain
Attached is the form that needs to be reconverted to XLS.
MALAWI_2015EGRA_HOUSEHOLD_SURVEY_150512HK.xml (916 KB)
···
On Tue, May 12, 2015 at 10:09 PM, Humphreys Kabota < humphreys.kabota@investinknowledge.org> wrote:
Dear Team,
I created an XLS form for a baseline household survey and successfully
converted to XML in 2013. This year we want to conduct a mid-line survey
with few edits to the form, unfortunately I misplaced the original XLS
file. I what I have managed to trace is the XML file that was used to
collect data.
Is it possible, using the ODK or any other software to convert this XML
file back to XLS for me to do the new edits? Or else, could it be possible
to do the edits in the actual XML?
Please assist
--
HUMPHREYS KABOTA
ALTERNATE EMAIL: humphkabota@gmail.com
MOBILE PHONE: +265 999 340648
SKYPE: humphkabota
"Whenever you find you are on the side of the majority, it is time to
pause and reflect."
--Mark Twain
--
HUMPHREYS KABOTA
DATA MANAGER
INVEST IN KNOWLEDGE (MALAWI)
P.O. BOX 506
ZOMBA
MALAWI.
ALTERNATE EMAIL: humphkabota@gmail.com
MOBILE PHONE: +265 999 340648
SKYPE: humphkabota
"Whenever you find you are on the side of the majority, it is time to
pause and reflect."
--Mark Twain
Yes you can absolutely edit the XML file, though it is a lot less user-friendly than the XLS forms. If it's just for a few edits you'll be all right however.
https://opendatakit.org/help/form-design/
If you're not familiar with XML, what I would suggest:
- Get a quick read of the link to understand how it is structured.
- Understand that unlike XLS forms, in XML you have a few different sections that refer to the same question (e.g. the tags with the label/value, the bindings that set the conditions & behavior). So if you want to ADD a question, then you'll have to make you add the correct entry in each of those section. Read the link above carefully and it will guide you through.
- Start from what you already have (the xml file) I use that as starting example. That the time to look at your xml file & compare that to what they explain above.
- Use notepadd ++ (https://notepad-plus-plus.org/) or something similar, but notepad ++ is pretty good. It will make this job exactly 57 times less of hassle.
- Use the search (ctr + f) in notepad to check things out, will highlight things for you.
-MAKES VERSION. Every time you make and edit,save it as myFormName_v1 & update the version. Better yet, work off something like dropbox which will take careof that automatically for you.
Make one change at a time, test it, then make another one once you're sure it works. Use ODK validate to validate your changes.
Also, the one advantage you have working in XML directly is that you can just push the XML form with the change you just have made with USB. You don't really need to upload it to your server every single time you make a change & want to test it on the phone. Just valide it (using odk validate) & test through USB. You'll need to put the XML file in your phone under odk/forms.
Hi Pat,
Just a clarification: is it a mechanism to PRODUCE an XLS forms based on a provided XML or to allow upload of XML forms in Kobo?
E.g. if you upload an XLS forms in Kobo, you can retrieve both the XLS & the XML. Would the reverse now be true?
That's greate Pat, I think being able to upload XML is a plus, especially for older forms.
Well then if you can recover the XLS Humphrey, and even if that XLS is not perfect it would advise to try that out - if you've never used XML forms you will probably find it easy to work on a XLS (even if it needs adjustements) than on a XML....
Unfortunately, no.
This is one reason I prefer to supply the XLS file as a media attachment to
the XML form definition -- it will then always be available on the server
or on any of your devices.
···
On Tue, May 12, 2015 at 1:32 PM, Humphreys Kabota < humphreys.kabota@investinknowledge.org> wrote:
Attached is the form that needs to be reconverted to XLS.
On Tue, May 12, 2015 at 10:09 PM, Humphreys Kabota < humphreys.kabota@investinknowledge.org> wrote:
Dear Team,
I created an XLS form for a baseline household survey and successfully
converted to XML in 2013. This year we want to conduct a mid-line survey
with few edits to the form, unfortunately I misplaced the original XLS
file. I what I have managed to trace is the XML file that was used to
collect data.
Is it possible, using the ODK or any other software to convert this XML
file back to XLS for me to do the new edits? Or else, could it be possible
to do the edits in the actual XML?
Please assist
--
HUMPHREYS KABOTA
ALTERNATE EMAIL: humphkabota@gmail.com
MOBILE PHONE: +265 999 340648
SKYPE: humphkabota
“Whenever you find you are on the side of the majority, it is time to
pause and reflect."
--Mark Twain
--
HUMPHREYS KABOTA
DATA MANAGER
INVEST IN KNOWLEDGE (MALAWI)
P.O. BOX 506
ZOMBA
MALAWI.
ALTERNATE EMAIL: humphkabota@gmail.com
MOBILE PHONE: +265 999 340648
SKYPE: humphkabota
“Whenever you find you are on the side of the majority, it is time to
pause and reflect."
--Mark Twain
--
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
1 Like
Hi Humphreys, you can try to import your xml file in kobotoolbox (
kf.kobotoolbox.org)
After log in, select "+Add Form", then "Import Form" - navigate to your xml
file and give it a try. The function is normally for xls form import, but
we have added support for xml. However, it is still experimental and not
fully supported, but it may work.
We are doing our best to ensure compatibility.
P.
···
On Wed, May 13, 2015 at 7:43 PM, wrote:
Yes you can absolutely edit the XML file, though it is a lot less
user-friendly than the XLS forms. If it's just for a few edits you'll be
all right however.
https://opendatakit.org/help/form-design/
If you're not familiar with XML, what I would suggest:
- Get a quick read of the link to understand how it is structured.
- Understand that unlike XLS forms, in XML you have a few different
sections that refer to the same question (e.g. the tags with the
label/value, the bindings that set the conditions & behavior). So if you
want to ADD a question, then you'll have to make you add the correct entry
in each of those section. Read the link above carefully and it will guide
you through.
- Start from what you already have (the xml file) I use that as starting
example. That the time to look at your xml file & compare that to what they
explain above.
- Use notepadd ++ (https://notepad-plus-plus.org/) or something similar,
but notepad ++ is pretty good. It will make this job exactly 57 times less
of hassle.
- Use the search (ctr + f) in notepad to check things out, will highlight
things for you.
-MAKES VERSION. Every time you make and edit,save it as myFormName_v1 &
update the version. Better yet, work off something like dropbox which will
take careof that automatically for you.
Make one change at a time, test it, then make another one once you're sure
it works. Use ODK validate to validate your changes.
Also, the one advantage you have working in XML directly is that you can
just push the XML form with the change you just have made with USB. You
don't really need to upload it to your server every single time you make a
change & want to test it on the phone. Just valide it (using odk validate)
& test through USB. You'll need to put the XML file in your phone under
odk/forms.
--
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.
kf. is a formbuilder so you can create forms from scratch, or import
existing forms. You can import a XLS forms. You can also import a XML but
that feature is still experimental so it may not work properly with your
form - if you manage the import, I would still carefully check the form,
especially skipping patterns and validation rules.
Regardless of how the form is imported or created, you can retrieve /
download your forms in both .xls or .xml.
P.
···
On Wed, May 13, 2015 at 11:36 PM, wrote:
Hi Pat,
Just a clarification: is it a mechanism to PRODUCE an XLS forms based on a
provided XML or to allow upload of XML forms in Kobo?
E.g. if you upload an XLS forms in Kobo, you can retrieve both the XLS &
the XML. Would the reverse now be true?
--
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.
not working brother, still xml not supported