Re: [IUG] Create list of bib records with more than one location

[Ted Waller <wallert at meredith dot edu>]

Here's an easy way to get a list: 

1. Do a Create List of all bib records with location = multi 

2. Export the bib and item locations to Excel. Now a visual check of the columns shows which bibs only have one item record.  You also need to include bib and item record numbers in the export to identify the records needing a fix. 



Ted Waller 

Meredith College 





Message: 2 
Date: Thu, 27 May 2010 08:20:38 -0700 
From: "Findley, Erica S." < erica dot findley at pacificu dot edu > 
Subject: [IUG] Create list of bib records with more than one location 
To: " innopac at innovativeusers dot org " < innopac at innovativeusers dot org > 
Message-ID: 
        < 8D94A946E17E9941AE94FC3AE11CAB7E03E1FF50CF at everest dot ad dot pacificu dot edu > 
Content-Type: text/plain; charset="us-ascii" 

Hello, 

Please excuse me if this question has been previously asked and answered. I am new to this list and I tried to search the archives. 

We are starting to do some analysis of our circulating collections and have discovered that several bib records in our catalog have 2 locations, but only one attached item record. Our item and bib locations match and when we have one title in more than one location, we use multiple bib locations (one for each copy at a different location). However, the records that we are finding have two bib locations and only one item. We think that over time items have been deleted and the bib location was never reconciled. 

Does anyone know how I can create a list of bib records that have multiple locations, but only one attached item record? Any help is appreciated. Thank you. 

------------------------------------------------------------------------ 
Erica Findley | Cataloging Assistant | Pacific University Library 


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---