hello, another tool you can try is marcedit at http://oregonstate.edu/~reeset/marcedit/html/index.php it has a feature to take csv file and generate a file (.mrk) that it now makes into marc. I've used this to convert a csv file into marc for import. Of course i dont know perl :-(, so i found this route easier. Olugbenga Adara Ibadan, Nigeria. Mobile: 234-803-3220288 --- On Mon, 1/5/09, Jeffrey LePage <jeffrey_lepage@yahoo.com> wrote:
From: Jeffrey LePage <jeffrey_lepage@yahoo.com> Subject: Re: [Koha] Converting non-MARC records To: "Koha" <koha@lists.katipo.co.nz>, "Davoodifar, H. Sam (EDU-ECY)" <H.Sam.Davoodifar@gov.mb.ca> Date: Monday, January 5, 2009, 12:34 PM 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@gov.mb.ca> wrote: From: Davoodifar, H. Sam (EDU-ECY) <H.Sam.Davoodifar@gov.mb.ca> Subject: [Koha] Converting non-MARC records To: "Koha" <koha@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@gov.mb.ca _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha