[Koha] A simple question about Class

[Roger Buck]

# From a galaxy far away, the wise ones wrote:
[--snip--]
> > It seems in acquisionting page, the dewey number can not take
> > anything with letters. It can only take numbers. That is the
> > reason why I ask how did this J get into
> > http://hlt.katipo.co.nz/ dewey part?

 
> I suspect for HLT it actually came in with their big data
> import - but they may also use a different acquisitions module
> to you - they use the full acquisitions within the library,
> where as at the moment on the demo site I think it is the
> simple acquisitions that is running.
> 
> However it sounds like you might have found a bug between
> the two systems - because I'd have thought you could enter
> in the same info in both.

I know it is bad manners to answer your own question - especially if you
don't know the answer :) - but here goes attempt #1"

" Subject:  [Koha] Dewey entry
  Date:     Wed, 17 Apr 2002 09:42:50 +1000
  From:     Roger Buck <rog at saas.nsw.edu.au>
  To:       koha at lists.katipo.co.nz

 I am in the process of migrating items from our
 current library system into koha and I have a
 question about Koha Dewey entries.

 When adding Dewey entry for new biblio I note two
 fields:  "Dewey" and "Dewey Subclass"

 All our current entries follow this format:

 JSM 428.007 WEN
 JSM 362.2 TOP 
 JSM 170 VER

 ...and so on...

 What is the correct way to enter above data into
 the Koha Dewey field(s)? 

 ==========================================

# From the example koha db tables for <biblioitems.dewey>:

  dewey double (8,6) default NULL

I think this means that the dewey entry is restricted to being a numeric
data type (double precision - up to 8 digits displayed, with up to 6
digits following the decimal point)? As far as I know, the Dewey numbers
are "labels" - their value is not used for computation - so the dewey
number could be entered as a "text" data type?

I'd guess that simply changing the db entry to something like:
 
   dewey varchar (16) default NULL

might cover most of your needs?


I am just a newbie at this stuff and the above is all just guess-work -
so make modifications at your own risk ;^)

R.