{"id":278,"date":"2015-05-09T17:27:46","date_gmt":"2015-05-09T16:27:46","guid":{"rendered":"http:\/\/www.meiotic.co.uk\/my\/?p=278"},"modified":"2015-06-07T19:10:44","modified_gmt":"2015-06-07T18:10:44","slug":"collections-a-simple-online-whisky-cupboard-2","status":"publish","type":"post","link":"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/","title":{"rendered":"Collections: a simple, online whisky cupboard"},"content":{"rendered":"<p><script>document.getElementById('menu-item-107').className += \" current-menu-item current_page_item\";<\/script><br \/>\nWith an increasing list of whiskies having been sampled at the <a href=\"http:\/\/sswc.org.uk\" target=\"_blank\">Southside Whisky Club<\/a> as well as a growing personal sample collection, keeping a record of whiskies becomes more useful &#8211; mostly just as a memory aid. Obviously the following works equally for any collection of things you may have..<\/p>\n<p>In this case, it&#8217;s pretty standard tabular data albeit with a variety of datatypes. After a quick look through various JavaScript libraries that might do the job, I settled on <a href=\"http:\/\/tablesorter.com\/docs\/\" target=\"_blank\">tablesorter<\/a>.<\/p>\n<div id=\"attachment_543\" style=\"width: 775px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-543\" decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-543\" src=\"http:\/\/www.meiotic.co.uk\/my\/wp-content\/uploads\/2015\/05\/tablesorter1-765x403.jpg\" alt=\"You can add a whole lot of functionality\" width=\"765\" height=\"403\" srcset=\"http:\/\/www.meiotic.co.uk\/my\/wp-content\/uploads\/2015\/05\/tablesorter1-765x403.jpg 765w, http:\/\/www.meiotic.co.uk\/my\/wp-content\/uploads\/2015\/05\/tablesorter1.jpg 766w\" sizes=\"(max-width: 765px) 100vw, 765px\" \/><p id=\"caption-attachment-543\" class=\"wp-caption-text\">You can add a whole lot of functionality<\/p><\/div>\n<p>It&#8217;s light and powerful, with a pretty impressive built-in interpretation of datatypes. You might need to fiddle around a little bit (with date formats, for example), but if you have the time, you can create all sorts of custom processing.<\/p>\n<div id=\"attachment_186\" style=\"width: 776px\" class=\"wp-caption aligncenter\"><img aria-describedby=\"caption-attachment-186\" decoding=\"async\" loading=\"lazy\" class=\"wp-image-186\" src=\"http:\/\/www.meiotic.co.uk\/my\/wp-content\/uploads\/2015\/05\/collections.jpg\" alt=\"collections\" width=\"766\" height=\"260\" srcset=\"http:\/\/www.meiotic.co.uk\/my\/wp-content\/uploads\/2015\/05\/collections.jpg 1275w, http:\/\/www.meiotic.co.uk\/my\/wp-content\/uploads\/2015\/05\/collections-300x102.jpg 300w, http:\/\/www.meiotic.co.uk\/my\/wp-content\/uploads\/2015\/05\/collections-1024x348.jpg 1024w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><p id=\"caption-attachment-186\" class=\"wp-caption-text\">The end result is a simple, sortable online table<\/p><\/div>\n<p>Anyway, I didn&#8217;t need to do that. Just the odd fiddle to make things work how I&#8217;d expect. Check out the results here. NB you can order any column by clicking on the column title, and holding shift allows a multi-column sort. The table won&#8217;t be massively usable on a mobile due to screen size, but there&#8217;s not a great deal you can do about that with this many columns.<\/p>\n<div class=\"demo\" onClick=\"window.open('http:\/\/sswc.org.uk\/collections');\" onMouseOver=\"this.style.backgroundColor='#E96656';\" onMouseOut=\"this.style.backgroundColor='#56B7E8';\">\n<div style=\"float: left;\"><img decoding=\"async\" style=\"margin-left: 15px; margin-top: 0px; height: 40px;\" src=\"\/my\/wp-content\/uploads\/box_small.png\" alt=\"\" \/><\/div>\n<div style=\"float: left; margin-left: 10px; margin-top: -3px; color: #fff; font-family: 'Open Sans'; font-size: 20px; font-weight: 100;\">View Site <span style=\"font-size: 24px; color: #fff;\">\u00bb<\/span><\/div>\n<\/div>\n<p>So, there you have it. A simple, easy-to-use way to use tabular data online. This is all hooked into a database so will keep updated over time, and wasn&#8217;t complicated to do. I now use it pretty frequently to find whiskies, organise by region etc &#8211; pretty useful.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With an increasing list of whiskies having been sampled at the Southside Whisky Club as well as a growing personal sample collection, keeping a record of whiskies becomes more useful &#8211; mostly just as a<\/p>\n","protected":false},"author":1,"featured_media":186,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[19],"tags":[20,22,5,11],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.7.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Collections: a simple, online whisky cupboard | *meiotic*<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Collections: a simple, online whisky cupboard | *meiotic*\" \/>\n<meta property=\"og:description\" content=\"With an increasing list of whiskies having been sampled at the Southside Whisky Club as well as a growing personal sample collection, keeping a record of whiskies becomes more useful &#8211; mostly just as a\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/\" \/>\n<meta property=\"og:site_name\" content=\"*meiotic*\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-09T16:27:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-06-07T18:10:44+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.meiotic.co.uk\/my\/wp-content\/uploads\/2015\/05\/collections.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1275\" \/>\n\t<meta property=\"og:image:height\" content=\"433\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"meiotic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ScienceAndMaps\" \/>\n<meta name=\"twitter:site\" content=\"@ScienceAndMaps\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"meiotic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/\",\"url\":\"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/\",\"name\":\"Collections: a simple, online whisky cupboard | *meiotic*\",\"isPartOf\":{\"@id\":\"http:\/\/www.meiotic.co.uk\/my\/#website\"},\"datePublished\":\"2015-05-09T16:27:46+00:00\",\"dateModified\":\"2015-06-07T18:10:44+00:00\",\"author\":{\"@id\":\"http:\/\/www.meiotic.co.uk\/my\/#\/schema\/person\/1995e1cecd67d2ff1e6a638aa331d032\"},\"breadcrumb\":{\"@id\":\"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/www.meiotic.co.uk\/my\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Collections: a simple, online whisky cupboard\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.meiotic.co.uk\/my\/#website\",\"url\":\"http:\/\/www.meiotic.co.uk\/my\/\",\"name\":\"*meiotic*\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.meiotic.co.uk\/my\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.meiotic.co.uk\/my\/#\/schema\/person\/1995e1cecd67d2ff1e6a638aa331d032\",\"name\":\"meiotic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"http:\/\/www.meiotic.co.uk\/my\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/cacd48b532259fb621d7acf4cc462290?s=96&d=retro&r=r\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/cacd48b532259fb621d7acf4cc462290?s=96&d=retro&r=r\",\"caption\":\"meiotic\"},\"sameAs\":[\"http:\/\/meiotic.co.uk\",\"https:\/\/twitter.com\/ScienceAndMaps\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Collections: a simple, online whisky cupboard | *meiotic*","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"Collections: a simple, online whisky cupboard | *meiotic*","og_description":"With an increasing list of whiskies having been sampled at the Southside Whisky Club as well as a growing personal sample collection, keeping a record of whiskies becomes more useful &#8211; mostly just as a","og_url":"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/","og_site_name":"*meiotic*","article_published_time":"2015-05-09T16:27:46+00:00","article_modified_time":"2015-06-07T18:10:44+00:00","og_image":[{"width":1275,"height":433,"url":"http:\/\/www.meiotic.co.uk\/my\/wp-content\/uploads\/2015\/05\/collections.jpg","type":"image\/jpeg"}],"author":"meiotic","twitter_card":"summary_large_image","twitter_creator":"@ScienceAndMaps","twitter_site":"@ScienceAndMaps","twitter_misc":{"Written by":"meiotic","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/","url":"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/","name":"Collections: a simple, online whisky cupboard | *meiotic*","isPartOf":{"@id":"http:\/\/www.meiotic.co.uk\/my\/#website"},"datePublished":"2015-05-09T16:27:46+00:00","dateModified":"2015-06-07T18:10:44+00:00","author":{"@id":"http:\/\/www.meiotic.co.uk\/my\/#\/schema\/person\/1995e1cecd67d2ff1e6a638aa331d032"},"breadcrumb":{"@id":"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.meiotic.co.uk\/my\/whisky\/collections\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.meiotic.co.uk\/my\/"},{"@type":"ListItem","position":2,"name":"Collections: a simple, online whisky cupboard"}]},{"@type":"WebSite","@id":"http:\/\/www.meiotic.co.uk\/my\/#website","url":"http:\/\/www.meiotic.co.uk\/my\/","name":"*meiotic*","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.meiotic.co.uk\/my\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Person","@id":"http:\/\/www.meiotic.co.uk\/my\/#\/schema\/person\/1995e1cecd67d2ff1e6a638aa331d032","name":"meiotic","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"http:\/\/www.meiotic.co.uk\/my\/#\/schema\/person\/image\/","url":"http:\/\/0.gravatar.com\/avatar\/cacd48b532259fb621d7acf4cc462290?s=96&d=retro&r=r","contentUrl":"http:\/\/0.gravatar.com\/avatar\/cacd48b532259fb621d7acf4cc462290?s=96&d=retro&r=r","caption":"meiotic"},"sameAs":["http:\/\/meiotic.co.uk","https:\/\/twitter.com\/ScienceAndMaps"]}]}},"_links":{"self":[{"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/posts\/278"}],"collection":[{"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/comments?post=278"}],"version-history":[{"count":6,"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/posts\/278\/revisions"}],"predecessor-version":[{"id":564,"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/posts\/278\/revisions\/564"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/media\/186"}],"wp:attachment":[{"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/media?parent=278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/categories?post=278"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.meiotic.co.uk\/my\/wp-json\/wp\/v2\/tags?post=278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}