<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">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?<br><br>Assuming you want to convert the records to MARC, and then import...<br><br>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.<br><br>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. <br><br>Do you know any perl?<br><br>To get the data in the right format I would use the Perl MARC library, available at http://marcpm.sourceforge.net/<br><br>To manipulate data in CSV files I would suggest the Perl library Text::CSV_XS<br><br>To see a very simple example of Perl MARC in action, see my script at http://contribs.koha.org/revision_view.php?rid=15<br><br><br><br><br><br><br><br>-- <br>
Please avoid sending me Word or PowerPoint attachments.<br>
See http://www.gnu.org/philosophy/no-word-attachments.html<br><br>--- On <b>Mon, 1/5/09, Davoodifar, H. Sam (EDU-ECY) <i><H.Sam.Davoodifar@gov.mb.ca></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">From: Davoodifar, H. Sam (EDU-ECY) <H.Sam.Davoodifar@gov.mb.ca><br>Subject: [Koha] Converting non-MARC records<br>To: "Koha" <koha@lists.katipo.co.nz><br>Date: Monday, January 5, 2009, 10:52 AM<br><br><pre>Hi everyone,<br><br>I've recently got a SydPlus system which has about 20000 non-MARC<br>records and runs on SQL Server. I've been able to export all tables into<br>CSV format. Now I want to get these records loaded into KOHA and need<br>some help. Also, I need to figure out database structure to associate<br>(map) each one to MARC fields. Unfortunately, I'm not familiar with<br>SydPlus as we just recently inherited the collection and system. So,<br>essentially my questions
are:<br><br>1- Is anyone familiar with SydPlus record structure and tables?<br>2- How to convert non-MARC records and load them into KOHA. <br><br>I'd really appreciate any help and suggestion....<br><br>Thanks<br><br>H. Sam Davoodifar<br>Systems Admin/IT Services<br>IRU - Educational Resources<br>Manitoba Education, Citizenship & Youth<br>1181 Portage Ave., Winnipeg, MB R3G OT3<br>Tel: 204-945-4904 Toll free: 800-282-8069 (ext. 4904)<br>Fax: 204-945-8756<br>New email: h.sam.davoodifar@gov.mb.ca<br>_______________________________________________<br>Koha mailing list<br>Koha@lists.katipo.co.nz<br>http://lists.katipo.co.nz/mailman/listinfo/koha<br></pre></blockquote></td></tr></table><br>