Suppressing records in Koha 3.2.x
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.
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@gmail.com 2010/12/2 Altaf Mahmud <altaf.mahmud@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@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/
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@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@gmail.com
2010/12/2 Altaf Mahmud <altaf.mahmud@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@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.
The deletedbiblio, deletedbiblioitems and deleteditems tables are for materials that have been deleted from your catalog. This provides a failsafe recovery option, in case the deletion was not correct. If you're confident you don't need any of the materials in those tables, you can truncate them to clear up space. It's much like emptying the trash on many desktop systems. OpacSuppression is determined by the 942$n MARC subfield. It is not mapped to the database, so you'll need to query and parse the MARC record in order to get a list of all items that are suppressed from OPAC view. -Ian 2010/12/3 Altaf Mahmud <altaf.mahmud@gmail.com>
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@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@gmail.com
2010/12/2 Altaf Mahmud <altaf.mahmud@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@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.
_______________________________________________ Koha-devel mailing list Koha-devel@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/
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
Hi, suppressed and deleted are different things. 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#AEN3 113 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. Katrin From: koha-devel-bounces@lists.koha-community.org [mailto:koha-devel-bounces@lists.koha-community.org] On Behalf Of Altaf Mahmud Sent: Friday, December 03, 2010 12:34 PM To: Fridolyn SOMERS Cc: koha@lists.katipo.co.nz; Koha-devel@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@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@gmail.com 2010/12/2 Altaf Mahmud <altaf.mahmud@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@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.
Thanks, I just learned a lot! On Fri, Dec 3, 2010 at 6:28 PM, Fischer, Katrin <Katrin.Fischer@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
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@lists.koha-community.org [mailto: koha-devel-bounces@lists.koha-community.org] *On Behalf Of *Altaf Mahmud *Sent:* Friday, December 03, 2010 12:34 PM *To:* Fridolyn SOMERS *Cc:* koha@lists.katipo.co.nz; Koha-devel@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@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@gmail.com
2010/12/2 Altaf Mahmud <altaf.mahmud@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@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.
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@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@lists.koha-community.org [mailto: koha-devel-bounces@lists.koha-community.org] *On Behalf Of *Altaf Mahmud *Sent:* Friday, December 03, 2010 12:34 PM *To:* Fridolyn SOMERS *Cc:* koha@lists.katipo.co.nz; Koha-devel@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@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@gmail.com
2010/12/2 Altaf Mahmud <altaf.mahmud@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@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.
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@gmail.com] Sent: Friday, December 03, 2010 3:14 PM To: Fischer, Katrin Cc: koha@lists.katipo.co.nz; Koha-devel@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@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#AEN3 113 Though I found this feature under cataloging section of the manual: http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN2 96 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@lists.koha-community.org [mailto:koha-devel-bounces@lists.koha-community.org] On Behalf Of Altaf Mahmud Sent: Friday, December 03, 2010 12:34 PM To: Fridolyn SOMERS Cc: koha@lists.katipo.co.nz; Koha-devel@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@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@gmail.com 2010/12/2 Altaf Mahmud <altaf.mahmud@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@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.
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@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@gmail.com] *Sent:* Friday, December 03, 2010 3:14 PM *To:* Fischer, Katrin
*Cc:* koha@lists.katipo.co.nz; Koha-devel@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@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@lists.koha-community.org [mailto: koha-devel-bounces@lists.koha-community.org] *On Behalf Of *Altaf Mahmud *Sent:* Friday, December 03, 2010 12:34 PM *To:* Fridolyn SOMERS *Cc:* koha@lists.katipo.co.nz; Koha-devel@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@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@gmail.com
2010/12/2 Altaf Mahmud <altaf.mahmud@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@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@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@gmail.com
participants (4)
-
Altaf Mahmud -
Fischer, Katrin -
Fridolyn SOMERS -
Ian Walls