TPAC search does not find some items

[Robert Soulliere]

EG version: 2.2.0
OpenSRF: 2.1
PostgreSQL: 9.1
Linux: Ubuntu Lucid

Searches in the TPAC are not finding existing items in our database. The same searches inthe JSPAC are finding the items.

Example:

I am searching for a book titled: "AutoCAD 2010 in 2D and 3D"

Doing a keyword search in the TPAC does not find the item:

http://libcat.mohawkcollege.ca/eg/opac/results?fi%3Aitem_type=&query=Autocad+2010+in+2d+and+3d&qtype=title&locg=1&_adv=1&page=0&sort=

However, same search in the old JSPAC does find it:

http://libcat.mohawkcollege.ca/opac/en-CA/skin/default/xml/rresult.xml?rt=keyword&tp=keyword&t=Autocad%202010%20in%202D%20and%203D&ft=&l=1&d=0&f=

We have other examples where search results differ considerably in TPAC compared to JSPAC.

[Dan Scott (denials)]

The record in question has 901 field. TPAC depends on 901 fields to display records.

[Robert Soulliere (rcsoulliere)]

An update: our cataloguers found an extra MARC field in the record:

 04 ‡aST3A

When they deleted this using the flat editor, the record can now be found in the now TPAC. Could something in the upgrade have added this field? The cataloguers assure me they did not add this and that it wasn't there before.

[Dan Scott (denials)]

Anything's possible, but it's highly unlikely that the upgrade added it. You can always check the auditor tables to see the history of a given record.

More likely is that the presence of the malformed "04" tag prevented the maintain_control_numbers() function from doing its work and adding the 901 field. When the cataloguers saved the record to remove the 04 field, the 901 was added by the trigger on the biblio.record_entry table, and now it can be retrieved in the TPAC.

[Robert Soulliere (rcsoulliere)]

Thanks Dan,

One of my suspicions was that some of the reported TPAC catalogue search issues are related to local malfomed MARC records. This seems like a great opportunity for MARC cleanup on our end.

Robert Soulliere, BA (Hons), MLIS
Systems Librarian
Mohawk College Library
<email address hidden>
Telephone: [phone] x3936
Fax: [phone]
________________________________________
From: <email address hidden> [<email address hidden>] On Behalf Of Dan Scott [<email address hidden>]
Sent: July 19, 2012 2:23 PM
To: Soulliere, Robert
Subject: [Bug 1026703] Re: TPAC search does not find some items

Anything's possible, but it's highly unlikely that the upgrade added it.
You can always check the auditor tables to see the history of a given
record.

More likely is that the presence of the malformed "04" tag prevented the
maintain_control_numbers() function from doing its work and adding the
901 field. When the cataloguers saved the record to remove the 04 field,
the 901 was added by the trigger on the biblio.record_entry table, and
now it can be retrieved in the TPAC.

--
You received this bug notification because you are a member of Evergreen
Bug Wranglers, which is subscribed to Evergreen.
https://bugs.launchpad.net/bugs/1026703

Title:
  TPAC search does not find some items

Status in Evergreen - Open ILS:
  New

Bug description:
  EG version: 2.2.0
  OpenSRF: 2.1
  PostgreSQL: 9.1
  Linux: Ubuntu Lucid

  Searches in the TPAC are not finding existing items in our database.
  The same searches inthe JSPAC are finding the items.

  Example:

  I am searching for a book titled: "AutoCAD 2010 in 2D and 3D"

  Doing a keyword search in the TPAC does not find the item:

  http://libcat.mohawkcollege.ca/eg/opac/results?fi%3Aitem_type=&query=Autocad+2010+in+2d+and+3d&qtype=title&locg=1&_adv=1&page=0&sort=

  However, same search in the old JSPAC does find it:

  http://libcat.mohawkcollege.ca/opac/en-
  CA/skin/default/xml/rresult.xml?rt=keyword&tp=keyword&t=Autocad%202010%20in%202D%20and%203D&ft=&l=1&d=0&f=

  We have other examples where search results differ considerably in TPAC compared to JSPAC.

To manage notifications about this bug go to:
https://bugs.launchpad.net/evergreen/+bug/1026703/+subscriptions

This E-mail contains privileged and confidential information intended
only for the individual or entity named in the message. If the reader
of this message is not the intended recipient, or the agent responsible
to deliver it to the intended recipient, you are hereby notified that
any review, dissemination, distribution or copying of this communication
is prohibited. If this communication was received in error, please
notify the sender by reply E-mail immediately, and delete and destroy
the original message.

[Robert Soulliere (rcsoulliere)]

I marked this as invalid since it is a local issue. We need to clean up oir MARC records a bit.