[Koha] MARC importing tool?
markj at cloaked.freeserve.co.uk
Sat Aug 16 01:28:10 NZST 2003
Wolfgang Pichler <wolfgang.pichler at ivv.tuwien.ac.at> wrote:
> MJ Ray wrote:
>> Existing data from what?
> source : ms-access data (id,author, title, maybe isbn and many other
> fields, all heavily postprocessed by exporting cvs and running heavy
You store access data in CVS?
> perl-scripts to check if isbn is valid, to try to figure out multiple
> authors, since they are given with various delimiters [ John & Jack Doe
> / Doe, John and Jack / Doe, John ; Smith, J. / and all that funny things
> an unconstrained user may do :-(((, -- size about 16000 items !)
OK. You could output MARC records, would be my best guess. Maybe someone
here can point at helpful things about MARC.
> overall they crunched their audio-tapes and multilingual items into such
> a system,
> moreover there are borrower's data and currently-issued-states to
> monitor --- l o t s of funny things to do /w perl.
I'm not 100% clear on this just now and I doubt it will become clearer
until you have a testbed running. Maybe other library users can explain
how they cope with current issues while moving to koha? Just reenter,
run the two systems alongside, or something smarter?
> they wish to reorganize the current overall shelving and collection
> systematics (not sure where to find it in koha :
> biblioitems:classification ?)
Again, this is probably something other library users on this list can
advise on, but I think that's where you should be looking.
>> OK, I asked you to restate it because I didn't understand the first
>> time. I still don't understand. Can you rephrase/expand?
> there are many tinyint's and char(1-4) in the db-scheme, which are
> obviously sometimes booleans, or other indicators for some status
> (biblio:serial == boolean : is a serial?, borrowers:categroycode,
Yes, I admit that I'm not sure why they are those types instead of
enumerated or foreign keys in another table, unless it's because we're
*still* working without foreign keys in MySQL :-(
> any summaries about these ? or just RTFC ?
A better question for -devel. If you can post a complete list of these
unexplained ones, developers of the relevant parts will explain it
eventually, I guess.
MJR/slef My Opinion Only and possibly not of any group I know.
Creative copyleft computing services via http://www.ttllp.co.uk/
Thought: Edwin A Abbott wrote about trouble with Windows in 1884
More information about the Koha