{"action":"created","issue":{"url":"https://api.github.com/repos/chfw/pyexcel-ods/issues/3","labels_url":"https://api.github.com/repos/chfw/pyexcel-ods/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/chfw/pyexcel-ods/issues/3/comments","events_url":"https://api.github.com/repos/chfw/pyexcel-ods/issues/3/events","html_url":"https://github.com/chfw/pyexcel-ods/issues/3","id":104615762,"number":3,"title":"ValueError: invalid literal for int() ...","user":{"login":"joaoe","id":461983,"avatar_url":"https://avatars.githubusercontent.com/u/461983?v=3","gravatar_id":"","url":"https://api.github.com/users/joaoe","html_url":"https://github.com/joaoe","followers_url":"https://api.github.com/users/joaoe/followers","following_url":"https://api.github.com/users/joaoe/following{/other_user}","gists_url":"https://api.github.com/users/joaoe/gists{/gist_id}","starred_url":"https://api.github.com/users/joaoe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joaoe/subscriptions","organizations_url":"https://api.github.com/users/joaoe/orgs","repos_url":"https://api.github.com/users/joaoe/repos","events_url":"https://api.github.com/users/joaoe/events{/privacy}","received_events_url":"https://api.github.com/users/joaoe/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-09-03T03:39:05Z","updated_at":"2015-09-09T23:05:18Z","closed_at":"2015-09-08T22:35:56Z","body":"Howdy.\r\nI have an ODS file in which there is a column with a custom date/time format (yyyy-mm-dd hh:mm). The file was generated by libreoffice.\r\nThe xml for a cell in that column is\r\n`<table:table-cell table:style-name=\"ce4\" office:value-type=\"date\" office:date-value=\"2015-08-17T19:20:00\" calcext:value-type=\"date\"><text:p>2015-08-17 19:20</text:p></table:table-cell>`\r\n\r\nSo, when loading that file, I get the error\r\n`File \"/usr/local/lib/python2.7/dist-packages/pyexcel_ods/__init__.py\", line 56, in date_value\r\n    day = int(tokens[2])\r\nValueError: invalid literal for int() with base 10: '17T19:10:00'`\r\nbecause the code is expecting the data to be in the format yyyy-mm-dd.\r\n\r\nThe safest bet would be to always use `dateutil.parser.parse(value)` which handles the iso format.\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/chfw/pyexcel-ods/issues/comments/139068237","html_url":"https://github.com/chfw/pyexcel-ods/issues/3#issuecomment-139068237","issue_url":"https://api.github.com/repos/chfw/pyexcel-ods/issues/3","id":139068237,"user":{"login":"chfw","id":4280312,"avatar_url":"https://avatars.githubusercontent.com/u/4280312?v=3","gravatar_id":"","url":"https://api.github.com/users/chfw","html_url":"https://github.com/chfw","followers_url":"https://api.github.com/users/chfw/followers","following_url":"https://api.github.com/users/chfw/following{/other_user}","gists_url":"https://api.github.com/users/chfw/gists{/gist_id}","starred_url":"https://api.github.com/users/chfw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chfw/subscriptions","organizations_url":"https://api.github.com/users/chfw/orgs","repos_url":"https://api.github.com/users/chfw/repos","events_url":"https://api.github.com/users/chfw/events{/privacy}","received_events_url":"https://api.github.com/users/chfw/received_events","type":"User","site_admin":false},"created_at":"2015-09-09T23:05:18Z","updated_at":"2015-09-09T23:05:18Z","body":"Before I publish it to pypi, could you help verify it? Here is the command:\r\n\r\n    pip install git+https://github.com/chfw/pyexcel-ods.git"}}