[Koha-patches] [PATCH] Bug 4222 - allow nonpublicnote to be a mapped DB column

[Galen Charlton]

Hi,

On Sat, Nov 13, 2010 at 12:31 PM, Ian Walls
<ian.walls at bywatersolutions.com> wrote:
> Depending on the number of biblios, this could cause the updatedatabase.pl
> script to take a VERY long time to complete.  It would also require the use
> of C4::Biblio (or else rewriting the GetMarcBiblio subroutine within the
> updatedatabase.pl script).  Is it worth making this part of
> updatedatabase.pl, or should a separate cleanup script be written?

Actually, it wouldn't require use of C4::Biblio.  If non-public notes
exist but are not mapped to a field in the items table, they will end
up in items.more_subfields_xml.  An upgrade script can simply munge
items.more_subfields_xml and items.nonpublicnote, but would not need
to touch the bib MARC.  For example, if the note is embedded in the
952$x, as far as the bib record is concerned it will remain there;
only two columns in items would change.

For a database with a large number of item records, it could still
take a while to complete, so a separate script may still be justified,
but it wouldn't need to touch the bib records.

Regards,

Galen
-- 
Galen Charlton
gmcharlt at gmail.com