URL of experiment: none yet Description of the problem: Dear code wizards, I am trying to upload an experiment to Pavlovia that I have partly created in PsychoPy builder, but that includes some code components. I have amended some of my code according to the Wake crib sheet, but I am stuck on one…

OKAY, I may have found a solution, although in a bit of a roundabout way. I’m very curious though what the problem was. What ended up working: In builder, I have created a loop that doesn’t do anything, but that references my excel file. This, apparently triggers the loading of my excel file, befo…

@Menno_van_Berkel , you can use the trialHandler to handle your csv import, in both Python and JS - see the link below [image] Read from xlsx in javascript Online experiments @pinar , you will not be able to import Python libraries in the JS code, so you will need a differe…

Thanks! I tried this but got the following error: Unfortunately we encountered the following error: when importing condition: conditions.xlsx when getting the value of resource: conditions.xlsx unknown resource This is strange because that file (spelled correctly) is in my resources, in my folde…

Ah yes I forgot to mention, you also need to add the conditions file as a resource. Go to Experiment Settings - online tab and use the “Additional Resources” box to add the spreadsheet (click the plus button). Now PsychoPy will recognise your conditions file defined in the code as a resource and sen…

One step closer, but I’m still getting the same error message. Here’s a screenshot of my online tab (the xlsx file is not named condition.xlsx. But I’ve referred to it in the past for simplicity’s sake) [Screenshot (18)]

@Menno_van_Berkel , in case you have not already, you need to replace the name of the conditions file in the code, e.g., trials = new TrialHandler({ psychoJS: psychoJS, nReps: 1, method: TrialHandler.Method.RANDOM, extraInfo: expInfo, originPath: undefined, trialList: 'court_size_stims_JS.x…

Yep, here’s a screenshot in case I’m missing something. [Screenshot (20)]

I have since looked at a number of similar queries, that are usually solved with a typo. I can assure you that there are no typos here (the file name is copied directly into the code). I have also tried to run the JS script locally from the psychopy builder (just to eliminate possible causes), and …

@Menno_van_Berkel , try moving that code from the “Before Experiment” tab to the “Begin Experiment” tab. If you look at the JS code you will see where the additional resources are imported, so you need the trialhandler code to appear after that code has imported the resources, then it should find th…

I actually had the same thought and I have since moved it to the begin experiment tab. Still no luck though.

Perhaps you need to refresh your browser cache to get the up to date code running. Still a good idea to open the JS file and make sure the code is in the right place. If no joy after this, if possible please share your project with me so I can take a look.

Replacing "import xlrd" to JS code - creating arrays from a csv

Online experiments

dvbridges January 28, 2021, 1:29pm 2

@Menno_van_Berkel , you can use the trialHandler to handle your csv import, in both Python and JS - see the link below

Topic		Replies	Views
Replacing importing functions in Python Online experiments	12	1952	June 6, 2020
XLRD on Pavlovia Online experiments importing , pavlovia	6	1284	November 26, 2020
How to import CSV data into an array using JS Online experiments	8	2225	January 27, 2021
Alternative to pandas for reading csv/excel files online Blog pavlovia	16	5444	June 12, 2020
How to store image file paths on Pavlovia Online experiments images , pavlovia	9	3548	November 10, 2019

Replacing "import xlrd" to JS code - creating arrays from a csv

Related topics