Sharing Information


One of the great things about the CODI Users Group is the ability to share problems, concerns and solutions with other users.

What is shared is up to you. Anything that might be of interest to others is welcome from brochures or guides to electronic files containing useful scripts and reports. Some specific suggestions that have been requested are:

These are just a few of the possibilities. There may be lots of others. So, give it some thought and see what you may have that would be of interest to others.

Please send electronic files to Frances Orton at codioffice@att.net for inclusion in the sharing information section of the CODI Users Group Web site.

WARNING: All electronic files have been made available by member libraries and have been written based on THEIR databases and THEIR experiences. ALL files should be checked to determine their appropriateness for use at another site. NO GUARANTEES are made about the safety of running any of the queries included here against your database.

 

Sharing Table

The following files have been submitted by member libraries:

 

Creating a Table with Reconstructed Titles Details the procedures to create a table containing bib# and title_reconstructed fields to display human-friendly versions of titles without needing client-side macros. Includes trigger modifications to title triggers necessary to maintain table entries. Replaces ALA-encoded diacritics and special characters commonly used at PRL with characters that display in reporting structure. YMMV.
create_prl_title_table.qry
Creating a Table with Reconstructed Titles
populate_table.qry
title_d_trig_mod.qry
title_i_trig_mod.qry
Title_Recon_Table.qry
title_u_trig_mod.qry
Submitted by: Michael Silver
5404 56 Avenue Lacombe, AB T4L 1G1 Canada
Date Submitted: April 12, 2007 and update April 25, 2007

 

Predictions
Predictions
Instructions for submitting additional predictions
Submitted by: David Schuster
Plano ISD, Plano, TX
Date Submitted: September 6, 2004

 

OCLC RLIN .zcf file
rlin.zcf
Submitted by: Stuart Miller
University of Chicago Libraries, Chicago, IL
Date Submitted: January 9, 2004

 

Horizon 7.2 Day One/Launcher Training Materials
[Outline of Training Session, Accompanying handout]
Submitted by: Stuart Miller
University of Chicago Libraries, Chicago, IL
Date Submitted: June 18, 2002

Workslip Report [INCLUDES: The workslip is used as a routing slip to follow a title through Cataloging and Physical Processing. The date of receipt is at the top which helps us keep the books in order so that they can be found easily while they are being processed. We have a backlog so this is important. The workslip also includes "internal notes" which frequently include special cataloging instructions. Finally the workslip has the location and fund code for each copy which tells us, for example, that this book is to be cataloged for the Northeast Branch and that it should go in the Reference Collection. There are many other pieces of information on this workslip that are helpful. It basically includes just about everything that is on the order record.]
Submitted by: Bruce Heimburger
Richland County Public Library, Columbia, SC
Date Submitted: February 11, 2002

Printing Spine Labels from Horizon Using a Microsoft Word Template [template (right click to save), instructions]
Submitted by: Clairellen Nentwich, Transport Canada, Ottawa, ON and
Ruth Webster, Environment Canada, Hull, ON
Date Submitted: January 24, 2001

Serials Routing Procedures
Submitted by: Bruce Heimburger
Richland County Public Library, Columbia, SC
Date Submitted: November 1, 2000

Circulation Procedures and Guidelines
Submitted by: Evelyn Lord
Peralta Community College District, Oakland, CA
Date Submitted: November 1, 2000

Purchase Alert SQL
Submitted by: Carol Vaughan
Fort Bend County Libraries, Richmond, TX
Date Submitted: November 1, 2000

5.3 Upgrade Test Plan
Submitted by: Kathleen Pierson
Sandia National Laboratories, Albuquerque, NM
Date Submitted: November 1, 2000

SQL Scripts from HUG (UK)
Submitted by: Brian Hackett
University of Huddersfield, West Yorkshire, England
Date Submitted: November 1, 2000

WebPAC Guides
Submitted by: Lorraine Waitmansharing
United Nations, New York, NY
Date Submitted: November 1, 2000

Jim Taylor's Utilities [INCLUDES: An internet e-mail utility which will mail out any number of e-mail messages, in batch, from a text file or an ODBC source; a utility that will allow you to submit a request to retrieve URLs from an application which stores URLs in a database using an SQL interface or an ODBC source; a utility which allows you to define the keystrokes to repetitively enter data into an application or simply send keystrokes to accomplish some other task; a script management tool which can can be used with almost any database that allows you to submit jobs in script form, from the command prompt; a utility which will only allow one instance of an application to run at a time; and a utility used when you have an application which passes a URL to your web browser and you have to specify the location of your web browser.]
Submitted by: Jim Taylor
Asbury Theological Seminary
Date Submitted: January 6, 2000

English Wizard for Horizon [Presented to the Utah Academic Library Consortium (UALC) Systems Committee, September 17, 1999]
Submitted by: Joan M. Gregory
Spencer S. Eccles Health Sciences Library, University of Utah
Date Submitted: September 18, 1999

Sharing Horizon Bibliographic Records [Presented to the Utah Academic Library Consortium (UALC) Cataloging Committee, July 9, 1999]
Submitted by: Joan M. Gregory
Spencer S. Eccles Health Sciences Library, University of Utah
Date Submitted: July 9, 1999

WebPAC 1.24 Templates [Meriam Library, California State University, Chico]
Submitted by: Jessica Hartwigsen
Meriam Library, California State University, Chico
Date Submitted: May 17, 1999

Cataloging Department PAC Flavor Search Indexes
Submitted by: Dawn Hale
Johns Hopkins University, Milton S. Eisenhower Library
Date Submitted: January 22, 1999

Claims Report[Report Smith, MS Access Reports]
Submitted by: Susan Way
Arnold Digital Library, 1100 Fairview Ave North B1-010, Seattle, WA 98109
Date Submitted: January 7, 1999

INSTRUCTIONS: How to obtain usage statistics from WEBPAC 1.2
Submitted by: Aloysius A. Bauer, Bristol-Myers Squibb
Date Submitted: October 19, 1998

Reports Generated Using Microsoft Access
Submitted by: Marie Tweed,
Air Products and Chemicals Library, 7201 Hamilton Blvd., Allentown, PA 18095
Date Submitted: November 9, 1998

Reserve Report(including instructor name, course name, call number and reserve title).
[Instructions, ISQL Report, ReportSmith Report(.rpt)]
Submitted by: Don Carlin , Austin Peay State University, Clarksville TN 37044
Date Submitted: December 16, 1998

WebPAC User's Guide
Submitted by: Judy Himelrick, Bellcore, Piscataway, NJ
Date Submitted: December 16, 1998

PERL scripts for use with MARC files and MARCIN on Windows
Submitted by: Melissa Belvadi, Maryville University, St. Louis, MO
Date Submitted: December 9, 1998

WebPac 1.2 Templates
Submitted by: Melissa Belvadi, Maryville University, St. Louis, MO
Date Submitted: December 9, 1998

Cataloging Internet and Multimedia Resources in Horizon: Making it Work A presentation at the 1998 Annual Meeting of the Horizon Users Group, Raleigh, NC, November 10, 1998.
Submitted by: Joan M. Gregory, Spencer S. Eccles Health Sciences Library, University of Utah
Date Submitted: October 29, 1998

How to create a web page list of 856 tags [description & report]
Submitted by: Aloysius A. Bauer, Bristol-Myers Squibb
Date Submitted: October 14, 1998

In-House Use Statistics - ReportSmith Report [description, report]
Submitted by: Susan Way, Fred Hutchinson Cancer Research Center Library, Seattle, WA
Date Submitted: July 16, 1998

ReportSmith Reports prepared for use at Southern Utah University and presented at the Utah Horizon Users Group Meeting at the 1998 Annual Meeting of the Utah Library Association, May 9, 1998. [NOTE: "Instructions" are Microsoft Word documents. "Reports" are ReportSmith reports.]:

Submitted by: Philip Dillard, Southern Utah University
Date Submitted: June 2, 1998

Selecting and Cataloging Internet Resources: Making it Work A presentation at the 1998 Annual Meeting of the Technical Services Section of the Medical Library Association, May 26, 1998.
Submitted by: Joan M. Gregory, Spencer S. Eccles Health Sciences Library, University of Utah
Date Submitted: May 19, 1998

BiptoHorizon: A program that converts the output from Books in Print into MARC formatted records
and Instructions on Installing BiptoHorizon
Submitted by: Matt Miles and Bruce Bills, Ricks College.
Date Submitted: April 23, 1998

Report of Items by Publication Date [ReportSmith]
Submitted by: David Stephenson, Waterloo Region District School Board.
Date Submitted: January 23, 1998

Provisional MARC Maps
Submitted by: Janet Lute, Princeton University Library
Date submitted: October 17, 1997

OPAC Users Guide (Microsoft Word document)
Submitted by: Jennifer Walz, Morrison-Kenyon Library, Asbury College
Date submitted: October 16, 1997

WebPAC Panel Discussion Outline (HTML document)
Submitted by: Joan M. Gregory, Eccles Health Sciences Library, University of Utah
Date submitted: October 16, 1997

ISQL Reports, ReportSmith Reports, and WordPerfect Documents mainly submitted by Katherine Arendt for the Sharing Table at the 1996 Annual Meeting of the Horizon Users Group in St. Louis, MO
Submitted by: Katherine Arendt, U.S. Patent and Trademark Office
Date submitted: October 20, 1996

Various Documents submitted by various individuals for the Sharing Table at the 1996 Annual Meeting of the Horizon Users Group in St. Louis, MO
Date submitted: October 20, 1996

WARNING: All electronic files have been made available by member libraries and have been written based on THEIR databases and THEIR experiences. ALL files should be checked to determine their appropriateness for use at another site. NO GUARANTEES are made about the safety of running any of the queries included here against your database.

Updated 12/14/05 - FPO