{"url":"https://api.github.com/repos/open-cogsci/opensesame-extension-osweb/issues/17","repository_url":"https://api.github.com/repos/open-cogsci/opensesame-extension-osweb","labels_url":"https://api.github.com/repos/open-cogsci/opensesame-extension-osweb/issues/17/labels{/name}","comments_url":"https://api.github.com/repos/open-cogsci/opensesame-extension-osweb/issues/17/comments","events_url":"https://api.github.com/repos/open-cogsci/opensesame-extension-osweb/issues/17/events","html_url":"https://github.com/open-cogsci/opensesame-extension-osweb/issues/17","id":608871089,"node_id":"MDU6SXNzdWU2MDg4NzEwODk=","number":17,"title":"Character encoding issues when converting JATOS results","user":{"login":"smathot","id":594936,"node_id":"MDQ6VXNlcjU5NDkzNg==","avatar_url":"https://avatars.githubusercontent.com/u/594936?v=4","gravatar_id":"","url":"https://api.github.com/users/smathot","html_url":"https://github.com/smathot","followers_url":"https://api.github.com/users/smathot/followers","following_url":"https://api.github.com/users/smathot/following{/other_user}","gists_url":"https://api.github.com/users/smathot/gists{/gist_id}","starred_url":"https://api.github.com/users/smathot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smathot/subscriptions","organizations_url":"https://api.github.com/users/smathot/orgs","repos_url":"https://api.github.com/users/smathot/repos","events_url":"https://api.github.com/users/smathot/events{/privacy}","received_events_url":"https://api.github.com/users/smathot/received_events","type":"User","user_view_type":"public","site_admin":false},"labels":[{"id":1028925541,"node_id":"MDU6TGFiZWwxMDI4OTI1NTQx","url":"https://api.github.com/repos/open-cogsci/opensesame-extension-osweb/labels/bug","name":"bug","color":"d73a4a","default":true,"description":"Something isn't working"}],"state":"closed","locked":false,"assignees":[{"login":"smathot","id":594936,"node_id":"MDQ6VXNlcjU5NDkzNg==","avatar_url":"https://avatars.githubusercontent.com/u/594936?v=4","gravatar_id":"","url":"https://api.github.com/users/smathot","html_url":"https://github.com/smathot","followers_url":"https://api.github.com/users/smathot/followers","following_url":"https://api.github.com/users/smathot/following{/other_user}","gists_url":"https://api.github.com/users/smathot/gists{/gist_id}","starred_url":"https://api.github.com/users/smathot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smathot/subscriptions","organizations_url":"https://api.github.com/users/smathot/orgs","repos_url":"https://api.github.com/users/smathot/repos","events_url":"https://api.github.com/users/smathot/events{/privacy}","received_events_url":"https://api.github.com/users/smathot/received_events","type":"User","user_view_type":"public","site_admin":false}],"milestone":null,"comments":8,"created_at":"2020-04-29T08:25:49Z","updated_at":"2020-04-30T13:52:46Z","closed_at":"2020-04-30T13:52:46Z","assignee":{"login":"smathot","id":594936,"node_id":"MDQ6VXNlcjU5NDkzNg==","avatar_url":"https://avatars.githubusercontent.com/u/594936?v=4","gravatar_id":"","url":"https://api.github.com/users/smathot","html_url":"https://github.com/smathot","followers_url":"https://api.github.com/users/smathot/followers","following_url":"https://api.github.com/users/smathot/following{/other_user}","gists_url":"https://api.github.com/users/smathot/gists{/gist_id}","starred_url":"https://api.github.com/users/smathot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smathot/subscriptions","organizations_url":"https://api.github.com/users/smathot/orgs","repos_url":"https://api.github.com/users/smathot/repos","events_url":"https://api.github.com/users/smathot/events{/privacy}","received_events_url":"https://api.github.com/users/smathot/received_events","type":"User","user_view_type":"public","site_admin":false},"author_association":"COLLABORATOR","issue_field_values":[],"type":null,"active_lock_reason":null,"sub_issues_summary":{"total":0,"completed":0,"percent_completed":0},"issue_dependencies_summary":{"blocked_by":0,"total_blocked_by":0,"blocking":0,"total_blocking":0},"body":"The first issue occurs when writing an `.xlsx` file, and should probably be fixed in smathot/python-datamatrix. The second issue seems to be a decoding issue that occurs on Python 3 on Windows.\r\n\r\n\r\n```\r\nTraceback (most recent call last):\r\n  File \"/Applications/OpenSesame.app/Contents/Resources/share/opensesame_extensions/oswebext/oswebext_widget.py\", line 187, in _convert_results\r\n    io.writexlsx(dm, export_path)\r\n  File \"/Applications/OpenSesame.app/Contents/Resources/lib/python3.7/site-packages/datamatrix/io/_excel.py\", line 114, in writexlsx\r\n    ws[utils.get_column_letter(colnr+1)+str(rownr+2)] = value\r\n  File \"/Applications/OpenSesame.app/Contents/Resources/lib/python3.7/site-packages/openpyxl/worksheet/worksheet.py\", line 309, in __setitem__\r\n    self[key].value = value\r\n  File \"/Applications/OpenSesame.app/Contents/Resources/lib/python3.7/site-packages/openpyxl/cell/cell.py\", line 216, in value\r\n    self._bind_value(value)\r\n  File \"/Applications/OpenSesame.app/Contents/Resources/lib/python3.7/site-packages/openpyxl/cell/cell.py\", line 192, in _bind_value\r\n    value = self.check_string(value)\r\n  File \"/Applications/OpenSesame.app/Contents/Resources/lib/python3.7/site-packages/openpyxl/cell/cell.py\", line 159, in check_string\r\n    raise IllegalCharacterError\r\nopenpyxl.utils.exceptions.IllegalCharacterError\r\n```\r\n\r\nAnd (Python 3):\r\n\r\n```\r\nTraceback (most recent call last):\r\n  File \"C:\\Program Files (x86)\\OpenSesame\\share\\opensesame_extensions\\oswebext\\oswebext_widget.py\", line 174, in _convert_results\r\n    dm = data.parse_jatos_results(jatos_results_path)\r\n  File \"C:\\Program Files (x86)\\OpenSesame\\Lib\\site-packages\\osweb\\data.py\", line 40, in parse_jatos_results\r\n    for line in fd:\r\n  File \"C:\\Program Files (x86)\\OpenSesame\\lib\\encodings\\cp1252.py\", line 23, in decode\r\n    return codecs.charmap_decode(input,self.errors,decoding_table)[0]\r\nUnicodeDecodeError: 'charmap' codec can't decode byte 0x90 in position 358: character maps to <undefined>\r\n```","closed_by":{"login":"smathot","id":594936,"node_id":"MDQ6VXNlcjU5NDkzNg==","avatar_url":"https://avatars.githubusercontent.com/u/594936?v=4","gravatar_id":"","url":"https://api.github.com/users/smathot","html_url":"https://github.com/smathot","followers_url":"https://api.github.com/users/smathot/followers","following_url":"https://api.github.com/users/smathot/following{/other_user}","gists_url":"https://api.github.com/users/smathot/gists{/gist_id}","starred_url":"https://api.github.com/users/smathot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smathot/subscriptions","organizations_url":"https://api.github.com/users/smathot/orgs","repos_url":"https://api.github.com/users/smathot/repos","events_url":"https://api.github.com/users/smathot/events{/privacy}","received_events_url":"https://api.github.com/users/smathot/received_events","type":"User","user_view_type":"public","site_admin":false},"reactions":{"url":"https://api.github.com/repos/open-cogsci/opensesame-extension-osweb/issues/17/reactions","total_count":0,"+1":0,"-1":0,"laugh":0,"hooray":0,"confused":0,"heart":0,"rocket":0,"eyes":0},"timeline_url":"https://api.github.com/repos/open-cogsci/opensesame-extension-osweb/issues/17/timeline","performed_via_github_app":null,"state_reason":"completed","pinned_comment":null}