Form Loading Time and Drop Down List in the Phone Not Appear - Enketo

Hi all,

I am about to launch a survey to social assistance providers in Indonesia using Enketo. When I piloted the form, it took very long to load, regardless the types of phone and internet providers. I suspect that this is because the dynamic filtering using external files that I have to ask for the province (lk01), district (lk02), sub-district (lk03), and village (lk04). There are 34 provinces, 514 districts, 7k sub-districts, and 80k villages in total in Indonesia. For the villages, I split the external files to 34 files with the hope that it will make the questionnaire transition between sub-district and villages processing faster. I’d like to ask your guidance if there are more ways to make the form loading quickly? I attached my form and the supporting files attached.

In addition, the drop down list for the questions on district (lk02), sub-district (lk03), and village (lk04) did not appear in iphones and some android phones which frustrated our pilot respondents. Do you know how to solve this issue?

Thank you.sembako Kuesioner e-Warong.xlsx (70.7 KB) list_desa_11.csv (493.3 KB) list_desa_12.csv (564.0 KB) list_desa_13.csv (128.5 KB) list_desa_14.csv (153.9 KB) list_desa_15.csv (128.4 KB) list_desa_16.csv (315.9 KB) list_desa_17.csv (127.7 KB) list_desa_18.csv (226.8 KB) list_desa_19.csv (40.1 KB) list_desa_21.csv (39.0 KB) list_desa_31.csv (25.8 KB) list_desa_32.csv (487.2 KB) list_desa_33.csv (667.9 KB) list_desa_34.csv (39.5 KB) list_desa_35.csv (660.1 KB) list_desa_36.csv (118.2 KB) list_desa_51.csv (51.8 KB) list_desa_52.csv (103.2 KB) list_desa_53.csv (310.9 KB) list_desa_61.csv (189.1 KB) list_desa_62.csv (149.7 KB) list_desa_63.csv (190.9 KB) list_desa_64.csv (97.3 KB) list_desa_65.csv (44.0 KB) list_desa_71.csv (172.8 KB) list_desa_72.csv (174.8 KB) list_desa_73.csv (272.1 KB) list_desa_74.csv (209.8 KB) list_desa_75.csv (60.7 KB) list_desa_76.csv (56.0 KB) list_desa_81.csv (104.3 KB) list_desa_82.csv (108.7 KB) list_desa_91.csv (165.6 KB) list_desa_94.csv (406.9 KB) list_kab.csv (13.6 KB) list_kec.csv (194.6 KB) list_prov.csv (743 Bytes)

Hi @zanty,

Would you mind trying this workaround that has been discussed previously (it should solve your issue):

Have a great day!

Hi Kal,

Yes, it works to show the drop down list. Thanks for tips!

How about the form loading time? Is there anyway I could make the loading time faster? With your tips, I only use 1 csv file but it is 3.4 MB

1 Like

Hi @zanty,

The survey content definitely affects the loading time. Hence would request you to have only those variables that are really required.

Have a great day!

Hi @zanty,

Try to upload your csv file as a zip file.

Best,
Yasser

1 Like

Thanks Kal and Yasser for the tips. I’ve tried uploading my csv file as a zip file, but the answer choices did not appear. Do you know why this happens?

Hi @zanty,

I think Enketo doesn’t support the zip files.

Best,
Yasser

Hi @zanty
As @Ysr3322 has mentioned, ZIP is not supported. On the other hand, the amount of time taken to load is dependent on the speed of your own data collection device which is in turn affected by the size of the file in this case the >3 MB file. Unfortunately, there is no way to increase this if the data collection device and the file still remain constant.

Stephane

1 Like

Thanks Yasser and Stephane for sharing! I see your point. I think one option that I have now is to make the village name as open ended question instead of drop down list. It should make the loading time faster.

1 Like