Local Practices Macro

Connexion macros

for bib records

macro	use
028 to 500	Adds 500 based on 028.
033	Creates 033 field based on 518 data.
047	Adds 047 based on subject headings.
082 travel	Converts WebDewey data from table 2 to proper 082 field.
245 to 240	Moves title from 245 to 240. Useful for deriving records of translated works.
245 ‡c to 700	Creates added entries for names in 245 ‡c. Used mainly for feature films on DVD.
246	Adds prescribed 246s based on 245 data.
300 to 306	Creates 306 field and cleans up duration note in 300.
4XX to 830	Creates 830 field and fixes 4XX based on new LC guidelines
505 no ‡g	Removes ‡g from before initial articles in the 505 field.
505 no ‡r	Removes data in ‡r from 505 field. Useful for removing composers from non-classical records.
505 ‡r to 7XX	Creates added entries from 505 ‡r. Most often used for soundracks and compilation CDs.
65X removal	Deletes bad subject headings.
690 xxx language materials	Creates 690 xxx language materials note based on fixed field element Lang.
700 to 710	Switched headings back and forth between 700 and 710. Use in conjunction with 505 ‡r to 7XX.
856 removal	Deletes unnecessary 856 fields.
Audiobooks	Applies local practices to audiobook records.
Blu-ray	Applies local practices to Blu-rays.
CDs	Applies local practices to CDs.
CD-ROMs	Applies local practices to CD-ROMs.
Closed-captioned	Adds closed-captioning note and corresponding 655 field.
Complete idiot's guide	Adds 246 fields based on authority record.
Dervive new record	Derives new record. Creates title change links for serials. Cleans up NUKAT records.
DVDs	Applies local practices to DVDs.
Foreign summaries	Coverts text with diacritics copied from the web to a Connexion-friendly format. (Currently only works with Polish)
Encoding level 3 records	Applies local practices to encoding level 3 records.
Multiple to Multipart	Derives a new, multipart monograph from an existing monograph record.
Playaway	Applies local practices to Playaway records.
Uniform titles for motion pictures	Adds motion picture uniform title.

for authority records

macro	use
Geographic	Adds 043 and 781 to geographic authority records.
Give phrase as a quoted note	Changes series heading to phrase heading and inserts 667 note.
IMDb note	Adds 670 note with today's date and reference to IMDb

general

macro	use
Export record	Exports record or lists error messages.
Pin and lock	Pins and locks a record.
Print	Prints current record. Has junk tag option.

Word macros

macro	use
Union list	Wikifies the union list from CCS website version.

Excel macros

macro	use
Director's Station	Formats spreadsheets exported from Director's Station. Mainly for spreadsheets created by the pdf (e.g. Show shelflist)