[Koha-bugs] [Bug 13023] Nonpublic note for items should be mapped to a database column like itemnotes

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13023

--- Comment #29 from David Cook <dcook at prosentient.com.au> ---
(In reply to Katrin Fischer from comment #28)
> Because the data is still in more_subfields_xml or items.paidfor (depending
> on the age of the installation) you will have problems accessing your data. 
> 
> I did a lot of tests when we tried to do that in the first iteration and
> there always remained problems (see bug 4222).

I'm looking at this right now...

I used admin/koha2marclinks.pl to update my frameworks to use the
itemnotes_nonpublic column for 952$x, and if I manually edit an item, I see the
data from more_subfields_xml, and when I re-save it, it moves into
itemnotes_nonpublic.

However, I'm trying to automate this to do thousands of items... and I'm
finding "touch_all_items.pl" isn't doing the trick...

--

It looks like admin/koha2marclinks.pl just runs the following SQL:

"update marc_subfield_structure set kohafield='$tablename.$kohafield' where
tagfield='$temp[0]' and tagsubfield='$temp[1]'"

So that can be scripted easily enough...

As for updating the item records...I think maybe what I need to do is run
GetMarcItem, which runs Item2Marc, and then maybe run ModItemFromMarc.

my $item_marc =  GetMarcItem($biblionumber, $itemnumber);
my $item = ModItemFromMarc($item_marc, $biblionumber, $itemnumber);

I've tried that on a few records, and that seems to do the trick.

--

I wonder what we should do about this... add it as a maintenance script? Do we
add it to updatedatabase.pl?

-- 
You are receiving this mail because:
You are watching all bug changes.