{"action":"created","issue":{"url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/issues/53","repository_url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher","labels_url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/issues/53/labels{/name}","comments_url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/issues/53/comments","events_url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/issues/53/events","html_url":"https://github.com/Strassengezwitscher/Strassengezwitscher/pull/53","id":159934547,"number":53,"title":"Vorbereitungen fürs Importieren der bestehenden Excel-Daten","user":{"login":"piepmatz","id":1163632,"avatar_url":"https://avatars.githubusercontent.com/u/1163632?v=3","gravatar_id":"","url":"https://api.github.com/users/piepmatz","html_url":"https://github.com/piepmatz","followers_url":"https://api.github.com/users/piepmatz/followers","following_url":"https://api.github.com/users/piepmatz/following{/other_user}","gists_url":"https://api.github.com/users/piepmatz/gists{/gist_id}","starred_url":"https://api.github.com/users/piepmatz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/piepmatz/subscriptions","organizations_url":"https://api.github.com/users/piepmatz/orgs","repos_url":"https://api.github.com/users/piepmatz/repos","events_url":"https://api.github.com/users/piepmatz/events{/privacy}","received_events_url":"https://api.github.com/users/piepmatz/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/labels/backend%20feature","name":"backend feature","color":"c2e0c6"}],"state":"open","locked":false,"assignee":{"login":"mathebox","id":1757680,"avatar_url":"https://avatars.githubusercontent.com/u/1757680?v=3","gravatar_id":"","url":"https://api.github.com/users/mathebox","html_url":"https://github.com/mathebox","followers_url":"https://api.github.com/users/mathebox/followers","following_url":"https://api.github.com/users/mathebox/following{/other_user}","gists_url":"https://api.github.com/users/mathebox/gists{/gist_id}","starred_url":"https://api.github.com/users/mathebox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mathebox/subscriptions","organizations_url":"https://api.github.com/users/mathebox/orgs","repos_url":"https://api.github.com/users/mathebox/repos","events_url":"https://api.github.com/users/mathebox/events{/privacy}","received_events_url":"https://api.github.com/users/mathebox/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/milestones/2","html_url":"https://github.com/Strassengezwitscher/Strassengezwitscher/milestones/Minimum%20viable%20product","labels_url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/milestones/2/labels","id":1764197,"number":2,"title":"Minimum viable product","description":"","creator":{"login":"Bensk1","id":1655756,"avatar_url":"https://avatars.githubusercontent.com/u/1655756?v=3","gravatar_id":"","url":"https://api.github.com/users/Bensk1","html_url":"https://github.com/Bensk1","followers_url":"https://api.github.com/users/Bensk1/followers","following_url":"https://api.github.com/users/Bensk1/following{/other_user}","gists_url":"https://api.github.com/users/Bensk1/gists{/gist_id}","starred_url":"https://api.github.com/users/Bensk1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bensk1/subscriptions","organizations_url":"https://api.github.com/users/Bensk1/orgs","repos_url":"https://api.github.com/users/Bensk1/repos","events_url":"https://api.github.com/users/Bensk1/events{/privacy}","received_events_url":"https://api.github.com/users/Bensk1/received_events","type":"User","site_admin":false},"open_issues":6,"closed_issues":4,"state":"open","created_at":"2016-05-13T09:24:19Z","updated_at":"2016-06-13T12:04:15Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2016-06-13T12:04:15Z","updated_at":"2016-06-13T15:31:26Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/pulls/53","html_url":"https://github.com/Strassengezwitscher/Strassengezwitscher/pull/53","diff_url":"https://github.com/Strassengezwitscher/Strassengezwitscher/pull/53.diff","patch_url":"https://github.com/Strassengezwitscher/Strassengezwitscher/pull/53.patch"},"body":"Die Real-World-Excel-Daten haben einige Anpassungen nötig gemacht.\r\nDie Hintergrunddiskussion zu den benötigten Feldern ist in #49.\r\n\r\nEinige Änderungen dürften nicht sofort nachzuvollziehen sein, daher hier einige Erläuterungen.\r\n## Anpassungen am Datenmodell\r\n### Events\r\n#### Neue Felder\r\n- `participants`: Das ist die Teilnehmeranzahl als CharField, weil die Excel-Tabellen Intervalle und Schätzungen enthalten, z.b: 1500-1700 Teilnehmer. Optional, weil kann erst nach dem Event eingetragen werden.\r\n\r\n#### Angepasste Felder\r\n- `organizer`: Ist in den Excel-Files oft leer, daher optional.\r\n- `type`: Benutzen wir momentan um zu speichern, ob es Event eine Versammlung (also angemeldet) oder eine einfache Ansammlung ist. Optional, weil in den Excel-Files mitunter nichts dazu angegeben ist.\r\n- `url`: Darf noch blank sein, aber nicht mehr null, weil Django es so [empfiehlt](https://docs.djangoproject.com/en/1.9/ref/models/fields/#null).\r\n\r\n### FacebookPages\r\n#### Neue Felder\r\n- `notes`: Feld für allgemeine Anmerkungen. Einige weniger wichtige Excel-Spalten werden dort zusammengefasst.\r\n- `facebook_id`: Wird für die Abfrage der Like-Zahl per Facebook-Graph-API benötigt. Zwar ist diese häufig schon in den URLs vorhanden, aber nicht immer. Tatsächlich wäre andersrum richtig: Wir könnten theoretisch die URL löschen, weil sich diese aus der ID bauen lässt. Können wir gern noch drüber diskutieren.\r\n\r\n### MapObjects\r\n### Neue Felder\r\n- `location`: Wir haben zwar GPS-Koordinaten, aber die sind für einen Menschen unverständlich und man hat womöglich mal ein MapObject in der Hand, ohne eine Karte gleichzeitig offen zu haben.\r\n\r\n#### Angepasste Felder\r\n- `name`: Ist jetzt leider optional, weil viele Events keinen Namen haben. FacebookPages hingegen schon, aber durch die Vererbung enforcen wir das dort nicht. Geht das vielleicht trotzdem irgendwie?\r\n\r\n## Eigentliches Fixture als Ergebnis\r\nWeil die Daten da drin nicht ins öffentliche Repo sollen, liegen sie im Google Drive. Wie die Daten geladen werden können, findet sich in der Commit-Message von 9985302e676afc774274963e34d850ab3fcff04d.\r\nDie Fixture wird in ein App-unabhängiges Projekt-spezifisches Fixture-Directory gepackt, weil die enthaltenen Daten App-übergreifen sind (nämlich Facebook und Events). Ob das der richtige Ort dafür ist, können wir auch diskutieren."},"comment":{"url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/issues/comments/225617148","html_url":"https://github.com/Strassengezwitscher/Strassengezwitscher/pull/53#issuecomment-225617148","issue_url":"https://api.github.com/repos/Strassengezwitscher/Strassengezwitscher/issues/53","id":225617148,"user":{"login":"coveralls","id":2354108,"avatar_url":"https://avatars.githubusercontent.com/u/2354108?v=3","gravatar_id":"","url":"https://api.github.com/users/coveralls","html_url":"https://github.com/coveralls","followers_url":"https://api.github.com/users/coveralls/followers","following_url":"https://api.github.com/users/coveralls/following{/other_user}","gists_url":"https://api.github.com/users/coveralls/gists{/gist_id}","starred_url":"https://api.github.com/users/coveralls/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coveralls/subscriptions","organizations_url":"https://api.github.com/users/coveralls/orgs","repos_url":"https://api.github.com/users/coveralls/repos","events_url":"https://api.github.com/users/coveralls/events{/privacy}","received_events_url":"https://api.github.com/users/coveralls/received_events","type":"User","site_admin":false},"created_at":"2016-06-13T15:31:25Z","updated_at":"2016-06-13T15:31:25Z","body":"\n[![Coverage Status](https://coveralls.io/builds/6574418/badge)](https://coveralls.io/builds/6574418)\n\nCoverage increased (+0.1%) to 98.819% when pulling **83b17bad8403241bb77193410c2cd524e2efeed8 on issue-49/import-existing-data** into **9201438662f85ae43a4a534f54566cfb0dcbb578 on develop**.\n"}}
{"actor":{"display_login":"coveralls"}}