<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Jeffrey,<br>
<br>
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.<br>
<br>
<a moz-do-not-send="true"
href="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</a><br>
<pre class="moz-signature" cols="72">-Blake-
Conducting Magic
Can consume data in any format
MOBIUS
</pre>
<div class="moz-cite-prefix">On 11/2/2020 12:47 PM, Jeffrey Goettsch
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:D7D7D0EC-7480-45BD-B5E0-E9B918987D6B@ucdavis.edu">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
Hi,
<div class=""><br class="">
</div>
<div class="">Thanks for any assistance you can provide.</div>
<div class=""><br class="">
</div>
<div class="">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?</div>
<div class=""><br class="">
</div>
<div class="">--</div>
<div class=""><br class="">
<div class="">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.</div>
<div class=""><br class="">
</div>
<div class="">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.</div>
<div class=""><br class="">
</div>
<div class="">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:</div>
<div class=""><br class="">
</div>
<div class=""> <a
href="https://docs.evergreen-ils.org/eg/docs/3.6/admin_initial_setup/migrating_your_data.html"
class="" moz-do-not-send="true">https://docs.evergreen-ils.org/eg/docs/3.6/admin_initial_setup/migrating_your_data.html</a></div>
<div class=""><br class="">
</div>
<div class="">Here is a link to my import scripts, a sample of
our records and holdings, a formatted MARC record, and the
PostgreSQL query:</div>
<div class=""><br class="">
</div>
<div class=""> <a
href="https://gist.github.com/jdgoettsch/ac56e6ba82207c97c7de8f21ed5102a6"
class="" moz-do-not-send="true">https://gist.github.com/jdgoettsch/ac56e6ba82207c97c7de8f21ed5102a6</a></div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">➞ Specifically now I’m wondering what the
metabib.record_attr_vector_list is for, and how it is
populated.</div>
<div class="">(1) Is my import script missing a step?</div>
<div class="">(2) Are our MARC records missing a piece? Our
previous database did not use MARC records, so we may be
missing something.</div>
<div class=""><br class="">
</div>
<div class="">Thanks again.</div>
<div class=""><br class="webkit-block-placeholder">
</div>
<div class="">
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Hack; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: 0px; text-decoration:
none;"><br class="Apple-interchange-newline">
-- </div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Hack; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: 0px; text-decoration:
none;">Jeff Goettsch</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Hack; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: 0px; text-decoration:
none;"><br class="">
</div>
<br class="Apple-interchange-newline">
</div>
<br class="">
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Evergreen-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Evergreen-dev@list.evergreen-ils.org">Evergreen-dev@list.evergreen-ils.org</a>
<a class="moz-txt-link-freetext" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>