{"id":976,"date":"2021-03-16T22:45:24","date_gmt":"2021-03-16T20:45:24","guid":{"rendered":"http:\/\/pori.hacklab.fi\/wordpress\/?p=976"},"modified":"2022-04-02T16:15:56","modified_gmt":"2022-04-02T13:15:56","slug":"lampotila-paineanturi-ttn-pipedream-google-sheet-wordpress","status":"publish","type":"post","link":"https:\/\/pori.hacklab.fi\/wordpress\/?p=976","title":{"rendered":"L\u00e4mp\u00f6tila-paineanturi + TTN + Pipedream + Google Sheet + WordPress"},"content":{"rendered":"\n<p>Kokeilussa tavoitteena saada ns. heatmap-tieto (Google Sheet) mittalaitteelta LoraWAN-verkon avulla (The things network) yhdist\u00e4m\u00e4ll\u00e4 laitedata Pipedream-palvelun avulla: <br><br>\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"100%\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQsE0w9d70a1HV9_WPlTlhmH6LSAFSGEO1dj9m4m2GZroefy9xwCQK6BEAurBOJHLIg4bAqYyACMErV\/pubhtml?gid=891324031&amp;single=true&amp;widget=true&amp;headers=false\"><\/iframe>\n\n(T\u00e4ss\u00e4 demossa google sheet on upotettu iframe-tekniikalla. WordPress-k\u00e4ytt\u00e4j\u00e4n tulee osata m\u00e4\u00e4ritt\u00e4\u00e4 iframe-elementtiin lis\u00e4ksi width ja height.)\n<\/p>\n\n\n\n<!--more-->\n<!--noteaser-->\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"715\" height=\"1080\" src=\"https:\/\/pori.hacklab.fi\/wordpress\/wp-content\/uploads\/2021\/03\/image-715x1080.png\" alt=\"\" class=\"wp-image-985\" srcset=\"https:\/\/pori.hacklab.fi\/wordpress\/wp-content\/uploads\/2021\/03\/image-715x1080.png 715w, https:\/\/pori.hacklab.fi\/wordpress\/wp-content\/uploads\/2021\/03\/image-199x300.png 199w, https:\/\/pori.hacklab.fi\/wordpress\/wp-content\/uploads\/2021\/03\/image.png 730w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Koko ketjusta ja ehk\u00e4 itse\u00e4ni eniten haastaneesta filosofiasta &#8221;ohjelmoinnin demokratisointi&#8221; my\u00f6hemmin lis\u00e4\u00e4. Todetaan heti ett\u00e4 t\u00e4h\u00e4n pisteeseen p\u00e4\u00e4tymiseen meni muutama ehtoo ainakin allekirjoittaneella. HeatMap-idea tuli Hacklabin ulkopuolelta k\u00e4vij\u00e4laskuri-ideasta Kyl\u00e4saaren kyl\u00e4yhdistykselt\u00e4, t\u00e4ss\u00e4 demossa tavallaan pyk\u00e4l\u00e4\u00e4 monimutkaisempi &#8221;laskuridata&#8221; ehdon kera. Sovellutusideat sek\u00e4 Lorawan- ja TTN-perehdytykset tulivat Marko Kauppiselta, iso kiitos kipin\u00e4n luomisesta itselle uutta aihetta kohtaan. Markolta tuli siis my\u00f6s laitteet jota t\u00e4ss\u00e4 demossa hy\u00f6dynnettiin, lyhyesti siis suurin ty\u00f6 koko kokeilusta. Itse keskityin ainoastaan softa-puoleen. <\/p>\n\n\n\n<p>Melko varmasti tulee muitakin demoja lis\u00e4\u00e4. Mutta ensin t\u00e4m\u00e4 demo tullaan palastelemaan paremmin&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kokeilussa tavoitteena saada ns. heatmap-tieto (Google Sheet) mittalaitteelta LoraWAN-verkon avulla (The things network) yhdist\u00e4m\u00e4ll\u00e4 laitedata Pipedream-palvelun avulla<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2,21,1],"tags":[44,32,41,43,42],"_links":{"self":[{"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/976"}],"collection":[{"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=976"}],"version-history":[{"count":12,"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/976\/revisions"}],"predecessor-version":[{"id":1144,"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/976\/revisions\/1144"}],"wp:attachment":[{"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pori.hacklab.fi\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}