Reply To: Creating a .csv file that can be read in PCIbex Farm

PennController for IBEX Forums Support Creating a .csv file that can be read in PCIbex Farm Reply To: Creating a .csv file that can be read in PCIbex Farm

#6823
Jeremy
Keymaster

I think what happened is that the stylized double-quote characters were not properly handled by Excel and/or TextEdit, which would cause the exported CSV file to be unreadable once uploaded onto the PCIbex Farm.

You should replace those characters (both the opening and the closing ones) with ": that expression will be rendered as a double-quote character by the browser running the experiment

I just tested it and it worked: I couldn’t directly open the file items1.csv in the PCIbex Farm editor (just like you reported) so I downloaded it (checked the box to the left of its filename, then clicked the “download” icon) then opened it in a text editor, replaced all occurrences of the character � (which had replaced the stylized quotes) with " and re-uploaded it back to the project. The experiment then ran smoothly, and I was able to open the file directly in the project’s editor

Jeremy

  • This reply was modified 3 years ago by Jeremy.