https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13023 --- Comment #29 from David Cook <dcook@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.