Error uploading csv file

mrt_ky · March 1, 2020, 1:00pm

Hello all,

I was trying to upload choices as CSV file as shown here . However, I get an error like this

I cannot find the mistake I make.
Thanks in advance.

Kal_Lam · March 2, 2020, 8:58am

Welcome to the community! I just tried out uploading a csv file for select one from file question type and was successful. Please try using the attached file:

Reference xlsform:
select_one_from_file.xlsx (10.5 KB)

Reference csv file:
fruits.csv (522 Bytes)

For reference, you could also have a look at our previous post which should outline you with detailed steps on uploading a csv file in KoBoToolbox:

Have a great day!

vishwadeep · October 22, 2021, 12:06pm

Hi @Kal_Lam , I am getting an error with the same files you reffer…

stephanealoo · October 22, 2021, 3:10pm

Hi @vishwadeep
Could you provide context to how you were trying to operationalize this for your case? This clarification would help other users chime on your problem.

Stephane

vishwadeep · October 23, 2021, 10:28am

Hi @stephanealoo ,
First I upload the XLS file "select_one_from_file.xlsx file then I deploy the project then go to SETTINGS and then MEDIA and upload the CSV file “fruits.csv” and Redeploy it again.
And this error coming in the Form Builder view

Kal_Lam · October 24, 2021, 1:18pm

@vishwadeep, when you try to edit a survey form that has the select_one_from_file question type you see this error message. It’s a but and we already have a GitHub issue for the same. You could follow it here:

github.com/kobotoolbox/kpi

select_one_from_file question type issues in KoBoToolbox form builder user interface

opened 06:02AM - 12 Jun 20 UTC

Kalyan-Lama

## 2 issues observed with `select_one_from_file` question type issues in KoBoToo…lbox form builder user interface #### First issue: An error message (for the `select_one_from_file` question) is seen while trying to edit a survey form as shown in the image below: ![Image 1](https://user-images.githubusercontent.com/50188479/84469265-5d670980-aca0-11ea-9c2e-b094d33cebae.png) #### Second issue: The `select_one_from_file` question disappears when 1) editing 2) saving and 3) redeploying the survey form that has already been deployed. The form builder user interface would only have the remaining questions (other then the `select_one_from_file` question) as shown in the image below: ![Image 2](https://user-images.githubusercontent.com/50188479/84469497-e4b47d00-aca0-11ea-8ef7-14594e175521.png) ## Steps to Reproduce 1. Deploy a survey project with `select_one_from_file` question type. 2. Edit the survey project with `select_one_from_file` question type. **(You should now be able to see Issue 1 listed above)** 3. Save the survey project with `select_one_from_file` question type. 4. Redeploy the survey project with `select_one_from_file` question type. 5. `select_one_from_file` question from the form builder user interface disappears. Check by going through Forms>edit. **(You should now be able to see Issue 2 listed above)** ## Expected behavior 1. Should not see an error message as outlined in `First issue`. 2. The `select_one_from_file` question should not disappear as outlined in `Second issue`. ## Actual behavior 1. See an error message as outlined in `First issue`. 2. The `select_one_from_file` question disappears as outlined in `Second issue`. ## Additional details The data collected and stored (in the KoBoToolbox server) for the `select_one_from_file` question however does not get lost with the error message being displayed and questions getting disappeared. ## Reference xlsfrom: [Select One From File.xlsx](https://github.com/kobotoolbox/kpi/files/4769003/Select.One.From.File.xlsx) ## Reference csv file: Please extract the csv file from the flowdock thread as GH does not seem to support the same. ## Flodock thread: https://www.flowdock.com/app/kobotoolbox/support/threads/L4h_2ybNlTQ0cHmIh5qani6R5yu

vishwadeep · October 25, 2021, 5:42am

Thank you @Kal_Lam
Now the issue is gone, but the form not fetching any data from the CSV file when I see it in the Preview.
For reference, I am attaching the files. Pls help me.Cascade111.csv (9.2 MB)
Project2.xlsx (12.7 KB)

Kal_Lam · October 25, 2021, 5:49am

Did you redeploy your survey form (after uploading/updating your csv file)?

vishwadeep · October 26, 2021, 3:00am

@Kal_Lam
Yes

Kal_Lam · October 26, 2021, 5:26am

FYR: