How to use Form Components, I use form and meet a problem

Builder
1

ValueError: Item -12349872349873in items file ‘Items.xlsx’ is missing a required value for its response type. Permitted types are {‘free text’, ‘choice’, ‘slider’, ‘description’, ‘rating’, ‘radio’, ‘heading’}.

please help me

1 Like
2

I just had the same problem and found the answer - my form was correct, but I saved it in .csv (MD-DOS) rather than .csv (UTF-8)…

3

How does it work in detail

4

For forms I think you need to use csv files, not xlsx

5

thank you

6

I’m using a MacBook and encountering the same issue when uploading an .xlsx file. I’ve tried to save the file as several types of .csv files (MS-DOS, UTF-8, and the Macintosh type) and none of them seem to work either. Instead, the following error message comes up:

UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xd5 in position 396: invalid continuation byte

Is this a problem with my computer?

Thanks in advance!

7

For forms I think you need to use csv files, not xlsx

8

Maybe you run into the same error as me:

tldr:

  • use the csv file format
  • save csv with commas as delimiter (under some circumstances a semicolon will be used)

To achieve the last one: use libreoffice or some other application. Excel will mess with your files and change the delimiter without you noticing.

9

I’ve tried using libreoffice to change it to a csv file but unfortunately I now get a different error message…

UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xd5 in position 396: invalid continuation byte

I think it may be a MacBook issue. I will try to use a windows computer and see if I run into the same issue. Thanks for your advice!

10

If you upload your xlsx file here, I’m sure someone would be happy to convert it to a plain CSV.

11

Apple should not be the problem here.
PsychoPy needs UTF-8 Unicode encoded files but you’re feeding it some other character set. This is an easy fix, though:

  1. Save the file with libreoffice in the csv format

    image
    image908×615 24.3 KB

  2. Change the character set (Zeichensatz) to Unicode UTF-8 and the delimiter (Feldtrenner) to a comma
    image

12

I have a similar problem, do you think it’s also due to a mistake in csv? I used to template form in Excel and then converted it to csv but I have Error message:
logging.error(msg)
UnboundLocalError: local variable ‘msg’ referenced before assignment
################# Experiment ended with exit code 1 [pid:9952] #################

13

Here are some suggestions about that error.

14

Here’s the solution using Excel:

File → Options → Advanced

Uncheck “Use system operators”

Set “Decimal separator” to .
Set “Thousands separator” to ,

Save as CSV UTF-8 to make sure.

15

I’m encountering this error, 6 months later. Happens regardless of .csv or .xlsx. Any tips?

Error:
UnboundLocalError: local variable ‘msg’ referenced before assignment

I’m running an extremely simple test file, and nothing seems to be working.

EDIT: I was able to get past this error by eliminating quotes around the type entry, in this case ‘choice’ → choice. However, the radio are now giving me strange behavior: a click in one radio button displays a selection dot to the right. I’m giving up for now and will use Qualtrics. A sad day.

16

I recommend checking this: