[Koha] data migration from excel to koha

Koustubha Kale kmkale at anantcorp.com
Tue Feb 17 02:32:56 NZDT 2009

Here we go..
First get your data organized in Excel. Things we had to watch out for 
were.. date formats to match your koha / mysql date formats, barcode, 
itemtype, library branch. We had to add last three to the excel data. 
Also watch out for common things like quote, comma, tab marks & any 
unusual characters in your data. Clean up the data thoroughly.

Then save the excel file as unicode text. Excel saves as a tab delimited 
file in Unicode. We need utf-8. So you need some text editor which can 
save the file as utf-8. I use EditPlus.

After you have saved the file as utf-8 text, start the Delimited Text 
translation Wizard from the MarcEdit program group. On the second screen 
give i/p and o/p filenames, leave the delimiter to tab, put text 
qualifier if any in your text file, click on Edit LDR/008 select LDR 
dropdown appropriate to your data. Select utf-8 encoded checkbox.

On next screen you have  to  build a  mapping from  your excel file 
columns to koha marc tags. Tric is to click in the Select Field 0 drop 
box and while it is selected type your corresponding marc tag in the  
map to text box. then click apply. Once you have mapped all columns in 
your excel file tokoha marc tags, click on save template so you can 
reuse it next time you import data in the same excel format and click 
finish. It will save your template as a .mrd file and create a .mrk file 
of your text data.

Open the .mrk file in MarcEdit by double clicking it and simply click on 
the Compile Records button. This will compile all your records and give 
you a .mrc file.

In koha go to tools -- > Stage marc records for import, select your .mrc 
file set record matching rules s needed and click the big button. This 
will import the data in staging area and take you to a summary page 
which will have a link to manage the imported records. Click the link 
select record matching conditions needed and import the staged records 
in to the database..

Reindex your database by running misc/migration_tools/rebuild_zebra.pl 
-b -w ( or by running misc/migration_tools/rebuild_nozebra.pl if not 
using zebra. )

Koustubha Kale
Anant Corporation

Contact Details :
Address  : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w),
      	  	Maharashtra, India, Pin : 400601.
TeleFax  : +91-22-21720108, +91-22-21720109
Mobile     : +919820715876
Website  : http://www.anantcorp.com

Roche III, Edward wrote:
> This guide would help me because I downloaded and took a peek at the app
> and didn't know where to start.
> Thanks
> Ed
> Edward J. Roche
> Network Administrator
> Solanco School District
> 717.786.2151 x2437
> "At the End of the Day, Did You Play to Win or Not to Lose?" 
> -----Original Message-----
> From: koha-bounces at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Koustubha Kale
> Sent: Monday, February 16, 2009 8:01 AM
> To: Amandeep Kansal
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] data migration from excel to koha
> We used the excellent and free MarcEdit very successfully for this.
> If you need a step by step let me know..

More information about the Koha mailing list