Modfiying the barcode value in the get_dla_list.pl script

The barcode held in the Alto database, prod_talis, may different from what is contained within the barcode itself. The validation with Alto may have been configured to add or remove characters from the scanned barcode to match the value held in the database.

For the get_dla_list.pl script this means the item barcode extracted from the database may not match the scanned barcode value.

It is possible to modify the script to effectively reverse validate the barcode when extracting it for the export file. There may be limits to this depending on the number of validates involved and how easy it is to identify the type from the barcode in the database i.e. if there are two validates but the barcodes in the database look the same after validation it may be more tricky to reverse.

However that should be fairly uncommon. If there is a range of rules it would be necessary to code this in the Perl script itself but if the requirement is just to add a prefix to all barcodes this can be done in the SQL select statement in the script.

$sql = " select I.BARCODE,
substring(W.AUTHOR_DISPLAY, 1, 10) + '/' +
substring(W.TITLE_DISPLAY, 1, 30),
C.CLASS_NUMBER
from ITEM I,
CLASSIFICATION C,
WORKS W";

would be

$sql = " select 'XX' + I.BARCODE,
substring(W.AUTHOR_DISPLAY, 1, 10) + '/' +
substring(W.TITLE_DISPLAY, 1, 30),
C.CLASS_NUMBER
from ITEM I,
CLASSIFICATION C,
WORKS W";

where XX are the characters to be added. If control characters are involved this would again probably be better done in the Perl script directly.

Thanks

Brian Crampton