[Koha] Converting non-MARC records

[Olugbenga Adara]

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 at yahoo.com> wrote:

> From: Jeffrey LePage <jeffrey_lepage at yahoo.com>
> Subject: Re: [Koha] Converting non-MARC records
> To: "Koha" <koha at lists.katipo.co.nz>, "Davoodifar, H. Sam (EDU-ECY)" <H.Sam.Davoodifar at 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 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
> 
> 
> 
>       _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha