Macros for the Connexion Client

For help in loading these macros into Connexion, see my step-by-step instructions.

Utility functions

NikAdds!IncludeFunctions [Macrobook file (not text)]
A macrobook containing a macro of various handy functions that can be called by other macros. To do so, add '$Include "NikAdds!IncludeFunctions" before Sub Main in your macro. The Declare Function statements at the start of the macro lists the functions and their arguments. These functions include, but are not limited to: To load this macrobook into Connexion, simply save the file to your hard drive in the Macros directory in your Connexion program directory (usually C:\Program Files\OCLC\Connexion\Program\Macros).

Macros

082to092 [Text]
Copy the call number from an 082 to the 092 field. The macro strips out any subfield codes and LC breakpoints from the call number in the process.
508-511to700 [Text]
Take all names from existing 508 or 511 fields (or both), and add a 700 field for each name. The macro relies on the presence of commas and semi-colons to determine where a name starts and stops, so there may often be "false" fields that need to be deleted, and some names (especially those that should be in direct order, or where there are multiple surnames) will need to be altered to reflect the authorized form of the name.
Add007 [Text]
Creates an 007 tag based on user input.
AF-SeriesBrowse [Text]
If you put the cursor anywhere in a 440 or 490 field, then run the macro, the macro will use the contents of the field to browse the series title in the Authority File.
BatchAction [Text]
Execute OCLC actions on a list of records.
BatchChange [Text]
Add, delete, or find & replace fields, subfields, or data almost anywhere in the variable fields of a list of records. (Note: This macro has not yet been fully bulletproofed & rendered "smart" enough to handle certain common situations. For example, when adding a subfield to the end of a 6XX field, if the existing field ends with a period, the macro is not yet smart enough to move the period to the end of the new subfield. Therefore, this should be considered a work in progress rather than a completed macro. I will update the file here when I have time to alter the macro.)
CatME2Cnx [Text]
Copy an open NEW OCLC bib or authority record from CatME to Connexion. Does not copy full records (export, then import those instead). It should correctly handle flipping diacritics from before the letters they modify to afterwards. (Note: Due to a bug in the CS.FixedFieldPosition command, your Connexion display will always display the fixed fields in tagged rather than mnemonic format after running this macro. To switch back to the standard mnemonic display when you're done copying in-process records, go to the View menu, select OCLC Fixed Field, then select Top or Bottom.)
Cnx2XL [Text]
Copy the author (if any), title, OCLC number, record format, and today's date from a displayed record into an existing Excel file, in order to keep cataloging statistics.
CopyMultiple [Text]
Copy multiple, non-contiguous fields from a displayed record for later pasting into another record, a text document, or an e-mail.
Enhance505 [Text]
Automatically add enhanced subfields to an unenhanced contents note. Note that, because of variations in the way different catalogers enter 505s, the results are not always accurate, especially where section names (e.g. "Cassette 1") and names or titles in parentheses are concerned, so be sure to double-check the results before taking final actions on the record. This macro requires the NikAdds macrobook (available above).
MacroSynch [Text]
Check whether the versions of macrobooks on a shared drive are newer than the local versions, and if they are, automatically copy down the new versions. Note: This macro has to be in its own macrobook, because you can't overwrite a book with a macro that's currently running.
NextAF [Text]
When looking at a record from an authority file brose, this macro goes forward to the next record in the browse list. (Note: Due to a bug in Connexion, this macro will not work properly if the next item is supposed to open up an expanded browse list instead of a single record, but it will work properly if the current record was opened from an already-open expanded browse list. In other words, this macro will work most of the time, but not all of the time.)
PrintRecordNoDiacritics [Text]
Dump a record to the Windows default printer, with all diacritics converted to printable characters. (If the default printer is "Generic/Text Only", this enables speedy draft printing of records.)
ReSaveFile [Text]
Resave all records in the online cataloging save file. If you are currently viewing a save file list that does not include every record in the save file, then the macro will only resave the listed records. If you are not currently viewing a save file list, the macro will automatically search for all records in the save file. If you are not currently online, the macro will automatically log on first.
SaveRecordAsFile [Text]
A Connexion version of Passport's SaveScreen macro, this takes the currently-displayed record and saves it to a text file in the Connexion program directory.
SirsiCopy [Text]
Copy selected variable field data from Connexion to the Windows Clipboard, reformatted for later pasting into Sirsi's Workflows product. This macro may work with any other vendor's catalog software, if pipes (vertical bars) are used for delimiters and no spaces are present on either side of a subfield delimiter or letter.
SirsiPaste [Text]
Reformat and paste at the current cursor position data already copied from Sirsi's Workflows product to the Windows Clipboard. This macro may work with any other vendor's catalog software, if pipes (vertical bars) are used for delimiters and no spaces are present on either side of a subfield delimiter or letter.
Split041 [Text]
Split up an 041 field so that each language code is in its own subfield.
StartFromScratch [Text]
Delete all but the system-supplied fields from a minimal Encoding Level 3 record and replace it with workform data, so that enhancing the record is more like doing original cataloging.
Transliteration [Zipped macrobook file]
This macrobook contains a suite of six macros: Each macro transliterates a field to or from a particular non-Latin script.

To use the ***2Latin macros, put the cursor in a field containing script using that alphabet, then run the macro. The macro will attempt to transliterate the data, will add the Romanized data in a new field, and will link the new field to your existing field.

To use the Latin2*** macros, put the cursor in a field containing Romanized data, then run the macro. The macro will attempt to un-transliterate the data, will add the vernacular characters in a new field, and will link the new field to your existing field. These macros will attempt to transliterate all Latin-alphabet text in a field (except for subfield indicators), so you may have to manually change some subfields back to Latin; for example, GMDs.

In both cases, you will have to double-check the results, because the macro cannot handle every possible case and exception. This is in part because some vernacular characters on the transliteration tables are not yet valid for use in MARC records, and some valid MARC characters are not included in the Arial Unicode MS font (nor most other Unicode fonts); these will be transliterated by the macro as fill characters (a black rectangle). In these cases, you must manually edit the transliterated field before the record will validate. You may have to use character descriptions instead of the actual characters, as instructed in the Connexion help file; for example, the Azerbaijani schwa should be entered as "[Schwa]" or "[schwa]" (depending on case) in an otherwise vernacular field, as that character is not valid for use in MARC records.

With all of the macros, you will be asked to select a transliteration table to use. If you want to change the default selections (so that you can simply press Enter most of the time), you can do this by editing the indicated values just after "Sub Main" in the relevant macro.

If you have problems unzipping the file, here is the plain macrobook file, which you should be able to simply download and move into your Macros directory. However, because the file is so large, and I do not want the number of download requests to overwhelm my daily limits, I ask you to please instead download the zipped version above unless absolutely necessary.

Return to the Main page.