Hi Stephen, & koha-devel. for everybody : this mail is about import of copyrightdate into Koha. You can see the initial bug at http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=514 Stephen pointed that copyrightdate was not loaded into Koha-db when importing MARC records (note that the 260c was imported into MARC-DB. The problem was that it was not transfered to koha-db (the DB that is used in many places where MARC is not interesting, like opac for example). I thought it was a spydus problem, but I was wrong. 260c in MARC21 contains "dates". It means it can contain : "copyright 1968, reedited 1985, something-else 1995". (see http://www.loc.gov/marc/bibliographic/ecbdimpr.html#mrcb260) The problem for importing is that copyrightdate is a *NUMBER* in koha-db. and "c1968, reedited 1985, something else 1995" is not really a number :-( So, we have 2 solutions (both being easy to code) : * modify the DB structure to have a char, and copyrightdate would be : "c1968, reedited 1985, something else 1995" in my sample. (con : Maybe a little too many info for OPAC ?) * modify the import tool to extract the 1st "date" in the string (mean, the 1st time where 4 digits are found) : "1968" in my sample. (con : risk to choose a date that is not really a copyrightdate) Which solution do readers of this list prefer ? Stephen Hedges wrote:
Paul -
The beginning "c" stands for "copyright." That's standard MARC21 cataloguing.
(This time we _did_ follow the rules!) It's not a Sypdus problem, it's a MARC21 problem -- and therefore a Koha problem.
Stephen
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=514
In the sample you sended me, I see :
260 0 _a[Mankato, Minn.] : _bThe Child's World, _cc1993. So, the date in 260$c is : c1993. which is not a date isn't it :-) (note that it seems that EVERY date have a c at beginning and . at the end. Sometimes, it's even worst : 260 0 _aSouth Yarmouth, MA : _bJohn Curley & Associates, _cc1926,1954. In samples here : http://www.loc.gov/marc/bibliographic/ecbdimpr.htm l#mrcb260 I read : 260 ##$aNew York, N.Y. :$bElsevier,$c1984.
260 ##$a[S.l.] :$bInsight Press,$c1981. The ending . is OK (and should be accepted by Koha. The beginning c is a spydus creation.
I mark the bug invalid.
-- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)