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