Parsing error by using form component

Builder
1

OS : MacOS Ventura 13.2.1
PsychoPy version : v2022.2.5

Hello everyone,
I have a problem with the form component.
I have integrated a routine with form component into my flow and first worked with a paceholder text. Everything worked perfectly. But when I copied my correct questions and answers one by one into the template of psychopy, I always get the following error code:

File "pandas/_libs/parsers.pyx", line 2042, in pandas._libs.parsers.raise_parser_error
pandas.errors.ParserError: Error tokenizing data. C error: Expected 5 fields in line 6, saw 8

################ Experiment ended with exit code 1 [pid:13438] #################

The file with the questions and answers is saved as .csv and everything remains the same, only the text changes. Sometimes the error code only occurs after 7 inserted questions and sometimes after 4. Does anyone know how I can fix the cause?

Here are some examples of the questions I wanted to insert:

Bildschirm­foto 2023-03-03 um 10.16.20
Bildschirm­foto 2023-03-03 um 10.16.202136×254 77.8 KB

Thank you in advance :slight_smile:

2

Hello,

Were you able to correct this error? I am having the same issue now… Thank you!

Best

3

That sounds like your spreadsheet has blank columns (and/or rows).

4

Thank you @wakecarter for the quick response. I am indeed not sure how to fill the spreadsheet for the form component. Should I open a new discussion topic or may I share with you my spreadsheet here? I tried with only 1 row for the heading and psychopy was also not able to read that properly. I downloaded the template that you can get from the “Open/Create in your default table editor” but I am not able to make it work. I am running it in Psychopy version 2022.2.4. Is there a compatibility issue?

Thanks!

5

You could upload your csv file here and I can try to fix it. 2022.2.4 is quite old now, but forms hasn’t seen and development recently, so that shouldn’t be an issue.

6

Thank you. Here is the file I want to attach to the form component

questionnaire1_final.xlsx (87.5 KB)