Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    WebV/Cat - Records with a right quotation mark aren't fully normalized

    • Article Type: General
    • Product: Voyager
    • Product Version: 8.1.0

    Description:
    Bug Report Form for Issue 16384-16849

    Module(s): WebVoy?ge, Cataloging
    Server platform(s) affected: Tested on Solaris, Reported in Linux
    PC OS (if applicable): N/A
    Browser & version (if applicable): N/A

    Release(s) replicated in: 8.1.0, 8.0.0, 7.2.5, 7.0.1
    Last version without bug (if applicable): N/A

    Expected results: Right quotation marks should be normalized out.

    Actual results: Right quotes are not normalized out; records which are indexed with a right quotation mark can only be found if the search term includes a right quotation mark.

    Workflow implications: Microsoft Word replaces an apostrophe (') with a right quotation mark (’) when typing. If someone is copying a word or phrase from a word document that includes an apostrophe, they won’t be able to find the record they’re looking for because we only normalize the apostrophe, not the right quote.

    Replication steps:
    1. Attached to this report is a .bib file named “right-quote.bib”, import this file into Cataloging via the Choose the Record -> Import -> From new file… option in the menu
    2. Click OK on the confirmation box (there should only be one record attached)
    3. Once the bib record is displayed in the client, hit the “Save to DB” button and save it to the database
    4. Hit the “Search” button and change to the Keyword tab
    5. Change the type of search to “Free Text” and use “Twain's” as the search term (do NOT copy from this text, type it manually)
    6. You should receive 11 results in the default training database, but the record saved in step 3 is not included
    7. Hit the search button you see in the results list, and change “Twain's” to “Twains”
    8. You should receive the same 11 results you did in step 6
    9. Hit the search button in the results list again, and now use “Twain’s” (using a right quote, you may have to copy from this text)
    10. You should receive only 1 result, the record imported in step 3
    11. Load the OPAC for this instance and go to the Basic Search page
    12. Run a GKEY search for “Twains”, you should see 11 results, the same 11 from steps 6 and 8
    13. Hit the “edit search” button and change the term to “Twain's”, (type it manually), you should receive the same 11 results as steps 6, 8 and 12
    14. Hit the “edit search” button again and use the term “Twain’s”, (using a right quote, you may have to copy from this text), you’ll receive 1 result, the same record imported in step 3

    Other information: If we check the index in the database, we can see that the apostrophe is being normalized, but the right quote mark is not:
    From a bibID that uses an apostrophe in the 245A:
    SQL> select * from bib_index where bib_id=31574 and index_code='2450';

    BIB_ID INDE
    ---------- ----
    NORMAL_HEADING
    ----------------------------------------------------------------------------------------------------------------------------------
    DISPLAY_HEADING
    ----------------------------------------------------------------------------------------------------------------------------------
    31574 2450
    MARK TWAINS AMERICA
    Mark Twain's America.

    From a bibID that uses a right quote in the 245A:
    SQL> select * from bib_index where bib_id=75715 and index_code='2450';

    BIB_ID INDE
    ---------- ----
    NORMAL_HEADING
    ----------------------------------------------------------------------------------------------------------------------------------
    DISPLAY_HEADING
    ----------------------------------------------------------------------------------------------------------------------------------
    75715 2450
    TWAIN S TEST RECORD WITH A RIGHT QUOTE
    Twain?s Test record (with a right quote)

    Resolution:


    • Article last edited: 3/6/2015
    //doorbell.io feedback widged