LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Sourav Debnath replied to Sourav Debnath's discussion Online National workshop from 16-20th June 2025 by IIT (ISM) Dhanbad
6 hours ago
Prakash Rabi Das updated their profile
yesterday
Dr. U. PRAMANATHAN replied to Dr. U. PRAMANATHAN's discussion INFLIBNET App & WhatsApp Service Launched: Unlock Academic Resources on the Go!
Friday
Alka Gohel replied to Dr. U. PRAMANATHAN's discussion INFLIBNET App & WhatsApp Service Launched: Unlock Academic Resources on the Go!
Friday
Dr. U. PRAMANATHAN replied to Dr. U. PRAMANATHAN's discussion INFLIBNET App & WhatsApp Service Launched: Unlock Academic Resources on the Go!
Friday
Alka Gohel replied to Dr. U. PRAMANATHAN's discussion INFLIBNET App & WhatsApp Service Launched: Unlock Academic Resources on the Go!
Friday
shradhashesh commented on Dr. U. PRAMANATHAN's blog post Notice for Phase-XIII/2025/Selection Posts — MTS (Library Attendant), Senior Library Attendant, Library Clerk, Library and Information Assistant, Assistant Library Information Officer, and Librarian
Thursday
Pramod Kumar Sharma posted a blog post
Thursday
Dr. U. PRAMANATHAN posted discussions
Wednesday
Dr. U. PRAMANATHAN posted blog posts
Wednesday
Dr. U. PRAMANATHAN posted events
Wednesday
Dr. U. PRAMANATHAN posted a blog post
Jun 2
Dr. U. PRAMANATHAN posted an event
Jun 1
Sumit Chakraborty posted a discussion
Jun 1
Archanagita Saikia is attending Md Nasm Akhtar's event

Online workshop on KOHA at Online

June 1, 2025 from 10am to 1pm
May 31
Md Nasm Akhtar shared their event on Facebook
May 30
Sumit Chakraborty updated their profile
May 30
Sumit Chakraborty might attend Sourav Debnath's event
Thumbnail

Online National workshop on Library Management using Open Source Software at Dhanbad

June 16, 2025 at 10am to June 20, 2025 at 5pm
May 30
Dr. U. PRAMANATHAN posted blog posts
May 29
Dr. U. PRAMANATHAN posted discussions
May 29

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

Reply to This

Replies to This Forum

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.

Thank you sir.

RSS

© 2025   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop