I need help from people who use stocknumbers in their Koha's installs. I assume this is mostly Europe-specific since we are required by low to keep invetory books with each item in our library but I hope that other people might have similar legal requirements.
For a start, why is index defined on items.stocknumber non-unique? I would assume that it has to be unique like barcode is (at least that's our legal requirement). Other than that, we need to have some representation of "inventory book" which I plan to implement using additional local table in which I will record stocknumber, biblionumber and various other fields required for invertory book reporting. This duplicates data (which is bad if you ever heard for normal forms in RDBMS), but it's required to cover case of erasing items. If we don't have a copy of item, erased it would also erase entry from invetory book which is very, very bad. During implementation of this feature, I stumbled upon bug 7451[1] which breaks AJAX value_builder in which I plan to implement assigment of next invetory number and copying of data into separate invetory audit table. Would this value_builder be useful to other Koha users, or is it too specific for our use-case? 1: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7451 -- Dobrica Pavlinusic 2share!2flame [email protected] Unix addict. Internet consultant. http://www.rot13.org/~dpavlin _______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
