Can't find file.csv

Please kindly find below is error message I am getting we are trying to view a form that we have deployed, however, we keep getting the following message. We have a fiew more questions to upload that require files thus needing assistance as we may be missing something.
Ø File has been uploaded from the local machine where we are working on the form.
Ø Sequence: Upload the file to “Media” via settings, then deploy form.
Ø Add a question using “Select one from file”.

Appreciate your help.

Are you able to upload your form file and associated data file? That will greatly assist in determining the issue.

FWIW, your data filename and the name you use in your form for the select question must match. See Form Datasets - ODK Docs for an example.

Also, if you modify the data file or form then you will have to Redeploy to keep everything in sync.

1 Like

Hello, yes, we are able to upload the file. We we were able to upload and see the file in another form. Not sure what is happening with this one.

For the deployment, yes, re-deployed after the file was added.

Actually, I meant upload your form and data file here, so we can take a look at it :slightly_smiling_face:

1 Like

aZ2BfR2ukQuHLLPt6ZRWrJ.xlsx (22.6 KB)
Please find herewith.

llgs.csv (4.5 KB)
The data file herewith.

Your form appears to have a few errors:

I also note that your select_one_from_file references 'LLGs.csv", whereas your data file above is “llgs.csv”.

In most situations filenames are case-sensistive. Can you fix these are try again.

1 Like

Thank you for checking. Changes applied. Find attached is the updated Excel file.
aZ2BfR2ukQuHLLPt6ZRWrJ (1).xlsx (22.4 KB)

aZ2BfR2ukQuHLLPt6ZRWrJ (2).xlsx (22.4 KB)
llgs.csv (4.5 KB)
This is the form from the most recent updates done, including the media that is currently being used.

Your csv file is malformed.

You have trailing comma on the end of each line. This will be interpreted as a blank/empty last field, which will cause an error.

name,label,district_filter,
llg01,Abau,Amazon Bay Rural,
llg02,Abau,Aroma Rural,
llg03,Abau,Cloudy Bay Rural,
llg04,Goilala,Guari Rural,
llg05,Goilala,Tapini Rural,
llg06,Goilala,Woitape Rural,

You also have a very large number of basically empty lines, with a malformed entry at the end:

,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,Wakunai
,AROB,Central Bougainville,

If you correct your data file I expect your form will work.

1 Like

Thank you for the checks and the update. We will check and keep you informed.

We have attached a ward.csv file as well. However, it does not display anything when the LLG is selected, as the ward depends on it.

Your assistance is appreciated.

aped5LcWpryQaM7u5QZjVZ.xlsx (19.4 KB)