[Evergreen-dev] Why are our catalog searches always empty?

[Galen Charlton]

Hi Jeff,

On Mon, Nov 2, 2020 at 1:47 PM Jeffrey Goettsch <jdgoettsch at ucdavis.edu>
wrote:
> TL;DR: All our catalog searches give no results. The search query joins
on the
> metabib.record_attr_vector_list table, which is empty. How do we populate
this table?

First, thank you for including a clear set of data and scripts for
reproducing the problem; I was able to get it working without much effort.

The immediate reason why the record attributes table is not being populated
is because the MARC records being supplied don't include values that feed
into that table. At minimum, the Leader/06-07 (counting from zero) should
be set to non-blank values suitable for your materials. E.g., if they're
books, "am" would be a good value for those two positions. You should also
consider adding an 008 control field, as that's where the stock record
attribute definitions expect to find the publication date and the language
of the work.

Unrelated, but something I noted: be careful about doing truncates on
biblio.record_entry, asset.call_number, and asset.copy to clear the way for
the next attempt: the script should make sure that it's restoring the row
in each of those tables whose ID is -1, as those serve a special function
for handling pre-catalogued item checkouts.

Regards,

Galen
--
Galen Charlton
Implementation and Services Manager
Equinox Open Library Initiative
phone:  1-877-OPEN-ILS (673-6457)
email:  gmc at equinoxInitiative.org
web:  https://equinoxInitiative.org
direct: +1 770-709-5581
cell:   +1 404-984-4366
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20201102/64084b72/attachment-0001.html>