<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
you can try Koustubha's fantastic how to on data migration from excel
to koha<br>
<br>
------- Original Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">Subject: </th>
<td>Re: [Koha] data migration from excel to koha</td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">Date: </th>
<td>Mon, 16 Feb 2009 19:02:56 +0530</td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">From: </th>
<td>Koustubha Kale <a class="moz-txt-link-rfc2396E" href="mailto:kmkale@anantcorp.com"><kmkale@anantcorp.com></a></td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">To: </th>
<td>Roche III, Edward <a class="moz-txt-link-rfc2396E" href="mailto:edward_roche@solanco.k12.pa.us"><edward_roche@solanco.k12.pa.us></a></td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">CC: </th>
<td><a class="moz-txt-link-abbreviated" href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a></td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">References: </th>
<td><a class="moz-txt-link-rfc2396E" href="mailto:94752abe0902160412q53534aa2g923cc449fe354c57@mail.gmail.com"><94752abe0902160412q53534aa2g923cc449fe354c57@mail.gmail.com></a>
<a class="moz-txt-link-rfc2396E" href="mailto:49996385.2070800@anantcorp.com"><49996385.2070800@anantcorp.com></a>
<a class="moz-txt-link-rfc2396E" href="mailto:ACFB645515A2A143A2066BE75BF6D87A01825E2F@exchange.solanco.local"><ACFB645515A2A143A2066BE75BF6D87A01825E2F@exchange.solanco.local></a></td>
</tr>
</tbody>
</table>
<br>
<pre>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. )
</pre>
vinod kumar wrote:
<blockquote
cite="mid:cee31d210903132245u1f348e6btf01572944ae71723@mail.gmail.com"
type="cite">how to microsoft excel data convert to marc21 in koha<br>
<br>
please help me as soon as<br>
<br>
<br>
thanks $ regards<br>
vinod kumar<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Koha mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a>
<a class="moz-txt-link-freetext" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a>
</pre>
</blockquote>
</body>
</html>