Hello,
i downloaded my XSL form and I’m trying to upload it but it is not working as it says new users cannot upload files. How can I solve this problem with the duplicate choices?
Best,
Sara
Hi @toexcelsara,
Glad to know that you have finally solved your issue as outlined by @stephanealoo. Hence, if the issue is solved you need not share your xlsform in the community. But kindly please be informed that i have changed the settings and you should now be able to upload files to the community!
Regarding your query:
You see this when you have a select_one sw6ck96 or a select_multiple sw6ck96 question in the survey tab of your xlsform but you do not have the choices name sw6ck96 in the choices tab. Try ensuring this in the upcoming days and you should not see this issue.
Have a great day!
Thank you!
I still cannot preview the form or see my changes as the duplicate choice problem i spoke of earlier remains.
How can I solve this?
Best,
Sara
Hi @toexcelsara,
If you are still having an issue, could you kindly please share your xlsform with the community. The community should be able to identify the duplicates present within the choices tab of you your xlsform.
Have a great day!
Hi @toexcelsara,
Sorry, but how were you able to upload the image (when you are not able to upload a file in the community)!
Have a great day!
I’m not sure. I’m assuming I was allowed to upload a image but not a file. I tried again and was unable to upload the file.
What do you advise me to do?
Hi @toexcelsara,
What is the format of the file you wish to share? You should be able to share an MS Excel File format.
Have a great day!
Hello again!
you are right. It has worked. Can you help me solve the duplicate choice issue mentioned earlier?
apA9eqBfyfiQS84ikG8tDY.xlsx (22.4 KB)
Hi @toexcelsara,
Would you mind providing the highlighted signs with a unique name such as 1, 2, 3, 4.
Also follow the same process throughout the entire document (as outlined below).
It should solve your issue.
Have a great day!
1 Like
Hello,
yes thank you. I’m going to do this now. But I was wondering how do I put this back into the survey on Kobotoolbox?
Best,
Sara
EMERGENCY
I am unable to edit the excel sheet at all. How can I edit it?
Thank you so much,
Sara
Hi @toexcelsara,
Could you kindly let us know more on what you mean by:
Or do you mean by replacing the xlsform back to the KoBoToolbox server?
Have a great day!
Hello,
I have replaced the form with the new edited form (which i have attached for reference) but I now have another problem
apA9eqBfyfiQS84ikG8tDY (2).xlsx (33.2 KB)
I HAVE FIXED THE PROBLEM PERVIOUSLY MENTIONED. BUT NOW THERE IS A NEW ONE.
I have fixed the sw6ck96 problem and replaced the XSL form but the problem is that now we are back to not being able to preview the form because of the same duplicate choices problem
Hi @toexcelsara,
Kindly please be informed that there were still some issues within the xlsform which i have fixed it out:
Issue 1:
There were some duplicates (as shown in the image below) within the choices tab which i have cleaned it. As a reference i have also marked it yellow so that you could see it (for learning) comparing with the previously shared xlsform.
Issues that was still in the choices tab of your xlsform:
Fixed it as follows:
Issue 2:
You had used the language code as Arabic (AR) which i have changed it as Arabic (ar) in the survey, choices as well as the settings tab.
Issue 3:
In the survey tab of your xlsform, you had select_one sw6ck96 as shown in the image below:
But when looking at the choices tab, could not find the list_name sw6ck96. Hence changed the same to integer (as shown in the image below):
If you feel it should not be an integer question type and should be a select_one question type please change it accordingly.
Issue 4:
The relevant column still has this unreadable codes (as shown in the image below which i have not fixed it as you should be more knowledgeable then me):
Kindly please change it based on the formatting that you made previously.
Reference xlsform:
apA9eqBfyfiQS84ikG8tDY (2).xlsx (38.1 KB)
Please be informed that you should be able to upload your xlsform (without any error message). However, please fix Issue 4 for better skipping performance.
Have a great day!
Thank you so much. Issue 4 is the skip logic. i did not create this code it was created automatically when I inputted my skip logic per question. Should I erase it and reenter the skip logic to the form after uploading it?
1 Like
Hello,
thank you so much the preview problem has been solved.
But i’m facing a problem with the skip logic. I have organized it and created a skip logic within the form on kobotoolbox (not the downloaded excel form as it is easier for me cause I’m unfamiliar with how to create skip logic on the excel sheet).
However none of my skip logic inputs are showing up in the submission as I edited them to be. They work in the preview perfectly and I deployed the form but the submission still dose not show the skip logic I created.
it translates the skip logic i entered into the settings – skip logic as ${} = ‘1’ and ${} = ‘2’ and ${_} = ‘3’ for example instead of how i inputted them.
Thank you,
Sara
Hi @toexcelsara,
Yes your skip logic should be changed as you changed the list_name and name to avoid duplication within your survey form. You will have to assign them manually. Maybe this support article ADDING SKIP LOGIC TO YOUR FORM should help you solve your issue.
Have a great day!
1 Like
