Re: [IUG] help

["Matt Polcyn" <MattP at ohionet dot org>]

The original inquiry didn't say so, but if the 2,000 records in question
are for the Taylor and Francis titles recently removed from Ebrary, you
should contact your Ebrary rep to request a MARC file for the deletions.
You can then load the file and then delete any records that overlay (and
depending on the load table you use, any records that are inserted as
well).  

Otherwise, Dao's suggestions are probably the way to go.  And depending
on how many deletions you get each month, that route might be better
long-term solution since Ebrary doesn't normally provide MARC files for
deletions. 

Best wishes,

Matt

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Gong, Dao Rong
Sent: Friday, December 21, 2007 5:45 PM
To: IUG INNOPAC List
Subject: Re: [IUG] help


What are in the Excel file? Are there some matching fields such as
title, isn numbers, oclc # or the like? And better yet, barcodes?

If your library has the inventory module, you might be able to read a
list of barcode into review file, what you need to do is to extract and
list the barcodes from the Excel file in the format the inventory system
requires. See previous posting:

http://innovativeusers.org/list/archives/2007/msg02714.html

Otherwise, if you had loader training, you can do the following:

1. Extract a delimited list from your Excel file to include only the
field you use to match, ex. oclc#, it has to be unique.
2. Use the delimited text translator of MarcEdit (thanks to Terry Reese)
to map the oclc# into 001 filed and compile it into a Marc file.
3. Use MarcEdit to add a 9xx field that says something like
"FOR_DELETION".
4. Configure your loader to match on the 001 field and load the records
with 9xx fields being "FOR_DELETION".
5. Run a review file to collect those records that have 9xx as
"FOR_DELETION" and delete them.

To avoid accidentally deleting good records, you need to make sure the
matching point is unique and your MARC file doesn't overlay any other
records you don't want to delete. 

Dao

Libraries, Michigan State University

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Baggett, Lorrie
Sent: Friday, December 21, 2007 3:45 PM
To: IUG INNOPAC List
Subject: Re: [IUG] help

I have the same problem -- I suspect there are many of us trying to
avoid deleting these records one at a time -
Please share you response to this query online - 
Thanks, 
Lorrie Baggett-Heuser
Camden County College Library

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of tahirs at uaeu dot ac dot ae
Sent: Wednesday, December 12, 2007 11:44 PM
To: IUG INNOPAC List
Subject: [IUG] help
Importance: High

I have an Excel file of 2000 ebrary deleted records I want a possible
way of converting them to a review file in Millennium then have them
deleted in batch instead of deleting them one by one which is time
consuming  
any help 
 u can send me off list any procedure for that

--
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

--
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

--
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