Jeffrey,
You will likely need to perform what's known as a "reingest" - there is
a perl tool included in the Evergreen repo to aid this process.
https://docs.evergreen-ils.org/eg/docs/latest/development/support_scripts.html#pingest_pl
<https://docs.evergreen-ils.org/eg/docs/latest/development/support_scripts.html#pingest_pl>
-Blake-
Conducting Magic
Can consume data in any format
MOBIUS
On 11/2/2020 12:47 PM, Jeffrey Goettsch wrote:
Hi,
Thanks for any assistance you can provide.
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?
--
We are migrating to Evergreen 3.6 from a much more primitive,
homegrown database. Everything is working well, except all catalog
searches turn up empty, whether through the patron view or the admin
view. Searching by barcode works fine.
I captured the search query in PostgreSQL. It performs a join on
the metabib.record_attr_vector_list table, which is empty, and thus
returns no results. If I modify the query to remove the join, or if I
insert some dummy records into the metabib.record_attr_vector_list
table, then the query returns some results. And if I insert dummy
records into the table, then searches in the web interface work as
expected.
I have tried to import our MARC records with the batch import tool
through the web and also directly through the database, but both give
the same results. I have modeled our import code on the samples
provided here:
https://docs.evergreen-ils.org/eg/docs/3.6/admin_initial_setup/migrating_your_data.html
<https://docs.evergreen-ils.org/eg/docs/3.6/admin_initial_setup/migrating_your_data.html>
Here is a link to my import scripts, a sample of our records and
holdings, a formatted MARC record, and the PostgreSQL query:
https://gist.github.com/jdgoettsch/ac56e6ba82207c97c7de8f21ed5102a6
<https://gist.github.com/jdgoettsch/ac56e6ba82207c97c7de8f21ed5102a6>
➞ Specifically now I’m wondering what the
metabib.record_attr_vector_list is for, and how it is populated.
(1) Is my import script missing a step?
(2) Are our MARC records missing a piece? Our previous database did
not use MARC records, so we may be missing something.
Thanks again.
--
Jeff Goettsch
_______________________________________________
Evergreen-dev mailing list
[email protected]
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev
_______________________________________________
Evergreen-dev mailing list
[email protected]
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev