Re: [Koha-devel] [important] copyrightdate is not loaded into biblio table

[Rosalie Blake]

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 address@hidden
> https://lists.sourceforge.net/lists/listinfo/koha-devel