Archive for the ‘NExpress News’ Category

Training Materials September 2010

In preparation for the eminent arrival of the Leavenworth Public Library, we are reviewing and updating our training materials and videos.  This list will add as time allows for the recording and re-recording of videos.

An Introduction to the NExpress (Koha) Staff Client

Part 1 – Checking items in:

Part 2 – Checking items out:

Part 3 – Issuing new cards and editing patron records:

Part 4 – Managing Holds

    • Transfers to Receive Report – How-to instructions for using this Circulation report to see what items are in transit to your location. Useful for tracking items mis-routed on the Courier.
    • Managing the Holds Shelf - How-to instructions for using the Holds Awaiting Pick Up circulation report to clear out expired holds from your shelf.  The Holds Awaiting Pick Up report is not yet working as expected.  PTFS is working on the issue.

Part 5 – Searching

  • Overview of the keyword and advanced search features of the Staff Client
    • Keyword searching hints -
      • add “leavenwrth” or “leavenworth” to improve results
      • Look for and use UNIQUE terms.  Is the author’s last name unusual, like “Evanovich”? Is there a term like “playaway” that will improve results?
      • As in Google, use a combination of keywords from the title, series and author name
      • Keyword searching looks at All fields of All attached items, even mis-cataloged ones
    • Advanced searching hints
      • Title, Author, Series Title searches are exact, so spelling counts but you get faster results
      • Look for unique or unusual subject headings to help narrow your search – “cookery for two”
      • Koha can’t find what is NOT in the record.  If a series title isn’t in the record, no amount of searching will find the book.
    • Use Amazon, use ISBN numbers, use What’s Next in the Series, use NoveList (if available)

Part 6 – Placing  a Hold:

Cataloging Training Materials (reminder: they are permanently located on this page)

Advanced Training and Homework Posts:

  • Managing Suggestions for Purchase - overview video 9/10
    • Must be logged in as TECH or DIRECTOR
    • Step-by-step instructions post, with a video from Royce at Tonganoxie Public Library
    • Patrons are alerted the next time they log into their account of your decision
    • Currently, there are 245 requests!  Patrons DO use this feature.

Harley Highlights 1.1 Release Notes

The Upgrade has been postponed until Saturday, August 21 to give PTFS time to fix an issue with Holds, specifically with reviving the “Please return THIS BOOK to Home Library” prompt after all of the holds have been filled.  (Just a note, all of the patrons shown are fictional.)

PTFS-Master 1.1 Release Notes (.pdf)

New or Enhanced Features

Turn Off Item Type/Collection Code Search Section in Advanced Search – We will leave the Collection Code Advanced Search sections ON in both the Staff Client and OPAC.  This, with the addition of the Shelving Location limits, should assist in all of your searches.  Read and Watch more about Searching.

Add XSLT Support for Staff Search Results and Record Details – We have turned on this feature, which will display the 245 subfields h, b, n and p in the Search Results list in both the Staff Client and OPAC.  However, due to some ugly looking code, we will NOT turn on this display in the Staff Client Details Display.  So, make sure you selected the correct Go Diego Go or Naruto before going to the details page, because the sub-title will magically disappear.

Use Slave Database for Reports – We have asked PTFS to setup our system to run Koha reports against a backup database rather than the primary database.  We are still trying to determine if this means running MySQL command line (uber geeky) reports, or just using the Circulation Wizard, which is what we want.

Fixes and Functionality Enhancements

Written by PTFS or picked from “other Koha codelines,” with details available in the Bugzilla report.

  • Translate ampersand (&) in XSLT title display. (Note: You still need to remove punctuation from searches). But, now titles display will go from this:

    to
  • Bug 3344Hold priority list needs additional status for items assigned but not waiting. We made this enhancement request, which Galen Charlton picked up and ran with.  So, when an item has been confirmed and is “In transit” to fill a hold, that item will no longer be a numbered hold in the Holds priority list, but will be down with those ‘waiting’ holds!
  • Bug 4224Holds queue (Pick List) report includes items already allocated.  This fix should remove extraneous entries.  We need to wait until we are ‘live’ to really test this.
  • Bug 4372Transferring an item does not update date last seen. Adds a date update to the Circulation History table for items when transfers are initiated, items are checked out AND when transfers are completed.  This was a bug we reported and our good friend Chris Cormack fixed!
  • Bug 3299Sticky calendar renew date doesn’t work.  The calendar gadget in the patron checkout/renewals column should work now!  Thank You to Galen Charlton for patching this for us.

Public Service Announcement – Old Batch Labels

Thank you Claudia!

Harley Highlights Continued

More Bits and Pieces from the Release Notes

Reports

Bugfix to Allow User Specified Limit in SQL – This is more of a back end fix that we are excited about, but it does mean that we can run a report on your Shelflist, say for the Insurance agent or City auditor.

Patrons and Holds

Patron Batch Edit and Batch Delete (Bug 3468) – Sorry, but until there is a granular permission that allows us to limit this feature to TECH and DIRECTOR accounts, we will suppress it.  Too dangerous – we’d rather not tempt fate and accidentally delete a group of patrons we meant to just change from Child to Adult.  Anyway, it’s a bit buggy – the “Select All” link within the Cart doesn’t work.  But we wanted you to be aware of this functionality, which we can turn back on if there is a pressing need.

Patron Improved Searching (Bug 3468) – PTFS added email, phone number, and borrower number to the standard search.  They also added an optional SQL search, but we thought it best to suppress that for now.  For email or phone number, use an asterisk (*555-1212 or *.rainbow.net).  Note that searching (212) 555-1212 and 212 555 1212 are NOT equivalent, you have to search for the phone number as entered, or truncate to just a part (like *1212*).

Predefined Borrower Notes (Bug 3472) – Diana and her staff at Atchison are excited about this feature.  It allows us to have predefined “canned” messages in a drop-down menu that are visible on the checkout tab.  For example, “Proof of Address Required” or “Email Correction Requested.”  Still testing this, can’t get any of the canned messages (or free text notes) I created to actually show up on the Checkout Tab of my patron record!  Hmmm….

Allow Multiple Holds on Items for One Title (Bug 4239) - This is the “I need 4 copies of the same book for my book club” feature.  We have set up this feature to allow patrons to place multiple holds on items with the Item Type of BOOK and NEWBOOK, but nothing else.  Unfortunately, we have not been able to get this feature to work, even though we set up the system preference.  We’ve sent a support request….

Place Hold Option on Checkout Tab (Bug 3659) – We’d like you all to test this “Search to Hold” feature and see what comments, suggestions and changes you’d like to see.  We think this is a good feature that can get better.

Fines

Calculate Fines on Claims Returned Items (Bug 4236) - PTFS wrote a feature to stop fine accrual on claims returned items.  When a patron says they’ve returned an item, but it’s not on the shelf – instead of marking it lost, you can mark it “Claims returned”.  The item will stay on their account, but fines won’t accrue and the item will show up on the Patron details page AND Fines page.  This message stays until the item is marked LOST and charged to the patron for replacement or found and returned to the library.  In this example, I am using one of our testing patrons…

Pre-Defined Fee Types (Bug 3476) - This is another feature we need feedback on…what standard fees are typically used when you create manual invoices for patrons?  Photocopies? Replacement cards? Debt collection fee?  We can add these to the Manual Invoice Type drop-down menu.

Circulation

Change Checkin Date (Bug 351o) – We call this the Snow Days check in feature – you can back-date the Check in feature, in case you were closed 2-3 days because of weather or flood…something that wasn’t expected and recorded using the Holiday Calendar.  You can also choose to Forgive overdue charges AND backdate the check in, in the name of exceptional customer service ;-)

Check In Damaged (Bug 4242) – If an item’s status is set to damaged while it is checked out (say the called over the phone or you noticed the missing front cover while clearing the drop box), and there are existing holds on the item, checking the item in will NOT trigger the next hold.  Instead, you’ll get a message like:

Item Damaged: Title of Book
Hold will remain on item until repaired

Clear Borrower Record After Checkout (Bugs 3485 and 3486) – In the name of patron privacy, there is now a built in “Circ Timeout – Are you finished with this patron?” prompt after 300 seconds AND a Clear Screen button.  New habits!

Cataloging

Batch Item Edit (Bug 3509) – After further review and discussion, we discovered that the TOOLS permission needed to view this feature has to be reactivated for every TECH account.  Also, this feature needs additional training before it can be widely used – it’s that powerful.

Adding Additional Items Copies Item Data (Bug 3480) – We want to bring this to your attention because this is NEW behavior when adding additional items to a Bib record (from the Bib record, not the Cataloging Module).
So, you Search the Catalog, find a title, click New, and click New Item on the title display page will open a new item screen WITH DATA (except barcode and other fields such as number of checkouts) COPIED from the FIRST item attached to the record.  So, you will need to be very careful when editing your new Item record, or your call number scheme may look a lot like Basehor’s or Atchison’s or whichever library cataloged the first item attached to the record!

Step One: Search the catalog and select New > New Item:

Step Two:  Edit, fix, update

http://content.screencast.com/users/SharonNEKLS/folders/Jing/media/9b438ad9-93b3-435d-8fff-663b1c99485e/00000076.png

Save Import Profiles (Bug 4247) – Heather will create MARC Import Profiles that have pre-defined fields set up to make importing easier.

OPAC

Bestseller’s Club and Email Notifications (Bug 4245) - We are still trying to test this feature, but hope to make the E-mail Lists work this way – Patron subscribes to a list and receives an email notification when new materials matching certain Item Type or Call Number scheme criteria are met.  For example, when new DVDs (‘MEDIA’  item type) are added to the collection or items that match a specific call number scheme (F QUINN or SF %).

OPAC Inactivity Timeout (Bug 4238) - An OPAC session will time out after 300 seconds (5 minutes) of inactivity and return to the main OPAC page.  We will need to craft a warning about the inactivity timeout to the OPAC’s main page – if you have any suggestions.

NOTE: The only guaranteed way for a patron to ensure that their “My Account” information can’t be accidentally seen is to CLOSE the BROWSER.  Logging out is not enough.

OPAC “Did You Mean” FEature (Bug 4240) - This new feature uses an open source dictionary to suggest five terms if an OPAC search term is misspelled or not found.  This does not work with some author names, but does work with commonly misspelled words that may appear in a title or subject.

OPAC and STaff Advanced Search Changes (Bug 3665) - A Search button has been strategically placed higher on the Advanced Search page, so you don’t have to scroll to the bottom of the page!  PTFS also moved subject, title and call number/barcode search options higher int he pulldown list.

Sorting of Item Holdings in Staff and OPAC (Bug 3702) - One of my favorite new features, the default sort order for the Item Holdings table will now be ALPHABETICAL by BRANCH LIBRARY DESCRIPTION, “so that a library’s holdings display together.”
NOTE: We are also working with PTFS to maintain our current CUSTOMIZATION of the Items holding table.  Our Catalog displays the items Permanent Home Branch in the Staff Client, rather than Current Location, which is the default behavior in Koha.  We needed a way to see how many copies were owned by a library at any given time for collection development.

Search by Shelving Location (Bug 4239) – NEW to the Advanced Search pages – You can limit to any of the following shelving locations!

Coming next…PTFS-Master 1.1 Release Notes

Harley: PTFS-Developed Koha Features

Release Notes (bits and pieces)

(Complete set of Release Notes in .pdf from May 2010)

Patrons and Holds

Borrower History Retention – Under the Circulation History tab, there are sections for Reserves (Holds) and Sent Notices history.  This will begin working once we upgrade, rather than retro-actively.

Place Hold Option on Checkout Tab – There will be a new “Search to Hold” section with a search link that opens a popup window for searching and placing holds.  A silent video demonstration.

Copy Patron Record – So, you have a family who needs 6 separate cards? No problem!  This feature takes an existing patron record and copies most of the information, except for First Name, date of birth and barcode.  This is an alternative to using the Set Guarantor feature or Add Child function, which assumes the new patron is a child.

To use: Find a patron, select More > Copy Patron

Then, update the record and save.

Fines

Partial Fine Payment - Patrons are now able to make partial payments of fines!  Click on the “Pay” button, insert the amount collected from the patron and Koha will automatically calculate the amount remaining.

Billing Notice and Debt Collection – We are still investigating this new feature, especially the new option for printing patron billing notices.  The Debt Collection piece is designed to work with Unique Management Inc, but could be adapted to work with other collection agencies.

Other Fines features worth looking into: Pre-Defined Fee Types (p. 34) and List Fines by Type on Checkout Tab (p. 36)

Circulation

Print Option for Hold and Overdue Notices - “PTFS has added an option to print hold and overdue notices for patrons who have no email addresses in their records.”  We will need to create a new notice template, then Koha will generate the notices and send the file to a web-accessible directory (that we’ll need to work with PTFS to get set up).

Renewal Source - Curious to know if an item was renewed by the Patron via the OPAC or by a staff member?  It shows up now!  An example…one guess who read all those romance novels…

Cataloging

Batch Item Edit – This new Tool allows you to select and edit Library, Item Type, Location, Permanent Location, Current Location, Not for Loan, Damaged, Lost status, Withdrawn status, Use Restrictions, and Collection Code.  So, say you want to find “Books” from Bonner Springs with a Collection Code of “New” and update that to “Fiction,” you can do that as a batch (all 610 of them).
Oops: Make sure you know what your search criteria is because this tool makes the changes to the item records without letting you preview the results and some of those 610 books should have been changed from “New” to “Nonfiction”…
Note: You can also scan the barcode numbers into a Text file, set the criteria you want to Change, upload that file, click Proceed and be done!  That was easy.

Other Cataloging Features that you might want to explore: Other Item Statuses (p.46), In Processing/Shelving Cart (p. 48) and Save Import Profiles (p. 49)

OPAC

Bestseller’s Club and Email Notifications – This is an expansion of a feature developed by Kyle Hall.  The part that I think is great is where patrons can self-enroll into a ‘club’ and then receive an email notification when a new item, for example by a favorite author, is added to the collection.  More information on pages 52-55.  Definitely something we will need to explore and probably discuss at an upcoming Users Group meeting.

Clear Reading History - Patrons can Opt Out of the Reading History, if we turn on the system preference “AllowReadingHistoryAnonymizing.”

OPAC and Staff Advanced Search Changes – PTFS moved the subject, title and call number search options higher int he pulldown list and added a Search button near the top of the screen.  Good thinking.

Sorting of Item Holdings in Staff and OPAC – The default sort order for items is accession date in the Staff Client and item type in the OPAC.  This new feature “forces the primary sort in both staff and OPAC to be by branch library description, so that a library’s holdings display together.”

Known Issue : Searches Choke on Special Characters

Today we received a question about searching for the item Bathrooms : moneysmart makeovers by Rick Peters, and it brought to light some known bugs (1807 – that a colon (:)  messes up the search and 2604 saying that a slash (\) does the same). Here are some additional search tips, courtesy of Mickey:

  1. NEVER include punctuation of any sort in a catalog search. Commas, colons, semi-colons, question marks, exclamation points, and periods should always be omitted.  This issue is fixed in Community Koha 3.2, but at this time special characters may cause faulty results.
  2. Since a Keyword search looks at all the data in the record, feel free to MIX SEARCH TERMS from author and title fields. You can even include publication information if you know it. So entering the words “peters” and “bathrooms” would return your item. Just those two words alone.
  3. Look for UNIQUE or less common search terms. Presented with a title like Bathrooms : moneysmart makeovers by Rick Peters, you would want to find a UNIQUE or uncommon term:  moneysmart certainly qualifies in that regard. So using that single term moneysmart is all you need to put into the search box. If you know the author’s name, you could put that in your search as well.
  4. Avoid TOO MUCH detail in Keyword searching. No need for complete titles. Omit articles the and a, an and conjunctions or and and.
  5. Remember that Koha uses a fuzzy logic search, and will return near-matches and “mystery” matches because is doesn’t stick with exact search terms. So don’t be put off if you get more hits than you think you should from Keyword searches in Koha. Look at the top 5 hits to see if your desired item is there. After the first five, most of the items below are fuzzy matches. If you don’t see what you need in the first five items, re-try your search using different terms.

Happy Searching,
Sharon

NExpress production upgrade to occur August 14-15

Posted from an email sent to the NExpress listserv by Mickey Coalwell yesterday:

Hello everybody.

As Jim mentioned in his July 13 email, big changes are (finally) coming to NExpress. LibLime, our support and hosting company, is now a wholly-owned subsidiary of PTFS, headquartered in Bethesda, Maryland. We have been working with the PTFS transition team over the last few months, and have negotiated an upgrade path that allows us to continue with our fall migration of Leavenworth Public Library into the NExpress Shared Regional Catalog.

Our current Koha installation will be upgraded with a newer code base which includes over a year of changes and improvements in both functionality and features, including some PTFS software enhancements.

We have a schedule now for this upgrade process, which will occur on Saturday, August 14 & Sunday, August 15. LibLime will do a database backup, and then run the upgrade scripts, which take about 2 hours. Once LibLime has confirmed that the scripts have run successfully, the last step is the reindexing, which will take 6-7 hours. LibLime is planning on doing the upgrade after hours on Saturday and Sunday, so there will be no need for offline circulation. It will take approximately 10+ hours to complete the upgrade over the weekend. Please do not do any catalog work during this period.

We should have a test instance of the new PTFS Master Koha available for our use very soon. LibLime will refresh our test instance with an up-to-date copy of our production database and upgrade it to PTFS Master. We should have several weeks to “play” and get used to the way it works in a test environment.

We are working now on developing training and support materials highlighting the many new features of the upgraded PTFS Master Koha. We think you’ll be very pleased with the changes!

We have already had a successful preliminary upload of Leavenworth’s data into an upgraded instance, which we are busy testing. Leavenworth Public Library is on track to join NExpress “live” on September 8. Leavenworth will bring almost 100,000 new items into our shared catalog.

Thank you all for your patience. We are very pleased to be moving ahead with this major Koha upgrade, and will do everything we can to make the process a smooth one.

Using the Koha Calendar

Hello NExpressers!

The Calendar (under Tools in Koha) will affect your circulation (and overdues) based on how it is set.  The Director account has permission to update the Calendar. There are basically three ways you can set your Koha Calendar, which is done individually for each library:

1. No holidays

  • Koha counts every calendar day when determining a checkout period.
  • An item with a 7 Day checkout that is checked out on Monday Nov 23 will be due seven days later, on Monday Nov 30.
  • It doesn’t matter if the library is open or closed on any of these days.
  • Overdues are determined in the same way — an item that is 7 Days Overdue will get a First Notice.
  • So, to use the example above, the unreturned item checked out on Nov 23 will trigger a First Overdue Notice on Dec 7.

2. Holidays only (Yearly and Unique)

  • Koha counts every calendar day when determining a checkout period EXCEPT for specific holidays “blocked out” on the calendar, like Thanksgiving, Christmas, Independence Day, etc.
  • Koha just skips the holiday in determining checkout periods.
  • Using the example above, a Koha Calendar with just yearly Holidays set would skip Thanksgiving Day on November 26.
    • The item checked out on Nov 23 would be due on Tuesday Dec 1.
    • The First Overdue Notice would be sent on Dec 8.
  • The benefit of setting your Calendar to skip holidays is that items won’t ever be due on days like Thanksgiving or Christmas.

3. Recurring weekly holidays (days library is closed)

  • Koha will skip every day the library is not open for business when counting checkout periods.
  • For a library that is closed on Saturday and Sunday each week, an item checked out on Monday, Nov 23 would be due Wednesday, Dec 2.
  • HOWEVER, if the Thanksgiving holiday is also “blocked out” in addition to the regular days the library is closed, then the item would be due on Thursday, Dec 3.
  • So a 7 Day checkout period could, in this scenario, encompass 10 actual calendar days, since the Calendar settings tell Koha to skip counting Thursday, Saturday and Sunday as checkout days.

Right now, libraries are using all combinations of 1, 2, and 3.  You do not HAVE to use any holiday settings whatsoever.

Mickey

New LOST reports in Saved Reports area

There are three new LOST reports available for libraries that use Koha’s LOST status feature to remove items from a patron’s checkouts and add the replacement cost as a FINE.

1. LOST Report
2. LOST Report ALL
3. LOST Report ONLY showing null values for replacement cost

Here’s a recap of the way the Koha LOST status feature works, as a reminder:

  • Manually changing a checked-out item’s status to Lost will remove the item from the patron’s checkout page, but add a replacement cost to the patron’s account under the Fines tab. Often, this will result in an account debarment, since the debarment ceiling is $10 and most items cost more than that.
  • If a Lost item is Checked In, the replacement cost is removed (reversed) from the patron’s fine account automatically. However, any overdue fines accrued prior to the item’s being marked Lost will remain on the account. You can forgive or pay these manually if you choose. Or not.
  • The returned item’s status will become AVAILABLE again in the catalog, but the debarment on the patron account will NOT be automatically lifted. You will need to do this manually.

Since applying the Lost status effectively severs the link between the patron and the item in the Checkouts page, there needed to be a different way to identify Lost items via the Fines account. The LOST Report does just that, identifying by name and cardnumber those patrons that have items in their Fines account, along with the date/time when the item was given a LOST status.  It lists all currently lost items, excluding those which have been returned. It’s sorted by patron, and you will see multiple entries for patrons with more than one lost item. The current amount outstanding for each lost item is in the last cell of each row. Here’s some sample data from the report:

10030070039X0    Miller    Leslie Q.    Lost Item  00105000634847    9/21/2009 12:36    $16.00
10030070039X0    Miller    Leslie Q.    Lost Item  00105000429354    9/23/2009 10:52    $25.00
10030070039X0    Miller    Leslie Q.    Lost Item  0003000000781    9/23/2009 10:53    $10.00
10030070039X0    Miller    Leslie Q.    Lost Item  0003000008926    9/23/2009 10:53    $15.00
10030070039X0    Miller    Leslie Q.    Lost Item  0003000010689    9/23/2009 10:53    $15.00
10030070039X0    Miller    Leslie Q.    Lost Item  00105000609229    9/23/2009 10:54    $17.00
10030070039X0    Miller    Leslie Q.    Lost Item  00105000408820    9/23/2009 10:54    $25.00
1003X99003039    Mirett    Mark N.    Lost Item  00103000402361    11/3/2009 14:33    $19.33
1003X99005892    Myles    Samuel R.    Lost Item  0003000002969    9/21/2009 12:12    $15.00
1003X99005892    Myles    Samuel R.    Lost Item  00105000452332    9/21/2009 12:12    $25.00
1003X99006021    Nunn    Grace Ellen    Lost Item  00105000336914    2/12/2010 10:59    $10.00
1003X99006021    Nunn    Grace Ellen    Lost Item  00105000344063    2/12/2010 10:59    $15.00
1003X99000909    Otembo    Odenga    Lost Item  00105000429990    9/22/2009 13:44    $25.00
1003X99000909    Otembo    Odenga    Lost Item  0003000010425    9/22/2009 13:45    $15.00

This report will allow you to identify patrons with Lost charges, as well as the specific Lost item by barcode, and to assess the dollar value of Lost items per account.

*The second “LOST Report ALL” outputs the entire NExpress catalog’s LOST items, ordered by Library.

*The third “LOST Report ONLY showing null value for replacement cost shows all items that have a NULL (zero) value for Lost Items” shows accounts where an item has been returned, and the replacement charges reversed; it also shows accounts where an item-linked WRITEOFF has occurred, or cases where the replacement cost is zero for a Lost item. You can run this report by inserting your Library Code into the SQL statement and running the report yourself.

Please let us know if you have any questions about these reports.

WordPress Search Widgets

Would you like to have a search box on your website that allows your patrons to quickly do Author, Title, Subject OR Keyword searches?  We also have a two new Koha Search Widgets that Liz wrote and submitted to the WordPress community.  You can find them by searching for the term ‘koha’ in Plugins > Add New:

http://content.screencast.com/users/SharonNEKLS/folders/Jing/media/66bdf0dd-7427-43db-9b2b-8ae96217bace/00000079.png