[Koha] [Koha-devel] Suppressing records in Koha 3.2.x

[Fridolyn SOMERS]

To query into the XML (marcxml field), you can use a MySQL 5.1 feature that
includes an XPATH into SQL :
http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html

Reards

2010/12/3 Fischer, Katrin <Katrin.Fischer at bsz-bw.de>

>  Hi,
>
>
>
> it’s not a file, but in the database. The table is called bibliotitems and
> the field is marcxml.
>
> But it’s the whole MARC21 record in XML syntax and not only the field for
> OPAC suppression.
>
> So you have to parse it for the field you want to check.
>
>
>
> Hope that helps,
>
>
>
> Katrin
>
>
>
> *From:* Altaf Mahmud [mailto:altaf.mahmud at gmail.com]
> *Sent:* Friday, December 03, 2010 3:14 PM
> *To:* Fischer, Katrin
>
> *Cc:* koha at lists.katipo.co.nz; Koha-devel at lists.koha-community.org
> *Subject:* Re: [Koha-devel] Suppressing records in Koha 3.2.x
>
>
>
> Please ignore this if found repetitive. I got a bounced reply for the last
> one.
>
>
> Thanks, I just learned a lot!
>
> On Fri, Dec 3, 2010 at 6:28 PM, Fischer, Katrin <Katrin.Fischer at bsz-bw.de>
> wrote:
>
> Hi,
>
>
>
> suppressed and deleted are different things.
>
>
> That what I guessed :)
>
>
>
> Deleted things go into the tables mentioned before.
>
>
>
> 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.
>
>
>
> The feature is described in the Koha manual:
> http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN3113
>
>
> Though I found this feature under cataloging section of the manual:
> http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN296
>
>
>
> 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.
>
>
> 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.
>
>
>
> *From:* koha-devel-bounces at lists.koha-community.org [mailto:
> koha-devel-bounces at lists.koha-community.org] *On Behalf Of *Altaf Mahmud
> *Sent:* Friday, December 03, 2010 12:34 PM
> *To:* Fridolyn SOMERS
> *Cc:* koha at lists.katipo.co.nz; Koha-devel at lists.koha-community.org
> *Subject:* Re: [Koha-devel] Suppressing records in Koha 3.2.x
>
>
>
> 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 *deletedbiblio, deletedbiblioitems *and *deleteditems
> *still have data. After getting your mail, I searched some items in normal
> OPAC view which are in *deletedbiblio *table. I got the items in Koha, the
> records are also in *biblio* 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?
>
> On Fri, Dec 3, 2010 at 1:30 PM, Fridolyn SOMERS <fridolyn.somers at gmail.com>
> wrote:
>
> Hie,
>
> The suppressed (="deleted") records from tables *biblio, biblioitems* and
> *items* are moved when deleted into tables *deletedbiblio*, *
> deletedbiblioitems* and *deleteditems*.
>
> Some other tables have a corresponding table beginning with *deleted* or *
> old*.
>
> Regards,
>
> --
> Fridolyn SOMERS
> ICT engineer
> PROGILONE - Lyon - France
> fridolyn.somers at gmail.com
>
> 2010/12/2 Altaf Mahmud <altaf.mahmud at gmail.com>
>
> Hello,
>
> 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?
>
> Thanks.
>
>
> --
> Altaf Mahmud
> System Programmer
> Ayesha Abed Library
> BRAC University
> Bangladesh.
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>
>
>
>
>
>
> --
> Altaf Mahmud
> System Programmer
> Ayesha Abed Library
> BRAC University
> Bangladesh.
>
>
>
>
> --
> Altaf Mahmud
> System Programmer
> Ayesha Abed Library
> BRAC University
> Bangladesh.
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>



-- 
Fridolyn SOMERS
ICT engineer
PROGILONE - Lyon - France
fridolyn.somers at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101206/a8d5f14c/attachment-0001.htm