{"action":"created","issue":{"url":"https://api.github.com/repos/buzzn/scrum/issues/2","repository_url":"https://api.github.com/repos/buzzn/scrum","labels_url":"https://api.github.com/repos/buzzn/scrum/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/buzzn/scrum/issues/2/comments","events_url":"https://api.github.com/repos/buzzn/scrum/issues/2/events","html_url":"https://github.com/buzzn/scrum/issues/2","id":271826457,"number":2,"title":"As a Pho, I want to import and view all real meters with their registers","user":{"login":"dottorer","id":14217285,"avatar_url":"https://avatars2.githubusercontent.com/u/14217285?v=4","gravatar_id":"","url":"https://api.github.com/users/dottorer","html_url":"https://github.com/dottorer","followers_url":"https://api.github.com/users/dottorer/followers","following_url":"https://api.github.com/users/dottorer/following{/other_user}","gists_url":"https://api.github.com/users/dottorer/gists{/gist_id}","starred_url":"https://api.github.com/users/dottorer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dottorer/subscriptions","organizations_url":"https://api.github.com/users/dottorer/orgs","repos_url":"https://api.github.com/users/dottorer/repos","events_url":"https://api.github.com/users/dottorer/events{/privacy}","received_events_url":"https://api.github.com/users/dottorer/received_events","type":"User","site_admin":false},"labels":[{"id":743198354,"url":"https://api.github.com/repos/buzzn/scrum/labels/size:%208","name":"size: 8","color":"fbca04","default":false},{"id":743190494,"url":"https://api.github.com/repos/buzzn/scrum/labels/User%20Story","name":"User Story","color":"0052cc","default":false}],"state":"open","locked":false,"assignee":{"login":"phillipoertel","id":5188,"avatar_url":"https://avatars1.githubusercontent.com/u/5188?v=4","gravatar_id":"","url":"https://api.github.com/users/phillipoertel","html_url":"https://github.com/phillipoertel","followers_url":"https://api.github.com/users/phillipoertel/followers","following_url":"https://api.github.com/users/phillipoertel/following{/other_user}","gists_url":"https://api.github.com/users/phillipoertel/gists{/gist_id}","starred_url":"https://api.github.com/users/phillipoertel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phillipoertel/subscriptions","organizations_url":"https://api.github.com/users/phillipoertel/orgs","repos_url":"https://api.github.com/users/phillipoertel/repos","events_url":"https://api.github.com/users/phillipoertel/events{/privacy}","received_events_url":"https://api.github.com/users/phillipoertel/received_events","type":"User","site_admin":false},"assignees":[{"login":"phillipoertel","id":5188,"avatar_url":"https://avatars1.githubusercontent.com/u/5188?v=4","gravatar_id":"","url":"https://api.github.com/users/phillipoertel","html_url":"https://github.com/phillipoertel","followers_url":"https://api.github.com/users/phillipoertel/followers","following_url":"https://api.github.com/users/phillipoertel/following{/other_user}","gists_url":"https://api.github.com/users/phillipoertel/gists{/gist_id}","starred_url":"https://api.github.com/users/phillipoertel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phillipoertel/subscriptions","organizations_url":"https://api.github.com/users/phillipoertel/orgs","repos_url":"https://api.github.com/users/phillipoertel/repos","events_url":"https://api.github.com/users/phillipoertel/events{/privacy}","received_events_url":"https://api.github.com/users/phillipoertel/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/buzzn/scrum/milestones/1","html_url":"https://github.com/buzzn/scrum/milestone/1","labels_url":"https://api.github.com/repos/buzzn/scrum/milestones/1/labels","id":2894127,"number":1,"title":"\"The\" product Backlog","description":"","creator":{"login":"dottorer","id":14217285,"avatar_url":"https://avatars2.githubusercontent.com/u/14217285?v=4","gravatar_id":"","url":"https://api.github.com/users/dottorer","html_url":"https://github.com/dottorer","followers_url":"https://api.github.com/users/dottorer/followers","following_url":"https://api.github.com/users/dottorer/following{/other_user}","gists_url":"https://api.github.com/users/dottorer/gists{/gist_id}","starred_url":"https://api.github.com/users/dottorer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dottorer/subscriptions","organizations_url":"https://api.github.com/users/dottorer/orgs","repos_url":"https://api.github.com/users/dottorer/repos","events_url":"https://api.github.com/users/dottorer/events{/privacy}","received_events_url":"https://api.github.com/users/dottorer/received_events","type":"User","site_admin":false},"open_issues":25,"closed_issues":9,"state":"open","created_at":"2017-11-07T13:08:07Z","updated_at":"2017-11-30T15:07:34Z","due_on":null,"closed_at":null},"comments":24,"created_at":"2017-11-07T13:12:30Z","updated_at":"2017-11-30T21:35:09Z","closed_at":null,"author_association":"NONE","body":"PR: \r\n- https://github.com/buzzn/admin-app/pull/252\r\n---\r\n**Story:**\r\nAs PhO, I want to import and view all real meters and registers from BeeKeeper into Admin App, so I can verify technical setup for my group.\r\n\r\n---\r\n**XD**\r\n - [x] register and meter list: https://invis.io/J6ENAO22A#/265627583_Desktop_HD_-_System_-_Register_List\r\n\r\n\r\n---\r\n**Definition of done**\r\n- [x] For each group, all real **meters** are imported\r\n- [x] each meter has values as outlined in the data mapping XLS sheet for this story.\r\n- [x] For each meter, all included **registers** are imported\r\n- [x] each register has values as outlined in the data mapping XLS sheet for this story.\r\n- [x] all registers are labeled correctly (see logic below)\r\n\r\n\r\n**Excluded**\r\n- The bubble chart shows all consumption registers and the production registers correctly; also in Display App\r\n- All registers that receive data from Discovergy are linked correctly with a broker (new story #29).\r\n- import of historic readings\r\n- link to current and historic PT contracts\r\n- new: import manufacturer name correctly (currently only \"Easymeter\" or \"Other\")\r\n- new: sequence number. To verify if we can really reassign them or if we need to import the exact BK numbers\r\n- new: reliably exclude virtual registers\r\n- new: set CONSUMPTION_COMMON correctly after data problems have been clarified\r\n- new: maybe fix the incorrect zählwerk.kennzeichnung of the power generation registers automatically\r\n\r\n---\r\n\r\n**Technical details**\r\n\r\n_Frontend_\r\n\r\n- [x] list of **registers** which shows these attributes: \r\n  - [x] register name (linked to register details)\r\n  - [x] meter serial number (attribute \"product_serialnumber\", linked to meter details)\r\n  - [x] direction\r\n  - [x] label\r\n- [x] use `group?include=meters[registers]` endpoint to get the data. \r\n\r\n_Backend_\r\n\r\n- [x] set meter group\r\n- [x] set register name\r\n- [x] set meter product serial number\r\n- [x] set type (based on direction)\r\n- [ ] assign every register to the correct meter\r\n- [ ] set label: \r\n  - [x] most labels already mapped in msb_zählwerk_daten.rb\r\n  - [x] new register label 'PRODUCTION_WATER' and 'PRODUCTION_WIND' (explained in https://github.com/buzzn/scrum/issues/2#issuecomment-344638661), and demarcation labels\r\n  - [x] assign (new) register label 'CONSUMPTION_COMMON' for \"Allgemeinstrom\". Identified by SN_contracts having the value for EEG_Umlage of \"-1\".\r\n  - [x] clarify why register \"Wachsbleiche 3+5 BHKW Produktion\" get incorrectly labeled CONSUMPTION_COMMON\r\n- [x] associate the GRID_CONSUMPTION and GRID_FEEDING registers to the group (ensure label matches)\r\n- [x] ~~remove meters product_name constraint~~ - not present any more\r\n- [x] exclude virtual meters/registers\r\n\r\n---\r\n\r\nSource tables:\r\n- [msb_gerät](https://buzzn-team.atlassian.net/wiki/download/attachments/102334520/msb_ger%C3%A4t.xlsx?version=5&modificationDate=1511603138337&cacheVersion=1&api=v2)\r\n- [msb_zählwerk_daten](https://buzzn-team.atlassian.net/wiki/download/attachments/102334520/msb_z%C3%A4hlwerk_daten.xlsx?version=4&modificationDate=1511603137307&cacheVersion=1&api=v2)\r\n\r\nData value mapping:\r\n- https://buzzn-team.atlassian.net/wiki/x/mAAq\r\n\r\n----\r\n\r\n**Latest beekeeper import report (run with SQL dump 2017-11-22)**\r\n\r\nhttps://gist.github.com/phillipoertel/fb4dfbe4a40ea323f77833613164ba30\r\n"},"comment":{"url":"https://api.github.com/repos/buzzn/scrum/issues/comments/348328198","html_url":"https://github.com/buzzn/scrum/issues/2#issuecomment-348328198","issue_url":"https://api.github.com/repos/buzzn/scrum/issues/2","id":348328198,"user":{"login":"phillipoertel","id":5188,"avatar_url":"https://avatars1.githubusercontent.com/u/5188?v=4","gravatar_id":"","url":"https://api.github.com/users/phillipoertel","html_url":"https://github.com/phillipoertel","followers_url":"https://api.github.com/users/phillipoertel/followers","following_url":"https://api.github.com/users/phillipoertel/following{/other_user}","gists_url":"https://api.github.com/users/phillipoertel/gists{/gist_id}","starred_url":"https://api.github.com/users/phillipoertel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phillipoertel/subscriptions","organizations_url":"https://api.github.com/users/phillipoertel/orgs","repos_url":"https://api.github.com/users/phillipoertel/repos","events_url":"https://api.github.com/users/phillipoertel/events{/privacy}","received_events_url":"https://api.github.com/users/phillipoertel/received_events","type":"User","site_admin":false},"created_at":"2017-11-30T21:35:09Z","updated_at":"2017-11-30T21:35:09Z","author_association":"CONTRIBUTOR","body":"@evaklopp the story is now ready to test on staging."}}
{"actor":{"display_login":"phillipoertel"}}