We've got a new boss, well, kind off, and she got some things going. Now I have been asked to delete some itemtypes, which is no problem when they are empty. Is there a possibility to change itemtypes in the database without screwing up the whole system? (I tried something like UPDATE items SET itype = 'CAS' WHERE itype ='AAC'; and UPDATE biblioitems SET itemtype = 'CAS' WHERE itemtype ='AAC'; to take an example, but that did not really change anything, or rather, it did, but it wasn't working that well.) I figured that when I change the itype/itemtype in biblio/biblioitems it still does not change in biblio.marcxml, is there a way to do that? Thanks, Marty
Le 23/06/2010 15:40, Marty a écrit :
We've got a new boss, well, kind off, and she got some things going. Now I have been asked to delete some itemtypes, which is no problem when they are empty. Is there a possibility to change itemtypes in the database without screwing up the whole system? (I tried something like UPDATE items SET itype = 'CAS' WHERE itype ='AAC'; and UPDATE biblioitems SET itemtype = 'CAS' WHERE itemtype ='AAC'; to take an example, but that did not really change anything, or rather, it did, but it wasn't working that well.) I figured that when I change the itype/itemtype in biblio/biblioitems it still does not change in biblio.marcxml, is there a way to do that?
nope, you must NOT do that this way the good news is that, in 3.2, there is will be a way to bulkedit items. - in SQL => SELECT barcode FROM items WHERE itype='AAC'; => run report => export CSV - go to tools / bulkedit > upload the previous file > define the new itype > validate > done ! maybe you can tell your boss to wait a little for 3.2 to be available ? -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08
I have migrated all circulation history to old_issues and all checkouts to the issues table. I have also edited the item records to reflect the current checked out items. But yet it still shows all items as available. I have checked out a book in koha and used it as a guide to see what changed in the database and then made the appropriate changes on the appropriate items. I can't seem to find the data element that directly controls items available. Any help would be greatly appreciated. - Joe
Le 23/06/2010 16:20, Joseph Faneuf a écrit :
I have migrated all circulation history to old_issues and all checkouts to the issues table. I have also edited the item records to reflect the current checked out items. But yet it still shows all items as available. I have checked out a book in koha and used it as a guide to see what changed in the database and then made the appropriate changes on the appropriate items. I can’t seem to find the data element that directly controls items available. Any help would be greatly appreciated. Hi availability depends on onloan field in items table. So if you updated only issues table, then it is not enough. You have to a) update items.onloan to the date_due of current issue b) run sync_items_in_marc_bib in order to sync marcxml information with items table c) run rebuild_zebra in order to sync zebra indexes. Hope that helps. -- Henri-Damien LAURENT
participants (4)
-
Joseph Faneuf -
LAURENT Henri-Damien -
Marty -
Paul Poulain