Collection division macros: Difference between revisions

Revision as of 14:02, 11 May 2018

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.

Expand to see macro command textMacro 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.

Expand to see macro command textMacro 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

Expand to see macro command textText 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.

Expand to see macro command textText 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.

Expand to see macro command textText 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

Expand to see macro command textMacro 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

Expand to see macro command textMacro 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

Expand to see macro command textMacro 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

Expand to see macro command textText 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

Expand to see macro command textText 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

Expand to see macro command textText 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)

Expand to see macro command textText Type: <SPACE>(BookReader view)

ctrl+shift+q

 (BookReader thumbnails)

Expand to see macro command textText Type: <SPACE>(BookReader thumbnails)

ctrl+shift+s

 (selections only)

Expand to see macro command textText Type: <SPACE>(selections only)

ctrl+alt+p

 (with partial transcription)

Expand to see macro command textText 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.)

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>

@@ Line 87: / Line 87: @@
 ''ctrl+shift+h''
 :HBCN
-<pre style="margin-left:2em">500 ## ‡a This record represents material that has not yet been cataloged. It may contain incorrect or incomplete information. Please consult Curator for assistance.  ‡5 DFo</pre>
+<pre style="margin-left:2em">500 ## ‡a This is a PRELIMINARY RECORD. It may contain incorrect information. Please email HamnetHelp@folger.edu for assistance ‡5 DFo</pre>
 <pre style="min-height:38px; margin-left:2em" class="mw-collapsible mw-collapsed" data-expandtext="Expand to see macro command text">
 Text Type: <F4>500