https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19113 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Text to go in the| |This fixes the generation release notes| |of item barcodes, where the | |autoBarcode system | |preference is set to | |"generated in the form | |<branchcode>yymm0001" and | |the library code is either | |a number or alphanumeric | |value. This automatically | |generated barcode format | |didn't work in this case, | |and the number generated | |would not automatically | |increment. --- Comment #19 from David Nind <david@davidnind.com> --- (In reply to William Lavoie from comment #17)
Hi David,
Have you changed the branchcode for a numerical value? I tried on KTD, using the following steps : 1- koha-mysql kohadev 2- update items set barcode=NULL; 3- change one of the barcode to any numerical value 4- update branches set branchcode = 1 where branchcode="MPL"
Note that for the last command you might receive a warning. Then, when creating a new item I put Midway for both the Home and Current library (I chose Midway but any library will do, it just has to be the same as the one with the numerical branchcode) and I was able to reproduce the problem.
I've retested - it was my error! I didn't read the bug properly, and didn't get that this is about library codes that have numeric or alphanumeric characters. How I tested: 1. Create a new library with a library code that is a number: - Administration > Basic parameters > Libraries > + New library - Library code: 001 - Name: Library 001 - Submit 2. Create a new library with a library code that is alphanumeric: - Administration > Basic parameters > Libraries > + New library - Library code: LIB1 - Name: Library 1 - Submit 3. Set the autoBarcode system preference to "generated in the form <branchcode>yymm0001". 4. Find a record with one item (any record will do): - Edit the current item: . Change the home library and current library to Library 001 (library code is 001) . Empty the "p - Barcode field:" . Click in another field . Click back in the "p - Barcode field:" . Generates barcode 00125020001 . Save changes ==> Result: successfully saves - Add another item to the same record: . Change the home and current library to Library 001 (library code is 001) . Click back in the "p - Barcode field:" . Generates barcode 00125020001 (note that it isn't incremented) . Add item ==> Result: Error saving item: Barcode must be unique. 5. Repeat step 4 for another record with one item, but use Library 1 (library code is LIB1): - Edit the current item: . Change the home library and current library to Library 001 (library code is 001) . Empty the "p - Barcode field:" . Click in another field . Click back in the "p - Barcode field:" . Generates barcode LIB125020001 . Save changes ==> Result: successfully saves - Add another item to the same record: . Change the home and current library to Library 001 (library code is 001) . Click back in the "p - Barcode field:" . Generates barcode LIB125020001 (note that it isn't incremented) . Add item ==> Result: Error saving item: Barcode must be unique. 6. Repeat for an existing library that has a library code with only alpha characters (Centerville Public Library, CPL): ==> Result: works as expected . First barcode is: CPL25020001 . Second barcode is: CPL25020002 7. Apply the patches and RESET everything (reset_all) . Note: this clears all the changes made, need to set autoBarcode system preference . Alternative is just to restart everything (restart_all), and note that the barcodes generated will be the next in the sequence, not necessarily 0001 and 0002 8. Repeat step 4 (Library 001, library code 001): ==> Result: Now works as expected . First barcode is: 00125020001 . Second barcode is: 00125020002 9. Repeat step 5 (Library 1, library code LIB1): ==> Result: Now works as expected . First barcode is: LIB125020001 . Second barcode is: LIB125020002 10. Repeat step 6 (Centerville Public Library, CPL): ==> Result: No change, continues to work as expected . First barcode is: CPL25020001 . Second barcode is: CPL25020002 -- You are receiving this mail because: You are watching all bug changes.