Thursday, February 9, 2012

Progress Update

In the last update I gave I had completed about 70% of the "Name" column on the spreadsheet.  That column consisted of student performer names, ensemble names, faculty ensemble names, faculty names, guest performers, and a few other random names.  Mostly I was separating out the individual names from the ensemble names.  That is now done!

What is now left in that column and the columns that got created from it is to separate out multiple names.  Some cells have two or more performers' names or two or more ensemble names.  I also haven't gone through those columns for authorized names.  So that is all still to be done.

I have also just completed my first pass through the column labeled "Composer."  This column had been worked on previously.  So I sorted the spreadsheet so it was in order according to this column and started going through it again.  I created four new columns to go along with this one:

  • Composer: name only (existing column)
  • Composer#$b: any sort of number associated with a name
  • ComposerOther$c: any sort of title (for example, Sir) associated with a name
  • ComposerFuller: for the fuller version of a name (when a name is commonly used with initials and we know what the initials stand for, we often put the fuller form of the name in parenthesis in another subfield in the name field).
  • ComposerDates: Birth and/or death dates associated with a name
Since this field was already checked against the authority file, I was just moving the info around.  It went pretty quickly.  It's not 100% done, but the good majority of it is done.  The remainder cells have some sort of issue associated with them: multiple names, just a last name, two or more possible authorized headings, problems with diacritics in Excel, unauthorized names, and a few other minor problems.  Those are all highlighted in different colors to let me know what the problem is.

My next step is to go through the Composer column again and work on those highlighted cells.  I expect this to take a little longer since I'll have to go into the authority file for each one and try to determine the correct form of name.  I'll also have to move the additional names to a different column.  I currently have three additional columns for "Other name."  

I'll get started on this this week, but then I'm leaving early next week to attend the Music OCLC Users Group Meeting and the Music Library Association's annual conference in Dallas, TX.  While there I'll probably take the opportunity to try and talk to other librarians about the cataloging and management of the recital recordings at their institutions.  I'm looking forward to the trip!

No comments: