[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)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20030320/5102e38f/attachment-0002.htm>