The OLIS is pleased to announce another How To document:
How To Protect Patron Privacy with Aleph
In Footprints: KB-7017
The document lists the various Aleph services available that scrub data to protect patron privacy and illustrates how each service can be setup in the job_list.
– Natalie
The following information is for campuses with Aleph regions housed on Delaware, Saranac, and Seneca.
The file tab_filing_call_no has been enriched to improve inventory and shelflist reports for non-LC call numbers. For this to take effect, p_item_06 needs to be run.
Beginning the week of June 8, p_item_06 will be run in the 50 library for each campus (both /dev and /prod) to update the z30 records. The library is not locked during this job so Aleph will not be down. The job should take 15-30 minutes for most campuses.
For running p_item_06, campuses are grouped together. p_item_06 will start at 1:00am for the first campus in the group. When p_item_06completes for the first campus, the job will start running for the second campus, etc. The OLIS will be reviewing the results of running p_item_06 in /dev and may modify the /prod schedule if needed.
A schedule for running p_item_06 is available in olisdocs at:
http://www.sunyconnect.suny.edu/olisdocs/public/Aleph/p_item_06_sched_June_2009.xls
If you have any questions, please submit them via Footprints.
Thank you.
— Natalie
Three new Custom Services are now available. All were initially developed for campus projects and then adapted for use as a Custom Service.
custom-90
Cataloging / Services / Custom Services - Reserves /
Re-index Course Reserves
This service re-indexes the Direct, Word and Browse indexes in the Course Reserves (30) library. This functionality was available via Web Services in v14 and v16, but did not work correctly in v18. Thus, OLIS removed it from Web Services. Now, the functionality is available in the GUI.
OLIS has hard-coded all the parameters into the program. For example, it does not matter which library is selected on the input screen; this service will always run in the 30 library.
—
custom-52
Circ / Services / Custom – Circ Stats (Titles) /
Circulation Statistics by Item with Patron Information
This service lists bibliographic, item, patron and transaction information for circulation transactions within the specified time frame. It can be run on one collection code or on an entire sublibrary. Bib records with an STA field are not included. The output file is in comma-delimited format that can be used and manipulated in Excel.
There is one entry for each circulation transaction. Each entry includes:
· Bib info from Z13 short doc: System Number, Title, Author, Imprint, Year
· Info from item record: Barcode, Sublibrary, Collection Code, Call Number, Item Status
· Patron information: Borrower Status, Borrower Type
· Transaction information: Event Type, Event Date
The Event Type is an Aleph assigned code. A listing of the codes can be found in the Help file for this report.
—
custom-45
Circ / Services / Custom Services - Items /
List of Items Containing OPAC Note
This service lists bibliographic and item information for items with OPAC notes. You can choose to retrieve all records with an OPAC note, or only those with OPAC notes that contain a specified character string.
Bib records with an STA field are not included. The output file is in comma-delimited format that can be used and manipulated in Excel.
Each entry includes:
· Bib info from Z13 short doc: System Number, Title, Year
· Info from item record: Sublibrary, Collection Code, Call Number, Description, OPAC Note, Item Status, Item Processing Status
Did you know that OLIS has created a number of How To documents for Aleph? You can find How To’s on a wide range of topics – from everyday needs to the occasional data cleanup project. There are currently over 20 documents, and the collection is growing!
Topics for How To’s are selected from the Footprints questions submitted by campuses. Thus, the documents address real needs and provide practical solutions and suggestions.
The How To documents are available through the Footprints Knowledge Base. They are listed on the Home screen, the first screen you see when you login. Search on the subject How To to see all that are available.
For more information on accessing the Footprints Knowledge Base and other resources for Aleph help, see Sources for Aleph Help.
Here is a list of How To’s that are currently available. Remember, more will be added in the future:
How To Access the OLIS Support and Documentation Portal
How To Add a Library or Base for Searching in the GUI
How To Configure Patron Address so it Fits in Window of Envelope
How To Correct Special Characters with p-manage-21
How To Create Local Call Number from 099 on OCLC Export
How To Create a Report of Bib Information from a File of Barcodes
How To Create a Report of Weeded Items Within a Particular Date Range
How To Email Overdues
How To Find Sources for Aleph Help
How To Gather z39.50 Server Configuration Information
How To Make a Persistent URL Link to an Aleph Web OPAC
How To Manage End of Semester Due Dates
How To Manage Library Hours and tab17
How To Move Aleph Data into Excel
How To Open an Older File in Services History
How To Rebuild the Print Templates Package After Modifying an XSL Report
How To Report Problems to ExLibris
How To Setup Overdues Using Different Templates (text) for Each Notice
How To Use Aleph to Retrieve Data for the NCES Academic Libraries Survey 2008
How To Use Sandbox, Including the Aleph Utilities
How To Use the job_list to Run a Program Now in v18
If you have a suggestion for a How To document, do let us know.
Enjoy!
— Natalie
The OLIS has created a documented entitled “Sources for Aleph Help.” It is a list of resources available to the SUNY library community that includes a brief summary of their scope and access information. This document is available from the Footprints Knowledge Base Solution #6571 and from the OLIS Documentation portal: http://www.sunyconnect.suny.edu/support.
The document provides information on the following:
• Footprints Knowledge Base and Service Request
• OLIS Documentation Portal
• Ex Libris Documentation Center
• Ex Libris CRM Knowledge Base
• SUNY Oswego Aleph/Ex Libris Resources
• Aleph Training in Angel
Maureen
________________________________________
Maureen Zajkowski
SUNYConnect Program Manager
Office of Library & Information Services
State University Plaza
Albany, NY 12246
voice: 518-443-5577
fax: 518-443-5358
The following information is for campuses with Aleph regions housed on Delaware, Saranac, and Seneca.
In Fall 2008, the OLIS enriched the z13 (short bib) record to include the OCLC number, the STA field, and the LDR from the bib record to permit additional functionality for current and future projects. Recently, it was determined that additional edits need to be made.
Beginning the week of March 23, updated files for tab_expand and tab_expand_join_simple will be delivered and p_manage_07 will be run in the 01 library for each campus (both /dev and /prod) to update the z13 records. While p_manage_07 is running, it is expected that most campuses will be down less than 30 minutes. Campuses with the largest bibliographic databases should be down less than 45 minutes.
For running p_manage_07, campuses are grouped together. p_manage_07 will start at 1:00am for the first campus in the group. When p_manage_07 completes for the first campus, the job will start running for the second campus, etc. The OLIS will be reviewing the results of running p_manage_07 in /dev and may modify the /prod schedule if needed.
A schedule for running p_manage_07 is available in olisdocs at:
http://www.sunyconnect.suny.edu/olisdocs/public/Aleph/p_manage_07_sched_Mar_Apr2009.xls
If you have any questions, please submit them via Footprints.
Thank you.
Maureen
________________________________________
Maureen Zajkowski
SUNYConnect Program Manager
Office of Library & Information Services
State University Plaza
Albany, NY 12246
voice: 518-443-5577
fax: 518-443-5358
SUNYergy Vol. 11 No. 1 is available on the web at http://www.sunyconnect.suny.edu/sunyergy/default40.htm
SUNYergy: SUNY Libraries Working Together, is a quarterly publication of the State University of New York’s Office of Library and Information Services (OLIS).
Footprints is your tool for reporting problems between the hours of 9 am - 5 pm M-F. Problems meeting the Prod Down criteria and occurring outside these hours, or on holidays, should be reported to ITEC by phoning: (716) 878-4832.
See the OLIS Service Portal (http://www.sunyconnect.suny.edu/service) for more support details.
What Footprints Priorities Mean
Prod Down - OLIS and/or ITEC staff will acknowledge within an hour (if the Prod Down criteria is met); review will take place within one hour; resolution is sought within 8 hours. Use this priority for problems affecting access to the Aleph Production servers, for example:
High - OLIS and/or ITEC staff will acknowledge within 5 hours; review will take place within one working day; resolution is sought within 1 work week. Use this priority for problems affecting staff work that will adversely affect other library functions if the problems continue for more than a day or two, for example:
Medium - OLIS and/or ITEC staff will acknowledge within 3 business days; review will take place within 4 working days; resolution is sought within 2 work weeks. Use this priority for problems with current functionality that can be worked around for approximately one week, for example:
Low - OLIS and/or ITEC staff will acknowledge within 1 work week; review will take place within 5 working days; resolution is sought within 4 work weeks. Use this priority for questions regarding new functionality, for example:
Over the next few weeks, the OLIS will be enriching the z13 (short bib) record to include the OCLC number and the LDR from the bib record. This will permit additional functionality for current and future projects.
New lines will be added to tab22 this week. Beginning next week, p_manage_07 will be run in the 01 library of each campus (both /dev and /prod) to create the new z13 records. It is expected that campuses will be down less than 30 minutes while p_manage_07 is running.
A schedule for running p_manage_07 is available in olisdocs at:
http://www.sunyconnect.suny.edu/olisdocs/public/Aleph/p_manage_07_sched_Oct2008.xls
If you have any questions, please submit them via Footprints.
Thank you.
— Natalie
New to ver 18 is a circulation log – viewable on the Patron screen in circ. Data for the circulation log is kept in a new z309 oracle table. Those campuses that scrub their patron data may also wish to scrub the circulation log. The z309 table is NOT scrubbed automatically – you need to change the entry for p_cir_32 in job_list for this to happen.To change your job_list entry for p_cir_32, you need to change (in the Sandbox editor) the very last ‘N’ in the parameter string to ‘Y’.
File: alephe/tab/job_list
Job that scrubs patron data: p_cir_32
Sample cir_32 parameter string:
The change will be effective after the next Monday morning Aleph restart . To make it effective immediately, use the Sandbox Util Menu feature and select:
E. Monitor Background Jobs
15. Managing Job Daemon
1. Start / Re-start job daemon
Managed Services campuses may submit a Footprints to request this change.
– Natalie