Monthly Archives: October 2007

Announcement-First Circulation in the Morning Resolution

 Hello All,

 Please read this important announcement below regarding the solution for the problems with the first circulation in the morning:


The first circulation of the morning was found on many SUNY campuses to result in error messages and the need to re-do the first circulation.  The SUNY OLIS reported this problem to Ex Libris, who reported back that the problem was the process that drops and re-creates tab16 & tab17 (cir_01) was in the job_list and should be removed.  Ex Libris stated that having cir_01 in the job_list was redundant as the process would take place automatically as part of overnight processing.


The SUNY OLIS tested this scenario by removing cir_01 from the job_list and editing both tab16 & tab17.  What was found was this:


If tab16 was changed, it would be updated by overnight processing

If tab17 was changed it would be updated by overnight processing

If both tab16 and tab17 were edited on the same day, only tab16 would be updated by overnight processing.


If tab16 & tab17 were edited on the same day and the cir_01 (reset z301 table) process was run manually, both tables were updated immediately.


Because of this unintended consequence of removing cir_01 from the job_list, the following is the recommended steps to take IF you want to edit both tab16 & tab17 on the same day.   You may also follow this procedure after editing either tab16 or tab17 if you want the changes to be in effect immediately:


 1.  Edit and save tab16 & tab17, using the editor of your choice.


2.  In the cataloging client, run “Clear UTF files/util x-7 (custom-98).  This may be found at: Cataloging/Services/Custom Services – General.


3.  In the Circulation client run cir_01 (Circulation/Services/Custom – Circ Reports and Jobs/Run p_cir_01 – reset z301 table (custom-99).


4.  Verify the change by refreshing your circ client, then click on [D] Active Due Dates in the Loan window.


The SUNY OLIS will remove cir_01 from the job_list for all campuses on
Delaware, Saranac and Seneca servers this week and the change will be effective starting Monday, November 5. 



Custom Report for Circulation Stats by Item

A new custom report has been developed to aid in collection development activities.

Custom-50, Circulation Statistics by Item, lists the number of circ transactions by item for a given loan period and for a minimum number of circ transactions.  Users can also limit by the publication date of the item.  The output file contains bibliographic information, barcode number, collection code, call number, and number of circ transactions.  It is a comma-delimited file to be read into Excel.  See the Help file for more details.
The report can be found in the Circulation Module under: 

 Services / Custom Circ Stats (Titles) / Circulation Statistics by Item (custom-50)
If you have any questions, please submit an issue in Footprints.

SUNYergy Vol. 9 No. 4 October 2007 available

SUNYergy, SUNY Libraries Working Together
October 2007
Volume 9, Number 4
On the web @

LiSUG 2007 – The Hottest Conference of the Year!
SUNYConnect-wide Group Evaluating New Search Tools —
Shared Search & Discovery Services Committee
SUNY Digital Library Proposal
Revisiting ALEPH Support Services Provided by the OLIS
Additional SUNYConnect Updates
Linkable Links
How to Contact Us

“SSZ – SUNY Science Direct Titles” updated in 360 Link

The SSZ – SUNY Science Direct Titles collection in 360 Link has been updated.

The update includes
– latest data (as of October 17, 2007) from Elsevier;
– corrections (to Elsevier’s data) previously identified;
new titles added to the Freedom Plan

If you had previously enabled this collection, no further intervention on your part should be needed.

Comments or questions?

FYI – Ex Libris tech support system offline late Sunday

We would like to bring to your attention that a CRM [Ex Libris’ tech support system] upgrade will take place on Sunday October 21, 1 a.m. EST  The system will be down for one to two hours.    

ScienceDirect offline 10/20/07 (8am – ~10am)

ScienceDirect will be unavailable due to scheduled maintenance
on October 20, 2007 for approximately 2 hours
starting at 08:00 AM EST (13:00 PM GMT).
We apologize for the inconvenience.

Serials Solutions Workshop (@ Rutgers 10/24-25)

Due to some late cancellations, there are a few spots still available for the upcoming Serials Solutions Rutgers Workshop, taking place next week (October 24-25) on the Rutgers University campus in New Brunswick, New Jersey.

Event highlights are described below my signature line, with other event details (directions and parking information) posted at If you wish to register for this event please simply visit and fill in the necessary information.

If you can’t attend this event, but interested in hosting a 2008 workshop, please let us know by emailing


Scott Schuetze

Sr. Marketing Manager

Serials Solutions
Event Overview

If you attend this workshop you will gain a better understanding of our services and how to better use them at your library. Specifically, we hope you will learn more from your fellow colleagues and Serials Solutions staff through interactive presentations and stimulating discussion. Topics are to include discussion around: Serials Solutions’ knowledgebase, e-resource management and assessment, and e-resource access.

Other event notes:

· A special guest appearance and presentation from our company co-founder – Peter McCracken – is included as part of this workshop.

· A continental breakfast, lunch and a reception on Wednesday evening, October 24, will also be included as part of this free workshop.

· Thursday’s ½ day session, which is optional for workshop attendees, will feature breakout sessions for attendees and opportunities to interact with Serials Solutions support representatives and product managers.