{"action":"closed","issue":{"url":"https://api.github.com/repos/QutBioacoustics/baw-server/issues/227","labels_url":"https://api.github.com/repos/QutBioacoustics/baw-server/issues/227/labels{/name}","comments_url":"https://api.github.com/repos/QutBioacoustics/baw-server/issues/227/comments","events_url":"https://api.github.com/repos/QutBioacoustics/baw-server/issues/227/events","html_url":"https://github.com/QutBioacoustics/baw-server/issues/227","id":94867466,"number":227,"title":"Annotation export issues","user":{"login":"atruskie","id":1452968,"avatar_url":"https://avatars.githubusercontent.com/u/1452968?v=3","gravatar_id":"","url":"https://api.github.com/users/atruskie","html_url":"https://github.com/atruskie","followers_url":"https://api.github.com/users/atruskie/followers","following_url":"https://api.github.com/users/atruskie/following{/other_user}","gists_url":"https://api.github.com/users/atruskie/gists{/gist_id}","starred_url":"https://api.github.com/users/atruskie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/atruskie/subscriptions","organizations_url":"https://api.github.com/users/atruskie/orgs","repos_url":"https://api.github.com/users/atruskie/repos","events_url":"https://api.github.com/users/atruskie/events{/privacy}","received_events_url":"https://api.github.com/users/atruskie/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/QutBioacoustics/baw-server/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/QutBioacoustics/baw-server/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/QutBioacoustics/baw-server/labels/triage:low","name":"triage:low","color":"9C7600"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-07-14T04:49:11Z","updated_at":"2015-07-31T02:02:55Z","closed_at":"2015-07-31T02:02:55Z","body":"\r\n- Inconsistent naming for fields: `created_at_date_utc`,\t `created_at_time_utc`, \t`event_created_at_datetime_utc`\r\n- For all `*_time_utc` columns, Excel is inconsistently parsing the value due to the fractional seconds component. Strip fractional seconds from these columns\r\n- For all `*_datetime_utc` columns use ISO8601 format (particularly the `T`) separator. This will prevent excel from trying to parse the date at all (provides visual sanity if all else fails, also easily parseable)\r\n- _discuss_: why is there no audio recording started date?\r\n\r\n\r\n\r\n"}}