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.)
Expand to see macro command textText 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.)
Expand to see macro command textMacro 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.
Expand to see macro command textMacro 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.
Expand to see macro command textMacro 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.
Expand to see macro command textText 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.
Expand to see macro command textText 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]).
Expand to see macro command textClipboard 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].
Expand to see macro command textClipboard 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.
Expand to see macro command textClipboard 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.
Expand to see macro command textClipboard Copy
Text Type: leaf<SPACE>
Clipboard Paste
Text Type: <ARROW DOWN>