Can't convert Jatos data to xlsx

Comments

• kri

  March 2020

  JATOS doesn't impose any format for its result data apart from that it has to be text (so no binary - but for this one can use result files). That on your Mac it is shown as an TextEdit document just means that the default application on your computer for text files seem to be TextEdit.

  xlsx on the other side is MS Excel's file format. I'm not sure what you mean with "click Convert". I can just guess that it is a feature provided by MacOS (I'm not using MacOS myself). This can only work if the format of your JATOS data file are in a way that the "Convert" feature can parse and transform. I guess this is not the case. How does the text of your result data file look like if you open it?
• sebastiaan

  March 2020

  For data collected with OSWeb, you can use the OSWeb extension in OpenSesame to convert the JATOS data to .xlsx as described here:

  • https://osdoc.cogsci.nl/3.3/manual/osweb/#downloading-and-converting-data

  If this doesn't work you, could you describe in more detail why this doesn't work for you? Where does it go wrong?

  PS. As Kristian says, JATOS itself doesn't have a specific format. So this conversion tool only works for OSWeb data, not for data collected with JATOS through some other tool, such as jsPsych.

  
  
  Check out SigmundAI.eu for our OpenSesame AI assistant!
  
• esraoguz

  March 2020 edited March 2020

  Hi everyone,

  When I try to convert the txt formatted file to xlsx on osweb I keep receiving those sort of errors:

  Error message:

  Traceback (most recent call last):
   File "C:\Program Files (x86)\OpenSesame\share\opensesame_extensions\oswebext\oswebext_widget.py", line 187, in _convert_results  io.writexlsx(dm, export_path)
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\datamatrix\io\_excel.py", line 127, in writexlsx  wb.save(path)
  

  What am i missing?

  Best,

  Esra.
• sebastiaan

  March 2020

  What am i missing?

  The actual error message ;-) This only the top part of the error message (Traceback). Could you post all of it?

  
  
  Check out SigmundAI.eu for our OpenSesame AI assistant!
  
• esraoguz

  March 2020 edited March 2020

  :)) Yes sure, just did not want to invade the whole page with the error message :))

  Error message:

  
  

  Traceback (most recent call last):
   File "C:\Program Files (x86)\OpenSesame\share\opensesame_extensions\oswebext\oswebext_widget.py", line 187, in _convert_results
    io.writexlsx(dm, export_path)
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\datamatrix\io\_excel.py", line 127, in writexlsx
    wb.save(path)
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\openpyxl\workbook\workbook.py", line 349, in save
    save_workbook(self, filename)
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\openpyxl\writer\excel.py", line 269, in save_workbook
    writer.save(filename)
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\openpyxl\writer\excel.py", line 251, in save
    self.write_data()
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\openpyxl\writer\excel.py", line 82, in write_data
    self._write_worksheets()
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\openpyxl\writer\excel.py", line 200, in _write_worksheets
    xml = ws._write()
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\openpyxl\worksheet\worksheet.py", line 870, in _write
    return write_worksheet(self)
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\openpyxl\writer\worksheet.py", line 166, in write_worksheet
    xf.write(tables.to_tree())
   File "C:\Program Files (x86)\OpenSesame\lib\contextlib.py", line 24, in __exit__
    self.gen.next()
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\et_xmlfile\xmlfile.py", line 50, in element
    self._write_element(el)
   File "C:\Program Files (x86)\OpenSesame\lib\site-packages\et_xmlfile\xmlfile.py", line 77, in _write_element
    xml = tostring(element)
   File "C:\Program Files (x86)\OpenSesame\lib\xml\etree\ElementTree.py", line 1126, in tostring
    ElementTree(element).write(file, encoding, method=method)
   File "C:\Program Files (x86)\OpenSesame\lib\xml\etree\ElementTree.py", line 820, in write
    serialize(write, self._root, encoding, qnames, namespaces)
   File "C:\Program Files (x86)\OpenSesame\lib\xml\etree\ElementTree.py", line 939, in _serialize_xml
    _serialize_xml(write, e, encoding, qnames, None)
   File "C:\Program Files (x86)\OpenSesame\lib\xml\etree\ElementTree.py", line 939, in _serialize_xml
    _serialize_xml(write, e, encoding, qnames, None)
   File "C:\Program Files (x86)\OpenSesame\lib\xml\etree\ElementTree.py", line 939, in _serialize_xml
    _serialize_xml(write, e, encoding, qnames, None)
   File "C:\Program Files (x86)\OpenSesame\lib\xml\etree\ElementTree.py", line 939, in _serialize_xml
    _serialize_xml(write, e, encoding, qnames, None)
   File "C:\Program Files (x86)\OpenSesame\lib\xml\etree\ElementTree.py", line 940, in _serialize_xml
    write("</" + tag + ">")
  MemoryError
  
• Daniel

  March 2020

  It looks like your dataset it too large for the amount of memory that your computer can address. Can you try performing this operation on a computer with more memory and see if the problem persists?