[Koha-devel] Re: MARC links

[paul POULAIN]

Stephen Hedges wrote:
> Paul (amd Chris) -
>
> I've attached my list of suggested links between the koha database and the MARC 
> database.
>
> As you can see, some of the links need to be repeatable.  1.9.0 currently 
> accepts only the last link that's entered when there are duplicate links, which 
> means the "Checks MARC" function always reports errors.
>
> I've sprinkled other comments in the body of the text attachment.
>
> Stephen
1 month after, I haven't forgotten this mail, and use it.
I try to improve the MARC21 english parameters for 1.9.1, to have a working
parameters in the release.

[biblio table]

biblionumber      090  c  Koha biblionumber
author            100  a  Personal name
title             245  a  Title
unititle          246  a  Title proper/short title
notes             500  a  General note
serial            400  v  Volume number/sequential designation
seriestitle       440  a  Title
copyrightdate     260  c  Date of publication, distribution, etc
timestamp         005     DATE AND TIME OF LATEST TRANSACTION
  [computer generated]

==> for instance, timestamp is not auto-managed in koha. It should be
possible to develop a plugin to do this.

abstract          520  a  Summary, etc

[biblioitems table]

biblioitemnumber  090  d  Koha biblioitemnumber
biblionumber      090  c  Koha biblionumber
volume            440  v  Volume number/sequential designation
number            440  n  Number of part/section of a work
classification    082  a  Classification number
  [or it could be an extra subfield in the 090 tag, since
   this + dewey + subclass = callnumber]
 [classification, dewey, and subclass could also be:
   classification  852  h  Classification part
   dewey           852  k  Call number prefix
   subclass        852  m  Call number suffix]

==> i've chosen 852 h/k/m, which seems better, and will work fine.

itemtype
  [this probably should be added as a 955 subfield]

==> i think you speak of 995, not 955. In this case, it's a bad idea.
995 fiels are related to ITEMS, and itemtype is a biblioitem field. I've
choosen 686a

isbn              020  a  International Standard Book Number
issn              022  a  International Standard Serial Number
publicationyear   260  c  Date of publication, distribution, etc
volumedate        260  c  Date of publication, distribution,
etc

==> multi-linked field... 260c is the only remaining multi-linked
field (see below for 500a, and dewey 090b is solved by using 852h/k/m)
In fact,  those fields are differents things, and i'm surprised to see marc21
doesn't differenciate them. I think our best solution is to choose one, and
do with it.

publishercode     260  b  Name of publisher, distributor,
etc
volumeddesc       300 all PHYSICAL DESCRIPTION

==> I really don't find any MARC21 field for volume desc. Maybe we can
ignore this

timestamp         005     DATE AND TIME OF LATEST TRANSACTION
illus             300  b  Other physical details
pages             300  a  Extent
notes             500  a  General note

==> As 500a is already used for biblio notes, i don't know where to put
biblioitem notes.
Note too that i think biblioitem notes is a unuseful field (biblio.notes
and item.notes are enough no ?)

size              300  c  Dimensions
place             260  a  Place of publication, distribution, etc
lccn              010  a  LC control number
marc   [what's in this field?]

==> this field is not used, don't worry :-)

url               856  u  Uniform Resource Identifier

[items table]
  [lots of gaps here, all needing new 995 subfields?]

==> I've added some, and there's no problem
to have unmapped fields. For example, i don't think it's important to hare
prices and bookseller info in the MARC record.

itemnumber        995  s  Koha item number
biblionumber      090 c Koha biblionumber
multivolumepart
biblioitemnumber  090 d Koha biblioitemnumber
barcode           995 f barcode
dateaccessioned   995 m dateaccessioned
booksellerid
homebranch        995 d homebranch
price
replacementprice
replacementpricedate
datelastborrowed
datelastseen
multivolume
stack
notforloan        995 o notforloan
itemlost
wthdrawn
bulk
issues
renewals
reserves
restricted
binding
itemnotes         995 u item notes
holdingbranch
paidfor
timestamp         005     DATE AND TIME OF LATEST TRANSACTION
-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)