LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

Satabdi Bezbaruah updated their profile
yesterday
Prashant Kumar Ganta is now a member of LIS Links
Friday
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
Friday
0 Comments
UTTAM PRADHAN updated their profile
Thursday
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
Wednesday
0 Comments
Dr. U. PRAMANATHAN posted blog posts
Wednesday
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
Wednesday
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
Wednesday
0 Comments
Profile IconKapil Kathuria and Ravikant tiwari joined LIS Links
Wednesday
Tapas Mandal is now a member of LIS Links
Nov 30
Welcome Them!
Amar Rithe is now a member of LIS Links
Nov 29
Welcome Them!
NAVEEN SATAPPANAVAR updated their profile
Nov 29
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
Nov 28
0 Comments
Manjunatha N updated their profile
Nov 28
Dr. Bhakti Gala posted a discussion

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

Nov 27
0 Comments
Profile IconRupam Tamuli and Manashi Devi joined LIS Links
Nov 27
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

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

▶ 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