<div dir="ltr"><div>Bruce --<br><br>All forms of barcode autogeneration except incremental are problematic. I strongly recommend against using them.<br><br>"Home branch" or "hbyymmincr" style barcodes, in particular, are not implemented in a widely applicable way. It should not be used by multi-branch libraries, or libraries with more than 9999 items, or libraries with non-4-character branch codes, or libraries with digits or underscores in their branch codes... or basically anyone.<br>
<br>The query that obtains the next valid barcode for hbyymmincr is:<br></div> $query = "SELECT MAX(CAST(SUBSTRING(barcode,7,4) AS signed)) FROM items WHERE barcode REGEXP ?";<br> my $sth=$dbh->prepare($query);<br>
$sth->execute("^[a-zA-Z]{1,}$year");<br><div><br>In this case, year would be "08", but you can see the flaws in this query result in the extreme limitations above. <br><br>You can print the branch and year directly on the barcode stickers and spine labels you generate. That info does not need to be part of the barcode itself.<br>
<br>--Joe Atzberger,<br>LibLime<br><div><div><br><div class="gmail_quote">On Mon, Sep 1, 2008 at 11:31 PM, Bruce Raymond <span dir="ltr"><<a href="mailto:braymond@regisjesuit.com">braymond@regisjesuit.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
Installation details: Koha 3.0 stable.<br>
Setting details: Automatic barcode generation using the home branch method<br>
is turned on.<br>
<br>
The automatic barcode generating has been working ok until a few days ago.<br>
Now no barcode is being generated. The automatic setting is still set on.<br>
<br>
Any suggestion about how to troubleshoot this problem?<br>
<font color="#888888">--<br>
View this message in context: <a href="http://www.nabble.com/Barcode-not-being-generated-in-new-MARC-records-tp19263641p19263641.html" target="_blank">http://www.nabble.com/Barcode-not-being-generated-in-new-MARC-records-tp19263641p19263641.html</a><br>
</font></blockquote></div><br></div></div></div></div>