[OPEN-ILS-DEV] ***SPAM*** Re: Catalog records

[Grant Johnson]

Use a select query to get a list if record ID's from the biblio.metabib
table in the database.
where deleted = false.
Then check them in the OPAC like this...

http://islandpines.roblib.upei.ca/opac/en-CA/skin/roblib/xml/rdetail.xml?r=121164
Where 121164 is from the list of record ID's

Does this help?





F. Grant Johnson
  Systems Coordinator
  309 Robertson Library
  University of Prince Edward Island
  902-566-0630(w),  902-393-4920(c)





>>> On 3/31/2010 at 01:23 PM, in message
<968891196.133506.1270052596255.JavaMail.root at hagrid.georgialibraries.org>,
"Hardy, Elaine" <ehardy at georgialibraries.org> wrote: 
> Anne, 
> 
> I would run a report of each shelving location (such a DVD), sorting
by call 
> number or what ever sort you need. You could either print out the
report or 
> just save it to a file. Then you could mark the list with action
taken (if 
> you need that information) and where you stopped. 
> 
> Or you could browse by call number/shelf list, starting at your first
call 
> number, and then make a note of the last record you reviewed. 
> 
> 
> 
> 
> 
> 
> Elaine 
> 
> 
> J. Elaine Hardy 
> PINES Bibliographic Projects & Metadata Manager 
> Georgia Public Library Service 
> 1800 Century Place, Ste 150 
> Atlanta, Ga. 30345-4304 
> 
> 404.235-7128 
> 404.235-7201, fax 
> ehardy at georgialibraries.org 
> www.georgialibraries.org 
> www.georgialibraries.org/pines 
> 
> 
> 
> ----- Original Message ----- 
> From: "Anne Andres" <Anne.Andres at columbiabc.edu> 
> To: "Evergreen Development Discussion List" 
> <open-ils-dev at list.georgialibraries.org> 
> Sent: Wednesday, March 31, 2010 11:54:17 AM 
> Subject: [OPEN-ILS-DEV] Catalog records 
> 
> 
> Hi, 
> We'd like to systematically go through all our catalog records, one
by one 
> to review the record, and we're wondering how to do this, starting
with 
> the first record. When we stop, we'd like to know where we've stopped
and 
> where we've ended and which record to carry on with the next time. 
> 
> We could do this with a small number of batches such as calling up
all DVDs, 
> .....but with 40,000 books is there a systematic way of doing this? 
> 
> Thanks 
> 
> Anne Andres 
> Associate Librarian 
> Columbia Bible College 
> 2940 Clearbrook Road 
> Abbotsford, B.C. CANADA 
> V2T 2Z8 
> telephone: 604-853-3567 ext. 334 
> fax: 604-853-3063 
> email: anne.andres at columbiabc.edu 
> website: http://www.columbiabc.edu/library