[Koha] Changing itemtypes?

Paul Poulain paul.poulain at biblibre.com
Thu Jun 24 01:49:14 NZST 2010


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100623/a22df8d1/attachment.htm 


More information about the Koha mailing list