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

    Duplicate item barcodes

    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

     

    Description:
    Staff are able to create duplicate item barcodes within an ADM

    Resolution:

    In order for duplicate barcodes to be written:
      1. the z30_id1 Oracle index built on the z30_barcode needs to be NONUNIQUE*, and
      2a. the ./xxx50/tab/tab100 CHECK-BARCODE parameter needs to be set to "N"**; or
      2b. the duplicate barcode has been added using SQL.

     

    * This is the normal setting, as defined in ./alephm/sql_tab/z30_create_index_1.sql and as seen in util a/17/14 for z30. 
    ** This is *not* the normal setting: the usm50 tab100 has CHECK-BARCODE=Y -- which is the default.

     

    Note:  though the tab100 header entry for CHECK-BARCODE implies that the only effect of "Y" is to prevent blank barcodes, it can be seen in the check_z30 program that it also enables duplicate checking.

     

    The z30_id1 *could* be changed (in /exlibris/aleph/ann_n/alephm/sql_tab/z30_create_index_1.sql and z30_rebuild_index_1.sql) as UNIQUE, but the following SQL should be run before doing so to show instances of duplicate item barcodes: 

    > s+ xxx50 
    SQL> select z30_barcode, count(*) from z30 group by z30_barcode having count(*) > 1; 

     

    Category: Cataloging


    • Article last edited: 01/21/2016
    //doorbell.io feedback widged