Con Library Technical Services: Connexion

Connexion export settings: See Connexion setup (INTERNAL)

Unicode [IMPORTANT!]

Go to: Options--Export--Record Characteristics--Character Set. Make sure Character Set is UTF-8 Unicode under Bibliographic and Authority.  

Unicode-friendly font

Noto sans, download via Google. Once installed, can be used in Connexion, Word, etc.

Use MARC field 949 prior to exporting from Connexion to overlay or create bib records and to create item records. Details and a full list of commands are in the III Sierra Manual under  “Local Fields in Bibliographic and Item Record Downloading”.

Bib overlay, replace LLLL with bib location and XXXXX with match point including record-type letter prefix (b, o):

949  *recs=b;bn=LLLL;b3=-;ov=.XXXXX;

           To retain existing cataloging date in sierra, append: ct=mm-dd-yy;

Use second indicator "1" to create an item record, adding one field per item.

Bib overlay, cons (replace XXXXX with bib no, e.g. ov=.b123456;)

949  *recs=b;bn=cons;b3=-;ov=.XXXXX;

Bib overlay, cons CD (includes code for bib mat type)

949  *recs=b;bn=cons;b2=9;b3=-;ov=.XXXXX;

Brief bib creation, suppress bib, cons

949  *recs=b;bn=cons;b3=s;

Recat overlay, preserve cat date (set here to common 9-6-1994 date)

949  *recs=b;bn=cons;b3=-;ct=090694;ov=.XXXXX;

Item records, Con [edit as needed]

Con regular score item record:

949 1ǂz 090 ǂs p ǂt 2 ǂl cs ǂi BARCODE ǂa CALLNO ǂc VOLUME

Con oversize score item record:

949 1ǂz 090 ǂs p ǂt 61 ǂl csos ǂi BARCODE ǂa CALLNO ǂc VOLUME

Con 3-day score item record:

949 1ǂz 090 ǂs p ǂt 7 ǂl cs ǂi BARCODE ǂa CALLNO ǂc VOLUME

Con noncirculating book/MT record:

949 1ǂz 090 ǂs i ǂt 6 ǂl cbk ǂi BARCODE ǂa CALLNO ǂc VOLUME

Con regular CD item record:

949 _1 CALLNO ǂz 099 ǂs p ǂt 31 ǂl crcd ǂi BARCODE

Con regular CD booklet record:

949 _1 CALLNO ǂz 099 ǂs p ǂt 31 ǂl clima ǂc notes ǂi BARCODE

Con regular DVD item record:

949 1DVD-XXXXX ǂz 099 ǂs p ǂt 13 ǂl cvidd ǂi BARCODE

Con regular LP item record:

949 LP-XXXXX ǂz 099 ǂs p ǂt 11 ǂl crlp ǂi BARCODE

Con Special Collections - Kohl, bib and item

949  *recs=b;bn=conss;b3=-;ov=.XXXXX;

949 1ǂz 090 ǂs i ǂt 6 ǂl csck ǂi BARCODE ǂa CALLNO ǂc VOLUME

• OCLC Macro page
• Joel Hahn macros of note
  • CopyMultiple
  • Enhance505
  • Transliteration
• Music Toolkit
  • Instructions and download link
  • Error reporting form

To back up preferences (toolbar, text strings etc):

• GO TO:  C:\Users\USERNAME\AppData\Roaming\OCLC\Connex\Profiles\MyProfile
• Copy all .xml files. Make sure you copy, not move.
• Put copies in a folder somewhere else (Documents, Desktop, flash drive, etc).

To back up local save files:

• GO TO:  C:\Users\USERNAME\AppData\Roaming\OCLC\Connex\Db
• Copy contents to folder somewhere else (Documents, Desktop, etc). Make sure you copy, not move.

To back up macros:

• GO TO: C:\Program Files (x86)\OCLC\Connexion\Program\Macros
• Copy contents to folder somewhere else (Documents, Desktop, etc). Make sure you copy, not move. 

NOTE: Add BACKUP to your folder names to make sure you and the computer do not confuse them for the originals.

To select or recorder columns:

Display a list of records from your local save file. Right-click anywhere in the list of records (not the column headers) and choose List Settings from the little menu that pops up. That gets you a dialog box where you can check and uncheck columns to get only the ones you want to see, and move them around using Move Up and Move Down buttons.

To sort list:

Click on column header for ascending or descending.