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 <[email protected]
<mailto:[email protected]>> 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
[email protected] <mailto:[email protected]>
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:[email protected]
--
Benjamin Shum
Open Source Software Coordinator
Bibliomation, Inc.
32 Crest Road
Middlebury, CT 06762
203-577-4070, ext. 113
