Macro Magic: Designing and Implementing Effective Macros Using VisualBasic and OCLC OML

A program from the Technical Services Workstations Interest Group (LITA/ALCTS)
American Library Association Annual Conference, New Orleans, Monday, June 28, 1999

Want to make your workstation work for YOU?! Come explore a variety of macros developed by creative library staff for use with cataloging and ILL applications. Five brief presentations will demonstrate applications using OCLC Macro Language and Visual Basic for use with OCLC and with local systems. A break-out session follows for audience members to meet the presenters.

The "FASTCAT" macro at MIT

Raymond Schmidt
Copy-based Cataloger
MIT Libraries
Eric Celeste
Assistant Director for Technology Planning and Administration
MIT Libraries

This presentation will describe the OCLC Passport for Windows macro we use to sort new acquisitions into two copy-cataloging work-supplies.

Using OML to manipulate data files

This presentation will explore a lesser-known use of OML (OCLC macro language) for data manipulation. OML can be used to clean up and "massage" data in files derived from OCLC, from the local integrated automation system, or from other sources. This makes it easier to develop local, customized reports as well as to prepare data for easy import into other applications.

Harvey E. Hahn
Manager, Technical Services Department
Arlington Heights Memorial Library, Arlington Heights, Illinois

Connecting to a Voyager database

The topic is development of a tool that allows programmers with less-than-gurulike abilities to connect to and search a Voyager database without having to deal with any of the connection-associated mess that's common when linking a program to an external data source. The second thing is the incorporation of this tool in end-user programs; and that because of the tool, these programs are fairly simple to throw together.

Gary L. Strawn
Authorities Librarian, etc.
Northwestern University

CatME for Windows and Macros

The OCLC Cataloging Micro Enhancer for Windows includes macro functionality which can be used to enhance cataloging productivity. An overview of how some libraries have used CatME macros will be provided along with discussion about how libraries can share CatME macros among each other.

David Whitehair
CatME for Windows Product Manager
OCLC, Online Computer Library Center, Inc.

Make your OPAC communicate with files

Passport for Windows is a powerful application which can save your institution thousands of dollars and countless hours of staff time each year. This session introduces you to some of Passport's capabilities as well as techniques for using its macro language to automate time consuming staff operations. Passport makes it very easy to make your opac communicate with files. Because if this, many operations such as label generation, record updating, authority searching, etc. can be partially or totally automated.

Banerjee's presentation in Adobe pdf format

Kyle Banerjee
Cataloging Librarian
Oregon State University

Resources of Interest

Sites about OCLC Macro Language, compiled by Harvey Hahn

RLG's Authority Assistant

User's Guide to CLARR, the cataloger's toolkit