could you attach your form?
Thank you so much for looking into this, and to you Geneviève for raising the issue. I had the same problem (same error message) today on forms that had previously been validated using http://opendatakit.org/xlsform/
In case it is relevant, just to say the other additional (new) error message I got today was regarding "
allow_choice_duplicates column header defined in your settings sheet". I was able to fix that and so the only error message I get is now relating to the list index out of range.
I too have not made any changes to the forms that were working fine last week, and only discovered the error message when trying to hand over work to a colleague today.
With thanks, Phil
We found the issue. Replace _ by -
I don't yet know what the problem is, but I've filed the upstream issue at https://github.com/XLSForm/pyxform/issues/352 and you can track progress there.
@Ukang_a_Dickson can you help?
Thank you for your help. Both the online and offline versions still produce the same error message. Is there another way to convert the xml file, I have always used this online/offline tools so I am not sure about other options.
Thanks a lot.
@AL Can you retry the online server? I just made a few changes. Also, what version of the offline app did you try? Finally, can you please share a small form that has this problem? It'd really help track this down.
The new online version now works This is life saving since we are starting our survey in Kenya next week!
Thanks again for your help.
Many thanks from me too, the XLSForm Online is working again for me. Much appreciated.
Hi, I think the issue is back today (Sep 24, 2019 @ 10:15 MST) using https://opendatakit.org/xlsform/ v.1.6.1 . I'm attempting to convert a XLSform that previously worked, and am getting the exact same error as above:
"Error: There does not seem to be a
allow_choice_duplicates column header defined in your settings sheet. You must have set
allow_choice_duplicates setting in your settings sheet to have duplicate choice list names in your choices sheet"
@Greg You probably have a duplicate choice name in one or more of your choice lists. This is a new error that was added because choices with the same name will be impossible to differentiate in analysis.
You will need to either remove the duplicate choices or add
allow_choice_duplicates column in your settings sheet and below that header write
This is a not great error message and there is an issue at https://github.com/XLSForm/pyxform/issues/373 to improve it.
OK, thanks @yanokwa ! I was just confused because it was the same form as before that worked.
Issue is still exist in 1.6.1
I experiment this issue with a form which previously works perfectly
I did not change any thing except the version name
were can I find the previous version ?
@ganesh_rajput, @Fabienne35, the problem is almost certainly that you actually have duplicate choice names in one or more of your lists. For example, you might have options with labels "Red" and Blue" that both have the name "2". This is a problem because you won't be able to tell in analysis whether the user selected red or blue. That's what the error is about.
Sometimes this is intentional because you want to do something like give red and blue the same "weight" when doing a calculation later. In that case, you can add a settings sheet (see http://xlsform.org/en/#settings-worksheet), add a column named
allow_choice_duplicates and put the value
yes below that heading.
I am also still having an issue with this in both the online and the offline forms. What was the fix that was made or needs to be made?
Please make sure to read this post for context. You have two options:
- If you intend for each choice to be treated differently in analysis, look for duplicate names in your lists and replace them with unique names
- If you intend to have choices that are treated the same in analysis, add the
allow_choice_duplicatescolumn with value
yesbelow it on the settings sheet (see http://xlsform.org/en/#settings-worksheet).
I currently have the same issue converting to xlsform using the online tool. The site it says it's on v.1.6.1. Can anyone help? Thanks.
Sorry I hadn't seen the posts above recommending adding the 'allow_choice_duplicates' column in settings. After doing this, it has worked thanks.