Hi folks !!!
I'm using Kobo post processor to deploy some data from ODK Collect 1.1.7.
The problem is the instance when exported to .csv the data aren't
dissociated with comma ...
all questions are in the same column.
someone had this problem or could help?
Attached the Xform that i used.
thanks for help!!!
Matriz_simples.xml (10 KB)
Renan,
I think you've just mis-named your fields. The Post Processor will seperate
Multi selects into discrete fields if "_MULTI" is appended to the node name
in the instance. This is the only way that KoBoPP can tell the difference
between a multi select and a text field.
All the details are here:
http://code.google.com/p/kobo/wiki/KoBoPPMultiSelect
Let me know if I can be of further help.
☞§※☼:airplane:
Neil Hendrick
Hi folks !!!
I'm using Kobo post processor to deploy some data from ODK Collect 1.1.7.
The problem is the instance when exported to .csv the data aren't
dissociated with comma ...
all questions are in the same column.someone had this problem or could help?
Attached the Xform that i used.
thanks for help!!!
--
Renan A. Kamimura--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
Renan,
You might also send along some completed XML files and your CSV output if
you want me to take a look at it.
~Neil
Hi Neil ... i've attached the .csv file and Xform.
Thanks a lot!
Renan
Matriz_simples.xml (10 KB)
Sementes.csv (322 Bytes)
Renan,
You might also send along some completed XML files and your CSV output if
you want me to take a look at it.~Neil
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
--
Renan A. Kamimura
Renan, could you send me a completed survey instance?
☞§※☼:airplane:
~Neil
Hi Neil ... i've attached the .csv file and Xform.
Thanks a lot!
Renan
2011/7/28 Neil Hendrick mojotexas@gmail.com
Renan,
You might also send along some completed XML files and your CSV output if
you want me to take a look at it.~Neil
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en--
Renan A. Kamimura--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
Sorry Neil.
Atacched
Thanks
Matriz_simples_2011-07-28_15-15-59.xml (637 Bytes)
Matriz_simples_2011-07-28_15-15-18.xml (631 Bytes)
Renan, could you send me a completed survey instance?
☞§※☼:airplane:
~Neil2011/7/28 Renan Kamimura renankami@gmail.com
Hi Neil ... i've attached the .csv file and Xform.
Thanks a lot!
Renan
2011/7/28 Neil Hendrick mojotexas@gmail.com
Renan,
You might also send along some completed XML files and your CSV output if
you want me to take a look at it.~Neil
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en--
Renan A. Kamimura--
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
--
Renan A. Kamimura
OK, Renan, looks to me like you are nesting your instances one level too
deep. It's like you are treating your whole survey as if it were a nesting
group. A) That's not necessary, and B) KoBoPP doesn't support groups.
Your instance looks like this:
<model>
<instance>
<Sementes id="sementes">
<Matriz>
<N_matriz/>
You should dump Matriz, like this:
<model>
<instance>
<Sementes id="sementes">
<N_matriz/>
☞§※☼:airplane:
~Neil
Sorry Neil.
Atacched
Thanks
2011/7/28 Neil Hendrick mojotexas@gmail.com
Renan, could you send me a completed survey instance?
☞§※☼:airplane:
~Neil2011/7/28 Renan Kamimura renankami@gmail.com
Hi Neil ... i've attached the .csv file and Xform.
Thanks a lot!
Renan
2011/7/28 Neil Hendrick mojotexas@gmail.com
Renan,
You might also send along some completed XML files and your CSV output
if you want me to take a look at it.~Neil
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en--
Renan A. Kamimura--
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--
Renan A. Kamimura--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
Neil ... thanks a lot!! It's OK, the problem is solved!!!
Another doubt... It's possible that the questions into .csv appear in the
same sequence from Xform ?
Sorry for the simple questions and errors cause i'm don't a developer!!! I'm
begginer!
Renan
OK, Renan, looks to me like you are nesting your instances one level too
deep. It's like you are treating your whole survey as if it were a nesting
group. A) That's not necessary, and B) KoBoPP doesn't support groups.Your instance looks like this:
<model> <instance> <Sementes id="sementes"> <Matriz> <N_matriz/>You should dump Matriz, like this:
<model> <instance> <Sementes id="sementes"> <N_matriz/>☞§※☼:airplane:
~Neil2011/7/28 Renan Kamimura renankami@gmail.com
Sorry Neil.
Atacched
Thanks
2011/7/28 Neil Hendrick mojotexas@gmail.com
Renan, could you send me a completed survey instance?
☞§※☼:airplane:
~Neil2011/7/28 Renan Kamimura renankami@gmail.com
Hi Neil ... i've attached the .csv file and Xform.
Thanks a lot!
Renan
2011/7/28 Neil Hendrick mojotexas@gmail.com
Renan,
You might also send along some completed XML files and your CSV output
if you want me to take a look at it.~Neil
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en--
Renan A. Kamimura--
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--
Renan A. Kamimura--
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
--
Renan A. Kamimura
Renan,
Good questions all of them, and always welcome.
Glad your problem is solved.
You noticed that the fields show up in your CSV in a kind of random order.
That is true, it is because the Post Processor is opportunistic in
aggregating data, and so the CSV shows up like that.
You can handle it the same way we handle it.
Open your CSV in Excel, copy and Paste Special all the data into a new
worksheet. When you Paste Special, check the option to Transpose.
This will invert your data so that the columns and rows are switched. It's
like pasting sideways.
Now you can sort the columns alphabetically (or some other way).
Copy and Paste Special with Transpose again, in a new worksheet.
So, that's how you sort your data. Hope that helps.
☞§※☼:airplane:
~Neil
It's possible that the questions into .csv appear in the same sequence from
Xform ?