{"action":"created","issue":{"url":"https://api.github.com/repos/tbabej/testimportfinal/issues/938","repository_url":"https://api.github.com/repos/tbabej/testimportfinal","labels_url":"https://api.github.com/repos/tbabej/testimportfinal/issues/938/labels{/name}","comments_url":"https://api.github.com/repos/tbabej/testimportfinal/issues/938/comments","events_url":"https://api.github.com/repos/tbabej/testimportfinal/issues/938/events","html_url":"https://github.com/tbabej/testimportfinal/issues/938","id":294947066,"number":938,"title":"[TW-966] export does not include annotations","user":{"login":"tbabej","id":2123868,"avatar_url":"https://avatars2.githubusercontent.com/u/2123868?v=4","gravatar_id":"","url":"https://api.github.com/users/tbabej","html_url":"https://github.com/tbabej","followers_url":"https://api.github.com/users/tbabej/followers","following_url":"https://api.github.com/users/tbabej/following{/other_user}","gists_url":"https://api.github.com/users/tbabej/gists{/gist_id}","starred_url":"https://api.github.com/users/tbabej/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tbabej/subscriptions","organizations_url":"https://api.github.com/users/tbabej/orgs","repos_url":"https://api.github.com/users/tbabej/repos","events_url":"https://api.github.com/users/tbabej/events{/privacy}","received_events_url":"https://api.github.com/users/tbabej/received_events","type":"User","site_admin":false},"labels":[{"id":827746097,"url":"https://api.github.com/repos/tbabej/testimportfinal/labels/bug","name":"bug","color":"d73a4a","default":true},{"id":827752349,"url":"https://api.github.com/repos/tbabej/testimportfinal/labels/fixed","name":"fixed","color":"ededed","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/tbabej/testimportfinal/milestones/9","html_url":"https://github.com/tbabej/testimportfinal/milestone/9","labels_url":"https://api.github.com/repos/tbabej/testimportfinal/milestones/9/labels","id":3090412,"number":9,"title":"1.9.3","description":null,"creator":{"login":"tbabej","id":2123868,"avatar_url":"https://avatars2.githubusercontent.com/u/2123868?v=4","gravatar_id":"","url":"https://api.github.com/users/tbabej","html_url":"https://github.com/tbabej","followers_url":"https://api.github.com/users/tbabej/followers","following_url":"https://api.github.com/users/tbabej/following{/other_user}","gists_url":"https://api.github.com/users/tbabej/gists{/gist_id}","starred_url":"https://api.github.com/users/tbabej/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tbabej/subscriptions","organizations_url":"https://api.github.com/users/tbabej/orgs","repos_url":"https://api.github.com/users/tbabej/repos","events_url":"https://api.github.com/users/tbabej/events{/privacy}","received_events_url":"https://api.github.com/users/tbabej/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":7,"state":"open","created_at":"2018-02-05T17:26:47Z","updated_at":"2018-02-06T23:11:30Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2018-02-06T23:11:14Z","updated_at":"2018-02-06T23:12:16Z","closed_at":"2018-02-06T23:11:30Z","author_association":"OWNER","body":"_John Florian on 2009-07-28T20:02:45Z says:_ \n\n "},"comment":{"url":"https://api.github.com/repos/tbabej/testimportfinal/issues/comments/363597895","html_url":"https://github.com/tbabej/testimportfinal/issues/938#issuecomment-363597895","issue_url":"https://api.github.com/repos/tbabej/testimportfinal/issues/938","id":363597895,"user":{"login":"tbabej","id":2123868,"avatar_url":"https://avatars2.githubusercontent.com/u/2123868?v=4","gravatar_id":"","url":"https://api.github.com/users/tbabej","html_url":"https://github.com/tbabej","followers_url":"https://api.github.com/users/tbabej/followers","following_url":"https://api.github.com/users/tbabej/following{/other_user}","gists_url":"https://api.github.com/users/tbabej/gists{/gist_id}","starred_url":"https://api.github.com/users/tbabej/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tbabej/subscriptions","organizations_url":"https://api.github.com/users/tbabej/orgs","repos_url":"https://api.github.com/users/tbabej/repos","events_url":"https://api.github.com/users/tbabej/events{/privacy}","received_events_url":"https://api.github.com/users/tbabej/received_events","type":"User","site_admin":false},"created_at":"2018-02-06T23:12:16Z","updated_at":"2018-02-06T23:12:16Z","author_association":"OWNER","body":"_John Florian on 2009-08-14T06:43:10Z says:_ \n\n The most common method that I've seen for exporting a 1:M relationship in a flat format is to repeat the 1 portion for each instance of the M portion.  So you'd have something like:\n\n\nid1,priority,project,...,description,anno_1\nid1,priority,project,...,description,anno_2\nid1,priority,project,...,description,anno_3\nid2,priority,project,...,description\nid3,priority,project,...,description,anno_1\nid3,priority,project,...,description,anno_2\n\nAlso not pretty for just as many reasons, but that's one of the many inherent weaknesss of CSV.  If there were some formal specification for CSV files, there would likely also be a spec for tuples, lists, etc. that would allow something intelligible.\n\n*I think in the end, you must consider a task export to be only guaranteed suitable for task import.*  If anything else can make use of it, well yeah for it.\n\n"}}
{"actor":{"display_login":"tbabej"}}