Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Supported by
Bestel Een wereld vol denkers door Sebastiaan Mathôt via bol.com

[open] Pasting to loop variable table / variable wizard

floflo
edited November 2015 in OpenSesame

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

Comments

  • floflo
    edited December 2015

    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
  • eduardeduard
    edited 6:02PM

    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

    Buy Me A Coffee

  • floflo
    edited 6:02PM

    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
  • kskksk
    edited January 2017

    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

  • kskksk

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

Sign In or Register to comment.
Sebastiaan Mathôt » v2.0.18 » Copyright 2011 — 2019 » Vanilla flavored » License