[open] Pasting to loop variable table / variable wizard

flo

Hi,

when working through the step-by-step tutorial, I saw this tip:

Tip – You can prepare your variable list in your favorite spreadsheet program and copy-paste it into the loop variable table. In this case, you first need to set ‘Cycles’ to the correct number of trials.

This seems extremely useful and I just tried it but can't get it to work. I re-used some R code I wrote a while back and exported my "experimental design" as a CSV file. It has 4 columns with variables and 58 rows. Each row is one trial and the four variables dictate the action on screen and include the correct_response.

I can't seem to paste this information into the loop item, though. I have set the number of cycles to 58 but when I copy the appropriate column in Excel (excl. the variable name) and then try to paste the values, they all end up in a single cell.

The whole thing ends up looking like this:

Am I missing something obvious here?

Note: I am using OpenSesame 2.9.6 on Mac OS Yosemite.

Thanks!

• Florian

flo

Update: I worked around the issue by writing some code that generates a text file that has the appropriate format. Something like this:

setcycle 0 x_target "-128"
setcycle 0 target_pos "2"
setcycle 0 cresponse "6"
setcycle 0 sequence "NA"
setcycle 1 x_target "384"
setcycle 1 target_pos "4"
setcycle 1 cresponse "8"
setcycle 1 sequence "NA"
setcycle 2 x_target "-384"
setcycle 2 target_pos "1"
setcycle 2 cresponse "5"
setcycle 2 sequence "NA"
setcycle 3 x_target "128"
setcycle 3 target_pos "3"
...
setcycle 56 sequence "NA"
setcycle 57 x_target "384"
setcycle 57 target_pos "4"
setcycle 57 cresponse "8"
setcycle 57 sequence "NA"

So now I can copy-paste the content of this text file into the Script View of the loop item and the variables will be created accordingly.

This works but it'd obviously be nicer if I could just copy-paste from my "favorite spreadsheet program" as suggested in the tutorial.

• Florian

eduard

Hi Florian,

Not sure whether you are missing anything here. Unfortunately, I can't reproduce this unwanted behaviour (actually quite fortunate for me...). But I'm also not working on a Mac. Maybe there is someone else who can confirm that this is really an issue? If so, you can file an issue on OpenSesames github page.

Sorry,

Eduard

flo

Hi Eduard,

thanks for trying, though! I don't have access to a Windows computer at the moment so I can't test whether I'd have the same issue there.

Does anyone else have similar problems?

• Florian

ksk

Hi! The same problem here, also on Mac. Mac OS X Yosemite, OpenSesame v3.1, MS Excel 2016. It's very frustrating. I have tried to save my variable list as .xlsx, .xls, .csv, .txt and nothing worked. Thanks for looking into that. Kasia

ksk

Hi! I have resolved this issue by saving my file as "Windows Comma Separated". Hope it helps!