RE: Batch deleting records from OCLC

["Karen Straube" <kstraube at georgefox dot edu>]

I used to do this back when I was on a Sirsi system with CatME. So long
as you have the text file of OCLC #s I think the process would be the
same, though.

Open the file in Excel, add a column with the # signs, save and re-open
in Notepad. Delete the tabs which will be between the # sign and the
number, and you'll have the format OCLC wants. 

~Karen

> -----Original Message-----
> From: Koch, Paul [mailto:PKoch at mariancollege dot edu]
> Sent: Friday, January 28, 2005 10:09 AM
> To: INNOPAC at innopacusers dot org
> Subject: Batch deleting records from OCLC
> 
> Has anyone found a way to batch delete bibliographic records of
> withdrawn titles from OCLC using create lists and OCLC Connexion; that
> is, without having to manually enter each search key or modify it?  I
> seem to be missing a piece. Our procedure is to :
>     1. Supress the record in Millennium using a withdrawl code.
>     2. Periodically, create a list of "withdrawn" items.
>     3. In Create lists, create an export file specifying OCLC# as the
> element to be exported. If the text delimiter is set to none, a pure
> list of numbers is generated. Millennium will create a .txt file that
> can be read by OCLC Connexion.
>     4. In Connexion under the Batch>Enter bibliographic search keys
one
> can import a .txt file of search keys.
>     5. In order for Connexion to search by OCLC number each line must
be
> preceded by the # sign.
> I have not found a way to enter the # sign except by editing each line
> manually.  Has anyone found a way, or setting, to enter a # sign in
> batch mode, or, found another work around? Can Millennium be set to
add
> the # sign when exporting?
>     6. Set items to delete holdings (this can be done as a batch on
the
> summary screen) and run batch process in Connexion.
> 
> Any thoughts are appreciated.
> 
> Paul G. Koch
> Electronic/Technical Services Librarian
> Marian College
> 45 S. National Ave.
> Fond du Lac, Wis. 54935
> 
> Phone: 920.923.8726
> mailto: pkoch at mariancollege dot edu
> 
> 
> 
> 
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
> --
> This message was distributed through the Innovative Users Group
INNOPAC
> list
> Public replies:  INNOPAC at innopacusers dot org
> Update your subscription options:
> http://innopacusers.org/mailman/listinfo/innopac