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

[Fischer, Katrin]

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#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 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101203/1ddc675a/attachment.htm