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

[Ian Walls]

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 at 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 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.
>
>
> _______________________________________________
> 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/
>



-- 
Ian Walls
Lead Development Specialist
ByWater Solutions
Phone # (888) 900-8944
http://bywatersolutions.com
ian.walls at bywatersolutions.com
Twitter: @sekjal



-- 
Ian Walls
Lead Development Specialist
ByWater Solutions
Phone # (888) 900-8944
http://bywatersolutions.com
ian.walls at bywatersolutions.com
Twitter: @sekjal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101203/68018596/attachment-0001.htm