Book Groups Dashboard

I’ve been discussing with my colleague how automation can improve her productivity. While I went through what we’d need to do to make something happen, I paused and realized that what they needed was a dashboard to manage everything they need to track. Since I had some time set aside for them already, I kicked the planned project down the road to give them extra time to work on it. Then I settled into hacking together a quick book groups dashboard.

Courtesy of Darien Library

The Process
I began by looking up free dashboard templates. After examining a few dozen, I decided that DashGum was the one for my needs (view demo). The main files I edited were the index.html, panels.html, and style.css. My colleagues told me what websites they accessed the most often. For their needs, these are book review websites. I use Sublime as my text editor. The main color scheme of bright green and blue are based upon the colors they like to represent themselves with.

The Layout
My first consideration is that I wanted to personalize this dashboard for each member of the team. So I added their photo, name, and their work area title. The top row in the example are the things this coworker needs to access the most. They are simple links. Each link opens in a new tab so they can keep their dashboard up in one tab (better for their use if not my recommendation). Below that are the book review sites they use the most. This design is not ideal because it’s eating up a lot of space, but it works for now. On the right is for my benefit: a way to keep them on target with submitting publicity items to me. In the sidebar are some less often used links which may be useful for their day to day work. The icons are just what Font Awesome icons the theme comes packaged with. I quickly selected those particular icons.

Personalization
The two dashboards I made are almost identical. However, one colleague is comfortable with using MailChimp while the other is not. So I removed links which open up MailChimp.

Weaknesses
Since this was a quick, hacked together project, it is not perfect. At the moment, the two pages are living on our shared network drive. This allows me to update the pages from afar, but I’m managing two separated index.html files since they’re custom to the needs of each person.

My colleagues also share a Google account between them which they are both logged into in Chrome. So on one person’s computer, I could set the home button to her dashboard. With one account, I could not set the home button to the other to her own dashboard. So I gritted my teeth and made it as a bookmark. She’s happy enough with it right now. Perhaps Chrome profiles could alleviate this issue?

Reception

I just used my new dashboard to look up a book I hadn’t heard about-it is fabulous!!! Thank you so much. So easy getting in and out of! So far I am fully enjoying all of its charms!

What’s Next
The layout is not responsive. I work on large monitors, but when I tested on a smaller monitor, the text in the review sites word-wrapped in an ugly way.

They do all their work in an Outlook calendar. It’d be great to provide a link to opening Outlook to that specific place in the software since they have to make several clicks to view it. My current understanding is that I can’t link to their calendar. I tested the waters to see if I could migrate them out of it, but one of them has a strong preference for the software.

It is too bad that Asana does not offer a way to embed task lists elsewhere (by design). Then instead of my manually updated Publicity Deadlines, I could just include my work list there so they could see where I am in working through this month’s book group work.

A Little Attention

I was surprised to see that Techsoup for Libraries mentioned the Global Map of 3D Printing Map. I’ve admired their work for years, so what an honor!

Can’t find the live link on their website, but here it is in Google’s search results.

It should be noted that LITA’s Maker Technologies Interest Group voted a couple years back to give the map to LITA. I’m unsure if the current website they’re working on is ready to highlight the map’s presence, so I’ve linked to its location on my website.

Substituting Multiple Strings in Airtable

Thanks to W_Vann_Hall over on the Airtable Forums, I was able to figure out the formula I needed. The task is this:

* In JotForm, people select book covers to indicate which book they like.
* A Zapier zap takes that submission and puts it in my Airtable.
* However, the data appears at a bad URL with https://jotform.com added to the front of it. Worthless for our purposes.
* So to change that info, I need to substitute the long junk URL to the name of the book.
* I created a new column and added this formula:

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Name of Column — leave in brackets},’https://www.ilovemylibrary.com/images/little_red.jpg’,’Little Red Riding Hood, ‘),’https://www.ilovemylibrary.com/images/three_little_pigs.jpg’,’Three Little Pigs, ‘),’https://www.ilovemylibrary.com/images/cinderella.jpg’,’Cinderella, ‘)

* Output: Little Red Riding Hood, Three Little Pigs, Cinderella,
* Note that I added a comma and a space at the end of each item. I’m sure I could try to figure out how to check for any leftover items, so there isn’t an extra comma, but eh.

I’m sure there’s more work to be done and something will break, but I’m grateful to get at least this much figured out.

Under the Weather + Project Help

Since late January I’ve been under the weather. As such, I got an extremely last minute request (order!) from my doctor to forego attending ALA Midwinter. Thanks to the kind efforts of the LITA Board, I was able to attend the Board meetings by phone. My mind and energy has been redirected to the efforts of getting better this past month. Thus why things have things been so quiet around here. With any luck, I hope to be fully back in fighting shape any day now.

Meanwhile, the launch of the previous post’s project has been a roaring success. The Book Matchmaker has been so popular that I’m trying to find a solution to help them better manage it. My vision:

  • Easily tracks the submitter’s stated reading preferences.
  • Quickly show other times we’ve recommended a book to another reader. Thus, hopefully reducing staff time by seeing “oh, we said this book was great for Sci-Fi readers. Would this person appreciate it too?”
  • Help staff with planning out the next books to pull for that reader and when to do so.
  • Dead simple for staff to use.

Currently I’m thinking Airtable looks to be the best bet. Yet I’m not sure I can easily get the new submissions added automatically. I’ve tweeted at Airtable to see if they allow records to be added via email. Asana does which has spoiled me. If you have any further recommendations, let me know!

Re-launch Tomorrow

My lovely colleague took over a big project after one of our Assistant Directors left. She’s been polishing it for months now and tomorrow it goes live! I’m looking forward to discussing the work that went into bringing this service back online.

The most helpful thing for me was her interest and willingness to try her hand at Adobe Illustrator. She’s been working in InDesign for not too long and Illustrator is a whole other beast. By taking on this proactive role in her branding and publicity creation, she’s really owned this work. I’m happy to have helped when she needed me.

I Aten’t Dead

~ Granny Weatherwax

I’ve been working on so many projects at work that it’s hard to remember that I need to keep this site updated on them. I’ve also been trying to stay on task with NaNoWriMo, so I’ve been preoccupied.

My latest page design for the Fellowship goes live on Friday. I’m rather pleased with it. I had quickly wireframed it and took it to the department head for approval. The finished version is almost identical to the sketch.

It also presented another challenge: film a new video with the current fellow and combine that clip with interviews from the two previous fellows. Their clips come from a video with a heavy music overlay on top of their speaking. I contacted the videographer/editor of that film. He sent me a similar piece of music. I ended up importing that video plus my filmed clip into Final Cut Pro. I sliced each section into pieces. Then I disabled clips I didn’t want to use until I came up with my winning combination.

The audio part was difficult. I ended up moving the new audio about 20 seconds under the previous clip and had them intertwined with a fade-in. When my new clip appears, the music shifts. If you’re listening closely, you’ll notice that the music from the first two shots has dropped out completely. However, for our purposes, it goes smoothly enough to get the job accomplished.

As well, for what feels like the first time in forever, I’m coming up with new ideas. One cherished suggestion was taken seriously by my boss and she brought it forth as a co-sponsored program. She then took it one step further and contacted the local public access channel to see if they’d want to film it. They do!

Design Development Work

No images of today’s work since I tossed out most of it when I was finished with the design process. My tasks for the day were to create a print ad and a double-sided bookmark. For the ad, I created 11 layouts. The first two were digital versions of the sketches that were handed to me. From there, I worked out different arrangements of text, font sizes, colors, adding a border, adding images, until I came upon the final design which was accepted. As you scroll through the previous designs, you can see how I slowly tipped my chessboard towards it. Each idea sliding downwards until I arrived at the final image.

I printed out the proofs, marked my two favorite, scribbled a note of guidance, and left them on the requester’s desk. Later, when I returned to pick up the pieces, he had also chosen my favorite one. While checking and re-checking the layout back in InDesign, I got frustrated with the tools. I nabbed the metal ruler from my colleague’s desk and held it up to my iMac’s surface. Then I slowed nudged the text box into place.

For the bookmark, I had looked at the theme idea last week in some confusion. I poked around on the web and found a bunch of photos for a moodboard of sorts and uploaded it the shared drive. On Friday, my colleague wrote back that I was close, but not quite right. I took her words, spent 2 minutes googling and found a lovely stock illustration. She loved it.

Today I started the work of creating a bookmark from that image. I’ll admit, these bookmarks aren’t quite the thing of dreams. I’m a little crunched for time, so it’s more important to get them done than perfect. For this project thought, I made a dozen or so layouts with different words and color choices. Sent it over. After lunch I had my response back. I then laid out 4 or so designs for the back and sent it back. Hopefully tomorrow I’ll get the sign-off so I can mark it as done.

We’re pushing a deadline of Friday here for these ten bookmarks. I’ve gotten works-in-progress drafts for six of them now. Once staff sign off on them, I can move them to the finish pile. The goal is to have all of them back from the print shop by September 1st for National Library Card Sign Up Month.

Wanted: Help Archiving the EPA Website

I’ve found a way to make myself useful. I’m adding pages from the EPA’s website to the Internet Archive. As such, I’ve found perhaps hundreds of pages which are not archived yet. This bookmarklet is easier to use than the official one. Why? It does it within the page w/o opening a new one.

What to Do
* Install the bookmarklet above to your browser.
* Go to a page of links (like the first one in the following section) and then CTRL + left click on all the links.
* Then go through each page clicking the bookmarklet.
* When you’re done, work your way back across each open tab by clicking the back button. Then scroll down and look for additional links + PDFs.
* Close the tabs as you work your way back across them.
* Sometimes it’ll time out so you need to hit the back button, then try the bookmarklet again.

Things to Know
* If it’s a PDF, it usually downloads to your computer. Annoying. Right now I don’t know how to get those in the Internet Archives, but hold onto them.
* If the PDF is hosted online, you can click the bookmarklet to add it to the Internet Archive.
* If the website/page doesn’t allow robot.txt, you can’t add it to the Archive.
* If you notice that you’re working through pages which have been recently archived, go find another set to go through. It’s a better use of your time to find pages which have never been archived before. These random reports haven’t gotten any IA love before.

Pages to Start With
* Air Research Products in the Science Inventory
* Science Inventory pages

If you’re interested in strategically going through the EPA site with me, let me know. We can make a plan of action to go through and get the pages in.

New Micro Report: Clicks in Weekly Events Email

I still feel like I have no idea what I’m doing in developing reports, but this week’s attempt at finding meaningful information is to send a new micro report. It goes to the Head of Adult Programming and the Children’s events coordinator. I list the top 5 events clicked on per category. My ultimate goal is to help event planners be able to better predict their audiences based upon email interactions. This is part of my strategy in reducing descriptions in weekly events emails to just titles + date. If people want to know more, they’ll click through and thus provide us with valuable information.

Now if I can get a steady pipeline from people on their attendance stats…