Collection division macros

The following is a list of macros used in the Collection division. All macros except the Connexion macros were created with MacroExpress.

Connexion

OCLC Connexion comes with about 15 macros pre-loaded for catalogers to use when creating and editing records. Some examples are:

  • Add33x generates a set of 336, 337, and 338 fields (content, media, and carrier types) based on cataloger input, and is useful when creating or updating records to RDA.
  • GenerateAuthorityRecord creates a bare-bones authority record from a 1xx or 7xx field, and streamlines the entry of common authority information such as associated place and language.
  • GenerateERecord derives an e-resource record from the record currently being worked on (for example, if a cataloger discovers that the book they are working with has been digitized by the Hathi Trust, but a record has not yet been created in OCLC for the digitized version)


In the Connexion client interface, macros can be accessed at Tools > Macros > Manage (or Ctrl+Alt+Shift+G). Connexion macros can be edited, adapted, or created from scratch with the Edit or New Macro commands; more information can be found in the Macros section of OCLC's Connexion client documentation.

Many librarians and libraries have made collections of their own OCLC macros available: Joel Hahn has a number of useful macro resources, as does Walter Nickeson.

IrfanView

ctrl+alt+shift+2

When the left page of a two-page-spread is highlighted, saves each page separately and navigates to the next two-page-spread. (To be used with the ctrl+alt+shift+c macro.)
Text Type: <ALT>en
Text Type: s
Text Type: <RIGHT ARROW>a<ENTER>
Text Type: <CTRL>z
Text Type: <CTRL>x
Text Type: s
Text Type: <RIGHT ARROW>b<ENTER>
Text Type: <SPACE>

ctrl+alt+shift+c

Crops the blank space from all of the chopped-in-half images in a directory, and exits IrfanView when finished. (To be used with the ctrl+alt+shift+2 macro.)
Macro Playback Speed: 2 Times Slower than Normal
Variable Set String %T2% "true"
Repeat Until %T2% = "false"
   Text Type: <CTRL>Y
   Delay 100 Milliseconds
   Text Type: <CTRL>s
   Delay 100 Milliseconds
   Text Type: <ENTER>
   Delay 100 Milliseconds
   Text Type: <LEFT ARROW>
   Delay 100 Milliseconds
   Text Type: <ENTER>
   Delay 500 Milliseconds
   Text Type: <SPACE>
   Wait For Window Title: ".jpg"
   Variable Set String %T1% from Window Title
   Variable Set Integer %N1% from Position of Text in Variable %T1% //Search Text: .
   Variable Set Integer %N2% from Length of Variable %T1%
   Variable Modify Integer: %N2% = %N2% - %N1%
   Variable Modify Integer: Inc (%N1%)
   Variable Modify String: Delete Part of %T1% //Starting Position: N1, Characters to Delete: N2
   If Variable %T1% does not contain "a."
      AND
   If Variable %T1% does not contain "b."
      Variable Set String %T2% "false"
   End If
Repeat End
Text Type: <ALT>fx
Macro Stop

ctrl+shift+r

Batch renames thumbnails from the "images jpg" folder into the "images" folder (created with the ctrl+shift+i macro), then exits IrfanView.
Macro Playback Speed: 2 Times Slower than Normal
Text Type: <CTRL>a
Delay 250 Milliseconds
Text Type: b
Delay 250 Milliseconds
Text Type: <ALT>l
Delay 250 Milliseconds
Text Type: <ALT>w
Delay 250 Milliseconds
Text Type: <UP ARROW>
Delay 250 Milliseconds
Text Type: <ENTER>
Delay 250 Milliseconds
Text Type: <ALT>s
Wait For Window Title: "Batch conversion done"
Text Type: <ALT><F4>
Text Type: <ALT><F4>
Text Type: <ALT><F4>

Other

ctrl+shift+i

Within a BookReader folder within the "bookreaders to upload" folder, adds three empty folders, one called "images", one called "images jp2k", and one called "images jpg", and a book.properties file.
Macro Playback Speed: 2.5 Times Slower than Normal
Variable Set String %T1% from Window Title
Text Type: <ALT>fwf
Delay 0.5 Seconds
Text Type: images
Text Type: <ENTER>
Text Type: <ALT>fwf
Delay 0.5 Seconds
Text Type: images jp2k
Text Type: <ENTER>
Text Type: <ALT>fwf
Delay 0.5 Seconds
Text Type: images jpg
Text Type: <ENTER>
Delay 0.5 Seconds
Launch and Activate: "notepad.exe" // Window Title: Notepad; Program Path/Name: C:\WINDOWS\system32\notepad.exe
Text Type: BookIdentifier = %T1%
Text Type: <ENTER>
Text Type: Thumbnail Image = 0001
Text Type: <ENTER>
Text Type: TotalPages = 
Text Type: <ALT>fa
Text Type: C:\Users\ewahl.FOLGER2000\Desktop\bookreaders to upload\
Text Type: %T1%\book.properties
Text Type: <ENTER>
Text Type: <ALT>fx

ctrl+shift+e

With Outlook open, sends an email to [Person 1] and [Person 2] alerting them of a bookreader upload.
Text Type: <CTRL>n
Text Type: Person 1<TAB>
Text Type: Person 2<TAB>
Text Type: <TAB><TAB>
Text Type: insight upload today (bookreaders) (nfm)
Text Type: <CTRL><ENTER>

ctrl+shift+f

After copying a link from Luna, pastes a properly formatted link into the finding aid.
Text Type: <ENTER>
Text Type: <altformavail>
Text Type: <ENTER>
Text Type: <head>Digital image(s)
Delay 1 seconds
Text Type: <ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT>
Text Type: <ENTER>
Text Type: <p>
Text Type: <extref ns2:actuate="onLoad" ns2:show="new" ns2:title="Digital image(s)"<SPACE>
Text Type: ns2:href="
Clipboard Paste
Text Type: ">
Clipboard Paste

ctrl+shift+a

When a Bard Classic-style link (text: link) is highlighted, changes it to a Bard2/Folgerpedia-style link ([link text]).
Clipboard Copy
Variable Set String %T1% from Clipboard
Variable Set String T2% "%T1%"
Variable Set Integer %N1% from Length of Variable %T1%
Variable Set Integer %N2% from Position of Text in Variable %T1% //Search Text: :
Variable Modify Integer: %N3% = %N1% - %N2%
Variable Modify Integer: Inc (%N3%)
Variable Modify String: Delete Part of %T1% //Starting Position: N2, Characters to Delete: N3
Variable Modify String: Delete Part of %T2% //Starting Position: 1, Characters to Delete: N2
Variable Modify String: Left Trim %T2%
Text Type: [%T2% %T1%]

alt+shift+s

When the text is highlighed, will flip text from [string a], [string b] to [string b], [string a].
Clipboard Copy
Variable Set String %T1% from Clipboard
Variable Set String T2% "%T1%"
Variable Set Integer %N1% from Length of Variable %T1%
Variable Set Integer %N2% from Position of Text in Variable %T1% //Search Text: ,
Variable Modify Integer: %N3% = %N1% - %N2%
Variable Modify Integer: Inc (%N3%)
Variable Modify String: Delete Part of %T1% //Starting Position: N2, Characters to Delete: N3
Variable Modify String: Delete Part of %T2% //Starting Position: 1, Characters to Delete: N2
Variable Modify String: Left Trim %T2%
Text Type: %T2%, %T1%

ctrl+alt+t

When text is highlighted, a text box will display with the ASCII values of the characters in the highlighted text.
Clipboard Copy
Variable Set String %T1% from Clipboard
Variable Set Integer %N1% from Length of Variable %T1%
Variable Set String %T2% ""
Repeat Start (Repeat %N1% times)
   Variable Set %N2% to ASCII Value of %T1%
   If Variable %N3% = 1
      Variable Modify String: Append "%N2%" to %T2%
   Else
      Variable Modify String: Append ", %N2%" to %T2%
   End If
   Variable Modify String: Delete Part of %T1% //Starting Position: 1, Characters to Delete: 1
Repeat End
Text Box Display: //Box Content: %T2%

ctrl+shift+L

For BBI project: in Access, to be used when "leaf" is left off before the signature. This macro will add "leaf" to the beginning of the page-level metadata field in the highlighted cell, and then navigate to the cell below.
Clipboard Copy
Text Type: leaf<SPACE>
Clipboard Paste
Text Type: <ARROW DOWN>