[Koha] MARC Export and adding data to marc tables
manzo at salk.edu
Tue Sep 18 10:17:23 NZST 2007
I have been trying a variety of techniques to swap data from a
library specific field (we are using 900 to store legacy data) to the
Koha items field (952).
Specifically moving data from 900 sub 6 to 952 p (barcode, we are
using a custom number in place of barcode)
My problems are:
1. The MARC export is producing a file that has incorrect Leader
data. I have verified this through two utilities which I have used
before successfully with other marc files - Marcedit ( a free win32
app) and File_MARC (pear extension).
2. My next attempt was to try to directly edit the data in the Koha
database. I was able to update items.barcode =
marc_subfield_table.subfieldvalue with plain old sql. However it
seems this data is only part of the story and I need to also update
the marc_subfield_table(900 sub 6 to 952 p OR items.barcode to 952
p). I could not figure out which fields need which data to do this
step and if this (marc_subfield_table) was the only other table that
I needed to update.
So to reiterate.
Is there a known problem w/marc export?
Can someone help me w/the sql to create the necessary entries from
items.barcode to the other marc related tables so that this data is
visible throughout Koha.
More information about the Koha