Re: [IUG] help

[tahirs at uaeu dot ac dot ae]

all thanks for those wgo responded to me i will follow their suggestions...

----- Original Message -----
From: Matt Polcyn <MattP at ohionet dot org>
Date: Saturday, December 22, 2007 3:20 pm
Subject: Re: [IUG] help

> The original inquiry didn't say so, but if the 2,000 records in 
> questionare 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 
> dependingon 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 
> systemrequires. 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 
> recordswith 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 aeSent: 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 
> INNOPAClist
> 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 
> INNOPAClist
> 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 
> INNOPAClist
> 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