Re: Same barcode numbers on different titles

["Alfred Kraemer" <akraemer@xxxxxxxxxx>]

James,

Here is what I would do (without knowing exactly how the problem came about)
1. Create a review file of item records with a CREATED date range that would
include
    the items in question.
2. If the list is short:
                       work from a printout.
    if the list is very long.
                       export key fields from the item record, pull them
into MS Access, and use
                       a the find duplicates function or use totals/count
option in a query.
3. After you have the list of identical barcodes, I don't know if there is a
big timesaver. I believe you might have to do it manually to make sure you
delete the 'bad' ones and retain the 'good' one.

Alfred Kraemer
Head, Technical Services
Medical College of Wisconsin Libraries
8701 Watertown Plank Road
Milwaukee, WI 53226

Phone: 414-456-4273
E-Mail: akraemer@xxxxxxxxxx




----- Original Message -----
From: James Rentz <JAMES@xxxxxxxxxx>
To: 'INNOPAC Listserv' <INNOPAC@xxxxxxxxxx>
Sent: Thursday, January 27, 2000 1:55 PM
Subject: Same barcode numbers on different titles


> We have run into a problem with the same barcode number being attached to
> multiple, and incorrect, titles. It occured when we tried to use the ITEM
> (Multiple) function to add a series of volumes. Evidently we entered some
> incorrect information because we ended up with a few thousand  duplicates
> that attached themselves to other titles and seem to have changed numbers
as
> well. We did try to delete the original range of barcodes off of the
correct
> title, but the duplicates are still attached to titles all over the place
> and come up as duplicate numbers when someone brings an item up for
> checkout.
>
> My question is: Is there any effective way to track down, and delete,
these
> duplicates in an organized manner rather than waiting for reports from our
> Circulation departments.
>
> James Rentz
> Manager - Technical Services
> Rockford Public Library
> 215 N. Wyman Street
> Rockford, IL  61101
> (815)965-6731 x136
> james@xxxxxxxxxx
>