or, The Hitchhiker’s Guide to Fear and Loathing at a Public Library Reference Desk


Reference Question of the Week – 3/1/15

   March 7th, 2015 Brian Herzog

powerpoint-printanimationsThis question wasn't all that difficult to answer, but I thought it was interesting in that, it's something I didn't know before and for some reason feel a little bit better for knowing now, kind of way.

A grad student patron had been at one of our computers for awhile, working on a Powerpoint presentation for a group project. She'd asked me a few various questions over the course of maybe an hour, but then came up very frantic.

It turned out one of her team members had added a bunch of animations to their presentation, and now that she was finished adding her part and was playing the slideshow to see how it all looked, none of the animations were working. She said they had worked for her at home, but our computer was not displaying them.

I don't know if Powerpoint has a setting that would block animations - or if there was one, that our computers set that way - but then in the course of talking about it with her Powerpoint suddenly crashed.

She was surprisingly calm about that. I knew she had it saved so there was no danger of losing anything, but usually when something isn't going well, anything out of the ordinary escalates stress quickly. However, she saw the crash as a positive thing - her logic was that Powerpoint on this computer must be glitchy, which would account for both the crash and not playing animations (as opposed to the idea that something was wrong with the presentaiton and that's what caused the crash). Now this is my kind of patron.

Anyway, here comes the reference question:

At this point she said she no longer cared about playing the slideshow, and all she wanted to do was print a copy for her professor to have during their presentation. However, how do you print slides with animations? Good question (and much more reasonable than the patron who asked how to print a YouTube video).

Apparently her team member created one slide where the animation was four different graphs replacing each other (instead of just creating four separate slides). Only one showed at a time during the actual presentation, but looking at it in normal edit mode, all of them were superimposed over top each other.

It seemed logical that Powerpoint would have a "Print Animations" option, so I went online to look for the solution.

From what I gather, Powerpoint 2007 (which we have on our workstations) does not. However, you can still do it, but it's a bit of a manual process. The answer I found was this:

  • click on the "home" tab
  • go to the far right and click on "select" (it is located in the "editing" box on the far right)
  • (for me, a dropdown box opened and I chose Selection Pane)
  • the "visibility panel" will open up showing you the animations for the [slide] you are on
  • just hide each [animation layer] at a time and print them out

See the image above for this Powerpoint pane (or try it yourself!).

Although a manual process, this worked extremely well. You can show or hide whichever layers you want by clicking the little eye icon, so the patron was able to always show the slide title, and toggle off/on each chart and print them pretty quickly.

She was extremely happy with me - although still annoyed at her team member for making all this necessary.



Tags: , , , , , , , , , , ,



Reference Question of the Week – 6/9/13

   June 15th, 2013 Brian Herzog

Wednesday is my night to work at the library, and a couple hours before we closed I got an email from a coworker that just said,

I just took a picture that I think will be perfect for your blog. Ask me about it before you leave.

I had no idea what this might be, but at the end of the night, this was the picture from her phone:

patron kneeling at the Reference desk

She found this amusing because it looked to her that this patron was so desperate for help that she was willing to kneel before the desk (and pray?).

That is a funny thought, but when I explained to the rest of the evening staff what was really going on, they were even more amused.

So: around 2:30 that afternoon, a woman called in asking to reserve a study room for 7-9pm that evening, because she was proctoring a test for a student. No problem. Not 30 seconds after I hung up the phone, it rang again, this time a different woman asked to reserve a study room for her daughter, who was taking a test with a proctor.

I was quick on the uptake and asked if her daughter's name was the same one the proctor just gave me, and it was. Which, really, is just a funny little aside, and didn't really portend the communication difficulties to come.

The evening passd unremarkably. Seven o'clock rolls around and the proctor and student show up for their room.

About seven-thirty, the proctor comes out to the desk to ask if there is a way for her to print from her iPad. This perked me up a bit, because wireless printing is still new to us, and I am always happy when I can show it off. I gave her our little how-to handout, which she was satisfied with and went back to the room before I could help her with it.

About ten minutes later she was back, asking for help - and she was at the desk for the next half-hour. Here's what was going on:

  • It turns out, she was proctoring a test for a foreign exchange student from Australia. The test the girl was taking had been emailed to the proctor, as a password-protected PDF (two of them, actually)
  • She couldn't email the test to our wireless printer because it was a school iPad, and apparently could only send outgoing mail when it was connected to the school's network (this may or may not be true, but her email was definitely not working, and I wasn't going to change any of her school's settings playing around)
  • After we got the wireless printing app installed, we still couldn't print because the PDFs were password protected, and the app just kept saying it couldn't access the file (but gave no provision to enter a password)
  • She couldn't log into her school email from any other computer, because she couldn't remember her webmail password, and had left her school laptop at school

Sometime during our conversation, she also relayed that the test this girl was taking was some kind of Australian standardized test, which all Australian students must take - and must take at the same time. Which, of course, is Australia time, hence why they were in the library so late. Of course, the clock had already started, and we still hadn't even managed to print it yet.

The proctor was frazzled, the student was frustrated, and I, being functionally illiterate when it comes to Apple products, was running out of ideas.

But I know that if you start tapping things on an iPad other things happen, so this became my new strategy. When we just opened the PDF, it launched it Adobe Reader, which had limited export options*. However, at some point one of us noticed that her email had the option to move the PDF to iBooks, so we tried that.

Playing with it in iBooks, we found an option to email it with her personal (non-school) account, which miraculously did work. She emailed it to my library email, I opened the file at the desk, she entered the password, and thank goodness it printed okay. Repeat for part two of the test, and the girl was quickly to work - by about 8:20 pm.

All of this really was an ordeal to get through, compounded by the fact that the longer we screwed around, the less time the student had to take her test. My coworkers all appreciated this, and one remarked that she now understood why the woman was kneeling at the desk.

But no, that's not the reason. The proctor's shirt happened to have a very loose and floopy neckline, and if she leaned over towards the desk in the slightest, she'd be putting on quite a show. So, the entire time I was working with her, she kept using one hand to hold her shirt closed. And I don't know if you've tried it, but it is very difficult to try to operate an iPad while one hand is preventing a wardrobe malfunction.

Eventually, she just gave up and knelt in front of the desk, because at least that meant she didn't have to lean over. That was the point at which my coworker walked by.

So, amusing yes, but the story isn't quite over. At 8:55 pm I went to the study room to let them know the library was closing. Since I knew the student got a late start, I was going to offer to stay a bit past 9:00, if she needed just another ten or fifteen minutes to finish up.

The proctor said she appreciated that, but the test had another three hours(!) to go. Holy smokes. This town pretty much rolls up the sidewalks at 9pm, so I really have no idea where they were going to go to finish this test. I felt bad for them, but they were just happy to have the printed tests and said they'd figure something out.

And speaking of figuring something out, here's something I can't figure out: so, foreign exchange students usually go to the host country by themselves, right? So, when this student's mother called to reserve a room, she must have been calling from Australia. Huh.

 


*One option I never ruled out was opening the test on the iPad and just photocopying the screen. Luckily, we never had to implement this.



Tags: , , , , , , , , ,



Print From Anywhere to the Library

   March 27th, 2013 Brian Herzog

PrinterOn: mobile printing solutionLast week's reference question reminded me to post about a new service we've just started offering in my library - wireless "print from anywhere" for patrons.

We use Envisionware's LPT:One for our pay-for-print station in the library, which does have wireless capability. But patrons need to install a driver on their laptop, and only really works within the library - which is great for people printing from their own laptops, but we were hoping for more.

A couple nearby libraries were using PrinterOn, and that's what we decided to go with. It is web-based printing, which lets people really print from anywhere - the library, home, the coffee shop in the Town center, their smartphone while standing on the sidewalk, Canada - anything that can get to the internet can now send print jobs to be picked up at my library. Pretty neat.

Getting it Set Up
Of course we kept LPT:One for printing from our public workstations, because it works really well. Our initial intent was to integrate the wireless printing with our existing pay-for-print station, so it would be totally self-serve for patrons. However, when we spoke with our printer/copier management company, the cost of integration was prohibitive (about $4,000, mainly to update the hardware already in place) - especially for a service that we had no idea how much use it would get.

So we decided to do it the cheap way and run everything out of the Reference Desk. We lose the self-service aspect, and staff have to release each print job and manually handle patron payments, but it was worth it for a trial (and, if use justifies the $4,000, I'm sure we can negotiate with the print management company later on).

The PrinterOn software works well and was easy to install. There was a $200 setup fee and about a $500 annual subscription (roughly - and our Friends group provided the funding), and PrinterOn tech support installed everything we needed on our existing network server. The only other cost was that we bought a new printer, because we wanted to offer B&W and color, single- and double-sided printing, all from one printer. The printer we chose was the Xerox Phaser 6500, which, so far, has been just fine.

How It Works
To use it, patrons start at http://www.chelmsfordlibrary.org/webprint, and it's pretty straight-forward. You can upload a file from your computer or print a website, choose between B&W/color, single- or double-sided, and page orientation. Patrons both name their print job and get a job number, so we know which is theirs when they pick it up. There's also an option to print from email - you just email an attachment to our "print" email address (provided by PrinterOn), and the software knows to add the attachment to the print queue.

When patrons come to the Reference Desk, we log into the print queue and locate their job, hit print, and then calculate cost X number of pages after the job prints. We charge $0.15 for B&W and $0.25 for color, and charge based on pages - so, printing double-sided still only counts as one page. We also set it so jobs stay in the queue for 72 hours - after that, they automatically disappear.

Promotion and Results
We've got handouts for in-library promotion, and we're going to try to leave them at other likely spots around town - coffee shops, hotels, etc. It's fairly simple, but anyone is free to use and adapt it for your library if you like:

We launched this service about two weeks ago, and I have been shocked at how much it's been used so far - about once a day, at least. When it was ready, I added a link to our homepage (and mobile and Library Anytime sites too), and we put it on Facebook and in our weekly email newsletter. The next day three different patrons casually picked up print jobs, as if we'd been offering it for years.

But best of all, all patrons have figured out the interface, and no one has had any trouble sending print jobs.* The whole thing couldn't have gone more smoothly, and I love offering library services people can use from home.

 


*We did encounter one Acrobat PDF that the system couldn't handle - a complex text form that had a special print button built in, but we sometimes have trouble with PDFs on our public workstations, so I can't fault PrinterOn for that.



Tags: , , , , , , , ,



Reference Question of the Week – 3/17/13

   March 23rd, 2013 Brian Herzog

PrintFriendly logoOne of the most common questions we get at the Reference Desk is something along the lines of:

I tried to print something, but all I got was this blank page. Can you print it for me?

The reason this happens (I think) is that a lot of web pages - especially news sites and free email accounts - compartmentalize information using frames*, and many web browsers have a difficult time trying to print all these different frames at the same time.

When patrons try to print a page like this just using the browser's File > Print function, it often doesn't work. The page designers know this, so they usually embed a little printer icon somewhere within the content frame the person wants to print - the body of the email, the news story, etc. It generally seems to appear in the top-right corner of the content window, and when you click it, opens the important content in an entirely new window that will print nicely. However, it is often so subtle that people never notice it.

But check this out: I stumbled upon PrintFriendly by accident, and I love the idea. It is specifically designed to make printing these annoying pages easier. You can copy/paste in the URL of the page you want to print, it grabs the content, and then you have full control over which parts of the page actually print - it lets you remove anything you don't want.

What I thought was even more useful is their bookmarklet that you can stick right in your browser - that way when you want to print a page, the PrintFriendly button is always right there, instead of having to mess with copy/pasting the URL. Neat.

Since finding this, I've been testing it every chance I get, and it seems to work about 90% of the time. Usually, exactly what I want to print is the only thing that shows up. But even when extra sidebars and things do show - like in this Lowell Sun newspaper article (source) - PrintFriendly makes it so easy to remove all the junk (just click on whatever you want to delete). This means the good content fills the page (a single page), instead of being a very narrow column four pages long.

It didn't work everywhere though. For instance, Zap2it.com listings seem to print much better the normal way than through PrintFriendly.

A few more neat features: once you render a page to print in PrintFriendly, it gives you the option to print, create a PDF, or email it. Very handy.

Of course, my first thought was to put the bookmarklet in all the browsers on our public workstations. This still might be a good idea, but patrons will need to be trained to use it, which will be a challenge. Everyone is so conditioned to File > Print, and usually people don't know something went wrong until after they've paid for their print job (why doesn't anyone File > Print Preview?!?).

So for the time being, this might just be a handy tool in the librarian toolbox (but I do have it installed on my computer).

I have no idea how long PrintFriendly has been around, so I might be the last person to know. Has anyone been using this? I'm curious to see how well PrintFriendly works on a wider array of websites.

 


*Frames is an HTML way of embedding multiple "windows" into the same webpage. The best clue for knowing whether or not there are frames on a page is to notice if there are scroll bars inside the page. There will always be the main vertical scroll bar all the way on the right edge of the browser window (for pages longer than the screen), but sometimes there are additional vertical scroll bars in the page itself, that just moves some content in a little window. This is a frame, and may or may not print when you print using the browser's File > Print functionality.



Tags: , , , , , ,



Reference Question of the Week – 9/4/11

   September 10th, 2011 Brian Herzog

This week's question is one we get asked many times a day - it's not difficult at all, but this time had a sort of heart-wrenching twist.

A woman in her early twenties walked up to the desk. Very politely, and with a little hesitation, she asked:

I just printed something for my school, but I don't know where to pick it up. Can you please help me?

For public printing in my library, we use Envisionware's LPT:One, which works well for us. All the print jobs from our public computers go to a central print release station, where patrons pay for their job before it actually gets printed. So that patrons know which print job is theirs, when they print they get prompted to name their job:

Envisionware Print Box

Once a patron goes through this once, they understand how it works. But the first time isn't totally intuitive, so we do get asked for help in printing frequently.

My personal rule is this: if someone asks me where they pick up their print job, I take that to mean they've never printed here before, so I go with them over to the print station and walk them through the steps to pay for and release their print job.

That's what I did in this case, and while walking over to the printer, I asked the patron if she had entered a name for her job. She replied,

Well, a little box asked me to name my job, so I typed in "waitress."

I don't know why this struck me as so sweet and sad - maybe her innocence and naivety, maybe the idea of someone working their way through college. Maybe I'm just getting sentimental in my old age. She didn't mean anything by it though, so when we got to the print station, I showed her how to select the job named "waitress" and print it out. She thanked me and left.



Tags: , , , , , , ,



Printing Books on Demand

   November 17th, 2009 Brian Herzog

POD Printer at Harvard Book StoreA couple weeks ago I posted about new options for printing books, in which I mentioned Google's Expresso book-on-demand printer. I found out that the Harvard Book Store in Cambridge has one, so I went to check it out.

I still really like this as a source for out-of-print books to fill out a library's collection, so my "test book" was The History of Chelmsford, written by Wilson Waters in 1917. My library has lots of copies of this, but I chose it because:

  • I knew it was in Google Books
  • It is huge (almost 1000 pages) and I wanted to see how well the book-on-demand printer handled it
  • It has text, maps, illustrations and photographs, and I was curious to see how they reproduced

The people at the Harvard Book Store were incredibly nice and informative. I told them who I was and what I was doing, and the owner Jeff and shop assistant Amanda explained each step of the process to me, as well as told me about their experience so far with the service.

Typically, the process (photos) is completely automated and books take less than ten minutes to print start to finish (including download time), and cost $8 (which is the price announced by Google in a press conference, so the store is honoring it). However, since the book I wanted was so long, everything was expanded: downloading alone took five minutes, and it had to be printed in two volumes, because the printer can only handle about 500 pages at a time. Since it had to be divided, Amanda had to find the best place to split the book, and then do some quick calculations to figure out how thick each textblock would be to make sure the covers fit properly. And due to the extra labor involved, my two books cost $10 each, with the whole process taking about 40 minutes.

A few other interesting points:

  • There were no ghost hands, but some of the pages were not cropped correctly - this caused them to be shrunk when printed, and in some cases the page numbers got trimmed off
  • It seems like the quality of the printing was excellent - the only real variable is the quality of the scan
  • The paper they use is acid-free and feels slightly glossy. I asked how long they expect the paperback covers and binding to last, but it's so new they're not sure
  • Color is only available for the covers - book pages are b&w only
  • I asked if they consider themselves "the publisher" for these books, and the answer was no - they are "the printer" because being a publisher involves more legal responsibility for the content of the books
  • Jeff said they've had the printer for about a month and a half, and it is used three or four 15-40 times a day (which was more often than I expected, but then again, the store is right across the street from Harvard. Nerds.)
  • Their catalog interface doesn't just search Google Books, but allows the printing of any book in the public domain, as well as self-published books
  • I don't want this to sound like a commercial for the store, but Jeff said he'd be interested in working with libraries - contact him for details

I tried to photograph the interesting parts, so check out my Books-on-Demand Printer flickr set or watch the slideshow below:

Related



Tags: , , , , , , , , , , , , , , ,