Archive for May, 2008

Migration Issues

Wednesday, May 28th, 2008

 

As the current Sunline libraries migrate to their new automation vendors, data that is specific to each library (items, borrowers) as well as system-wide data (Bib records) must be copied out of the Sunline server, reshaped to fit the new environment, and loaded onto a new library server.  In addition for some Sunline libraries, new connections must be established between the new server(s) and our local SIP and RPA servers, so that your patrons can continue to access electronic materials from their home PC’s, and so that the third party services you have purchased (e.g. Self Check, PC Reservation) can continue to function in the new environment. And, the closed period between your last day on the current system and your first day on the new system must be managed. For example, we don’t want any checked out items to be due during that period, and we don’t want patrons to place holds on the current system, after the final data extraction.
Here—in no particular order—are the specific issues we’re addressing, whom they affect, and what we are doing to stay on top of them.

Closed Period Due Dates
Polaris: Checkouts done on the current Sunline system will carry over to Polaris, so we do not need to create “fixed and final” due dates. We will make July 28 through August 4 ‘closed days’ in Sunline, and the system will simply advance the originally calculated due date to the next open day.

Koha: Because the migration will occur between semesters, there will be a clean break for the Academics. We will set fixed and final due dates, as we do every year.

New Port Richey: We don’t know yet how we will handle this, as we do not yet know which vendor New Port Richey will migrate to.

Subscription Database Access

Subscription databases identify valid users in two main ways. They look at the IP address of the computer that is trying to connect, or they can check a validation server. As each library moves to its new system, its IP address will change. We—TBLC staff and library staff—will need to compile a list of the subscription database vendors and provide each of them with the new IP addresses and the date they will become active. Presumably, then, they will accept searches from computers with the new and different IP address. RPA is an intermediary. When a patron at home wants to search a subscription database, he comes to the RPA server first and is asked for his barcode. RPA looks that barcode up in the main library database and, if it is good, passes it on to the subscription data base with an “OK” stamp. RPA will need to be told the new IP addresses, so that at the appropriate time it can go to the correct server to validate remote borrowers. In most cases your new vendor will provide you with or help you find a substitute for TBLC-managed RPA.

SIP

Like RPA, SIP is a process that uses an intermediate server (housed here at TBLC) to validate a patron for a specific purpose. It may be for self checkout or to reserve a public access PC or for some other purpose. The patron’s barcode is keyed in or scanned at the library and is sent to the SIP server. The SIP server does a barcode lookup in the patron database and sends a response back to the device at the library. Like RPA, SIP has to know where the patron database is, so we will have to give it the IP address of the new server at the time of the transition. Again, SIP services will probably be a part of your new vendor’s package.

DebtCollect and Unique Management

Four Sunline libraries currently use Debtcollect and Unique Management. Three of them are migrating to Polaris. Unique tells us that they can work with Polaris as easily as they can with Horizon, and that nothing special needs to be done for the transition. The fourth user is New Port Richey, and we do not yet know how their migration will affect their use of Unique Management.

iBorrow

There are a large number of iBorrow issues that come out of the migration.

1. Duplicate barcodes. The problem of duplicate item barcodes has come up with PALS in the past, but it should not come up in relation to iBorrow. This problem would occur if a library that migrated into the PALS database brought with it an item that had been borrowed (e.g through OCLC) from an existing PALS library. The copy attached to the brief record for the borrowed item would have the same barcode as the original item in the PALS database. Since iBorrow has not so far been able to communicate with Polaris, the PALS Polaris libraries are not part of the iBorrow network. So, no PALS items will have come into our Sunline system through iBorrow. Items borrowed through traditional ILL mechanisms and entered into the Sunline database with their original barcodes could cause this problem. But not iBorrow.

2. Use by patrons prior to the closed period. Patron searches in iBorrow and ILL staff work in the URSA client are both done on a server in Utah that is unaffected by the migration. When a Sunline library fills a request for another library system through iBorrow, that item is checked out to a dummy patron in the Sunline database, while it is on loan to the ‘foreign’ borrower. To Sunline, this is a normal checkout, and it will carry over intact into Polaris. Fixed and final due dates for the libraries going to Koha will prevent any issues there. Generally speaking, there is no technological reason to restrict patrons’ use of iBorrow prior to the closed period.

3. Use by patrons during the closed period. Sunline patrons who use iBorrow are, by definition, getting materials from other libraries, and these libraries are not affected by the Sunline migration. I see no reason to restrict the Polaris libraries ability to initiate requests in iBorrow during the closed period. The Koha libraries will probably cease to use iBorrow after they migrate, because Koha does not have an NCIP responder iBorrow can talk to. We can’t yet address how this will be handled with New Port Richey.

4. Use by patrons after re-opening. Like SIP and RPA, iBorrow stores an IP address for a library and communicates with it at that address. We will have to change the IP addresses for the Polaris libraries in iBorrow. This will take about 2 minutes per library. The bigger post-migration issue is that–as of mid-May–Polaris can handle only one of the eight NCIP messages that iBorrow uses. Fortunately, it is the most critical of those messages: the one that enables patrons to validate and request. We are making progress with Polaris and may have many or all of the working by the time of final migration.  At present, Koha and iBorrow to communicate at all, so we’re not optimistic about the academics being able to continue to participate.

Overdrive

There are two migration-related issues with Overdrive: titles available and patron validation.

We need to make sure that any titles to which Polaris patrons have legal access are copied into the new database, if they are not there already.

Overdrive also uses RPA to validate borrowers. Our RPA server will not move nor change its address, so the change of home server should not matter to Overdrive, so long as they can find our RPA server and our RPA server can find the new Polaris server.  Again, new RPA or RPA-like services provided by your new vendors may eliminate any need for RPA in relation to Overdrive.

Suncat display
This is a pre-migration issue. To prevent problems after the migration, we are restricting our users’ ability to place holds on titles their home library or library group does not own. Because everyone’s items have been available for holds until now, everyone’s holdings display on many Suncat screens. This leads patrons to attempt a request, only to be told they are not allowed to do that. Matt and Al will work on redesigning the Suncat screens for specific libraries, so that only those titles that are ‘locally owned’ will be visible. This may help, but there are limitations. Anyone who searches from home and uses

http://ipac.tblc.org will see everyone’s material, because this is the ‘all libraries’ interface.This is the first ‘draft’ of this message. I expect that there will be additions and corrections.   If you have any, contact me at TBLC by phone or email.

–Al Carlson
 

 

 

Just what I’ve always wanted!

Friday, May 23rd, 2008
You’ve all heard the question, “What do you get for the person who has everything?”
To find out, we just called her up and asked her.  (We’re good at getting unlisted numbers)  To our surprise, she said, “I’d just love to have an iBorrow T-shirt!  I look so good in black.  And, despite my have-it-all reputation, I don’t have one of those.”
Well, we may grant her wish. But, frankly, we’d rather give you first dibs on one of these rare and soon-to-be-priceless items.  You’ve worked with iBorrow. You’ve sweated over it and cursed it and whispered sweet nothings in its ear to make it behave. You deserve something special.
And for the price of an email, you can have it.  (While supplies last, of course)
Send your email message to Vickie Frost (frostv@tblc.org) and tell her what size you’d like (Medium, Large, or Extra Large) and which library you work at.  She’ll send you your own personal shirt in Delivery.
It’s that simple.  Really.  Even Billy Mays can’t give you a deal this good.

But don’t delay! Ms. Has-it-all-but-wants-more keeps calling us back to ask why she hasn’t gotten hers yet.  And she can’t even spell iBorrow.

 –Al Carlson

 

 

 

 

 

New iBorrow Build: Test Drive Results

Monday, May 12th, 2008

The latest build of iBorrow was installed on our server in Provo Friday evening, and we tested it over the weekend.  Our assessment so far is that it passes the test nicely.  Here’s some detail.

Java 1.6 compliance:  Yes.  No problems at all.

Faster “Edit Request” response:  Well, maybe.  A little faster, I think.  It’s not yet what you would call ’speedy’, but if you can set up a three way race with MS Vista and a glacier as the other two competitors, you can bet on URSA.

Proxy Request Improvements:  The patron’s barcode is now readable as you type it in.  Yayyy!

Incoming Loan to Fill Loan:  This one is lovely.  It is still true that URSA can’t place a hold on your local system, if it can’t give your server a single unique bib record to request.  That is why ISBN’s are so important.  But there are several other things that can drop a request into your Incoming Loan box, even if it has an ISBN.  Most of these are transient.  So, if you could try again, the hold would take.  The new build lets you do that.  If you go to your Incoming Loan space and find requests there with ISBN’s, you can right click on each request, choose Process Request, and watch it go to Fill Loan.  That’s not the important part, though.  The important part takes place in your server, where a Hold gets placed, and a copy will show up on someone’s pick list tomorrow morning.

More Detail in History:  I’ll send this out to you as Email and attach a spreadsheet Holly gave us.  When you edit an item now and look at its History, you (and SirsiDynix Support) will see a lot more information.

Availability Rules and LOLR Issues:  These weren’t really testable over one weekend.  Time will tell us how much closer to ‘perfect’ iBorrow/URSA is at following the Availability Rules and properly routing requests that run into LOLR issues.

As we learn more, we’ll share it with you.  And I trust you to tell me when you find something that doesn’t work.

–Al Carlson

Testing the New iBorrow Build

Saturday, May 10th, 2008

It is Saturday evening, and so far the new build looks good.  Very, very good.  It has been well behaved in all the tests I’ve done so far, and the new features just add to the good feeling.  Like having the vinyl in your car replaced by hand sewn leather.

The neatest trick is being able to go into the Incoming Loan work space in the client, find a request there with an ISBN, right click and ‘process’ it, and have it show up in Fill Loan.  With a hold placed in the local system.

I used this a lot on Friday evening, because both Hillsborough County and Sunline have been ‘resistant’ to iBorrow requests for the past week.  Both issues were resolved Friday afternoon, just before the new build was loaded, so there were LOTS of requests hanging around, eager for a chance to create a real Hold.

It also runs nicely with Java 1.6.

We’ll keep testing and keep you informed.

–Al Carlson

Migration Preparation–Limiting Patron Holds

Friday, May 2nd, 2008
As we get closer to the day the Sunline libraries migrate to your new systems (Polaris, Koha, and ‘To Be Announced’), we want to reduce the number of borrowers who have ‘foreign’ items checked out to them.
If Tom from Tarpon Springs has an item owned by Florida Southern in his hands when the final data extraction takes place, both Polaris and Liblime will be confused afterwards, because Tom won’t exist in the Liblime Koha database, and the overdue item he has behind the couch won’t exist in Polaris.
So, I put a number of rules in place today to limit whose items could fill whose holds.  Hold on tight. This gets a bit complicated.
If you are a Clearwater Christian College borrower, any hold you place in Sunline from now on can be filled only by an item owned by CCC.
If you are a Florida Southern College borrower, any hold you place in Sunline can be filled only by an FSC item. (This rule has been in place for a few weeks now, but I’ll list it here anyway)

If you are a Southeastern University borrower, any hold you place in Sunline from now on can be filled only by an SEU item.

If you are a New Port Richey borrower, any hold you place in Sunline from now on can be filled only by a New Port Richey item.

(Pause for dramatic effect)

If you are a borrower at Dunedin, Largo, Oldsmar, Safety Harbor, or Tarpon Springs, any Sunline hold you place from now on can be filled only by an item owned by any of the libraries migrating to Polaris. In other words, holds can still be filled among those five libraries just as they always could among the larger group. Those holds will behave as though New Port Richey and the Academics (Wouldn’t that be a great name for a rock band?) had vanished in the night, leaving only the Pinellas Publics behind. I can do this, because (Polaris tells me) those holds queues will be preserved and reassembled in the new system.

Got all that?   Want to read it again?  Good.  Let’s go on.

“Caveat” is Latin for “Gotcha!”  And there are some caveats to tell you about.

(1) This is one complex set of rules. I may have formulated them perfectly on the first try. And I may be the long lost heir to the throne of Pottsylvania. But I will not be surprised if errors crop up. Or someone else winds up on the throne. If you or your borrowers encounter weird stuff while placing holds, tell me.

(2) If things go as we hope they will with Polaris, the New Port Richey borrowers and the Clearwater Christian College borrowers will be part of the migration and will wind up in the PALS database as reciprocal borrowers. They will also be on their own new systems, of course. So, in theory, I could have tweaked the rules to allow those groups to be part of the Polaris Public group for requesting purposes, although their parent libraries would still be off limits to the borrowers in the Polaris Publics group. At present, I have decided not to attempt that level of rule complexity. If the rule set I put in place today works perfectly, and if we get hard data on what will happen to those borrowers during and after the migration, I can revisit this. But not right now.

(3) Keep in mind that Holds are placed at the Title level and filled at the Copy level. You don’t place a hold on the Dunedin copy of Dracula in Suncat. You place a hold on Dracula, and you get the first available copy. Which may or may not be Dunedin’s. So, depending on how many copies of a title there are in Sunline and who owns those copies, my new rules may stop a hold from being placed at all or they may not. If you are a CCC patron and try to place a hold on Dracula, you may see lots of copies and be unable to place a hold, because CCC owns none of them. If CCC owns one copy, you can place a hold. If that copy is out, and all the other libraries have copies on the shelf, you may be surprised by how long it takes your hold to be filled. Because none of those on-the-shelf copies at Oldsmar and Safety Harbor and so on can fill your request. Only the CCC copy can.

Got a headache, yet?  I do.   So, I’ll stop here and we’ll see what happens with Holds over the weekend and coming week.  I’d like to say, “If you run into problems, call Matt”, but that wouldn’t be fair.  Call me.

–Al Carlson

 

New Players Added; Some Current Players Sidelined

Thursday, May 1st, 2008

You may want to take notes.  There is a lot happening right now.

Lets start with the good stuff.  Citrus County is now an active iBorrow participant, and Collier County will join us on Monday morning, May 5.  Did I hear an Ooooo! or perhaps an Ahhhh!?  Well, I should hope so.

Both systems are easing in rather than jumping in, so here are the complications.  Citrus will begin by lending only.  Thats right.  Citrus County has been added to your list of lenders, and you should find yourself getting loans from them any day now.

For a while, they will request only out of Tech Svcs HQ.  These will mostly be staff tests, but for real items.  No more sandbox testing for them!  When they get used to that and work out any bugs, they will open it up to Reference Desk staff as a tool Reference can use when the patrons needs suggest it as the best option.  When that is going smoothly, theyll open it up to their borrowers for direct access.

Collier County will be doing pretty much the same thing.  They will begin lending right away on May 5.  But they will ease into borrowing a little at a time.  So, for a while, you may have to put up with both Citrus County and Collier County lending you more than they borrow from you.  Try to be brave about that.

 Now, lets do the not-so-good-at-the-moment stuff.

East Lake, Palm Harbor, and Pinellas Park have all completed their migration to Polaris.  Thats good for the citizens of Pinellas County, but it moves them to a library system that URSA/iBorrow cannotat the momenttalk to.  So, as I write this, they cannot fill any new requests for you.  (They can still fill requests they got before the migration, and they will return your stuff.  They promised.)

 But we are working with Rob Gray at Polaris on getting it and URSA to talk to one another.  Earlier this week we were able to get past a major hurdle on their test server.  We were able to go to the iBorrow Portal as a Polaris patron (which the Palm Harbor, East Lake, and Pinellas Park patrons now are), create an iBorrow user, and request a title.  If we can get that same thing set up on the real Polaris server, East Lake, Pinellas Park, and Palm Harbor borrowers can start requesting again.  I think there is also a way they can fill iBorrow requests, but we havent had a chance to really test that yet.  Remember all the glitches and strange errors that you went through when you were first coming up on iBorrow?  Well, its now Polaris turn for all that.

Check in here from time to time for updates.  I’ll also put them out as Email.

–Al Carlson