Mobile Registration Client

In a nutshell: a mobile registration app for Evergreen (initially imagined for Android though an iOS version would be cool).  The features list includes a password screen to protect the app, and the dual ability to edit accounts on the fly.  To be clear this is not a project that SCLENDS or York County has decided to take up but I was asked to imagine what such an application could do.  I’m trying to balance the original inspiration with robust functionality but I have to admit, once you go this far it’s tempting to add features like checkin or checkout though that might also be over reaching.  I’m posting this purely in case anyone is interested.  Ultimately this is a pretty simple app and has a lot of overlap with web based solutions that others have already done.

Use cases that drove these decisions:  I manage circulation and outreach departments.  With circulation we have frequent issues with lines backing up because patron registration takes a long time compared to normal checkouts.  This is made worse by things like summer reading program hikes in activity.  We could send people elsewhere to register but they still need a lot of assistance and the layout of our building is ... well, designed for a different age of the world.  So, mobility is better but not crucial.  However, mobility is all-important for outreach.  My outreach staff go out to events like festivals, walk lines and the ability to deliver services like register patrons with a table and a mobile hotspot are extremely attractive.  Finally, I can buy a decent Android tablet event with a pen and security devices substantially less than a desktop and usb tablet.

Requirement: We have to be able to store signatures.  This is a hold up for many library boards and in fact would be nice in Evergreen itself (upon demand).  

Proposal: To do this we add a column to the actor.usr table called signature.  This would handle the storage of the actual signature.  Alternatively we could work around and use the photograph field but that would interfere with anyone who uses that field for that function.  We might be able to save either binary data of the image there or the array for a bitmap or a mathematical value of the signature curve.  (This part of the idea was inspired by a lightning talk at the conference which nicely paralleled a lot of my own thinking.)

So, let’s break this down by workflow and screen:

When I run the app the screen I am greeted with will depend upon if this is the first time I have run the app.  If it is, then the first screen I see upon initial load of the app is the password screen. The purpose of the password is to prevent patrons from accessing the settings screen when they are using the app and therefore potentially messing up any settings.  Thereafter when the app is loaded it will go to the logon screen.

First time you load the app:

Logon Screen, this is the default you see after the first time, the Settings Password Screen:

[image not loading]

Settings Screen:

After logging in a registration screen is loaded.  The settings can be accessed from there and other screens.  There are actually two registration screens - one simple self-registration screen where staffs still have to intervene to finalize the record and a more full featured one meant for staff mobility. 

Self-Registration Screen:

The self-registration screen is pretty straight forward but you will notice that it lacks a few critical things and makes some assumptions.  Required fields should be marked by some kind of symbol or background filled in color, which is based on what is required in the database.  Note that I’ve tried to make this reflect some core Evergreen conventions not be SCLENDS specific but I have moved away from the staff client registration screen in a few places where I think it makes more sense for this purpose.

When the record goes into the actor.usr from here it will leave the password blank or make it the last four digits of their PIN number if you’ve set that option.  

Juvenile is calculated based on birthdate.

Parent/Guardian should only be set by staff so it’s missing.

Internet Access level should only be set by staff so it’s missing.

Profile Permission group should only be set by staff so it’s missing but it will default based on settings.

Privilege Expiration date should only be set by staff so it’s missing but it will be default based on settings.

Barred and collections exempt default to null, not set.

Active defaults to FALSE, so that they have to have staff activate their account.

Claimed return, claimed never checked out, alert message are all null on self registration.

Hold behind the circ desk defaults to null.

Valid address and statistical categories are for staff interface only.

 The planned workflow included that the patron would hit submit at the end of entering their information and a new screen would come up that would present the actor.usr id, entered name, phone number and email address.  When the submit button was hit it inserted a new actor.usr record that was automatically marked as invalid and without a barcode.  The password would be left blank.  The staff member would use the name, id, phone number or email address to access the patron record that has now been inserted into the database.  Based on library procedure they might go directly to the record via the user id or they might search based on name or email to find inclusion in a group or merging if it is a duplicate.  Since it is a self-registration some options are restricted from the app user.  The user name will be left blank until staff adds the barcode.  At that same time the password can be added along with a corrected patron profile group.

Then the staff member marks the account valid and adds a barcode to give the patron their barcode.  Using the options screen there is an option to set the machine to staff mode and there would be a barcode scanner to immediately attach a barcode and to override some default behaviors of the self-registration.

The staff registration screen is quite different and gives direct access to everything.  It is also used when editing a record:

Staff Registration/Editing Screen: 

---------------------------------------

Evergreen Easter Egg

It's a little early for Easter I know but if you pick up the December Computers in Libraries there is a little Evergreen Easter Egg.  

I took a few photos for my article on technology trends and in the one showing an iPad as a second screen to extend my laptop's display and input I'm running the Evergreen staff client directly from the iPad.

SCLENDS Wave VI Goes Live

  I should have posted this a few weeks ago but as of October 15th we had three new country library systems join SCLENDS - Lee County Library, the Harvin Clarendon Library of Clarendon County and Lancaster County Library System.  

SCLENDS as of October 2012

SCLENDS as of October 2012

October 15th seems like a popular date, that also marked the three year anniversary of our second wave of go lives, then York County, Dorchester County, Fairfield County and Chesterfield County.  It has also been a time of reflection for me.  In that time I've changed employers (twice!) but stayed in the SCLENDS family and watched both SCLENDS and Evergreen grow.  What seemed like a calculated maneuver (with a bit of inspired madness) four years ago is now business as usual.  The scrambling of a go live three years ago is now a calm procedure.  Our own knowledge of Evergreen has changed as the software has changed and changed it has - not just in user features but under the hood too, and all for the better.

Now with Wave VI live we are almost half the state of South Carolina and have 75 locations including 14 bookmobiles and 1 kiosk outlet.  

So, I did some quick math and found that our circulation with our new libraries is up 13% in October from September, two months that are traditionally pretty similar.  Also, looking at the number crunch of pre versus post go live it shows that the increase is in the go live period after the 15th.  So, traditionally we do see a surge when new libraries come on line and then it settles down into a more modest increase.  It will be intresting to see if these increases also come from older libraries or only from new libraries which will suggest whether or not we are reaching our saturation point.  The idea of the saturation point is one I hope to work on when I do a followup to last summer's article on intra-consortial loans and include updated data with some new analysis.

Evergreen in Library and Book Trade Almanac 2012

Library Book and Trade Almanac 2012

Library Book and Trade Almanac 2012

There is an article in this year's Library and Book Trade Alamanac (57th Edition) about the consortial effect that only large scale ILSes like Evergreen can provide.  In fact, data from one Evergreen Consortium is used as the basis (SCLENDS).  I co-wrote the article with Bob Molyneux ... well, it might be more accurate that I provided data and helped revise but Bob really wrote it but I was honored to work with him on it.  I'm hoping next year to do a followup both with more SCLENDS data and data from another Evergreen consortium.  At least one other has already promised me data!

http://www.amazon.com/Library-Trade-Almanac-Bowker-Annual/dp/1573874396

New CiL Article Referencing Evergreen

The new issue of Computers in Libraries (May 2012) features articles about curation and collections.  My own article about de-duplication 10% Wrong for 90% Done: A Practical Approach to Collection Deduping approaching bibliographic was not only selected as a feature but their freebie available directly on the web.  So be enticed, buy the magazine.  Actually, I have a fairly high opinion of Computers in Library compared to the other outlets that dicuss library technologies.

Anyway, in it I discuss the approach we within SCLENDS choose to handle bib dedupping and build a solution that was economically feasible, was positive customer experience centric and could be implemented fairly quickly.  As an Evergreen consortium already live timeliness was important to us.

Although I didn't post about it at the time, I should mention that since the article mentions me at the South Carolina State Library I have now actually moved to York County as their Manager of the Headquarters Library and Reference Services.  It is nice to be back in thick of public service including children's and outreach which I've dealt with less since I worked more with reference and circulation staff at the State Library (though those are among my departments now too).  I am still working with SC LENDS though and have been retained to continue my project management duties there.

A Tale of Two Presentations

As I write this I’m guessing that the last stragglers of the morning after the conference are winding out of the Hyatt and away from Indianapolis.  Another Evergreen International Conference is in the can and cleaned up.  The folks from Evergreen Indiana did a wonderful job.  And I want to thank Shauna for the great job she did coordinating and all of the other great staff whose names I don’t know off hand.  

I and two others were elected to the Evergreen Oversight Board for the next three years.  We made absolutely no campaign promises so we’re already doing better than most political bodies.  None of the elections were unanimous which is good but I wish there had been more candidates and more contention.  It might sound odd for someone who wins an election to be wistful for more people not wanting to elect him but an engaged community will have opinions and disagreement.  Uniformity of opinion is often a disguise for apathy.  However, I am excited to be elected and think we have a lot of good to do in the next few years, much of which was discussed at the community meeting and more will come.

However, what I’m thinking about right now, among the many take aways I’ve had from the conference, has to do with two of the conference sessions I was involved with and thinking forward to next year.  

One presentation, that I did on Friday, was a panel discussion and Q&A entitled “There and Back Again: A Journey in Handling Evergreen’s Network Needs.”  I did this with Galen from ESI, Genevieve from Bibliomation and Chris from GA PINES.  Despite us having no practice and only a brief review of the slides together it went really well.  Not only did we all have something of value to say (I think) but the moderating and handing off went really well as did the questions.  We ended exactly on time and we had a great time keeper.  That’s a harder job than it looks, really. 

The presentation can be found here : http://www.slideshare.net/roganhamby/there-and-back-again-the-networking-needs-of-evergreen but it basically consists of a few ice breaker slides and prompts for the discussion.  I wish I had been able to record the sessions and have resolved to bring a good microphone in order to do so next year.  By the way, if you want to see the “special” slides you’re out of luck - those have been removed - conference attendees only.  What happens in Indianapolis stays in Indianapolis.   

Now, I want to contrast that experience with Thursday’s “Everything A SysAdmin Needs to Know About Cataloging But Was Afraid to Ask.”  Even going in my co-presenter and I had basically built two presentations - one from the culture of cataloging side and one from the technical details of catalogs side.  Then, we decided to open the door to questions and really push for those from attendees.  And that is where it both went really well and really wrong.  The questions were great.  Engagement was great.  We got a lot of information out to a lot of people.  The bad?  It wasn’t the people we intended to be our audience or the information we wanted to provide.  We were hijacked by really nice people with really valid questions though it wasn’t where I imagined the questions being asked.

Essentially, we had a lot of catalogers attend who needed to ask questions about cataloging - a little bit about work flows, a little bit about where functionality is and a lot about where functionality is going.  I’m glad to have a forum for that discussion but it’s not what that forum was intended to be.  So, I’m resolving that next year that I’m going to try to give this another go as the feedback indicated to me that the topic does need to be done and from the IT folks that talked to me afterwards I learned even more about how to gear this discussion.  However, we also must have the cataloging forum that it obviously became and I’m convinced that the same format that we used for the networking panel would be perfect.  

So, I’m committing to trying to get two presentations onto the schedule next year.  One, I will present, maybe with someone else, and it will be version 2.0 of the cataloging / Evergreen for IT folks presentation and I will be party to it.  The second, I simply want to bully the right folks into doing but I probably won’t be a member of and that is The State of Cataloging and Acquisitions in Evergreen.  I have already gotten a commitment from one technical services and acquisitions person and I’m hoping to get similar commitments from one or two others and one developer.  

So, already thinking about 2013 in Vancouver.   See you there.

Evergreen 2.2 Features

As we start looking from 2.1 to 2.2 I'm interested in looking at the new features.  ESI has been great about having Sally Fortin document new changes but I suspect these are primarily the result of ESI's specific contracted work.  There are a lot more changes however from bug fixes, to under the hood improvements to major changes not from any specific contracted source.  

So, this PowerPoint is a result of taking the work Sally has done and simplifying the documentation.  Sally documented the configuration and uses of the new features while most of these slides only cover what the new features are.  

Evergreen 2.2 New Features as PowerPoint

Evergreen 2.2 New Features as PDF

A Practical Approach to Bibliographic De-duplication

De-Duplication Project

[ This is a duplicate of what I posted on sclends.net/projects/ ]

Early in the days of SC LENDS we faced the challenge of strict bibliographic de-duplication methods leaving our catalog messy for both staff and public. The issue wasn’t aesthetic but affected the services and workflow we offer. Unwilling to accept the common wisdom that we had to live with it we developed our own solution. The documents below give our history with the project and the code developed for it.

This is the presentation done at the Evergreen International Conference on the project and is the story of the project:

10% Wrong, 90% Done: A Practical Approach to Bibliographic De-duplication
http://sclends.net/wp-content/uploads/2011/09/10PercentWrong.pdf

This PDF describes the technical aspects of the project:

Bibliographic De-duplication Based on Narrow Data Element Matches Between Records
http://sclends.net/wp-content/uploads/2011/09/SC_LENDS_De-duplication.pdf

This is the actual SQL code developed by Equinox for us:

http://sclends.net/wp-content/uploads/2011/09/sclends_dedupe.txt

10% Wrong 90% Done: A Practical Approach to Bibliographic De-duplication and Bibliographic De-duplication Based on Narrow Data Element Matches Between Records are both licensed by Rogan Hamby and Shasta Brewer under:

Creative Commons LicenseCreative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

Open Source Reality Check

Library Journal just published an article they interviewed me for entitled Open Source Reality Check.  

http://www.libraryjournal.com/lj/home/891350-264/open_source_reality_check.html.csp

Over all, I thought it was one of the more balanced and fair articles looking at open source from a high level perspective that I've read in main stream library journals.  Open source isn't perfect, it's a human endeavor after all but it is a proven model though indivdiual projects can fail.  The article spends a lot of time looking at KCLS, which is to be expected.  The bit they quoted from me was me discussing, and dismissing, the idea that open source is somehow magically less stable than commercial software.  The factors that make an open source project stable have to do with scale, which is also true of commercial software - it is the metrics that vary.  

Oh, and they got my place of employment wrong.  I was at the time of my LJ Movers and Shakes award with the Florence County Library System but I'm now the Director of IT and Innovation for the State Library in SC.