LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

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
5 hours ago
0 Comments
Dr. U. PRAMANATHAN posted blog posts
6 hours ago
Dr. Hema Thakur posted an 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
7 hours ago
0 Comments
RAMESH posted an event

One Day National Seminar on Emerging Technologies and Future Libraries at Venue: 1st Floor, Training Hall, Academic Block, NITHM Campus, Gachibowli, Hyderabad – 500032 www.nithm.ac.in

December 7, 2025 all day
9 hours ago
0 Comments
Profile IconKapil Kathuria and Ravikant tiwari joined LIS Links
9 hours ago
Tapas Mandal is now a member of LIS Links
Monday
Welcome Them!
Amar Rithe is now a member of LIS Links
Saturday
Welcome Them!
NAVEEN SATAPPANAVAR updated their profile
Saturday
Manjunatha N 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
Saturday
0 Comments
Manjunatha N updated their profile
Saturday
Dr. Bhakti Gala posted a discussion

Invitation to Participate in an International Survey and Win a Chance to a 2 Year Free ALA Membership

Friday
0 Comments
Profile IconRupam Tamuli and Manashi Devi joined LIS Links
Friday
Dr. Bhakti Gala and Geetanjali Tiwari are now friends
Nov 27
Profile IconPallavi Sushant Sapkal, Gorti kartik mahadev and shrddha thomare joined LIS Links
Nov 25
Profile IconShubham Verma, Ranjit Das, Adari P N Lalitha Devi and 1 more joined LIS Links
Nov 23
Surendra Singh is attending Dr. Ashis Biswas's event

ICAL 2026: International Conference on Asian Libraries on Evolving Information Landscape: Making Libraries Future-Ready at IIM, Kashipur, Uttarakhand

April 16, 2026 at 9am to April 18, 2026 at 5pm
Nov 21
0 Comments
Dr. Ashis Biswas posted an event

ICAL 2026: International Conference on Asian Libraries on Evolving Information Landscape: Making Libraries Future-Ready at IIM, Kashipur, Uttarakhand

April 16, 2026 at 9am to April 18, 2026 at 5pm
Nov 21
0 Comments
Profile IconAbhishek shriyal and AMAN SAHU joined LIS Links
Nov 21
Pssprakasarao updated their profile
Nov 21
Profile IconSwati Malvi, S.Francis Selvaraj and Siva M joined LIS Links
Nov 19

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: 1253

▶ 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