OCLC 949 Macro

This is a macro you can use in Connexion to create a 949 control field.

What this macro does

This will insert two 949 fields at the end of a record in Connexion.

Open

• The first 949 with no indicators controls the bib record.

  • It follows the system described on this page: https://marmot-support.atlassian.net/wiki/x/NIBxJ

  • This line is not necessary. If you don’t want to use it, you can just delete it from each record, or remove it from the macro entirely.

  • The ov=. function will allow you to set a specific Sierra record number to overlay. This is probably the most common use of this command.

  • recs= can be used to select the load profile used (that will override the selection made in Data Exchange)

  • dflt= can set a bib or item template (overriding the templates set in the load profile)

  • ins= can set the initials of the user doing the load, if that was for some reason different from the person logged into Sierra.

  • If you use dflt= or ins= it would make sense to set those in the macro rather than changing them with each record. You could even create different macros with different templates or initials if you wanted.

• The second 949 with second indicator 1 controls the item record. This field actually triggers the creation of an item record (for many load profiles).

  • It follows the system described here: https://marmot-support.atlassian.net/wiki/x/K4DgLg or https://marmot-support.atlassian.net/wiki/x/AQChR

  • Multiple 949 1 fields would create multiple items.

  • ǂi is where you would put the barcode.

    • E.g. ǂi 33060013966168

  • ǂz is where you would put the MARC field that you want the call number to be in the item record.

    • E.g. ǂz 090 or ǂz 092 ǂz 099.

  • ǂa is where you would put the call number. If there is a cutter that would go in ǂb.

    • E.g. ǂa PS3618.O3268 ǂb A155 2026

• Filled out 949 fields might look like this in Connexion:

  Open

  

How to create a macro

• Open Tools => Macros => Manage

Open

• From here you get this menu

  Open

  

   

• Put the new macro in the OCLC group by clicking on the New Macro button

  Open

  

   

• Name the new macro “Add949”

  Open

  

   

• Name it “Add949” again

  Open

  

   

• Edit the new macro

  Open

  

   

• Select and delete all the default text

  Open

  

   

• Copy this text and paste it into the blank macro

  'MacroName:Add949 'MacroDescription:Add949 Sub Main Dim CS As Object Set CS = GetObject(,"Connex.Client") CS.AddField 1, "949 1" & Chr(223) & "i " & Chr(223) & "z " & Chr(223) & "a " CS.AddField 1, "949 *recs=b;ov=.;dflt=[BibTemplate],[ItemTemplate];ins=[login];" End Sub

• Save the new macro and close the editor

  Open

  

Assign the macro to a User Tool

• Open User Tools

  Open

  

   

• Click the Macro radio button

• Select OCLC!Add949 macro

• Select User Tool 1 (Or whichever you want to use)

• Click the Assign Tool button

  Open

  

   

• When OCLC!Add949 is selected the Current User Tool will display

  Open

  

   

• Now you can assign the macro to a toolbar shortcut

• Click Tools => Toolbar Editor

  Open

  

   

• Scroll all the way down to the User Tools section and choose Tool1 (or whichever tool you assigned)

  Open

  

   

• Click and drag the tool onto your toolbar. You can put it anywhere you want on your toolbar.

  Open

  

Assign a keyboard shortcut

• You can also assign a keyboard shortcut with Tools => Keymaps

  Open

  

   

• Select the Macro radio button

• Select the Add949 macro

• Put the cursor in the “Press New Shortcut Key” box

  Open

  

   

• Press the key you want to use like Alt+1 (not Alt+F1 which already does something)

• Click the “Assign” button

  Open

  

   

• Now Add949 is assigned to the Alt+1 key combination

  Open

  

   

• Now you can use either the keyboard shortcut or toolbar to insert these rows into an active record

  Open

  

   

Top of page

Related Documentation