Re: [IUG] Creating a report of deleted records

[said shafik <saidshafik at hotmail dot com>]

Hi Mary,
 
We do same here in our TS department. As you know, there are records can be deleted outside of TS (could be by other staff, or as a result of a user error, etc.). So, in order to gather all deleted bib, we use those tricks. The problem here is we collect only deleted bib records, not items or orders or other records. That's why I am asking for help.
 
 
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
Said Shafik Library Systems Manager Drexel University Libraries Philadelphia, PA 19104-2875 Phone: 215.895.1832 Fax: 215.895.2070 http://library.drexel.edu 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> Date: Wed, 27 Aug 2008 08:34:57 -0400> From: mgoodrum at townofchapelhill dot org> To: innopac at innopacusers dot org> Subject: Re: [IUG] Creating a report of deleted records> > I don't know if this is what you're trying to do, but here's how we get> information on deleted records:> > We mark the bib record that's to be deleted with a w (for withdrawn) in> the bcode3 field. It suppresses the record from public view. We mark> the item record with a w in the icode2 field and in the status field.> At the end of the month I run a list of everything with a w in those> fields, then export the information to Excel. Once I'm sure I have all> the information I need, I delete the records from Millennium. We're> still on release 2006.> > Hope that helps!> MJ> > > Mary J. Goodrum> Head of Technical Services> Chapel Hill Public Library> Town of Chapel Hill> 100 Library Drive> Chapel Hill, NC 27514-5705 > Phone: (919) 968-2777, ext. 130> Fax: (919) 968-2838 > > > -----Original Message-----> From: innopac-bounces at innopacusers dot org> [mailto:innopac-bounces at innopacusers dot org] On Behalf Of said shafik> Sent: Tuesday, August 26, 2008 3:36 PM> To: IUG List> Subject: [IUG] Creating a report of deleted records> > > > Has any library found a way different from what we do to create a report> of deleted bib records?> We do this in two ways (since we are an Oracle library):> First:> In Millennium's DataExchange:> 1- We set the printer to FTS file> 2- Pretend to collect for export MARC records in DataExchange (clicking> on Create c)3- Next window will ask for naming of a file of error> messages, those are the messages about which and when a records is> deleted.> 4- When finish, we "print" the file of error messages to FTS and output> it to a PC file.> 5- Delete the MARC file from the list.> Second;> In Oracle, our boss Peter Ivanic found a way to collect the cashed file> that stores DELETE information.> > Any other tricks, please?> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Said Shafik Library Systems Manager Drexel University Libraries> Philadelphia, PA 19104-2875 Phone: 215.895.1832 Fax: 215.895.2070> http://library.drexel.edu > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~> _________________________________________________________________> Be the filmmaker you always wanted to be-learn how to burn a DVD with> Windows(r).> http://clk.atdmt.com/MRT/go/108588797/direct/01/> > --- 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> > --> 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
_________________________________________________________________
Get thousands of games on your PC, your mobile phone, and the web with Windows®.
http://clk.atdmt.com/MRT/go/108588800/direct/01/

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---