Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    CIRC: Item records edited in Circulation store Sensitize and Magnetic media flags as 1 instead of Y

    • Product: Voyager
    • Product Version: 9
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

    Symptoms

    • Magnetic media & sensitize flags for item records store Y as 1 in database when the item is updated, created or resaved in Circulation.
    • Voyager sends 1 instead of Y in self-check responses

    Defect Status

    Issue VYG-6736 is resolved in Voyager 9.2.1.

    Replication Steps

    1. Identify an item record where ITEM.MAGNETIC_MEDIA=Y and/or ITEM.SENSITIZE=Y

    select item_id
    ,magnetic_media
    ,sensitize
    from item
    where item_id=NNNN;

    ITEM_ID M S
    ---------- - -
    NNNN N Y

    1. Circulation > Item > open item record
    2. Item > Edit item ...
    3. Click OK
    4. View flags in database again:

    ITEM_ID M S
    ---------- - -
    NNNN N 1

    1. Open item in Cataloging. Note that flag that had been Y and is now 1 is no longer checked.
    2. Click Save to DB. Flag is now N in database:

    ITEM_ID M S
    ---------- - -
    NNNN N N

    1. Check the checkbox and click Save to DB:

    ITEM_ID M S
    ---------- - -
    NNNN N Y

    1. Circulation > Item > Edit item ...
    2. Click OK:

    ITEM_ID M S
    ---------- - -
    NNNN N 1

    1. Circulation > Pick and Scan > select a change to make > use item_id or item_barcode and Update Database to update record:

    ITEM_ID M S
    ---------- - -
    NNNN N Y

    Workaround

    Option 1: Use Cataloging and Pick and Scan to update/create item records.

    Option 2: Manually update flag in Cataloging.

    Option 3: Use Pick and Scan to update Magnetic media & Sensitize flags for impacted item records:

    1. Identify two lists of item_id numbers: one where sensitize is impacted and another where magnetic_media is impacted.

    select item_id
    from item
    where sensitize='1';


    and

    select item_id
    from item
    where magnetic_media='1';

    1. Use Pick and Scan to set Sensitize or Magnetic Media flag to Yes in Changes to Make tab, as appropriate.
    2. Select list of item_id numbers for the corresponding flag in Records to Change and Update Database.

     

    Article last edited: 17-May-2016