Re: Batch deleting records from OCLC

[Josh Stompro <stomproj at larl dot org>]

You can also list instead of export (this method works with a basic text 
editor like wordpad or notepad).
Select only the oclc number for listing and check the box next to
"Display labels for variable-length fields"

Send the list to your email address.

Open email, ctrl-a to select all text and copy it into a wordpad document.

	Use the replace function to replace the label before each oclc number 
with a '#'.  Also do a replace on the '.' that is inserted after each 
number. And then delete the line breaks by hand.  And if you are using 
an editor that support regex's you can replace all the blank lines with 
returns to get rid of the page breaks.  jedit is a free editor that 
support regex searches.


	If you want to use export then you can set all the delimiters to none. 
 Export the file as a txt and load it into jedit or another editor that 
supports regex.  Search for '^' (beginning of a line) and replace with 
'#'.  Then search for '#\n' and replace with '' (blank) to get rid of 
the lines with # all by themselves.

Regular expressions are you friend.
Josh

Koch, Paul wrote:
> 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