[OPEN-ILS-GENERAL] Apostrophe and Title Searches (still an issue?)

[Tony Bandy]

Hi Ben, folks,

So basically, we need to force our system to reindex our bib records...and
to do this, we would "reingest" our records?  (Sorry, still grappling with
understanding what all that means and entails...)  Does this mean a
physical dump and reloading of the records or is there a command we can
give to force the system to do this with the records in place?

(I apologize, but some parts of this is still really new to me....)

Tony




On Tue, Nov 20, 2012 at 2:13 PM, Ben Shum <bshum at biblio.org> wrote:

>  Hi Tony,
>
> Ian's experience with reingesting bib records is exactly what we ended up
> doing during our upgrade to 2.2 too.  We weren't as selective, since we
> ended up adding new metabib indexes which required us to reingest all of
> our bib records anyways.
>
> I think what happened was that in the 2.1-2.2 upgrade something changed
> with the way that the title index was created, but only a portion of bibs
> were reindexed (for different reasons).
>
> Updating the bibs to force a reingest is definitely what I would suggest
> to fix the issues you're seeing.
>
> -- Ben
>
>
> On 11/20/2012 01:45 PM, Ian Bays wrote:
>
> We found that after upgrade from 2.1 to 2.2 the existing titles did not
> behave with apostrophes for title or keyword searching.  We observed that
> newly catalogued or edited titles did search OK with or without
> apostrophes.  So we investigated and found out that by just "touching" some
> of the metabib records that caused them to be re-indexed.
>
> such as:
> update metabib.title_field_entry set source = source where source in (select
> record from asset.call_number where owning_lib in (select id from
> actor.org_unit where parent_ou in (select id from actor.org_unit where
> shortname = 'AB' OR shortname = 'CD'))) and value like '%''%';
> and
> update metabib.keyword_field_entry set source = source where source in ...
>
> We chose to only update those with apostrophes in the "value" field.  This
> was to do it for bibs used in systems 'AB' and 'CD'
>
> It did the job quite nicely.  I figured we must have missed something in
> the upgrade so just put it down to experience.
>
> Not sure if there's a neater way of "touching" groups of records for
> re-indexing if ever needed.
>
> Good luck.
>
> Ian
>
> On 20/11/2012 18:23, Tony Bandy wrote:
>
> Hi Dan, folks,
>
>  So sorry...I should have been more detailed.
>
>  Using TPAC on 2.3.1, and hostname http://mountgilead.cool-cat.org,
> performing a title search for: Reader's Digest.  Under this method, I get
> zero hits, even though "Reader's Digest" is returned in the autocomplete
> box as I type the title.  If I perform the same search without the
> apostrophe, I get good hits.
>
>  Trying this same search on our training server with the same version of
> Evergreen (2.3.1) I get the same response.
>
>  -----------------
>
>  To test, I've done the exact same search at King County Public Library (
> http://catalog.kcls.org/eg/opac/home) and the demo server (
> http://demo.ils.edoceo.com/sap/sunshine) and have not received the error.
>  I also tried on the Equinox Demo server, but not sure if they had the
> title as I got zero hits each time.
>
>  -----------------
>
>  Here's a sample of one of the MARC records that carry the title Reader's
> Digest:
>
>    020
>  . ‡a0895773538  040
>  . ‡aDLC ‡cDLC ‡dDLC  050 0 0. ‡aT47 ‡b.H725 1990  082 0 0. ‡a600 ‡220
> 100 1 . ‡aReader's Digest.  245 0 0. ‡aHow in the World?
>
>
> Thanks for any updates as you have time....
>
>
>  Tony
>
>
>
>  On Tue, Nov 20, 2012 at 1:04 PM, Dan Scott <dan at coffeecode.net> wrote:
>
>> On Tue, Nov 20, 2012 at 12:53:05PM -0500, Tony Bandy wrote:
>> > Hi all,
>> >
>> > After upgrading to 2.3, we're noticing the apostrophe issue when doing
>> > title searching in the catalog.  Specifically, when using the
>> apostrophe,
>> > titles never get found.
>>
>>  Hi Tony:
>>
>> Please provide more details.
>>
>> What is the title in question? Where is the MARC record for it?
>>
>> What search are you trying to use to retrieve the record? Are you using
>> JSPAC or TPAC?
>>
>> Can you reproduce the problem using a clean install of a supported
>> release?
>>
>> Thanks,
>> Dan
>>
>
>
>
>  --
> Tony Bandy
> tonyb at ohionet.org
> OHIONET
> 1500 West Lane Ave.
> Columbus, OH  43221-3975
> 614-486-2966 x19
>
>
>
> --
> Ian Bays
> Director of Projects, PTFS Europe Limited
> Content Management and Library Solutions+44 (0) 800 756 6803 (phone)+44 (0) 7774 995297 (mobile)+44 (0) 800 756 6384 (fax)
> skype: ian.bays
> email: ian.bays at ptfs-europe.com
>
>
> --
> Benjamin Shum
> Open Source Software Coordinator
> Bibliomation, Inc.
> 32 Crest Road
> Middlebury, CT 06762203-577-4070, ext. 113
>
>


-- 
Tony Bandy
tonyb at ohionet.org
OHIONET
1500 West Lane Ave.
Columbus, OH  43221-3975
614-486-2966 x19
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20121120/d2bbc731/attachment-0001.htm>