<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Le 23/06/2010 15:40, Marty a écrit :
<blockquote cite="mid:591111.81042.qm@web62401.mail.re1.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit; -x-system-font: none;"
valign="top">We've got a new boss, well, kind off, and she got some
things going.<br>
Now I have been asked to delete some itemtypes, which is no problem
when they are empty.<br>
Is there a possibility to change itemtypes in the database without
screwing up the whole system?<br>
(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.)<br>
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?<br>
</td>
</tr>
</tbody>
</table>
</blockquote>
nope, you must NOT do that this way<br>
<br>
the good news is that, in 3.2, there is will be a way to bulkedit items.<br>
- in SQL => SELECT barcode FROM items WHERE itype='AAC'; => run
report => export CSV<br>
- go to tools / bulkedit > upload the previous file > define the
new itype > validate > done !<br>
<br>
maybe you can tell your boss to wait a little for 3.2 to be available ?<br>
<pre class="moz-signature" cols="72">--
Paul POULAIN
<a class="moz-txt-link-freetext" href="http://www.biblibre.com">http://www.biblibre.com</a>
Expert en Logiciels Libres pour l'info-doc
Tel : (33) 4 91 81 35 08</pre>
</body>
</html>