Fast & Easy Handouts with Adobe Spark Post

I’ve been making handouts for instruction sessions for a few months with Adobe Spark Post

My work-flow is to gather the text I’m going to be putting in my handout in Google Keep without any formatting.

Then I go through the process of picking one of the pre-selected templates in Adobe Spark Post. I’ll play around with colors (especially if I’m featuring a specific database or tool with a color scheme).

You can drill down to hex codes for colors, and there are a wide variety of fonts.

Here’s an example I’m going to be using soon featuring Zotero and other tools that take advantage of the DOI and ISBN systems. This took less than 5 minutes to create, with custom colors mimicking the Zotero logo colors.



Adding Hidden Search Limits on Certain Poorly Designed Search Forms

Sometimes you’ve reached the end of what’s possible with WYSIWYG search screen editors and very, very specific needed features (like search limits) are missing.

If  you have access to the HTML of the page or the ability to include arbitrary HTML, or can include Javascript in any form on the page you can apply this.

Most library search forms follow something like the following pattern



<input type=”text” id=”title_input”></br>


<input type=”text” id=”author_input”></br>

<h2 id=”j_title_input_text”>Journal Title</h2>

<input type=”text” id=”j_title_input”></br>

<input type=”button” value=”Search”


The key to keep an eye on here is the ID part of the input.

If you can include any javascript anywhere on the page, you can auto-fill part of the form, then hide it.

This will auto-fill the form

// Fill input
document.getElementById(“j_title_input”).value=”Harvard Business Review”;

And this will hide the input box

//Hide input

Now, this is pretty hacky, but with many of us dealing with hosted systems and limited budgets it can become difficult to get server side solutions. If you can create a search box and a search strategy, you can create limited, customized search boxes.

Fork and play with it here using CodePen.

Data from running Have MLIS, Will Travel for November 2016

This is just a quick update on the Have MLIS, Will Travel job sharing site. I did a substantial amount of work automating the collection and classification of the jobs I was collecting. I recently collected the data from the first full month I ran HMWT, and I wanted to share a couple of charts. Here’s the total data

Country Number of Jobs Nov 2016
Canada 73
United States 762
UK 126
Republic of Ireland 3
UAE 11
Kuwait 2
Netherlands 1
Qatar 2



Job Type Number of Jobs Nov 2016
Medical 32
School 121
Public 245
Academic 465
Legal 24
Special 57
Records Management 4
Archives 5


Some of the insights gleaned from this:

1)the automated job search strategies I’ve created are heavily biased towards academic jobs in North America.

2) I have not found a reliable source for european jobs outside of the UK

3) for jobs posted on the same day, I have a process to eliminate duplicates, but I have a problem with duplicates posted across multiple days. About 1/3 of the raw data was duplicate positions, posted as much as 3 weeks apart.

The total jobs posted in the month of November, after all duplicates were removed, was 980

The problem of duplicates is not enough of an issue to pursue further development to limit them. The process to tag and distribute these jobs is sustainable and easy to do, taking at most 15-20 minutes a day.

Subscribing to Journals with your institutional Subscription

There are some journals and magazines that you want to read every article in. However, in the institutional subscriptions that most academic libraries use, there are a lot of tiny (less than 150 word) articles that clutter up email alerts and RSS feeds.

This is a strategy to create smart RSS feeds and email alerts with only the larger articles.

Because I’m using some less-documented features, I’ll show you how to do this in two of the largest vendors, EbscoHost and ProQuest.


At the University of Toronto, we have access to Rolling Stone through CBCA Complete.

You can generally find the internal ProQuest ID’s of journals and magazines by clicking on the journal name in any generic search result, or through your OpenURL resolver.

The Rolling Stone internal ID on ProQuest is 47797

You can search for Rolling Stone in your ProQuest subscription by using this search string.


You can create an alert within the ProQuest interface for every article, but as mentioned earlier a lot of tiny articles will clutter up your alerts. ProQuest uses the operator WC to allow you to limit or place a lower limit the number of words in your search results.

The WC operator uses > (greater than) and < (less than) in front of the number of words. To only get longform articles from Rolling Stone, you can use this search string.

PUBID(47797) WC(>500)

ProQuest search results should be sorted by the ‘Most Recent first’. With this search string and sort option, you can then create the alerts inside ProQuest.


At the University of Toronto have access to International Affairs through our Academic OneFile subscription

Gale uses the Publication Title operator to identify individual works. You can find International Affairs with this search.

Publication Title (“International Affairs”)

Gale uses the Word Count operator to limit word counts, and uses the > or < in front of number of words..

To get only longform articles from International Affairs, use this search string.

Publication Title (“International Affairs”) AND Word Count (>500 )


At the University of Toronto we have access to the National Review through our subscription to Corporate ResourceNet.

Ebsco uses the JN operator to identify individual works. You can find the National Review with this search.

JN “National Review”

Ebsco does not use a word count operator, instead offering a page count limit. Put a page-count limit of Greater Than 1 and create a search alert inside the Ebsco interface.


All three interfaces allow both RSS and Email subscriptions to alerts with these search options.


Insights from Have MLIS, Will Travel

I’ve been running my experiment in library job sharing for a month now. This is very, very early preliminary data. It excludes some jobs that were not logged properly by by logging function.

In the cleaned up data set, I have 579 jobs for the month of March.

HMWT - 1

61 of those jobs are in Canada


As you can see from the images, three types of jobs predominate. Management, Liaison/Reference and Youth Services

Here’s a map of jobs posted in the month of March.

I’m going to start excluding school librarian positions from the jobs I’m sharing. I’m happy to share an RSS feed of those jobs to anyone interested in starting their own job board for school librarians.

I can also offer an RSS feed of the library technician positions.

Improvements to work on

  1.  fix the logging function.
  2. start excluding school librarian postings (as of April 1)
  3. Combine the Liaison and Reference job ‘types’
  4. duplicate detection



Dawn Alarm Clock & Workflow

I’ve been trying out the new app Workflow, and I’ve been enjoying the features this app brings to IOS 8. I’ve consolidated all of my social media sharing into a single workflow, and I’ve set up a workflow to create Do Not Link links for sharing controversial blog posts on forums

This is the most complicated workflow I’ve created, an app that adds a calendar entry for dawn tomorrow, based on your location and the Sunrise Sunset API

This is a first draft, if you have a way to improve it, let me in know!

Dawn Alarm Clock

ASM Handbooks EZproxy Stanza

After searching a number of different places, I had to write my own EZproxy stanza for the ASM handbooks.

The ASM website is put together in a simple way, which makes this basic ASM Handbook stanza appropriate. If you have a better stanza for ASM, please let me know.

T ASM International Handbooks