Error Loading csv file

kelvinaeb · November 25, 2024, 7:44am

Hi,

I am having an error message when I attempt to preview my file. It is showing that the .csv file cannot be found. Attached is the error image.

Thank you.

hakan_cetinkaya · November 25, 2024, 7:59am

Hi @kelvinaeb,

Did you upload your csv file to the system?

Please take a look at step 4 in this help article:

https://support.kobotoolbox.org/external_file.html

kelvinaeb · November 25, 2024, 8:04am

Hi @hakan_cetinkaya

Thanks for reaching out.

Yes, I uploaded the .csv file to the system via the media. But I am still getting the same error message.

hakan_cetinkaya · November 25, 2024, 8:23am

@kelvinaeb,

Can you show the variable names of your csv file?

Kal_Lam · November 25, 2024, 11:28am

@kelvinaeb, seems like there is a typo in the CSV filename you have specified:

KCDataSource2.csv used in the XLSForm vs. KCDataSource.csv seen in the error message.

So please check out the CSV file name properly and that should solve your issue.

kelvinaeb · November 25, 2024, 11:38am

Hi @Kal_Lam,

Thanks for your reply.

I have 2 csv files uploaded and only one (KCDataSource2.csv) is working. the second csv file (KCDataSource.csv) is what is bringing the error.

Here is the upload done in the settings.

Thank you

Kal_Lam · November 25, 2024, 11:43am

@kelvinaeb, if that is the case, where have you used the CSV file KCDataSource.csv within the XLSForm then?

kelvinaeb · November 25, 2024, 11:46am

It’s on the xlsform I shared above.

I used the KCDataSource.csv on a pulldata function (calculation).

Thank you

Kal_Lam · November 26, 2024, 8:49am

@kelvinaeb, would you mind sharing your KCDataSource CSV file so that we could see if it supports the format it should be in? You could remove all your information from there and just keep some dummy values when sharing the CSV file.