LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

Sanjana saini and Akshay Subhash Gadade are now friends
Saturday
Dr. U. PRAMANATHAN replied to Dr. U. PRAMANATHAN's discussion Call for Book Chapters: Digital Leadership in Library & Information Centers (Innovative Strategies in Library Management) by Ess Ess Publications.
Friday
Dr.Rajeshwar kumar G replied to Dr. U. PRAMANATHAN's discussion Call for Book Chapters: Digital Leadership in Library & Information Centers (Innovative Strategies in Library Management) by Ess Ess Publications.
Friday
Arunima Giri might attend Dr. U. PRAMANATHAN's event

National Level Webinar on “IPR: Balancing Research and Innovation” by Dr. Kohila G.T., Assistant Professor, Department of Library and Information Science, Pondicherry University, Pondicherry at Online

April 26, 2025 from 10:30am to 12pm
Friday
0 Comments
Shruthi updated their profile
Thursday
Mahesh B. updated their profile
Apr 21
Akshay Subhash Gadade joined Dr. Badan Barman's group
Thumbnail

Circular in Library and Information Science

Apr 20
6 Comments
Dr. U. PRAMANATHAN posted blog posts
1 more…
Apr 20
K Chiyuh commented on Hema Thakur's event 'One Day National Seminar on the Future of Libraries in the Era of Artificial Intelligence'
Apr 20
K Chiyuh might attend Hema Thakur's event
Thumbnail

One Day National Seminar on the Future of Libraries in the Era of Artificial Intelligence at Solan -Himachal pradesh

May 3, 2025 from 9am to 5pm
Apr 20
1 Comment
Mr.Vipul Kumar updated their profile
Apr 19
Mr.Vipul Kumar shared a profile on Facebook
Thumbnail

Mr.Vipul Kumar

Apr 19
Profile IconUmasankar mahata, Nikita Medhi, Prohlad Basumatary and 81 more joined LIS Links
Apr 19
Dr. SUDHI S VIJAYAN posted a discussion

Call for Articles – Library Gateway (Vol. 2, No. 1, Jan–Jun 2026)

Apr 19
1 Comment
Kanika sharma is now friends with Ramesh Kumar and Deepak Sharma
Apr 19
Oriental Library Association shared their discussion on Facebook

Call For Paper for "Granthendriya"

Apr 16
Sumit Sundar Ray updated their profile
Apr 15
Alka Gohel posted a discussion

Free Plagiarism Remover

Apr 15
0 Comments
Anna Poorani posted a blog post

Research Data Coordinator

Apr 15
0 Comments
Manoj Kumar posted a blog post

YouTube channel

Apr 15
0 Comments

Importing Excel Data to Koha Software

I want to import Bibliographic data in MS Excel (.xsl) to Koha on Ubuntu platform. 

What should be the Date format for date fields (e.g., 952$d), so that MarcEdit will read it properly? (MarcEdit is reading only MM field properly and putting in .mrk file). Tried many date formats in Excel all of which did not work. 

Thanks in advance.

Regards

Views: 1283

▶ Reply to This

Replies to This Forum

Permalink Reply by PRAVEEN KUMAR DEWANGAN on October 28, 2020 at 23:40

Hello 

Mukhedkar M. V

Whatever Excel format you are using that Date format Cell is protected sheet .....first you go to Excel file....format the particular date cell>>>>>uncheck the Protectiom box>>>>>save.

after that you entry all books date and after all complete data dont forger to  protect the sheet thats it. 

MM/DD/YYYY or DD/MM/YYYY all format works nicely.

Permalink Reply by Mukhedkar M. V. on November 9, 2020 at 19:03

Thank you sir.

RSS

© 2026   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp