[Koha] Converting non-MARC records

[Jeffrey LePage]

I suppose now that you have the data in a readable format you can convert the records to MARC, and then use the existing Koha tools to import the MARC records.  I'm new to Koha as well; are there tools to import records without passing through a MARC stage?

Assuming you want to convert the records to MARC, and then import...

I have no idea how to map SydPlus database structure to MARC.  You say you have successfully exported the SydPLUS data to CSV.  Unless you can get some help from SydPlus, I suspect you'll simply have to reverse-engineer the database.  I would begin with the Koha-to-MARC mapping, identifying each MARC tag in the Koha database with a table/column of the SydPlus database.

The Koha-to-MARC mapping is easy.  To see the mapping from Koha to Marc, go to the Koha Staff Client, Administration->Koha to Marc Mapping (http://<your server name>/cgi-bin/koha/admin/koha2marclinks.pl).  There are 3 tables that store details about books: biblio, biblioitems, items.  

Do you know any perl?

To get the data in the right format I would use the Perl MARC library, available at http://marcpm.sourceforge.net/

To manipulate data in CSV files I would suggest the Perl library Text::CSV_XS

To see a very simple example of Perl MARC in action, see my script at http://contribs.koha.org/revision_view.php?rid=15







-- 

Please avoid sending me Word or PowerPoint attachments.

See http://www.gnu.org/philosophy/no-word-attachments.html

--- On Mon, 1/5/09, Davoodifar, H. Sam (EDU-ECY) <H.Sam.Davoodifar at gov.mb.ca> wrote:
From: Davoodifar, H. Sam (EDU-ECY) <H.Sam.Davoodifar at gov.mb.ca>
Subject: [Koha] Converting non-MARC records
To: "Koha" <koha at lists.katipo.co.nz>
Date: Monday, January 5, 2009, 10:52 AM

Hi everyone,

I've recently got a SydPlus system which has about 20000 non-MARC
records and runs on SQL Server. I've been able to export all tables into
CSV format. Now I want to get these records loaded into KOHA and need
some help. Also, I need to figure out database structure to associate
(map) each one to MARC fields. Unfortunately, I'm not familiar with
SydPlus as we just recently inherited the collection and system. So,
essentially my questions are:

1- Is anyone familiar with SydPlus record structure and tables?
2- How to convert non-MARC records and load them into KOHA. 

I'd really appreciate any help and suggestion....

Thanks

H. Sam Davoodifar
Systems Admin/IT Services
IRU - Educational Resources
Manitoba Education, Citizenship & Youth
1181 Portage Ave., Winnipeg, MB R3G OT3
Tel: 204-945-4904 Toll free: 800-282-8069 (ext. 4904)
Fax: 204-945-8756
New email: h.sam.davoodifar at gov.mb.ca
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090105/3d11fc5f/attachment.htm