LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

jai prakash kumar posted a status
"What are you up to?"
18 hours ago
Abhisekh Chetry joined Dr. Badan Barman's group
20 hours ago
Abhisekh Chetry joined Dr. Badan Barman's group
21 hours ago
Sidhartha Batsya joined Dr. Badan Barman's group
Monday
Sidhartha Batsya joined Dr. Badan Barman's group
Monday
Dr. U. PRAMANATHAN posted blog posts
Saturday
Dr. U. PRAMANATHAN posted an event

Gyanotsav-2025: National Conference on Re-imagining Libraries as Engines of Viksit Bharat at Gyan Mandir at the National Law Institute University, Bhopal.

August 29, 2025 at 9am to August 30, 2025 at 5pm
Friday
Dr. U. PRAMANATHAN posted discussions
Friday
komal patel posted an event
Thumbnail

National Conference on Re-Imagining Libraries of Viksit Bharat 29-30 AUGUST 2025 at Bhopal

August 29, 2025 at 10am to August 30, 2025 at 5pm
Friday
komal patel updated their profile
Jun 26
Dr. U. PRAMANATHAN posted blog posts
Jun 25
Dr. O Seshaiaih posted a discussion
Jun 25
Jatin Baweja and Deepak Sharma are now friends
Jun 25
Dr. U. PRAMANATHAN posted a blog post
Jun 23
Dr. U. PRAMANATHAN posted a discussion
Jun 23
Profile IconJasvir kaur, Dr. Nilanjana Purkayastha, Aakib and 2 more joined LIS Links
Jun 22
Dr. U. PRAMANATHAN posted a discussion
Jun 22
Hemanta Kumar Biswal posted a blog post
Jun 22
Dr. U. PRAMANATHAN posted blog posts
Jun 22
Ramesh Kumar left a comment for Saaswatee Sahoo
Jun 21

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

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