<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi, <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>it’s not a file, but in the database. The table is called
bibliotitems and the field is marcxml. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>But it’s the whole MARC21 record in XML syntax and not only the
field for OPAC suppression. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>So you have to parse it for the field you want to check. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hope that helps, <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Katrin<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Altaf Mahmud
[mailto:altaf.mahmud@gmail.com] <br>
<b>Sent:</b> Friday, December 03, 2010 3:14 PM<br>
<b>To:</b> Fischer, Katrin<br>
<b>Cc:</b> koha@lists.katipo.co.nz; Koha-devel@lists.koha-community.org<br>
<b>Subject:</b> Re: [Koha-devel] Suppressing records in Koha 3.2.x<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Please ignore this if found
repetitive. I got a bounced reply for the last one.<br>
<br>
<br>
Thanks, I just learned a lot!<o:p></o:p></p>
<div>
<p class=MsoNormal>On Fri, Dec 3, 2010 at 6:28 PM, Fischer, Katrin <<a
href="mailto:Katrin.Fischer@bsz-bw.de">Katrin.Fischer@bsz-bw.de</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>Hi, </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'>suppressed and deleted are
different things.</span><o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><br>
That what I guessed :) <o:p></o:p></p>
</div>
<blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;
margin-left:4.8pt;margin-right:0cm'>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'>Deleted things go into the
tables mentioned before.</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'>Suppressed titles are not
shown in OPAC, but can still be researched and displayed in Intranet. It is a
separate feature. If you have set the sys pref to don’t hide, you probably have
no suppressed records yet. For a record to be suppressed in OPAC view the 942$n
field has to be set to 1.</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'>The feature is described in
the Koha manual: <a
href="http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN3113"
target="_blank">http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN3113</a></span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p class=MsoNormal><br>
Though I found this feature under cataloging section of the manual: <a
href="http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN296">http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN296</a>
<o:p></o:p></p>
</div>
<blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;
margin-left:4.8pt;margin-right:0cm'>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'>There is no separate database
field where you can see if a title is suppressed. The information is stored in
the XML of biblioitems.marcxml.</span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p class=MsoNormal><br>
Couldn't find the file even by exhaustive 'find' command, is it possible to
provide the exact path? I need to have those data somehow. <o:p></o:p></p>
</div>
<blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;
margin-left:4.8pt;margin-right:0cm'>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<div style='border:none;border-left:solid windowtext 1.5pt;padding:0cm 0cm 0cm 4.0pt;
border-color:-moz-use-text-color -moz-use-text-color -moz-use-text-color blue'>
<div>
<div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;
border-color:-moz-use-text-color -moz-use-text-color'>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span
lang=EN-US style='font-size:10.0pt'>From:</span></b><span lang=EN-US
style='font-size:10.0pt'> <a
href="mailto:koha-devel-bounces@lists.koha-community.org" target="_blank">koha-devel-bounces@lists.koha-community.org</a>
[mailto:<a href="mailto:koha-devel-bounces@lists.koha-community.org"
target="_blank">koha-devel-bounces@lists.koha-community.org</a>] <b>On Behalf
Of </b>Altaf Mahmud<br>
<b>Sent:</b> Friday, December 03, 2010 12:34 PM<br>
<b>To:</b> Fridolyn SOMERS<br>
<b>Cc:</b> <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a>;
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<b>Subject:</b> Re: [Koha-devel] Suppressing records in Koha 3.2.x</span><o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'>Actually,
our library never used this feature: OpacSuppression, that is always set as
'Don't hide'. Moreover, we don't have any marc record with $942 field, but the <i>deletedbiblio,
deletedbiblioitems </i>and <i>deleteditems </i>still have data. After getting
your mail, I searched some items in normal OPAC view which are in <i>deletedbiblio
</i>table. I got the items in Koha, the records are also in <i>biblio</i>
table. That's why I'm still confused. Does Koha retain those 'deleted' items
for any further reference, or those are supposed to be 'suppressed' items? What
the reason could be?<o:p></o:p></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>On
Fri, Dec 3, 2010 at 1:30 PM, Fridolyn SOMERS <<a
href="mailto:fridolyn.somers@gmail.com" target="_blank">fridolyn.somers@gmail.com</a>>
wrote:<o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'>Hie,<br>
<br>
The suppressed (="deleted") records from tables <i>biblio,
biblioitems</i> and <i>items</i> are moved when deleted into tables <i>deletedbiblio</i>,
<i>deletedbiblioitems</i> and <i>deleteditems</i>.<br>
<br>
Some other tables have a corresponding table beginning with <i>deleted</i> or <i>old</i>.<br>
<br>
Regards,<br>
<br>
-- <br>
Fridolyn SOMERS<br>
ICT engineer<br>
PROGILONE - Lyon - France<br>
<a href="mailto:fridolyn.somers@gmail.com" target="_blank">fridolyn.somers@gmail.com</a><o:p></o:p></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>2010/12/2
Altaf Mahmud <<a href="mailto:altaf.mahmud@gmail.com" target="_blank">altaf.mahmud@gmail.com</a>><o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'>Hello,<br>
<br>
Can someone please tell me how can I query to list the suppressed items in Koha
database? Which database field indicates that the item is suppressed in OPAC
view?<br>
<br>
Thanks.<br>
<span style='color:#888888'><br clear=all>
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.</span><o:p></o:p></p>
</div>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel"
target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a><o:p></o:p></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><br>
<br clear=all>
<o:p></o:p></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><br>
<br clear=all>
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br clear=all>
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.<o:p></o:p></p>
</div>
</div>
</body>
</html>