LIS Links

First and Largest Academic Social Network of LIS Professionals in India

LIS Links Becoming More Social

Latest Activity

Ashutosh Joshi is attending Hemanta Kumar Biswal's event
Thumbnail

National Conference on “Intelligent and Smart Digital Library (ISDL-2026)” at IIT Kharagpur at IIT Kharagpur

December 21, 2026 at 9am to December 22, 2026 at 6pm
7 hours ago
Profile IconShubhanshu Vishwakarma, KAMALDEEP, Dk and 13 more joined LIS Links
9 hours ago
Dr. Badan Barman posted an event

7th National Conference on Management of Modern Libraries (NACML– 2027) on “Contemporary Approaches to Libraries: Emerging Technologies, Services, and Skills at Manipal Academy of Higher Education (MAHE), Manipal, Karnataka

January 29, 2027 at 10am to January 30, 2027 at 5pm
20 hours ago
Shariyan Ahmed posted a blog post
20 hours ago
Dr. V. Senthur Velmurugan posted an event
20 hours ago
Biswaranjan Jayanti Manna posted an event
Thumbnail

IASLIC 31st National Seminar 2026 on Adaptive Libraries: Resilience and Innovation at Bansuri Guru Auditorium, Institute of Technical Education & Research, Bhubaneswar, Odisha, India

December 28, 2026 to December 30, 2026
20 hours ago
Dr.Giriraj Halkar posted a discussion
20 hours ago
CHIKKUDU VENKATA MURALI updated their profile
21 hours ago
Dr. Badan Barman and Paradip Sen Roy are now friends
21 hours ago
Umasankar Mahata is attending Dr. Manoj Das's event
Thumbnail

Two-Day Online National Workshop on Library Automation Using Koha at Cooch Behar, West Bengal

October 2, 2026 at 11am to October 3, 2026 at 5pm
yesterday
Umasankar Mahata is attending Paradip Sen Roy's event
Thumbnail

Two-Day Online National Workshop on "Library Automation Using Koha" at Online

October 2, 2026 at 11am to October 3, 2026 at 5pm
yesterday
Jayvardhan Singh updated their profile
yesterday
S. Jaffer Basha left a comment for Pallavi Sushant Sapkal
Wednesday
Anju sagar posted a status
"What are you up to?"
Tuesday
Sangeeta Manohar Sonawane posted a status
"What are you up to?"
Tuesday
Sangeeta Manohar Sonawane posted a status
"Dear All Librarian, PFA Call for Book Chapters/Research Papers for Edited Book To be Published with ISBN under IIP International Publi"
Tuesday
Sangeeta Manohar Sonawane posted a status
"What are you upCall for Chapters Transforming Libraries in the Age of AI: Towards a Smarter Knowledge Ecosystem to?"
Tuesday
Sangeeta Manohar Sonawane posted a status
"What are you up to?"
Tuesday
Sangeeta Manohar Sonawane posted a status
"What are you up to?"
Tuesday
Ankush Nandkishor Makode shared Dr. Badan Barman's group on Facebook
Monday

Dear All,

We want to transfer Excel database to the Koha database.

Is it possible? Please suggest me.

Views: 2780

▶ Reply to This

Replies to This Forum

what type of data import in koha like patron or books if books data upload in koha then convert your file exl to marc. and check the format of macc file and opload

If it is books,convert file into mrc and validate it.then upload in KOHA.if you do not know convert file xl to mrc then send me............shakilahma@gmail.com

Regards

Shakil

for patron data

follow the steps

click on tools

click on import patron

see the Notes

click on (here)  for the exact form of excel 

you ca arrange your data according to this excel file format

                 or

fields 'branchcode' and 'categorycode' are required and must match valid entries in your database.

for books you have to convert excel into marc records.

for conversion use marc edit software this soft is free and easy to use.

after conversion you follow the below steps.

1.Click on Tools

2.Click on Stage MARC records for import

3.Click on Choose file

4.Click on Upload file

5.Click on Stage for import

6. You will get the result like

MARC staging results :

  • 10 records in file
  • 0 records not staged because of MARC error
  • 10 records staged
  • Did not check for matches with existing records in catalog
  • 0 item records found and staged
  • Manage staged records

Please follow us in Facebook LIS Tech group for further queries

Dear Santoh

The link is not relevant  for the question

First specify what type of data do u have..

If it is bibliographic data, use marc edit..

There is a tool available in marc edit called Delimited text translator. u can map the columns into marc fields.

I fit is patron data use koha default csv file from the patron bulk upload tool.

Hello Sir , For detail of koha, you will call Mr. Vikram ,he is distribute r of koha in Pune , 

Dear Nidhi ,

we at Cameo Digital systems , Pune provide cloude hoted version of Koha , with SMS integration 

and i want to walk you through a demo please give me call on on +919975742180 or mail me on koustubh@cameoml.com when you are interested for the demo.

Best Regards ,

Koustubh Kulkarni

Respected sir,

i am using koha on Lubuntu platform recently and i migrate data on koha but data was copied multiple manner so i need to delete all the data and reenter the new data how can do that please help in that regards

thank you

RSS

© 2026   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp