BookOps Cataloging Dept. Connexion Macros

A repository of BookOps Cataloging Department macros for the OCLC Connexion client.

Installation

Easy Way

To install, find the macrobook you are interested in the Connexion-Macros/macrobooks/ folder, click on it, and download it to your computer.

Example, downloading the CAT macrobook which includes UpdateExport, BackupSettings, and other macros:

Then copy the macro book (.mbk file) to the C:/Users/[your-name]/AppData/Roaming/OCLC/Connex/Macros/ directory on your computer. If a copy of the macro exists already, overwrite it with the downloaded version. It is recommended to do this while your Connexion client is closed.

If you do not see the AppData directory in your Windows profile (it is hidden by default on library computers), reveal it using the following instruction:

1. Open the Windows Folder Explorer application
2. Navigate to your profile folder: C:/Users/[your-username]
3. Go to the View tab in the toolbar
4. Select Hidden items option
5. Verify AppData is visible now

Hard Way (Copy and Paste from Source)

Alternatively, copy the code for the individual macro directly from the .BAS file (/source directory) using the macro editor in Connexion.

1. Tools > Macros > Manage (CTRL-ALT-SHIFT-G)
2. Select a local macro book
3. Click the New Macro button
4. Enter in a description
5. Click OK
6. Enter in a name for the macro
7. Click the Edit button to open the OCLC Connexion Macro Editor and Debugger.
8. Use the mouse to select all the text
9. Paste the text copied from the source into the Editor
10. Click the Check icon in the toolbar
11. Click the Save icon in the toolbar
12. After the macro is saved then it can be mapped to a user tool, key, or key chord as usual (optional). Done!

Macros

1. Bookops.mbk macrobook
   • Utilities.bas v1.0.0: includes macro updater, single and dual profile creation, and Connexion settings backup and restore functions
2. Brooklyn.mbk macrobook
   • BPLCallNum.bas v3.4.0: BPL call number creation macro
   • ToExcel.bas v1.2: exports elements of displayed in the Connexion client record to the .xls format
3. NYPL.mbk macrobook
   • NYPLCallNum.bas v3.2.1: NYPL call number creation macro
   • NYPLMusicCD.bas v1.5: NYPL music CDs call number creation macro
4. CAT.mbk macrobook
   • BackupSettings.bas v1.0.0: backups Connexion client settings
   • BibcoEval.bas v1.0: evaluates and flags elements missing or incorrect for BIBCO records
   • UpdateExport.bas v1.9: updates holdings, cleans 6xxs, sets appropriate Sierra load table, and exports records to Sierra; to be used in BookOps CAT
   • UpdateExport_Permissive.bas v1.3: more permissive version of UpdateExport macro allowing a wider range of vocabularies in 6xx fields
   • ShareSave.bas v1.0
   • UserDual.bas v1.0.0: creates dual, BPL & NYPL, profiles in the Connexion client; requires access to CATAL network drive
   • UserNYP.bas: creates single NYPL Connexion client profile
5. ACQ.mbk macrobook
   • RLOrderRec.bas v3.2: encodes order record information in a special MARC field and exports to Sierra
6. NewMacros.mbk macrobook
   • updater.bas v2.1: pulls and updates local macrobooks using a network drive

License

MIT