KoboCat Error 400 external instance source

[emmhaze]

Hello all,

I’m trying to attach a large list of itemset but keep getting this error. Here’s a sample of my tool and itemset
admin2_info_county_itemsets.csv (2.9 KB)
tool.xlsx (208.9 KB)

Unexpected KoBoCAT error 400: b’{“detail”:“The same instance id will be generated for different external instance source URIs. Please check the form. Instance name: ‘admin2_info_county_itemsets’, Existing type: ‘file’, Existing URI: ‘jr://file-csv/admin2_info_county_itemsets.csv’, Duplicate type: ‘choice’, Duplicate URI: ‘None’, Duplicate context: ‘survey’.”}’

[Kal_Lam]

@emmhaze, if you wish to design your survey project using the select_one_external, you could do it as outlined in our post discussed previously:

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…

If you wish to design your survey project using the select_one_from_file, you could do it as outlined in the support article Select One or Many From External File Question Type.

[emmhaze]

Thanks @Kal_Lam
It worked fine

[emmhaze]

Hello @Kal_Lam,

I have another form that uses an external file but in this case, the example you gave earlier is for when one question needs to use the external file. My current form has three instances where the external file is to be used which will increase the rows of my external file to about 60,000. I guess there should be a way to this. I’m attaching the xlsx file and itemsets for your reference. Thanks

itemsets.csv (2.9 MB) tool.xlsx (1.5 MB)

[Kal_Lam]

Maybe in this case you could also try out select_one_from_file as outlined in the post discussed previously:

Pre-loading csv files in KoBo to cascade select

Welcome to the community @isaacmugabo! You could do the same as outlined in the images shared below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] In the csv file: state code [Image 3] In the csv file: district code [Image 4] In the csv file: village code [Image 5] Data entry screen as seen in Enketo: [Image 6] Reference xlsform: select_one_from_file.xlsx (15.7 KB) CSV file (state code): State_Code.csv (245 Bytes) CSV file (district cod…

[emmhaze]

I tried doing this and I’m getting a download results failure from the kobo collect mobile app on the phones.

[Kal_Lam]

Could you make your CSV file a bit small to make a test to see if should work with a smaller file size? 60k should be a large file size. Or alternatively try the same with a device that should have greater memory to over the same.

[emmhaze]

Yes my State csv is 1kb, district is 4kb and village is 27kb. The tool has just 5 lines

[Kal_Lam]

Would you reduce it to 10-15 for each i.e. state, district and village and see if this works?

[emmhaze]

District_Code.csv (3.4 KB) State_Code.csv (528 Bytes) tool2.xlsx (21.3 KB) Village_Code.csv (1.1 KB)

That didn’t work as well, attached is the test tool and csvs