Collection division macros

Revision as of 14:02, 11 May 2018 by DeborahLeslie (talk | contribs) (→‎Cataloging module: updated hbcn text)

The following is a list of macros used in the Central Library 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 do the University of Rochester libraries.

Voyager

Cataloging module

shift+F1

This macro imports to Voyager the exported records from Connexion. It saves the Bib record, creates new Holdings and Item records, saves all and clears the screen.
Macro Playback Speed: 2 Times Slower than Normal
Text Type: <ALT>rpv
Delay 1 Seconds
Text Type: <Enter>
Delay 1 Seconds
Text Type: <TAB><TAB><TAB><TAB><TAB>
Text Type: <SPACE><SHIFTD><ARROW LEFT><ARROW LEFT><ARROW LEFT><SHIFTU>
Repeat Until %T1% = "099"
   Clipboard Copy
   Variable Set String %T1% from Clipboard
   If Variable %T1% = "099"
      Text Type: <TAB><TAB><TAB>
      Delay 0.5 Seconds
      Text Type: <SHIFTD><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><SHIFTU>
      Clipboard Copy
      Variable Set String %T2% from Clipboard
      Break
   Else
      Text Type: <TAB><TAB><TAB><TAB>
   End If
Repeat End
Delay 1 Seconds
Text Type: <ARROW RIGHT>
Text Type: <CONTROL>b
Delay 1 Seconds
Text Type: <ALT>re
Delay 1 Seconds
Text Type: <TAB><TAB><TAB><TAB><TAB><TAB>8
Delay 0.5 Seconds
Text Type: <TAB><TAB>
Delay 0.5 Seconds
Text Type: <END><SPACE>
Delay 0.5 Seconds
Text Type: %T2%
Text Type: <CONTROL>b
Delay 1 Seconds
Text Type: <ALT>rt
Delay 0.5 Seconds
Text Type: <CONTROL>b
Delay 1 Seconds
Text Type: <ALT>fo
Text Type: <ENTER>
Text Type: <CONTROL>b
Delay 1 Seconds
Text Type: <ALT>fo

ctrl+shift+z

Highlight the call number in the 050 field and then deploy the shortcut. This macro creates new a new Holdings record.
Macro Playback Speed: 2 Times Slower than Normal
Text Type: <CONTROL>c
Variable Set String %T1% from Clipboard
Replace "‡b" with "‡i" in %T1%
Text Type: <ALT>rh
Delay 1 Seconds
Text Type: <TAB><TAB><TAB><TAB><TAB><TAB>0
Text Type: <TAB><TAB><END>
Text Type: <F9>h
Delay 1 Seconds
Text Type: %T1%
Delay 1 Seconds
Text Type: <CONTROL>b

ctrl+shift+h

HBCN
500 ## ‡a This is a PRELIMINARY RECORD. It may contain incorrect information. Please email HamnetHelp@folger.edu for assistance ‡5 DFo
Text Type: <F4>500
Text Type: <TAB><TAB><TAB>
Text Type: This record represents material that has not yet been cataloged. It may contain incorrect or incomplete information. Please consult Curator for assistance.
Delay 0.5 Seconds
Text Type: <F9>5
Delay 0.5 Seconds
Text Type: DFo

ctrl+alt+5

530 ## ‡a Also available as a digital reproduction.
Text Type: <F4>530
Text Type: <TAB><TAB><TAB>
Text Type: Also available as a digital reproduction.

ctrl+shift+p

530 ## ‡a Portions also available as a digital reproduction.
Text Type: <F4>530
Text Type: <TAB><TAB><TAB>
Text Type: Portions also available as a digital reproduction.

ctrl+shift+5

583 0# ‡a [Action] ‡c yyyy-mm ‡k RAB ‡n 1 ‡o piece ‡2 local ‡5 DFo
Macro Playback Speed: 1.5 Times Slower than Normal
Multiple choice menu: $a //Menu options: Radio button menu; Save item text; Destination variable: %T1%; Title: $a; Description/prompt: $a - Action; Menu list: A: Preliminary cataloging, B: Cataloged, C: Recataloged, D: Copy added
Delay 250 Milliseconds
Text Type: <F4>583
Text Type: <TAB>0<TAB><TAB>
Text Type: %T1%
Text Type: <F9>c
Delay 0.15 Seconds
Date/Time: Type out "YYYY-MM"
Delay 0.15 Seconds
Text Type: <F9>k
Text Type: RAB
If Variable %T1% does not contain "Preliminary cataloging"
   Text Type: <F9>n
   Text Type: 1
   Text Type: <F9>o
   Text Type: <F9>piece
End If
Text Type: <F9>2
Text Type: local
Text Type: <F9>5
Text Type: DFo

ctrl+alt+L

583 0# ‡a Upgraded ‡c yyyy-mm ‡k EEW ‡n 1 ‡o link ‡x Luna ‡2 local ‡5 DFo
Macro Playback Speed: 2 Times Slower than Normal
Date/Time: Save "YYYY-MM" into %T1%
Delay 0.15 Seconds
Text Type: <F4>583
Text Type: <TAB>0<TAB><TAB>
Text Type: Upgraded
Text Type: <F9>c
Delay 0.15 Seconds
Text Type: %T1%
Text Type: <F9>k
Delay 0.15 Seconds
Text Type: EEW
Text Type: <F9>n
Delay 0.15 Seconds
Text Type: 1
Text Type: <F9>o
Delay 0.15 Seconds
Text Type: link
Text Type: <F9>x
Delay 0.15 Seconds
Text Type: Luna
Text Type: <F9>2
Delay 0.15 Seconds
Text Type: local
Text Type: <F9>5
Delay 0.15 Seconds
Text Type: DFo

ctrl+alt+f

583 0# ‡a Upgraded ‡c yyyy-mm ‡k EEW ‡n 1 ‡o link ‡x Folgerpedia ‡2 local ‡5 DFo
Macro Playback Speed: 2 Times Slower than Normal
Date/Time: Save "YYYY-MM" into %T1%
Delay 0.15 Seconds
Text Type: <F4>583
Text Type: <TAB>0<TAB><TAB>
Text Type: Upgraded
Text Type: <F9>c
Delay 0.15 Seconds
Text Type: %T1%
Text Type: <F9>k
Delay 0.15 Seconds
Text Type: EEW
Text Type: <F9>n
Delay 0.15 Seconds
Text Type: 1
Text Type: <F9>o
Delay 0.15 Seconds
Text Type: link
Text Type: <F9>x
Delay 0.15 Seconds
Text Type: Folgerpedia
Text Type: <F9>2
Delay 0.15 Seconds
Text Type: local
Text Type: <F9>5
Delay 0.15 Seconds
Text Type: DFo

ctrl+shift+8

856 41 ‡u ‡z Digital reproduction of Folger Shakespeare Library 
Text Type: <F4>856
Text Type: <TAB>4<TAB>1<TAB>
Text Type: <BACKSPACE><BACKSPACE>u<SPACE>
Text Type: <F9>z
Text Type: Digital reproduction of Folger Shakespeare Library 

ctrl+shift+b

856 41 ‡u ‡z Bindings images and description for Folger Shakespeare Library 
Text Type: <F4>856
Text Type: <TAB>4<TAB>1<TAB>
Text Type: <BACKSPACE><BACKSPACE>u<SPACE>
Text Type: <F9>z
Text Type: Bindings images and description for Folger Shakespeare Library 

ctrl+shift+2

856 42 ‡u ‡z Folgerpedia article about Folger Shakespeare Library 
Text Type: <F4>856
Text Type: <TAB>4<TAB>2<TAB>
Text Type: <BACKSPACE><BACKSPACE>u<SPACE>
Text Type: <F9>z
Text Type: Folgerpedia article about Folger Shakespeare Library 

ctrl+shift+v

 (BookReader view)
Text Type: <SPACE>(BookReader view)

ctrl+shift+q

 (BookReader thumbnails)
Text Type: <SPACE>(BookReader thumbnails)

ctrl+shift+s

 (selections only)
Text Type: <SPACE>(selections only)

ctrl+alt+p

 (with partial transcription)
Text Type: <SPACE>
Text Type: (with partial transcription)

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>