Bug 5213

Summary: Suffix number sequence not resetting properly in hmyymmincr barcode autogen pattern
Product: Koha Reporter: Chris Nighswonger <cnighswonger>
Component: CatalogingAssignee: Chris Nighswonger <cnighswonger>
Status: CLOSED FIXED QA Contact: Bugs List <koha-bugs>
Severity: minor    
Priority: PATCH-Sent (DO NOT USE) CC: alex.arnaud, chris, koha.sekjal, stephane.delaune
Version: rel_3_2   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: patch (find on second comment) commit on git.koha-community.org 9 Sep 2010

Description Chris Nighswonger 2010-09-09 17:58:10 UTC
Two things are happening.

First, the SELECT does not account for a branchcode greater than 2 chars.

This is fixed by just selecting the final four digits representing the incremental suffix from the barcode field.

Second, the incremental suffix (4 digits) is not rolling back over to zero when reaching 9999.

This pattern probably needs help. It should allow for cataloging of 10000 items per month as is. I would not recommend doing barcode numbering this way, but need to support it since it is in use in at least one library.
Comment 2 Stéphane Delaune 2011-04-05 09:31:49 UTC
Created attachment 3655 [details] [review]
patch (find on second comment) commit on git.koha-community.org 9 Sep 2010
Comment 3 Chris Cormack 2011-04-07 03:44:09 UTC
Pushed, please test
Comment 4 Christophe Croullebois 2011-04-07 13:34:25 UTC
*** Bug 6093 has been marked as a duplicate of this bug. ***