Thank you very much Bernardo. I don't have a ton of experience with mysql, so this is really a big help. And you're definitely right that the list of tags not to be hidden would be the shortest. <br><br>Best,<br>
Patrick Redmon<br>Librarian <br>Casa Balthasar<br><br><div class="gmail_quote">2009/9/23 Bernardo Gonzalez Kriegel <span dir="ltr"><<a href="mailto:gonzalez@famaf.unc.edu.ar">gonzalez@famaf.unc.edu.ar</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">You could try something like this:<br><br>UPDATE marc_subfield_structure SET hidden = -5 WHERE tagfield NOT IN ('100','245') AND frameworkcode = 'XXX';<br>
<br>('100','245') is the list of all tags that are NOT to be hidden (I think is the shortest)<br>
'XXX' is the code of a trial framework (don't do this for all frameworks)<br>you could use hidden = -1,-2,-3,-4,-5,-6 etc (look the online help)<br><br>bgk<br><br><br><div class="gmail_quote">2009/9/23 Bibliotecario Casa Balthasar <span dir="ltr"><<a href="mailto:bibliotecacb@gmail.com" target="_blank">bibliotecacb@gmail.com</a>></span><div>
<div></div><div class="h5"><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Perhaps a more interesting question would be this: is there some way to hide a large number of fields without the million or so clicks that doing it through the staff interface requires? In the mysql tables? What would such a mysql command look like?<br>
<br>Best,<br>Patrick Redmon<br>Librarian<br>Casa Balthasar<br><br><div class="gmail_quote">2009/9/23 Magnus Enger <span dir="ltr"><<a href="mailto:magnus@enger.priv.no" target="_blank">magnus@enger.priv.no</a>></span><div>
<div></div><div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
2009/9/23 Sheldon T. <<a href="mailto:thecarterii@hotmail.com" target="_blank">thecarterii@hotmail.com</a>>:<br>
<div>> My question is: can the marc tags be hidden (not deleted) in the framework,<br>
> so that it wouldn't over whelm the staffs when they are adding records to<br>
> Koha.<br>
<br>
</div>Yes, they can! Have a look at this page - look for a bullett-point<br>
that starts with "Hidden" about 3/4 down the page:<br>
<a href="http://koha.org/documentation/manual/3.0/administration/catalog-administration/marc-bibliographic-frameworks" target="_blank">http://koha.org/documentation/manual/3.0/administration/catalog-administration/marc-bibliographic-frameworks</a><br>
<br>
Regards,<br>
<font color="#888888">Magnus Enger<br>
<a href="http://libriotech.no" target="_blank">libriotech.no</a><br>
</font><div><div></div><div>_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</div></div></blockquote></div></div></div><br>
<br>_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div></div></div><br>
</blockquote></div><br>