Dear Murali
Greetings from the GIPE Library!
With reference to your query "Porting of data from MS Excel/MS Access",
please find below the details.
Yes, there is a provision in Koha to import the data. The data can be either
in MS Excel or MS Access. The Excel / MS Access data can be ported in Koha
using a utility called MarcEdit. The utility is available on the net.
While creating the worksheet in Excel ensure that most important data fields
like Date of Accession, Accession Number, Author(s), Title, Subtitle,
Edition, Publisher, Place of Publication, Year of Publication, Notes, Class
Number / Call Number, Supplier, Invoice/Bill, Invoice Date, Type of Document
(Book, CD, DVD), Type of Material (Reference/Circulation), etc are entered
in separate fields. As excel or access does not support the repeatable
fields, please create as many as author fields as you require. In author
field please entre the data in the order Last Name, First Name and Middle
Name. Ensure to insert a comma after Surname. I have name few fields only.
If you wish / require, please add as many fields as you want. MARC21 / Koha
will support all the fields that you entre.
If you find any difficulty in creating the marc file for Koha or ISO file
for any other software, do get back to me. To start with, those who have not
started the library automation and have not thought of buying / installing
any software also can go for this kind of Excel / Ms Access Data entry.
Regards
Dr Nanaji Shewale
Librarian
Gokhale Institute of Politics and Economics
B M C C Road, Deccan Gymkhana
Pune 411004 (India)
T: 91 20 25679940 (Direct)
T: 91 20 25654288, 25650287 Ext 401
http://www.gipe.ac.in
Message: 1
Date: Thu, 25 Aug 2011 11:25:25 +0530
From: muruli acharya