LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

Mr REYAZ AHMAD KHAN updated their profile
58 minutes ago
Krishna Pal replied to Manmeet Kaur's discussion Need Help Regarding BLIS Assignment: Classification According to CC 6th Edition
4 hours ago
Pushpanjali Shriram Patil posted a discussion

Call for Book Chapters – Volume 6 (2026) Emerging Perspectives in Library and Information Science: Digital Libraries and Knowledge Management

5 hours ago
0 Comments
RAMESH posted an event
Thumbnail

Two Day National Seminar on Empowering Research Excellence: AI Tools for Academic Writing and Publishing at Mulugu

February 10, 2026 at 9pm to February 11, 2026 at 5pm
5 hours ago
0 Comments
Profile IconMr REYAZ AHMAD KHAN, SATYAM KUMAR TRIPATHI and Krishna Pal joined LIS Links
5 hours ago
Narendra Bhattacharya commented on Parthasarathivamanan.K's event 'International Conference on Transforming Libraries: Innovation, Management, Smart Technologies and Creative Knowledge of Society for the Future'
6 hours ago
Narendra Bhattacharya is attending Parthasarathivamanan.K's event

International Conference on Transforming Libraries: Innovation, Management, Smart Technologies and Creative Knowledge of Society for the Future at Hybrid Mode (Offline and Online)

December 12, 2025 at 9am to December 13, 2025 at 6pm
6 hours ago
1 Comment
Namita Bayan might attend Parthasarathivamanan.K's event

International Conference on Transforming Libraries: Innovation, Management, Smart Technologies and Creative Knowledge of Society for the Future at Hybrid Mode (Offline and Online)

December 12, 2025 at 9am to December 13, 2025 at 6pm
10 hours ago
1 Comment
Pushpanjali Shriram Patil and sandeep shukla are now friends
yesterday
Dr. O Seshaiaih posted a discussion

Koha 25.11.00

yesterday
0 Comments
Profile IconYogesh Modi, Dr. Vivek K. Jagtap and Rajesh Das joined LIS Links
yesterday
Dr. Hema Thakur and SANJEET SEHRAWAT are now friends
Tuesday
SANJEET SEHRAWAT might attend Dr. Hema Thakur's event

Two-Days National Conference on Research Libraries: A Source to Adapt to Digital Form Using the Indian Knowledge Systems (IKS) in Promoting Social Science Research (NIKS-DR 2026) at Himachal Pradesh - Baddi , Soalan

February 27, 2026 to February 28, 2026
Tuesday
0 Comments
SANJEET SEHRAWAT updated their profile
Monday
Shruthi C C is now a member of LIS Links
Monday
Welcome Them!
Satabdi Bezbaruah updated their profile
Saturday
Prashant Kumar Ganta is now a member of LIS Links
Dec 4
Welcome Them!
Shubhangi M Vedak posted an event
Thumbnail

17th Annual One Week Training Programme for Library Support Staff at Ramniranjan Jhunjhunwala College, Ghatkopar, Mumbai

December 26, 2025 to December 31, 2025
Dec 4
0 Comments
UTTAM PRADHAN updated their profile
Dec 3
Sandip Gaikwad posted an event

Two Days National Conference on Role of Libraries and Institutions in Research and Publication Ethics at Nanded, Maharashtra

December 19, 2025 to December 20, 2025
Dec 3
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: 1256

▶ 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

© 2025   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp