{"id":613,"date":"2018-05-31T22:32:20","date_gmt":"2018-05-31T10:32:20","guid":{"rendered":"http:\/\/deborahfitchett.com\/blog\/?p=613"},"modified":"2018-05-31T22:32:20","modified_gmt":"2018-05-31T10:32:20","slug":"wrangling-primo-resource-recommender-anzreg2018","status":"publish","type":"post","link":"https:\/\/deborahfitchett.com\/blog\/2018\/05\/wrangling-primo-resource-recommender-anzreg2018\/","title":{"rendered":"Wrangling Primo Resource Recommender #anzreg2018"},"content":{"rendered":"<p><strong>Resource wrangling : An implementation of Primo Resource Recommender service at State Library Victoria<\/strong><br \/>\nMarcus Ferguson, SLV<\/p>\n<p>Principles: find best way to present recommendations; control number of resources recommended; clearly identify subscription vs free. Include: databases, websites, research guides, custom types (collection pages, exhibition pages), &#8216;more to explore&#8217; (originally things like library hours, now repurposed libguides for subjects) 488 resources &#8211; with 10,500+ tags. Maintaining this either through Back Office or spreadsheet upload was going to be difficult.<\/p>\n<p>Built a spreadsheet with columns: list of keywords; database1..database5; website1..website3 etc; with dropdown menus to populate these. But then need to convert this. VLOOKUP wouldn&#8217;t work so needed custom function. Found a VBA function via Google. This operates on a new sheet to create a list of databases and all the tags used by it, plus a list of &#8216;other tags&#8217; added manually for each one. Final sheet pulls it all together into the format Primo expects.<\/p>\n<p>Finally also assigned icons to improve visual effect &#8211; found from vendor branding pages; website; or social media. Looks bad if a resource has none, so assign a default logo in that case.<\/p>\n<p>Subscription database use &#8216;Login to access&#8217; as URL text; free ones have title as URL text.<\/p>\n<p>Added rr_database_icon_check as a keyword so can search for Primo for all of these and check that they&#8217;re still valid &#8211; mostly they&#8217;re pretty stable. If that changes, will grab them and store locally.<\/p>\n<p>Final step is VBA macro to save export version and backup.<\/p>\n<p>Looking forward: &#8211; need to assess impact of the May release &#8220;tag enrichment&#8221;; extend spreadsheet to include research guides; apply additional error checking; investigate ways to allow other librarians to work with the tags while managing change control.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Resource wrangling : An implementation of Primo Resource Recommender service at State Library Victoria Marcus Ferguson, SLV Principles: find best way to present recommendations; control number of resources recommended; clearly identify subscription vs free. Include: databases, websites, research guides, custom types (collection pages, exhibition pages), &#8216;more to explore&#8217; (originally things like library hours, now repurposed [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[290,119,297],"_links":{"self":[{"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/posts\/613"}],"collection":[{"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/comments?post=613"}],"version-history":[{"count":1,"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/posts\/613\/revisions"}],"predecessor-version":[{"id":614,"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/posts\/613\/revisions\/614"}],"wp:attachment":[{"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/media?parent=613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/categories?post=613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/deborahfitchett.com\/blog\/wp-json\/wp\/v2\/tags?post=613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}