Unable to preview a survey form if the xlsform has rows more than 254

User Support Form Building
,
1

Hi,

We are creating the form with the help of Excel sheet, and uploaded the Excel sheet into the Kobotoolbox.org,

If the Excel sheet is more then 254 rows then the form is unable to preview.

Could please help us.

2

That’s odd; there are a lot of longer forms that are working properly (for example, I was just working with a form that has 300+ questions). There’s probably something else with the form structure that’s causing an issue. Is your XLSForm—the one that does cannot be previewed—confidential, or could you share it here?

3

Hi,

Thanks for responds,

While uploading the file we are facing an issue that “new user cannot upload the file”.

The Excel file consist of 700 lines.
So please find the attached link of Excel file:

https://odsol-my.sharepoint.com/:x:/g/personal/akeerthi_ondevice_co_uk/EcC8UzYYodpMjGzfIW4N2RcBO8PsRb9Gj5EXw2ozZhj9-w?e=Q7qgqP

Thanks & Regards,
Keerthi

4

Thank you for sharing the form. I’ve tried uploading it to kf.kobotoolbox.org with success. I was then able to open the form in Enketo and make a submission.

Could you help us figure out the problem by taking a screenshot of the error?

6

Hi,

Thanks for responds,

We are not getting any error message but if we try to preview the form it keeps “loading” till we close the previewing.

I have recorded the process of uploading and previewing the form in below link

https://odsol-my.sharepoint.com/:v:/g/personal/akeerthi_ondevice_co_uk/EdjyHjQ-VytImULmIOPo9oAB0yd-4xlcHG1woGX523ARAg?e=oIf6Id

Thanks & Regards,
Keerthi

7

probably the excel has an error or space on it or your network connection may be poor

8

Hi @keerthi

Please check row 119 and let me know if that resolves the loading issue.

image
image.png737×52 5.81 KB

9

Hi Mike,

Thanks for reposes,

I have done the correction of the XLS file. Still the loading issues is not resolved.
And I have changed the network connection and try to preview the form, but still the issue is not resolved.
Please find the XLS file in the below link.

https://odsol-my.sharepoint.com/:x:/g/personal/akeerthi_ondevice_co_uk/EU_VNtQp5S1PsV9JZPamI2kBgue5kUC9go3jX0Bl2GUAtw?e=o0951i

Thanks & Regards,
Keerthi

10

Hi,

Could anyone get a chance to look into the issue. We are waiting for your response.

We have checked in different networks too. But result is same as in video.

Video URL:
https://odsol-my.sharepoint.com/:v:/g/personal/akeerthi_ondevice_co_uk/EdjyHjQ-VytImULmIOPo9oAB0yd-4xlcHG1woGX523ARAg?e=hTRlf3

Thanks & Regards
Keerthi

11

let me see what i can do

12

It works fine are you using your own server?

13

Hi @keerthi

I am still seeing an error message.

image
image.png750×62 4.74 KB

Try uploading your form here to spot and resolve all the errors: https://opendatakit.org/xlsform/

14

i think the xls looks fine here is the form on my cloud https://ee.kobotoolbox.org/x/#kwALtl29

15

@keerthi, can you take a screenshot of the network information in your developer console when you experience the loading issue? I still can’t reproduce your problem. Previewing your form is slow (it takes over 16 seconds), but it does load for me. Here’s the kind of information that I’m looking for:

Screenshot_2019-04-17_07-21-47
Screenshot_2019-04-17_07-21-47.png1376×480 88.6 KB

16

No, We are not having our own server.

17

@keerthi i think this is your form looks like https://ee.kobotoolbox.org/x/#kwALtl29 its kobotoolbox server it works perfectly.

are you using VPN or Proxy server or check some firewall policy of your organization

18

Hi,

Thanks for response!

Now the form is working fine. No idea, whether the network issue or form data error, I tried to create the form and Upload it again then looks fine.