Hi,
my users are experiencing performance issues on the ODK collect...so i need
to convert my form using select_one_external.
Reading this guide (http://xlsform.org/) it would be simple: change the
select_one into select_one_external, move the choice into external_choice
excel tab... and convert the xls form ...
So i made all the changes, but when i converted my xls
with http://opendatakit.org/xiframe/ i got this strange message:
ODK Validate Warnings: XForm Parse Warning: Warning: 1 Unrecognized
attributes found in Element [input] and will be ignored: [query] Location:
I have used external itemsets before both by editing the xlm file or
editing the xls and it really improves the performance of your forms. I
passed from 55 secs to loading in 5 secs. Seriously! Editing the xlm is
good to develop an understanding of whats going on and get familiar with
xml language. However, in the end, editing the xls is more practical.
Basically you change the select_one into "select_one_external". Be careful
creating the itemsets.csv. I had to do this manually as instructed
here http://xlsform.org/#external. Put the csv in the media folder of your
form. I think the documentation is not very accurate.
I compile using the xlsform (windows)
Cheers,
Juan
···
Le mercredi 28 janvier 2015 16:36:22 UTC+7, Angelo Lazzari a écrit :
>
> Hi,
> my users are experiencing performance issues on the ODK collect...so i
> need to convert my form using select_one_external.
>
> Reading this guide (http://xlsform.org/) it would be simple: change the
> select_one into select_one_external, move the choice into external_choice
> excel tab... and convert the xls form ...
>
> So i made all the changes, but when i converted my xls with
> http://opendatakit.org/xiframe/ i got this strange message:
> ODK Validate Warnings: XForm Parse Warning: Warning: 1 Unrecognized
> attributes found in Element [input] and will be ignored: [query] Location:
>
> And i have the same if i try to convert your online example:
> https://docs.google.com/spreadsheets/d/12qZL34kuHSZGWDv0BBJ1qf7dSmml-d2VnMWH0Vtg-O4/edit?usp=sharing
>
> So i tried to look for example and i found this doc
> https://opendatakit.org/help/form-design/external-itemsets/
> but i think it's only in the caso you haven't the xls, no?
>
> So my questions are:
> am i using the wrong converting tool to convert from and XLS to a XML ?
>
> Is there a official documenti? Or i have to use my select_one XML and
> convert it to an external one? (using the
> https://opendatakit.org/help/form-design/external-itemsets/ guide?)
>
> Thank you very much
> Angelo
>
If the documentation is not accurate please file an issue on the xlsform.org
Github repo with the suggested improvements or do a pull request.
Thanks!
Matt
···
On Jan 29, 2015 6:06 AM, "jpardila" wrote:
Hello Angelo,
I have used external itemsets before both by editing the xlm file or
editing the xls and it really improves the performance of your forms. I
passed from 55 secs to loading in 5 secs. Seriously! Editing the xlm is
good to develop an understanding of whats going on and get familiar with
xml language. However, in the end, editing the xls is more practical.
Basically you change the select_one into "select_one_external". Be careful
creating the itemsets.csv. I had to do this manually as instructed here http://xlsform.org/#external. Put the csv in the media folder of your
form. I think the documentation is not very accurate.
Le mercredi 28 janvier 2015 16:36:22 UTC+7, Angelo Lazzari a écrit :
Hi,
my users are experiencing performance issues on the ODK collect...so i
need to convert my form using select_one_external.
Reading this guide (http://xlsform.org/) it would be simple: change the
select_one into select_one_external, move the choice into external_choice
excel tab... and convert the xls form ...
So i made all the changes, but when i converted my xls with http://opendatakit.org/xiframe/ i got this strange message:
ODK Validate Warnings: XForm Parse Warning: Warning: 1 Unrecognized
attributes found in Element [input] and will be ignored: [query] Location:
So my questions are:
am i using the wrong converting tool to convert from and XLS to a XML ?
Is there a official documenti? Or i have to use my select_one XML and
convert it to an external one? (using the https://opendatakit.org/help/
form-design/external-itemsets/ guide?)
Juan, i created the xls as the documentation you put says, but i think my
problem is on the conversion of the xls file, i will try to install locally
the converter as you said.
keep in touch
Angelo
···
Il giorno Thu Jan 29 2015 at 05:44:54 Matt Berg ha scritto:
Juan,
If the documentation is not accurate please file an issue on the xlsform.org Github repo with the suggested improvements or do a pull
request.
Thanks!
Matt
On Jan 29, 2015 6:06 AM, "jpardila" bluejp@gmail.com wrote:
Hello Angelo,
I have used external itemsets before both by editing the xlm file or
editing the xls and it really improves the performance of your forms. I
passed from 55 secs to loading in 5 secs. Seriously! Editing the xlm is
good to develop an understanding of whats going on and get familiar with
xml language. However, in the end, editing the xls is more practical.
Basically you change the select_one into "select_one_external". Be careful
creating the itemsets.csv. I had to do this manually as instructed here http://xlsform.org/#external. Put the csv in the media folder of your
form. I think the documentation is not very accurate.
Le mercredi 28 janvier 2015 16:36:22 UTC+7, Angelo Lazzari a écrit :
Hi,
my users are experiencing performance issues on the ODK collect...so i
need to convert my form using select_one_external.
Reading this guide (http://xlsform.org/) it would be simple: change the
select_one into select_one_external, move the choice into external_choice
excel tab... and convert the xls form ...
So i made all the changes, but when i converted my xls with http://opendatakit.org/xiframe/ i got this strange message:
ODK Validate Warnings: XForm Parse Warning: Warning: 1 Unrecognized
attributes found in Element [input] and will be ignored: [query] Location:
So my questions are:
am i using the wrong converting tool to convert from and XLS to a XML ?
Is there a official documenti? Or i have to use my select_one XML and
convert it to an external one? (using the https://opendatakit.org/help/
form-design/external-itemsets/ guide?)
Hi, i downloaded the xls forms converter on a windows PC, i converted my
file: no error but no external file too!
So i tried to convert the xls forms official external example file... and:
same situation, no errors, but no file csv. So at this point, i think there
is a problem.
Juan, can you tell us, why you told the doc is not completely correct? Did
you make a non-reported step to obtain the external files?
I did as the doc says:
the old select_one (just the ones with choice_filter...) are now
solect_one_external
and the data that where in the choices are now in the external_choices.
···
Il giorno Thu Jan 29 2015 at 08:27:52 Angelo Lazzari < angelo.lazzari@redtulp.com> ha scritto:
Thank you very much guys.
Juan, i created the xls as the documentation you put says, but i think my
problem is on the conversion of the xls file, i will try to install locally
the converter as you said.
keep in touch
Angelo
Il giorno Thu Jan 29 2015 at 05:44:54 Matt Berg mlberg@gmail.com ha
scritto:
Juan,
If the documentation is not accurate please file an issue on the xlsform.org Github repo with the suggested improvements or do a pull
request.
Thanks!
Matt
On Jan 29, 2015 6:06 AM, "jpardila" bluejp@gmail.com wrote:
Hello Angelo,
I have used external itemsets before both by editing the xlm file or
editing the xls and it really improves the performance of your forms. I
passed from 55 secs to loading in 5 secs. Seriously! Editing the xlm is
good to develop an understanding of whats going on and get familiar with
xml language. However, in the end, editing the xls is more practical.
Basically you change the select_one into "select_one_external". Be careful
creating the itemsets.csv. I had to do this manually as instructed here http://xlsform.org/#external. Put the csv in the media folder of your
form. I think the documentation is not very accurate.
Le mercredi 28 janvier 2015 16:36:22 UTC+7, Angelo Lazzari a écrit :
Hi,
my users are experiencing performance issues on the ODK collect...so i
need to convert my form using select_one_external.
Reading this guide (http://xlsform.org/) it would be simple: change
the select_one into select_one_external, move the choice into
external_choice excel tab... and convert the xls form ...
So i made all the changes, but when i converted my xls with http://opendatakit.org/xiframe/ i got this strange message:
ODK Validate Warnings: XForm Parse Warning: Warning: 1 Unrecognized
attributes found in Element [input] and will be ignored: [query] Location:
So my questions are:
am i using the wrong converting tool to convert from and XLS to a XML ?
Is there a official documenti? Or i have to use my select_one XML and
convert it to an external one? (using the https://opendatakit.org/help/
form-design/external-itemsets/ guide?)
Angelo and Juan,
It worked right off. I saved the third tab in google docs
"external_choices" as a plain csv file named "itemsets.csv" and put it
into a folder called odk\forms\select_one_external-media.
Curtis
···
2015-01-29 8:57 GMT+01:00 Angelo Lazzari :
Hi, i downloaded the xls forms converter on a windows PC, i converted my
file: no error but no external file too!
So i tried to convert the xls forms official external example file... and:
same situation, no errors, but no file csv. So at this point, i think there
is a problem.
Juan, can you tell us, why you told the doc is not completely correct? Did
you make a non-reported step to obtain the external files?
I did as the doc says:
the old select_one (just the ones with choice_filter...) are now
solect_one_external
and the data that where in the choices are now in the external_choices.
Juan, i created the xls as the documentation you put says, but i think my
problem is on the conversion of the xls file, i will try to install locally
the converter as you said.
keep in touch
Angelo
Il giorno Thu Jan 29 2015 at 05:44:54 Matt Berg mlberg@gmail.com ha
scritto:
Juan,
If the documentation is not accurate please file an issue on the xlsform.org Github repo with the suggested improvements or do a pull
request.
Thanks!
Matt
On Jan 29, 2015 6:06 AM, "jpardila" bluejp@gmail.com wrote:
Hello Angelo,
I have used external itemsets before both by editing the xlm file or
editing the xls and it really improves the performance of your forms. I
passed from 55 secs to loading in 5 secs. Seriously! Editing the xlm is
good to develop an understanding of whats going on and get familiar with
xml language. However, in the end, editing the xls is more practical.
Basically you change the select_one into "select_one_external". Be careful
creating the itemsets.csv. I had to do this manually as instructed here http://xlsform.org/#external. Put the csv in the media folder of your
form. I think the documentation is not very accurate.
Le mercredi 28 janvier 2015 16:36:22 UTC+7, Angelo Lazzari a écrit :
Hi,
my users are experiencing performance issues on the ODK collect...so i
need to convert my form using select_one_external.
Reading this guide (http://xlsform.org/) it would be simple: change
the select_one into select_one_external, move the choice into
external_choice excel tab... and convert the xls form ...
So i made all the changes, but when i converted my xls with http://opendatakit.org/xiframe/ i got this strange message:
ODK Validate Warnings: XForm Parse Warning: Warning: 1 Unrecognized
attributes found in Element [input] and will be ignored: [query] Location:
Curtis BRODERICK
Head of technical training and user support
---------------------------EpiConcept---------------------------
Systèmes d'Information en Santé
Health Information Systems
47, rue de Charenton - 75012 PARIS
Tel : +33 (0)1 53 02 40 60 Fax : +33 (0)1 53 02 40 62
In my case I created the csv file manually in excel. I don't think you get
the csv when compiling. You have to create it yourself as Curtis mentioned.
Make sure to put the file in media folder.
Cheers,
Juan
···
Le jeudi 29 janvier 2015 16:39:03 UTC+7, Curtis Broderick a écrit :
>
> Angelo and Juan,
> It worked right off. I saved the third tab in google docs
> "external_choices" as a plain csv file named "itemsets.csv" and put it
> into a folder called odk\forms\select_one_external-media.
> Curtis
>
> 2015-01-29 8:57 GMT+01:00 Angelo Lazzari >:
>
>> Hi, i downloaded the xls forms converter on a windows PC, i converted my
>> file: no error but no external file too!
>> So i tried to convert the xls forms official external example file...
>> and: same situation, no errors, but no file csv. So at this point, i think
>> there is a problem.
>>
>> Juan, can you tell us, why you told the doc is not completely correct?
>> Did you make a non-reported step to obtain the external files?
>>
>> I did as the doc says:
>> the old select_one (just the ones with choice_filter...) are now
>> solect_one_external
>> and the data that where in the choices are now in the external_choices.
>>
>> That's it...
>>
>> So i think that the
>> https://opendatakit.org/help/form-design/external-itemsets/
>> documentation is not valid? or is a step more to execute?
>>
>> Thank you very much guys!
>> Angelo
>>
>>
>> Il giorno Thu Jan 29 2015 at 08:27:52 Angelo Lazzari < angelo....@redtulp.com > ha scritto:
>>
>> Thank you very much guys.
>>>
>>> Juan, i created the xls as the documentation you put says, but i think
>>> my problem is on the conversion of the xls file, i will try to install
>>> locally the converter as you said.
>>>
>>> keep in touch
>>> Angelo
>>>
>>> Il giorno Thu Jan 29 2015 at 05:44:54 Matt Berg <mlb...@gmail.com > ha scritto:
>>>
>>> Juan,
>>>>
>>>> If the documentation is not accurate please file an issue on the
>>>> xlsform.org Github repo with the suggested improvements or do a pull
>>>> request.
>>>>
>>>> Thanks!
>>>>
>>>> Matt
>>>> On Jan 29, 2015 6:06 AM, "jpardila" <blu...@gmail.com > wrote:
>>>>
>>>>> Hello Angelo,
>>>>>
>>>>> I have used external itemsets before both by editing the xlm file or
>>>>> editing the xls and it really improves the performance of your forms. I
>>>>> passed from 55 secs to loading in 5 secs. Seriously! Editing the xlm is
>>>>> good to develop an understanding of whats going on and get familiar with
>>>>> xml language. However, in the end, editing the xls is more practical.
>>>>> Basically you change the select_one into "select_one_external". Be careful
>>>>> creating the itemsets.csv. I had to do this manually as instructed here
>>>>> http://xlsform.org/#external. Put the csv in the media folder of
>>>>> your form. I think the documentation is not very accurate.
>>>>>
>>>>> I compile using the xlsform (windows)
>>>>> https://opendatakit.org/downloads/download-info/xlsform-for-windows/
>>>>>
>>>>> Cheers,
>>>>>
>>>>> Juan
>>>>>
>>>>> Le mercredi 28 janvier 2015 16:36:22 UTC+7, Angelo Lazzari a écrit :
>>>>>>
>>>>>> Hi,
>>>>>> my users are experiencing performance issues on the ODK collect...so
>>>>>> i need to convert my form using select_one_external.
>>>>>>
>>>>>> Reading this guide (http://xlsform.org/) it would be simple: change
>>>>>> the select_one into select_one_external, move the choice into
>>>>>> external_choice excel tab... and convert the xls form ...
>>>>>>
>>>>>> So i made all the changes, but when i converted my xls with
>>>>>> http://opendatakit.org/xiframe/ i got this strange message:
>>>>>> ODK Validate Warnings: XForm Parse Warning: Warning: 1 Unrecognized
>>>>>> attributes found in Element [input] and will be ignored: [query] Location:
>>>>>>
>>>>>> And i have the same if i try to convert your online example:
>>>>>> https://docs.google.com/spreadsheets/d/12qZL34kuHSZGWDv0BBJ1qf7dSmml-
>>>>>> d2VnMWH0Vtg-O4/edit?usp=sharing
>>>>>>
>>>>>> So i tried to look for example and i found this doc
>>>>>> https://opendatakit.org/help/form-design/external-itemsets/
>>>>>> but i think it's only in the caso you haven't the xls, no?
>>>>>>
>>>>>> So my questions are:
>>>>>> am i using the wrong converting tool to convert from and XLS to a XML
>>>>>> ?
>>>>>>
>>>>>> Is there a official documenti? Or i have to use my select_one XML and
>>>>>> convert it to an external one? (using the
>>>>>> https://opendatakit.org/help/form-design/external-itemsets/ guide?)
>>>>>>
>>>>>> Thank you very much
>>>>>> Angelo
>>>>>>
>>>>> --
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "ODK Developers" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to opendatakit-developers+unsubscribe@googlegroups.com
>>>>> .
>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "ODK Developers" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to opendatakit-developers+unsubscribe@googlegroups.com
>>>> .
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "ODK Developers" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to opendatakit-developers+unsubscribe@googlegroups.com
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
>
> *Curtis BRODERICK*
> Head of technical training and user support
>
> ---------------------------EpiConcept---------------------------
> Systèmes d'Information en Santé
> Health Information Systems
> 47, rue de Charenton - 75012 PARIS
> Tel : +33 (0)1 53 02 40 60 Fax : +33 (0)1 53 02 40 62
>
>
···
On Thu, Jan 29, 2015 at 10:17 AM, jpardila wrote:
HI Angelo,
In my case I created the csv file manually in excel. I don't think you get
the csv when compiling. You have to create it yourself as Curtis mentioned.
Make sure to put the file in media folder.
Cheers,
Juan
Le jeudi 29 janvier 2015 16:39:03 UTC+7, Curtis Broderick a écrit :
Angelo and Juan,
It worked right off. I saved the third tab in google docs
"external_choices" as a plain csv file named "itemsets.csv" and put it
into a folder called odk\forms\select_one_external-media.
Curtis
Hi, i downloaded the xls forms converter on a windows PC, i converted my
file: no error but no external file too!
So i tried to convert the xls forms official external example file...
and: same situation, no errors, but no file csv. So at this point, i think
there is a problem.
Juan, can you tell us, why you told the doc is not completely correct?
Did you make a non-reported step to obtain the external files?
I did as the doc says:
the old select_one (just the ones with choice_filter...) are now
solect_one_external
and the data that where in the choices are now in the external_choices.
Il giorno Thu Jan 29 2015 at 08:27:52 Angelo Lazzari < angelo....@redtulp.com> ha scritto:
Thank you very much guys.
Juan, i created the xls as the documentation you put says, but i think
my problem is on the conversion of the xls file, i will try to install
locally the converter as you said.
keep in touch
Angelo
Il giorno Thu Jan 29 2015 at 05:44:54 Matt Berg mlb...@gmail.com ha
scritto:
Juan,
If the documentation is not accurate please file an issue on the xlsform.org Github repo with the suggested improvements or do a pull
request.
Thanks!
Matt
On Jan 29, 2015 6:06 AM, "jpardila" blu...@gmail.com wrote:
Hello Angelo,
I have used external itemsets before both by editing the xlm file or
editing the xls and it really improves the performance of your forms. I
passed from 55 secs to loading in 5 secs. Seriously! Editing the xlm is
good to develop an understanding of whats going on and get familiar with
xml language. However, in the end, editing the xls is more practical.
Basically you change the select_one into "select_one_external". Be careful
creating the itemsets.csv. I had to do this manually as instructed here http://xlsform.org/#external. Put the csv in the media folder of
your form. I think the documentation is not very accurate.
Le mercredi 28 janvier 2015 16:36:22 UTC+7, Angelo Lazzari a écrit :
Hi,
my users are experiencing performance issues on the ODK collect...so
i need to convert my form using select_one_external.
Reading this guide (http://xlsform.org/) it would be simple: change
the select_one into select_one_external, move the choice into
external_choice excel tab... and convert the xls form ...
So i made all the changes, but when i converted my xls with http://opendatakit.org/xiframe/ i got this strange message:
ODK Validate Warnings: XForm Parse Warning: Warning: 1 Unrecognized
attributes found in Element [input] and will be ignored: [query] Location:
Curtis BRODERICK
Head of technical training and user support
---------------------------EpiConcept---------------------------
Systèmes d'Information en Santé
Health Information Systems
47, rue de Charenton - 75012 PARIS
Tel : +33 (0)1 53 02 40 60 Fax : +33 (0)1 53 02 40 62