<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Thank you Galen, this fixes the issue. And thanks for the note about the ‘-1’ rows, I’ll look into getting those restored properly.<div class=""><br class=""></div><div class="">Cheers.<br class=""><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>
<div><br class=""><blockquote type="cite" class=""><div class="">On Nov 2, 2020, at 11:33 AM, Galen Charlton <<a href="mailto:gmc@equinoxinitiative.org" class="">gmc@equinoxinitiative.org</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi Jeff,<br class=""><br class="">On Mon, Nov 2, 2020 at 1:47 PM Jeffrey Goettsch <<a href="mailto:jdgoettsch@ucdavis.edu" class="">jdgoettsch@ucdavis.edu</a>> wrote:<br class=""><div class="">> TL;DR: All our catalog searches give no results. The search query joins on the</div><div class="">> metabib.record_attr_vector_list table, which is empty. How do we populate this table?</div><div class=""><br class=""></div><div class="">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.<br class=""></div><div class=""><br class=""></div><div class="">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.<br class=""></div><div class=""><br class=""></div><div class="">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.<br class=""></div><div class=""><br class=""></div><div class="">Regards,</div><div class=""><br class=""></div><div class="">Galen<br class=""></div>--<br class="">Galen Charlton<br class="">Implementation and Services Manager<br class="">Equinox Open Library Initiative<br class="">phone: 1-877-OPEN-ILS (673-6457)<br class=""><a href="mailto:gmc@equinoxInitiative.org" class="">email: gmc@equinoxInitiative.org</a><br class="">web: <a href="https://equinoxinitiative.org/" class="">https://equinoxInitiative.org</a><br class="">direct: +1 770-709-5581<br class="">cell: +1 404-984-4366</div>
</div></blockquote></div><br class=""></div></body></html>