Howdy, Stranger!

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

Supported by

Can't convert Jatos data to xlsx

I can't seem to be able to convert Jatos data to xlsx. I export the data from Jatos (on Mac it exports as TextEdit document) but when I click Convert Jatos Data, I cannot select the file at all, so I cannot convert it. What might be wrong?

Comments

  • 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?

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

    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.

  • 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.

  • What am i missing?

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

  • 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
    
  • 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?

    Buy Me A Coffee

Sign In or Register to comment.

agen judi bola , sportbook, casino, togel, number game, singapore, tangkas, basket, slot, poker, dominoqq, agen bola. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 50.000 ,- bonus cashback hingga 10% , diskon togel hingga 66% bisa bermain di android dan IOS kapanpun dan dimana pun. poker , bandarq , aduq, domino qq , dominobet. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 10.000 ,- bonus turnover 0.5% dan bonus referral 20%. Bonus - bonus yang dihadirkan bisa terbilang cukup tinggi dan memuaskan, anda hanya perlu memasang pada situs yang memberikan bursa pasaran terbaik yaitu http://45.77.173.118/ Bola168. Situs penyedia segala jenis permainan poker online kini semakin banyak ditemukan di Internet, salah satunya TahunQQ merupakan situs Agen Judi Domino66 Dan BandarQ Terpercaya yang mampu memberikan banyak provit bagi bettornya. Permainan Yang Di Sediakan Dewi365 Juga sangat banyak Dan menarik dan Peluang untuk memenangkan Taruhan Judi online ini juga sangat mudah . Mainkan Segera Taruhan Sportbook anda bersama Agen Judi Bola Bersama Dewi365 Kemenangan Anda Berapa pun akan Terbayarkan. Tersedia 9 macam permainan seru yang bisa kamu mainkan hanya di dalam 1 ID saja. Permainan seru yang tersedia seperti Poker, Domino QQ Dan juga BandarQ Online. Semuanya tersedia lengkap hanya di ABGQQ. Situs ABGQQ sangat mudah dimenangkan, kamu juga akan mendapatkan mega bonus dan setiap pemain berhak mendapatkan cashback mingguan. ABGQQ juga telah diakui sebagai Bandar Domino Online yang menjamin sistem FAIR PLAY disetiap permainan yang bisa dimainkan dengan deposit minimal hanya Rp.25.000. DEWI365 adalah Bandar Judi Bola Terpercaya & resmi dan terpercaya di indonesia. Situs judi bola ini menyediakan fasilitas bagi anda untuk dapat bermain memainkan permainan judi bola. Didalam situs ini memiliki berbagai permainan taruhan bola terlengkap seperti Sbobet, yang membuat DEWI365 menjadi situs judi bola terbaik dan terpercaya di Indonesia. Tentunya sebagai situs yang bertugas sebagai Bandar Poker Online pastinya akan berusaha untuk menjaga semua informasi dan keamanan yang terdapat di POKERQQ13. Kotakqq adalah situs Judi Poker Online Terpercayayang menyediakan 9 jenis permainan sakong online, dominoqq, domino99, bandarq, bandar ceme, aduq, poker online, bandar poker, balak66, perang baccarat, dan capsa susun. Dengan minimal deposit withdraw 15.000 Anda sudah bisa memainkan semua permaina pkv games di situs kami. Jackpot besar,Win rate tinggi, Fair play, PKV Games