LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

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
Thursday
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
Dr. U. PRAMANATHAN posted a blog post

Online applications are invited for the Assistant Professor-Library Science (01) teaching post purely on contractual basis @ Jagat Guru Nanak Dev Punjab State Open University Patiala, Punjab.

Nov 18
0 Comments
Dr.Stephen.G was featured
Congratulate them!
Nov 18
Dr. U. PRAMANATHAN posted a discussion

Ph.D. research study on "Work-Life Balance and Organizational Commitment of Library Professionals in India."

Nov 18
0 Comments
Surendra Singh left a comment for Arnica Kumari
Nov 18
Profile IconAyushi kushwaha, Shyamghan Nayak, Raja Rajeshwari G and 1 more joined LIS Links
Nov 17

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