[Koha] excel to iso convertion

[Andrew Buxton]

Hello Yatheesh

You do not say what your Excel format is like but it will probably be a lot less detailed than MARC.  For example, it probably won't have MARC indicators and won't distinguish main entry and added entry.  So the MARC you end up with may not be very high quality.  In any case you will need to decide how each of your Excel fields should convert to one or more MARC fields.

If you are a CDS/ISIS user, or know one, there is a utility that converts from Excel to CDS/ISIS and CDS/ISIS can export in ISO 2709 format (of which MARC is one example).  You would need to understand CDS/ISIS and MARC well to perform the conversion.

Andrew Buxton
IDS, Brighton, UK

From: koha-bounces at lists.katipo.co.nz [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Yatheesh Y
Sent: 27 September 2010 13:05
To: Koha at lists.katipo.co.nz
Subject: [Koha] excel to iso convertion

please help me

I have data in excel format  I want convert and load data into koha

please help me in this reg

thank you


This message is for the addressee only and may contain privileged or confidential information.  If you have received it in error, please notify the sender immediately and delete the original. Any views or opinions expressed are solely those of the author and do not necessarily represent those of IDS.

Institute of Development Studies
at the University of Sussex, Brighton BN1 9RE
Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202
IDS, a charitable company limited by guarantee:
Registered Charity No. 306371; Registered in England 877338;  VAT No. GB 350 899914

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100927/d5c41e0b/attachment.htm