Select Choices from an External File don't work

[evariste]

Hi everyone,

I implemented the survey() and pulldata() function in my form (mysurvey.xlsx) using an external file (surveyfile.csv)
however when I start my form (my survey) i have an error:

<label>node for itemset doesn't exist! [instance(surveyfile)/root/item/label]

I have looked at the other posts regarding this error on the forum and trying the solutions but this error on my form still persists.
how to correct this?
mysurvey.xlsx (10.2 KB)
surveyfile.csv (538 Bytes)

Thanks in advance.

Excuse my english.
Best Regards.

[Kal_Lam]

Welcome back to the community, @evariste! This is the issue (file format) I see in your CSV file:

Maybe this post discussed previously should help you fix the CSV file format:

Pulldata is not working on KoboCollect (Android)

@Victorpaisano25, you should be able to achieve the desired format by following the instructions as outlined in the steps shared below: Step 1: Open the CSV file. You should see your CSV file in the following structure: [Image 1] Step 2: Select the column that contains the data. [Image 2] Step 3: Select Text to Columns data tool from the Data Tab. [Image 3] Step 4: By default, you will see Delimited being selected. Now press Next. [Image 4] Step 5: Select Semicolon and press Nex…

[Mohmad_almAD]

How can data be aligned after extracting it from a CSV file?

[Mohmad_almAD]

How can data be aligned after extracting it from a CSV file?