{"id":4621,"date":"2017-02-20T20:57:46","date_gmt":"2017-02-20T20:57:46","guid":{"rendered":"http:\/\/johnjohnston.info\/blog\/?p=4621"},"modified":"2018-08-01T19:39:58","modified_gmt":"2018-08-01T18:39:58","slug":"frozen-words","status":"publish","type":"post","link":"https:\/\/johnjohnston.info\/blog\/frozen-words\/","title":{"rendered":"Frozen Words"},"content":{"rendered":"<p>I&#8217;ve had a long term interest in digital &#8216;fridge&#8217; poetry, making my first efforts with Flash around 15 years ago. A year or so ago <a title=\"Never aggregate ephemeral sheep | John's World Wide Wall Display\" href=\"http:\/\/johnjohnston.info\/blog\/never-aggregate-ephemeral-sheep\/\">I was excited<\/a> by <a href=\"http:\/\/bionicteaching.com\/fridge-poetry-google-sheets-as-database\/\">Fridge Poetry \u2013 Google Sheets as Database<\/a> by Tom Woodward. There were a couple of goodies in that post, getting the word list from a google sheet and a nifty way to allow folk to easily make their own. I <a title=\"Never aggregate ephemeral sheep | John's World Wide Wall Display\" href=\"http:\/\/johnjohnston.info\/blog\/never-aggregate-ephemeral-sheep\">made a sheet and a poem<\/a> and slotted the idea away.<\/p>\n<p>I&#8217;ve revisited Tom&#8217;s post (and others) a few times, gathering tools <a id=\"fnr1-2017-02-19\" href=\"#fn1-2017-02-19\"><sup>1<\/sup><\/a> and wondering.<\/p>\n<p>On the holiday weekend, given poor weather and a head cold, I revisited the idea and made my own <a title=\"The Fridge\" href=\"http:\/\/johnjohnston.info\/fridge\">Fridge<\/a>.<\/p>\n<p>This riffs &amp; extends the idea a wee bit:<\/p>\n<ol>\n<li>You can add a background image to the poem, either from a built in flickr search or a local one.<\/li>\n<li>There is a standard common word list and a topical one from the google sheet.<\/li>\n<li>The words in the lists can be used more than once.<\/li>\n<li>I used JavaScript as opposed to php (except for proxying images to allow you to export).<\/li>\n<li>You can export the poem as an image.<\/li>\n<\/ol>\n<p>I&#8217;ve edited Tom&#8217;s template a little, the new one:<\/p>\n<ul>\n<li>Automatically generated a link to use. Tom got you to copy paste in the sheets own url and parsed that.<\/li>\n<li>Adds a field for the image search.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1gjQknTGGEBV68GWl67lPIOupdUBdacLwt2xv2W8HxLs\/copy\">Make a List<\/a> this link should get you to create a copy of the list spreadsheet. You can edit the words (on the 2nd worksheet) and change the image search, \u00a0more info:\u00a0<a href=\"http:\/\/johnjohnston.info\/fridge\/about.html\">Fridge Poetry<\/a>.<\/p>\n<h3>Learning<\/h3>\n<p>I&#8217;ve gained a wee bit more JavaScript and jQuery. The idea of using Google sheets to populate a webpage or to display info from a sheet in a template is interesting. html2canvas is another tool that has interesting potential for storytelling on the web.<\/p>\n<p>Using <em>\/copy<\/em> at the end of a google sheet to allow anyone to make a copy is useful too.<\/p>\n<p>Finally the ability of google sheets to get the id of the current sheet is really handy in simplifying the creation of links. This relies on a very simple script:<br \/>\n<code><\/code><\/p>\n<pre>function getSheetID() {\n  var r = SpreadsheetApp.getActiveSpreadsheet().getId();\nreturn r;\n\n}<\/pre>\n<p>you can then get the id by typing <em>=getSheetID()<\/em> in a cell.<\/p>\n<h3>Next<\/h3>\n<p>There is more help on how to make and use a wordlist here: <a href=\"http:\/\/johnjohnston.info\/fridge\/about.html\">Fridge Poetry<\/a>.<\/p>\n<p>Hopefully someone will find this fun of useful, if you do and create new wordlists please let me know.<\/p>\n<p>NB, I made a bit of a mess of attributing on this post. <a href=\"http:\/\/johnjohnston.info\/blog\/an-apology-to-ericcurts-eric-curts\/\">An apology to @ericcurts Eric Curts |<\/a><\/p>\n<div class=\"footnotes\">\n<p>1. <a id=\"fn1-2017-02-19\"><\/a>Mostly JavaScript Libraries:<\/p>\n<ul>\n<li><a href=\"http:\/\/html2canvas.hertzen.com\/\">html2canvas &#8211; Screenshots with JavaScript<\/a><\/li>\n<li><a href=\"http:\/\/touchpunch.furf.com\/\">jQuery UI Touch Punch &#8211; Touch Event Support for jQuery UI<\/a><\/li>\n<li><a href=\"https:\/\/www.html5rocks.com\/en\/tutorials\/file\/dndfiles\/\">Reading local files in JavaScript &#8211; HTML5 Rocks<\/a><\/li>\n<\/ul>\n<p>and <a href=\"https:\/\/git-ftp.github.io\/\">Git-ftp by git-ftp<\/a>.<br \/>\n<a href=\"#fnr1-2017-02-19\">&#x21a9;<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve had a long term interest in digital &#8216;fridge&#8217; poetry, making my first efforts with Flash around 15 years ago. A year or so ago I was excited by Fridge Poetry \u2013 Google Sheets as Database by Tom Woodward. There were a couple of goodies in that post, getting the word list from a google [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4622,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"mf2_syndication":[],"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"webmentions_disabled_pings":false,"webmentions_disabled":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6],"tags":[510,38,229],"post_format":[],"class_list":{"0":"post-4621","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wwwd","8":"tag-google-sheets","9":"tag-javascript","10":"tag-poetry","11":"kind-article","13":"h-entry","14":"hentry"},"better_featured_image":{"id":4622,"alt_text":"","caption":"","description":"","media_type":"image","media_details":{"width":1000,"height":477,"file":"2017\/02\/thefridge.jpg","sizes":{"thumbnail":{"file":"thefridge-150x150.jpg","width":150,"height":150,"mime-type":"image\/jpeg","source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2017\/02\/thefridge-150x150.jpg"},"medium":{"file":"thefridge-620x296.jpg","width":620,"height":296,"mime-type":"image\/jpeg","source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2017\/02\/thefridge-620x296.jpg"},"medium_large":{"file":"thefridge-768x366.jpg","width":768,"height":366,"mime-type":"image\/jpeg","source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2017\/02\/thefridge-768x366.jpg"},"post-thumbnail":{"file":"thefridge-668x319.jpg","width":668,"height":319,"mime-type":"image\/jpeg","source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2017\/02\/thefridge-668x319.jpg"},"sempress-image-post":{"file":"thefridge-668x319.jpg","width":668,"height":319,"mime-type":"image\/jpeg","source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2017\/02\/thefridge-668x319.jpg"},"rpwe-thumbnail":{"file":"thefridge-45x45.jpg","width":45,"height":45,"mime-type":"image\/jpeg","source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2017\/02\/thefridge-45x45.jpg"},"jetpack-portfolio-admin-thumb":{"file":"thefridge-50x50.jpg","width":50,"height":50,"mime-type":"image\/jpeg","source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2017\/02\/thefridge-50x50.jpg"}},"image_meta":{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0","keywords":[]}},"post":4621,"source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2017\/02\/thefridge.jpg"},"jetpack_featured_media_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2017\/02\/thefridge.jpg","jetpack_shortlink":"https:\/\/wp.me\/p57zFQ-1cx","jetpack_likes_enabled":false,"jetpack_sharing_enabled":true,"kind":false,"_links":{"self":[{"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/posts\/4621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/comments?post=4621"}],"version-history":[{"count":3,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/posts\/4621\/revisions"}],"predecessor-version":[{"id":7594,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/posts\/4621\/revisions\/7594"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/media\/4622"}],"wp:attachment":[{"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/media?parent=4621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/categories?post=4621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/tags?post=4621"},{"taxonomy":"post_format","embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/post_format?post=4621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}