Hi all guys! Thank you guys for the help...finally i got my select external
version!
The documentation on http://xlsform.org/#
externa
l (that now is offline i think temporarily) is that is says:
External selects
When an XLSForm with external choices is converted to an XForm,
two files will be produced
, the XForm (e.g., form-filename.xml) with all the normal choices, and
This is not true, you have to create manually (just for the choices with a
choice_filter) your itemsets.csv (separated with commas) and put every
record relates to the select_one_external response). in the documentation
would be great (till the patch doesn't arrive) to aware the users about the
warnings message during the online conversion fron xls to xml.
antway My complication was the follow: that i had in a choice_filter a
number variable and che choice filter didn't work till i converted that
variable in a string (that i think because of the string instead of select1
of the external modification)
so now everything is working great.
thank you guys!
Angelo
The ODK Validate warnings about 'query' being an unrecognized parameter
···
Il giorno Thu Jan 29 2015 at 22:25:14 Mitch Sundt mitchellsundt@gmail.com> ha scritto:
> should not prevent a download of the converted form.
>
> These are due to an oversight -- when Nafundi contributed the external
> itemset changes, they didn't provide a patch to suppress these warnings.
>
> Created an issue to track this: https://code.google.com/p/open
> datakit/issues/detail?id=1103
>
>
>
> 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
>>>
>>> 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 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" 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/12qZL34kuHSZ
>>>>>>>> GWDv0BBJ1qf7dSmml-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
>>>
>>> --
>> 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.
>>
>
>
>
> --
> Mitch Sundt
> Software Engineer
> University of Washington
> mitchellsundt@gmail.com
>
> --
> 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.
>