LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Dr.Stephen.G replied to Dr.Stephen.G's discussion Call for Papers – ICDIASLS-2025
yesterday
Dr.Stephen.G posted a discussion
yesterday
CHETAN RAVAL updated their profile
Friday
Bilal Rabbani is now friends with Millan Krushna Dutta and Mhuammad Rafiq Akhtar
Thursday
Vinod Kumar Jain posted a blog post
Thursday
neema shukla posted an event
Thumbnail

International Conference on Libraries and Emerging Technologies for Smart Knowledge Ecosystems (ICLET 2025), at Jaipur,Rajasthan

November 14, 2025 at 9am to November 15, 2025 at 6pm
Thursday
Rohidas Rathod posted an event
Thursday
Hemanta Kumar Biswal posted an event
Thumbnail

4th International Symposium on Knowledge Engineering for Digital Library Design (KEDLD-2025) at Indian Institute of Technology, Kharagpur

November 3, 2025 to November 5, 2025
Thursday
SHIVAKUMARA BC posted a discussion
Thursday
Swati replied to Jayant Deshpande's discussion Librarian are forced to teach a subject
Wednesday
OKE CHANDAN updated their profile
Wednesday
jai prakash kumar updated their profile
Jul 8
Rohidas Rathod updated their profile
Jul 7
Rohidas Bhimrao Rathod updated their profile
Jul 7
Rohidas Bhimrao Rathod updated their profile
Jul 7
Vinod Kumar Jain posted a status
"Required Library paid Intern @ 8000 PM for 6 Months for “Indexing Database”- in Delhi, 9818180051"
Jul 6
Vinod Kumar Jain posted a status
"Required Library Intern for “Indexing Database”- in Delhi"
Jul 6
Dr.Stephen.G commented on Dr.Stephen.G's event 'International Conference on Digital and Innovative Advancements for Sustainable Library Services'
Jul 6
Dr.Stephen.G posted an event

International Conference on Digital and Innovative Advancements for Sustainable Library Services at Bharati Vidyapeeth’s Institute of Computer Applications & Management (BVICAM), New Delhi

August 29, 2025 at 10am to August 31, 2025 at 5pm
Jul 6
Dr.Stephen.G posted a discussion
Jul 6

Dear All,

We want to transfer Excel database to the Koha database.

Is it possible? Please suggest me.

Views: 2494

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

© 2025   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop