Software and/or materials required

• Sierra

• Connexion

• Internet browser

Project summary/background

In the original data from ROVI, some of the musician’s names were entered with nicknames with quotation marks. Somehow, these presence of these quotation marks caused the data extraction method used by ROVI to delete the last two letters of the person’s last name.

This project is to figure out who these musicians are and correct their names using the LC Name Authority File (LCNAF).

Project instructions

• Open the spreadsheet “Rovi Names with Nicknames.” https://docs.google.com/spreadsheets/d/10Lx8R6kZoMkSLWtZDh7T_7t-j0BWbzJSEV4ua-uNzXw/edit?usp=sharing

• Put your initials in the Initials column by some of the names. This will prevent multiple people from editing the same record at the same time.

• Figure out what the last name is. Sometimes you’ll be able to guess (i.e. “Smi” is likely to be “Smith”). But be prepared to search when your guess doesn’t work out.

• Finding a digital image of the CD is often helpful because you can read the name. Good places to find CD images are:

  • AllMusic https://www.allmusic.com/

  • Discogs regular search (1 search box) https://www.discogs.com/

  • Discogs advanced search 2 search boxes (title + creator) https://www.discogs.com/search/advanced

  • Amazon - Search the UPC code found in the 024 field of the Rovi bib record https://www.amazon.com/

  • Google - Search for [CD title] by [Name] and hope for the best

• Once you know the person’s name, search it in LCNAF in Connexion.

• If you find a name authority record, use that form of name to correct the heading in the bib record (s).

• If you do not find a name authority record, correct the last name and leave the rest of the name as is.

• Last step: Check the MARC coding and correct it if necessary. Personal names entered in indirect order (last name first), are coded 700 1_.

• When you’re done, put a mark in the Done column of the spreadsheet.

• If you have any questions or comments, put them in the Questions column.

• Rinse and repeat!