{"action":"created","issue":{"url":"https://api.github.com/repos/dennissiemensma/dsmr-reader/issues/226","repository_url":"https://api.github.com/repos/dennissiemensma/dsmr-reader","labels_url":"https://api.github.com/repos/dennissiemensma/dsmr-reader/issues/226/labels{/name}","comments_url":"https://api.github.com/repos/dennissiemensma/dsmr-reader/issues/226/comments","events_url":"https://api.github.com/repos/dennissiemensma/dsmr-reader/issues/226/events","html_url":"https://github.com/dennissiemensma/dsmr-reader/issues/226","id":199388460,"number":226,"title":"Import of external MySQL data ","user":{"login":"balk77","id":10166350,"avatar_url":"https://avatars.githubusercontent.com/u/10166350?v=3","gravatar_id":"","url":"https://api.github.com/users/balk77","html_url":"https://github.com/balk77","followers_url":"https://api.github.com/users/balk77/followers","following_url":"https://api.github.com/users/balk77/following{/other_user}","gists_url":"https://api.github.com/users/balk77/gists{/gist_id}","starred_url":"https://api.github.com/users/balk77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/balk77/subscriptions","organizations_url":"https://api.github.com/users/balk77/orgs","repos_url":"https://api.github.com/users/balk77/repos","events_url":"https://api.github.com/users/balk77/events{/privacy}","received_events_url":"https://api.github.com/users/balk77/received_events","type":"User","site_admin":false},"labels":[{"id":322739637,"url":"https://api.github.com/repos/dennissiemensma/dsmr-reader/labels/q/r","name":"q/r","color":"cc317c","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/dennissiemensma/dsmr-reader/milestones/26","html_url":"https://github.com/dennissiemensma/dsmr-reader/milestone/26","labels_url":"https://api.github.com/repos/dennissiemensma/dsmr-reader/milestones/26/labels","id":2142916,"number":26,"title":"Backlog / Other","description":"On backlog / Indefinitely planned / Closed / Duplicates / Won't fix / Unqualified.","creator":{"login":"dennissiemensma","id":16581744,"avatar_url":"https://avatars.githubusercontent.com/u/16581744?v=3","gravatar_id":"","url":"https://api.github.com/users/dennissiemensma","html_url":"https://github.com/dennissiemensma","followers_url":"https://api.github.com/users/dennissiemensma/followers","following_url":"https://api.github.com/users/dennissiemensma/following{/other_user}","gists_url":"https://api.github.com/users/dennissiemensma/gists{/gist_id}","starred_url":"https://api.github.com/users/dennissiemensma/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dennissiemensma/subscriptions","organizations_url":"https://api.github.com/users/dennissiemensma/orgs","repos_url":"https://api.github.com/users/dennissiemensma/repos","events_url":"https://api.github.com/users/dennissiemensma/events{/privacy}","received_events_url":"https://api.github.com/users/dennissiemensma/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":54,"state":"open","created_at":"2016-11-17T21:45:04Z","updated_at":"2017-01-07T22:31:17Z","due_on":"2020-01-01T08:00:00Z","closed_at":null},"comments":2,"created_at":"2017-01-07T22:15:50Z","updated_at":"2017-01-07T23:04:38Z","closed_at":null,"body":"I have a year worth of P1 reading data in MySQL which I would like to import in dsmr-reader. Is there some kind of import function?"},"comment":{"url":"https://api.github.com/repos/dennissiemensma/dsmr-reader/issues/comments/271116443","html_url":"https://github.com/dennissiemensma/dsmr-reader/issues/226#issuecomment-271116443","issue_url":"https://api.github.com/repos/dennissiemensma/dsmr-reader/issues/226","id":271116443,"user":{"login":"dennissiemensma","id":16581744,"avatar_url":"https://avatars.githubusercontent.com/u/16581744?v=3","gravatar_id":"","url":"https://api.github.com/users/dennissiemensma","html_url":"https://github.com/dennissiemensma","followers_url":"https://api.github.com/users/dennissiemensma/followers","following_url":"https://api.github.com/users/dennissiemensma/following{/other_user}","gists_url":"https://api.github.com/users/dennissiemensma/gists{/gist_id}","starred_url":"https://api.github.com/users/dennissiemensma/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dennissiemensma/subscriptions","organizations_url":"https://api.github.com/users/dennissiemensma/orgs","repos_url":"https://api.github.com/users/dennissiemensma/repos","events_url":"https://api.github.com/users/dennissiemensma/events{/privacy}","received_events_url":"https://api.github.com/users/dennissiemensma/received_events","type":"User","site_admin":false},"created_at":"2017-01-07T23:04:38Z","updated_at":"2017-01-07T23:04:38Z","body":"Thanks for providing input. I've checked your example, but I'm affraid it's currently not possible to import this data. The source telegrams provides some additional fields that are required as well, and can't be reconstructed from the data you provided.\r\n\r\nI think the best you can do is to either use the tool you've collected this data with, to view that year of data. Or to export it all as CSV, convert it to Excel and plot some graphs or stats there. \r\n\r\nBut regarding to gas consumption you might have an extra option. You could register and connect an account with MinderGas.nl and insert the gas positions of your last year there as well. \r\nI did that myself as well for any data I collected *before using this project*, by simply retroactivily inserting the gas meter positions on that website, one for each month. It provides a bit insight.\r\n"}}
{"actor":{"display_login":"dennissiemensma"}}