Thanks, I just learned a lot!<br><br><div class="gmail_quote">On Fri, Dec 3, 2010 at 6:28 PM, Fischer, Katrin <span dir="ltr"><<a href="mailto:Katrin.Fischer@bsz-bw.de">Katrin.Fischer@bsz-bw.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="DE">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Hi, </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">suppressed and deleted are different things.</span></p></div></div></blockquote><div><br>That what I guessed :)<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="DE"><div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Deleted things go into the tables mentioned before.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">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></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">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></p>
</div></div></blockquote><div><br>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> <br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div link="blue" vlink="purple" lang="DE"><div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">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></p></div></div></blockquote><div><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.<br>
</div><br><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div link="blue" vlink="purple" lang="DE">
<div>
<div style="border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue; padding: 0cm 0cm 0cm 4pt;">
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span style="font-size: 10pt;" lang="EN-US"> <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></p>
</div>
</div><div><div></div><div class="h5">
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal" style="margin-bottom: 12pt;">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?</p>
<div>
<p class="MsoNormal">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:</p>
<p class="MsoNormal" style="margin-bottom: 12pt;">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></p>
<div>
<p class="MsoNormal">2010/12/2 Altaf Mahmud <<a href="mailto:altaf.mahmud@gmail.com" target="_blank">altaf.mahmud@gmail.com</a>></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;">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: rgb(136, 136, 136);"><br clear="all">
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.<br>
<br>
</span></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<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></p>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
<br clear="all">
</p>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
<br clear="all">
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.</p>
</div></div></div>
</div>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>Altaf Mahmud<br>System Programmer<br>Ayesha Abed Library<br>BRAC University<br>Bangladesh.<br><br>