Bugzilla Bug 117
  Produce list of bib records with no holdings Last modified: 2005-07-11 14:18
Bug List: (14 of 102) First Last Prev Next   Show list      Search page      Enter new bug
Bug#: 117   Hardware:   Reporter: Ann Marie Obarski <annmarie.obarski@frontrange.edu>
Product:   OS:   Add CC:
Component:   Version:   CC:
Remove selected CCs
Status: ASSIGNED   Priority:  
Resolution:   Severity:  
Assigned To: Eric Sisler <esisler@cityofwestminster.us>   Target Milestone:  
QA Contact:
URL:
Summary:
Status Whiteboard:

Attachment Type Created Size Actions
BIB records with no holdings 2005-06-06 application/vnd.ms-excel 2005-06-06 16:09 534.50 KB Edit
Create a New Attachment (proposed patch, testcase, etc.) View All

Bug 117 depends on: Show dependency tree
Show dependency graph
Bug 117 blocks:

Additional Comments: Private

Users in the roles selected below can always view this bug:
(The assignee and QA contact can always see a bug, and this section does not take effect unless the bug is restricted to at least one group.)

Reporter CC List







View Bug Activity   |   Format For Printing

Description: reply Opened: 2005-03-17 10:55
Private 
I'd like to get a list of bib records that have no holdings so that we can begin
a systematic cleanup.  Records that I know about seen to fall into several
categories (but there are problably others):  1) FR and WPL temp records entered
for ILL purposes, 2) full bib records that were created by "system
administrator" about the time of migration, 3) Rocky Flats records for websites
and 4) some newish WPL records for new donations that will have holdings
attached in the near future.  

When the list is created, could we include some fields that would identity them
by the above types--like date created, user name etc.?

Also, after we get going, we will need to figure out why the ILL problem is
occurring.

------- Additional Comment #1 From Eric Sisler 2005-05-31 14:18 [reply] ------- Private 
Fields I can extract that may help you are:
  bib#
  create_user (created by)
  create_date (date created)
  change_user (changed/edited by)
  change_date (date changed)
  title

There are a few other fields in the bib_control table, but I don't think they
will be of much use.

Records created by "system administrator" are likely artifacts from the
migration. (Records incorrectly/incompletely deleted from Dynix, CARL, etc.)

Assuming I have done the query correctly, there are currently ~4,800 such
records in the system. I can extract them and export them to an Excel
spreadsheet for you. Do the fields above sound useful and what order do you want
the report sorted in?

If ILL items are still causing problems, please enter as a separate ticket with
additional details. Thanks!
Bug List: (14 of 102) First Last Prev Next   Show list      Search page      Enter new bug