Is there a limit to the size of the XLS form?

[GuiPortillo]

Hello everybody,

I sometimes have problems loading the form, so I think it is because of the size of the form, and now it does not let me generate reports in excel, it keeps generating the file, but it does not finish it.

My question is:

Is there a limit to the size of the XLS form?

[Kal_Lam]

Welcome to the community, @GuiPortillo! Did you have an issue uploading your survey form (XLSForm) or downloading the data (in XLS format)?

[GuiPortillo]

Hi Kal_Lam,
Today it worked fine for me, I think I had a lot of older versions, so that was not allowing me to make the reports, so that was the problem.
My previous question is, that my form is very large, it is for taking data for solar plant planning, so I wanted to put in a lot of information regarding solar panel brands, etc. I had to reduce the form a little bit, but I don’t know exactly if there is a limit for it?
Regards

[Kal_Lam]

@GuiPortillo

My previous question is, that my form is very large, it is for taking data for solar plant planning, so I wanted to put in a lot of information regarding solar panel brands, etc. I had to reduce the form a little bit, but I don’t know exactly if there is a limit for it?

OK, so there are a lot of factors that could time out the form while being loaded. Some of them could be as follows:

• If you have too many questions in your survey tab.
• If you have too many choices in your choices tab.
• If your XLSForm has a lot of complex constraints.

So to check out which caused the effect, you will need to …

• Break down the survey into smaller chunks to see if that does not time out.
• User external choices if you have too long choices under the choices tab.
• Try to remove the constraints/expressions to see if they are the ones that are timing out the form.

[GuiPortillo]

Thank you Kal_Lam, the problem is that i have too many choices in my choices tab, Is there a specific tool in Kobotool to use external choices?
Thank you for your time, best regards

[Kal_Lam]

@GuiPortillo, you should be able to use the external choices as outlined in our previous post:

Problem recognizing external choices command with today's system upgrade

@basualdo, kindly please be informed that I just checked the feature with the HHI server and it works. Please be informed that this feature at the moment only works with Collect android app while Enketo does not support it. You could design your xlsform as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] In the external_choices of your xlsform: [Image 3] Or, you could simply list out the unique list_name as show…

Here is another approach using external choices:

Select_one choice filter from another select_one

Hi @esmatullaharifi, Welcome to the community! You could design your survey form with the cascading select question to get what you have tried for by following the support article here. As a backup you could also have a look at the post that has a simple workaround that should help you understand the concept of cascading select question: But looking at your xlsform, i see there are more then 800 choices which should affect your data entry performance. Thus a solution for this could be design…

[GuiPortillo]

Thank you Kal_Lam, I appreciate it.

[GuiPortillo]

Hi Kal_Lam with the same form as last time, I have been trying the various forms that you have given me, but they do not work.
I copied the solution that is there (Select_one choice filter form another select_one), it works once and when I enter to modify it, the following error appears.
Zeile konnte nicht angezeigt werden:
type=“select_one_from_file” name=“CDC_Code” Label=“CDC Code” hint=“Select the Modell” requiered=“true”… here the file
select_one_from_file.xlsx (15.4 KB)
CDC_Code.csv (35.5 KB)