PfW Macros for use with OCLC

Here I have available the binary macrobooks with all of the listed macros, as well as text versions of each macro. Note that the macros that deal with updating holdings are optimized to work for a library within a consortium, where both the consortium and the individual library have their own holding symbols.

PRISMCat authority file utilities

AF-Utils [binary ~15k total]

AF [text]

Search the authority file via a dialog box. Type in (or paste in) the text to search for, select the database to search (person, subject, etc.), and send it on its way. The macro switches to the authority file, if not already there, and formulates the search key based on your selections. I find it easiest to use Tab to advance fields, the arrow keys to select the type of search to make, and Enter to send the search, rather than exclusively using the mouse.

NextRec [text]

Goes to the next record when FOR can't. This is of most use in the authority file, thus its inclusion here, but it will also work at times like the results of a scan search, when dealing with a series of single-hit results. (NOTE: Due to some changes with Prism displays, this macro may not always work.)

PrevRec [text]

Goes to the previous record when BAC can't. This is of most use in the authority file, thus its inclusion here, but it will also work at times like the results of a scan search, when dealing with a series of single-hit results. (NOTE: Due to some changes with Prism displays, this macro may not always work.)

Batch-change holdings in OCLC

Holdings [binary ~17k total]

DeleteHoldings [text]

Delete holdings via a user-entered list. Type in a list of OCLC numbers--theoretically up to a few hundred or so, but I've found that limiting each use to a maximum of 50 or so is the easiest in practice for the user to handle--each separated only by a "+", and click on Ok or press Enter. The macro will call up each record and present you with a choice of Ok to delete your holdings of the record, Skip to ignore the current record and go to the next record, or Quit to immediately end the macro.

DeleteHoldingsFromFile [text]

Delete holdings from a file of OCLC numbers, one to each line. (The macro LastSystem on the Libs+ page creates such a file.)

Update [text]

Update library's holdings for a single record. The macro makes sure it is on the page of the record that contains the 049 tag, replaces the existing holding symbol with your library's individual symbol, and sends the update command. You will have to customize this macro by including your library's holding symbol in the place indicated in the macro.

UpdateHoldings [text]

Update holdings via a user-entered list. Except for updating instead of deleting, this macro works the same as the DeleteHoldings macro. You will have to customize this macro by including your library's holding symbol in the place indicated in the macro.

UpdateHoldingsFromFile [text]

Update holdings from a file of OCLC numbers, one to each line. (The macro UpdateFile on the Libs+ page creates such a file.)

General utilities for working with PRISM-Cat

NIKUtils [binary ~182k total]

007 [text]

Automatically add an primary 007 tag to a record. The macro searches the record itself for the data it needs to create an 007 line for a primary format that normally needs an 007 tag (and thus those parts of the record need to be as complete otherwise as possible), adds the tag as line 2.5, and reformats the record. You still need to check the results, as the computer can't always perfectly determine everything, but you probably won't have to do as much typing as when adding an 007 by hand.

Add007 [text]

Add an 007 tag to a record via a dialog box. This macro assumes you know what codes are going to go in which subfields. You are first asked for the type code, which goes in subfield a, and the macro then calls up the valid subfields for that type, each of which will only accept valid codes for that field. (The macro does not check for invalid combinations of fields, however.) It then adds the 007 tag to the record.

Alt007 [text]

An altered version of the above macro, using a single interactive dialog box that automatically alters the number of fields and possible values of each depending on what value is selected for subfield a.

BatchXpo [text]

Export records from the online save file based on a user-entered list. The "/" is dropped, and each number must be separated by a "+"; the macro calls up each record, then gives the user the opportunity to make sure it is the correct record (in case of typo) before exporting.

Change049 [text]

Change the 049 field to any of a list of possible four-letter codes, then update. Designed to help those libraries who have multiple holding symbols, or catalogers who deal with records from many libraries.

CtrlEnd [text]

Move the cursor to the end of a page. Allows cursor movement in Passport to be set up to work exactly like a Windows word processor (and CatME), rather than as normal with Home/End and CTRL-Home/End reversed from the way every other program works. Thanks to Rhoda Bilansky for the original macro.

CtrlHome [text]

Move the cursor to the start of a page. Allows cursor movement in Passport to be set up to work exactly like a Windows word processor (and CatME), rather than as normal with Home/End and CTRL-Home/End reversed from the way every other program works. Thanks to Rhoda Bilansky for the original macro.

End [text]

Move the cursor to the end of a line. Allows cursor movement in Passport to be set up to work exactly like a Windows word processor (and CatME), rather than as normal with Home/End and CTRL-Home/End reversed from the way every other program works. Thanks to Rhoda Bilansky for the original macro.

Home [text]

Move the cursor to the start of a line. Allows cursor movement in Passport to be set up to work exactly like a Windows word processor (and CatME), rather than as normal with Home/End and CTRL-Home/End reversed from the way every other program works. Thanks to Rhoda Bilansky for the original macro.

PrintAreaNoDiacritics [text]

Print a highlighted area. Use the mouse or shift + arrows to highlight an area, select Reverse or Blink from the Edit menu, and then run this macro to print all text in the area you selected.

PrintRecordNoDiacritics [text]

Print a record, replacing all diacritics. This is a modification of a modification to OCLC's PrintRecord macro that was posted to one of the library listservs. Start-of-Line characters are replaced by ">", subfield delimiter characters are replaced by "|", End-of-Line characters are replaced by " ", and all other diacritics are replaced by "*". This allows for quick draft printing of full records while still being able to tell diacritics from normal characters and spaces (each of which is a problem when trying to do this with the macros this is derived from).

PrintRecordRemoveDiacritics [text]

Print a record, deleting all diacritics. This is a modification of OCLC's PrintRecord macro. All diacritics are deleted, including the Start-of-Line, field delimiter, and End-of-Line characters.

Save-Xpo-Save [text]

Save a record, call it back up, export it, then save it again.

SaveSearch [text]

Search the online save file for a given title or OCLC number.

TextArea [text]

This macro, altered from a macro by Rhoda Bilansky which was designed to teach how interactive dialog boxes work, shows how to duplicate the TextArea dialog control found in other versions of Visual Basic & in HTML forms. It has no function as is other than to demonstrate the techniques involved--but might be of some help to those attempting to create copy-cataloging macros and wishing for some way to enter text into a multi-lined, scrollable box.

UnEnhance505 [text]

Remove all field delimiters from all 505 tags on the current page; useful for those libraries whose systems do not support enhanced 505 tags.

UnExportedSearch [text]

Search the online save file for records that have not yet been exported, and resave them so that the 14-day clock is restarted for those records. Designed for consortia or libraries with multiple holding symbols, as it only resaves records with a specific holding symbol.

val [text]

Validate an edited record.

xpo-save [text]

Export and save an edited record.

Miscellaneous macros

AutoCutter [text only]

Take an inputted name, title, etc. from the user, look it up in a cutter table, and display the resulting code in a message box. Note that the table data itself is not included and must be provided by individual users.

AutoCutter [text only]

A better version of the above macro. Among other things, it provides context for the result, so that the user can easily determine whether a user typo, macro error, or a local exception to standard rules has caused the macro to display a cutter other than the one that was desired.