Replies to This Forum

Permalink Reply by AJEEMSHA S on June 8, 2016 at 16:39

http://marcedit.reeset.net/ is the site which offer software for conversion to marc. But your intermediary steps to be in correct format. Otherwise it will not be converted. I am also trying. If you succeed kindly share with me also.

• ▶ Reply

Permalink Reply by ABDUL GAFOOR on June 8, 2016 at 22:56

thanks and i will try

• ▶ Reply

Permalink Reply by AJEEMSHA S on June 9, 2016 at 17:54

http://www.botskool.com/geeks/how-import-excel-data-koha

• ▶ Reply

Permalink Reply by ABDUL GAFOOR on June 9, 2016 at 22:14

i am not comfortable with marc mapping or editing . any way i will try after reading the instructions well.

• ▶ Reply

Permalink Reply by Dr. O Seshaiaih on June 10, 2016 at 3:14

sir,

visit the following blog for step by step for data conversion from excel to koha.

http://lis-friends.blogspot.in/2015/07/excel-to-koha-data-conversio...

O.Seshaiah
Librarian
PBR VITS
Kavali
www.lis-friends.blogspot.in

• ▶ Reply

Permalink Reply by Ganesh Singh on June 10, 2016 at 20:35

Dear Mr. Abdul Gafoor, I have gone through your excel file. It is in good format, but it still lacks some essential MARC fields. These are :-

TITLE STATEMENT Statement of responsibility, etc --- 245 c

MAIN ENTRY Personal name ------ 100 a (this field should contain single author, but in yours some entries contain more than one author. And also personal name should contain comma between surname and forename.)

ADDED ENTRY Personal name ------ 700 a (Second and third author)

DEWEY DECIMAL CLASSIFICATION NUMBER Classification number ---- 082 a ( In yours it is call number. But it can be fixed. not a big problem)

Rest is fine. I can convert it into .mrc format but it is advised that first you fix above issues.

All the best.

• ▶ Reply

Permalink Reply by AJEEMSHA S on June 11, 2016 at 6:46

Sir, whether it should be in excel format or in txt?

• ▶ Reply

Permalink Reply by Ganesh Singh on June 12, 2016 at 19:40

excel format.

• ▶ Reply

Permalink Reply by ABDUL GAFOOR on June 15, 2016 at 22:17

thank you sir

i can do as directed

• ▶ Reply