[Koha] How to Import the Excel data in to the Koha

[Olugbenga Adara]

--- On Sun, 1/11/09, Beda Szukics <beda at muri-gries.ch> wrote:

> From: Beda Szukics <beda at muri-gries.ch>
> Subject: Re: [Koha] How to Import the Excel data in to the Koha
> To: "Thommy M." <thommy.m.malmstrom at gmail.com>
> Cc: koha at lists.katipo.co.nz
> Date: Sunday, January 11, 2009, 11:47 PM
> Thommy M. writes: 
> 
> > bjagadish1 at yahoo.co.in wrote:
> >> sir, i am new to the KOHA software , I have data
> in the excel sheet ,
> >> can u ple tell me how to import the Excel data in
> to the KOHA software.
> >> thanking you sir,
> >> with regards
> > 
> > Install Koha and check the data structure of the
> database. Then generate
> > SQL statements to read your data and import it into
> the correct tables. ;-)
> 
> An alternative way: Use MarcEdit to create a file you may
> import into Koha 
> using bulkmarkimport.pl 
> 

i also use marcEdit. Enter a sample record into koha and export it out as a marc record, use marcedit "marcbreaker" to break this marc file so you could see the tags and the sub fields used by koha. then export your data out of excel to csv.

you then use marcEdit csv to marc converter to convert it to .mrk after you have correctly mapped your csv fields to the appropriate tag and subfield.

Then to marc which you then import into koha. 

i use the web interface to import into koha


I hope this helps