Collection division macros

The following is a list of all macros used by the central library department. With the exception of the Connexion macros, all macros listed were created with MacroExpress.

Connexion

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.
Voyager import from OCLC
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.
YBP Holdings
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
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.

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>