{"id":2609,"date":"2014-05-02T15:59:53","date_gmt":"2014-05-02T15:59:53","guid":{"rendered":"http:\/\/blogs.northampton.ac.uk\/learntech\/?p=2609"},"modified":"2014-05-02T15:59:53","modified_gmt":"2014-05-02T15:59:53","slug":"2609","status":"publish","type":"post","link":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/","title":{"rendered":"Checking BIT.LY links"},"content":{"rendered":"

\"link<\/a><\/p>\n

\"bitly<\/p>\n

Bit.ly<\/a>\u00a0is great for creating and editing links used in multiple locations – particularly useful if you don’t remember where you used them. Within a VLE you might use the same link many times or copy it to a new module site – it’s easy to loose track – \u00a0‘corporate’ managers often restrict editing rights within institutional web sites.<\/p>\n

But do you want to manage your bit.ly links more efficiently? Check if they are still valid URLs? Keep a backup copy of your links in a spreadsheet?<\/p>\n

This Google spreadsheet \u00a0draws on the bitly API to pull out the links, then runs a script to check the status of the full URL on a \u2018Link summary\u2019 page. I\u2019ve colour coded the main response codes to indicate real (red) problems and potential (orange \u2013 login may be needed).<\/p>\n

Early days, but this spreadsheet can be used for any bitly library \u2013 you just need to generate an access key at \u00a0https:\/\/bitly.com\/a\/oauth_apps<\/a>\u00a0from your own login and add it to cell B1 in the \u2018data\u2019 sheet. It currently processes up to 1000 links, but you can easily change this. I would recommend making a copy of the values in a new sheet too, just in case there is ever a bit.ly disaster.<\/p>\n

Here’s a link to a public version<\/span><\/a>\u00a0– please\u00a0save as a copy<\/strong>\u00a0before adding your access key or the world will know how to access your bit.ly links!<\/p>\n

As ever, I am standing on the shoulders of giants, so great credit must go to the component writers:<\/p>\n

JSON import: Trevor Lohrbeer (http:\/\/blog.fastfedora.com\/projects\/import-json<\/a>)
\nURL checker:\u00a0Cheok Luk (http:\/\/www.tinkeredge.com\/blog\/2012\/04\/check-on-page-for-broken-links-with-google-docs\/)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

<\/a><\/p>\n<\/p>\n

Bit.ly<\/a>\u00a0is great for creating and editing links used in multiple locations – particularly useful if you don’t remember where you used them. Within a VLE you might use the same link many times or copy it to a new module site – it’s easy to loose […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[12],"tags":[],"class_list":["post-2609","post","type-post","status-publish","format-standard","hentry","category-learntech-news"],"yoast_head":"\nChecking BIT.LY links - Learning Technology Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Checking BIT.LY links - Learning Technology Blog\" \/>\n<meta property=\"og:description\" content=\"Bit.ly\u00a0is great for creating and editing links used in multiple locations – particularly useful if you don’t remember where you used them. Within a VLE you might use the same link many times or copy it to a new module site – it’s easy to loose [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/\" \/>\n<meta property=\"og:site_name\" content=\"Learning Technology Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-02T15:59:53+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blogs.northampton.ac.uk\/learntech\/wp-content\/uploads\/sites\/7\/2014\/05\/bitly-150x150.jpg\" \/>\n<meta name=\"author\" content=\"robhowe\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"robhowe\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/\",\"url\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/\",\"name\":\"Checking BIT.LY links - Learning Technology Blog\",\"isPartOf\":{\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/blogs.northampton.ac.uk\/learntech\/wp-content\/uploads\/sites\/7\/2014\/05\/bitly-150x150.jpg\",\"datePublished\":\"2014-05-02T15:59:53+00:00\",\"author\":{\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/#\/schema\/person\/4e3c62c9bf9bb2ee4a04fab5010ba098\"},\"breadcrumb\":{\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#primaryimage\",\"url\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-content\/uploads\/sites\/7\/2014\/05\/bitly.jpg\",\"contentUrl\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-content\/uploads\/sites\/7\/2014\/05\/bitly.jpg\",\"width\":849,\"height\":426},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Checking BIT.LY links\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/#website\",\"url\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/\",\"name\":\"Learning Technology Blog\",\"description\":\"News and Updates from the Learning Technology Team\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/#\/schema\/person\/4e3c62c9bf9bb2ee4a04fab5010ba098\",\"name\":\"robhowe\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b29d50d15e7d7e9dfa3cff830d1ef466bc7d487312521f6bf91e777fffe12cd3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b29d50d15e7d7e9dfa3cff830d1ef466bc7d487312521f6bf91e777fffe12cd3?s=96&d=mm&r=g\",\"caption\":\"robhowe\"},\"url\":\"https:\/\/blogs.northampton.ac.uk\/learntech\/author\/robhowe\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Checking BIT.LY links - Learning Technology Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/","og_locale":"en_US","og_type":"article","og_title":"Checking BIT.LY links - Learning Technology Blog","og_description":"Bit.ly\u00a0is great for creating and editing links used in multiple locations – particularly useful if you don’t remember where you used them. Within a VLE you might use the same link many times or copy it to a new module site – it’s easy to loose [...]","og_url":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/","og_site_name":"Learning Technology Blog","article_published_time":"2014-05-02T15:59:53+00:00","og_image":[{"url":"http:\/\/blogs.northampton.ac.uk\/learntech\/wp-content\/uploads\/sites\/7\/2014\/05\/bitly-150x150.jpg","type":"","width":"","height":""}],"author":"robhowe","twitter_card":"summary_large_image","twitter_misc":{"Written by":"robhowe","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/","url":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/","name":"Checking BIT.LY links - Learning Technology Blog","isPartOf":{"@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#primaryimage"},"image":{"@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#primaryimage"},"thumbnailUrl":"http:\/\/blogs.northampton.ac.uk\/learntech\/wp-content\/uploads\/sites\/7\/2014\/05\/bitly-150x150.jpg","datePublished":"2014-05-02T15:59:53+00:00","author":{"@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/#\/schema\/person\/4e3c62c9bf9bb2ee4a04fab5010ba098"},"breadcrumb":{"@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#primaryimage","url":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-content\/uploads\/sites\/7\/2014\/05\/bitly.jpg","contentUrl":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-content\/uploads\/sites\/7\/2014\/05\/bitly.jpg","width":849,"height":426},{"@type":"BreadcrumbList","@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/2014\/05\/02\/2609\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blogs.northampton.ac.uk\/learntech\/"},{"@type":"ListItem","position":2,"name":"Checking BIT.LY links"}]},{"@type":"WebSite","@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/#website","url":"https:\/\/blogs.northampton.ac.uk\/learntech\/","name":"Learning Technology Blog","description":"News and Updates from the Learning Technology Team","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.northampton.ac.uk\/learntech\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/#\/schema\/person\/4e3c62c9bf9bb2ee4a04fab5010ba098","name":"robhowe","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogs.northampton.ac.uk\/learntech\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b29d50d15e7d7e9dfa3cff830d1ef466bc7d487312521f6bf91e777fffe12cd3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b29d50d15e7d7e9dfa3cff830d1ef466bc7d487312521f6bf91e777fffe12cd3?s=96&d=mm&r=g","caption":"robhowe"},"url":"https:\/\/blogs.northampton.ac.uk\/learntech\/author\/robhowe\/"}]}},"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-json\/wp\/v2\/posts\/2609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-json\/wp\/v2\/comments?post=2609"}],"version-history":[{"count":0,"href":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-json\/wp\/v2\/posts\/2609\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-json\/wp\/v2\/media?parent=2609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-json\/wp\/v2\/categories?post=2609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.northampton.ac.uk\/learntech\/wp-json\/wp\/v2\/tags?post=2609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}