Hi everyone I use this data to keep track of average age of collections. FOr me, a clean date - ie first 4 digits would be much more useful. Rosalie Blake Horowhenua LIbrary Trust On 7 Jul 2003, at 10:52, paul POULAIN wrote:
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)
------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/ 01 _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel