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

[Ben Shum]

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 
>> <mailto: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 <mailto: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 06762
203-577-4070, ext. 113

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20121120/556d824f/attachment.htm>