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
