I am currently experiencing a bit of a excel file bug. I have nested loops such that the outer loop refers to an excel file containing the names of the inner loop excel files. (Images shown)
I have sounds playing and i read that having a parameters column called sound is not great so i changed it to soundfile, this does not update onto the inner nested excel file, but when running the task locally it works.
The reason this is of concern is because i am then pushing it to online and the repository has the wrong parameter name, therefore also not updating from the local excel file. (the directories in the this image are for the local task only, the online task has directories to the repository and with the forward slashes instead of backslashes)
Sorry, i used the wrong terminology, i meant parameters are loaded in wrong. In the last image its the title of the parameter which is different than the parameter which is loaded via the loop
An addition to wakecarter’s tip. You use an absolute path to your sound files, e.g. C:\User\rd0042\OneDrive - University of Surrey\Documents\Scene_object_task. However, if you are running the experiment online, you will need a path relative to the folder where your experiment is stored, e.g. stimuli/soundfile1.mp3. where stimuli is a folder in the folder where the *.psyexp, *.html, *.js and your Excel files are stored. The folder C:\User\rd0042\OneDrive - University of Surrey\Documents\Scene_object_task will not exist on the server.
Have you added the sound files as online resources?
Yes I have separate excel files for the online task since it requires mp3 instead of wav and a different directory.
I think what @wakecarter suggested worked, but what confuses me is how the sounds still played even though the name of the column was wrong on the local task. I expected an error saying sound_3 not defined.
I checked all my condition files and found out one was still sound instead of soundfile on the online repository so that was where the error for that was but still confused about the local task.
note: i created two different versions of the same task, duplicated the builder file and renamed it and put in a different location in file explorer, so that my task could work locally as well as online.
Great that you found a solution. One way to avoid this error is to use a single Excel file instead of multiple Excel files. With only one condition file, you use only selected rows instead of the whole file. Next time
I might have to start doing that since the excel files are quickly becoming too much as we are doing4 sessions of the task and each has 4 blocks of 30 trials
