Latest Activity

Arunima Giri and Akshay Subhash Gadade are now friends
19 hours ago
Mahesh B. updated their profile
yesterday
Akshay Subhash Gadade joined Dr. Badan Barman's group
yesterday
Dr. U. PRAMANATHAN posted blog posts
Monday
K Chiyuh commented on Hema Thakur's event 'One Day National Seminar on the Future of Libraries in the Era of Artificial Intelligence'
Monday
K Chiyuh might attend Hema Thakur's event
Monday
Mr.Vipul Kumar updated their profile
Monday
Mr.Vipul Kumar shared a profile on Facebook
Monday
Profile IconUmasankar mahata, Nikita Medhi, Prohlad Basumatary and 81 more joined LIS Links
Monday
Dr. SUDHI S VIJAYAN posted a discussion
Monday
Kanika sharma is now friends with Ramesh Kumar and Deepak Sharma
Sunday
Oriental Library Association shared their discussion on Facebook
Friday
Sumit Sundar Ray updated their profile
Apr 15
Alka Gohel posted a discussion
Apr 15
Anna Poorani posted a blog post
Apr 15
Manoj Kumar posted a blog post
Apr 15
Mr. Ambaresh H posted a blog post
Apr 15
Anna Kaushik posted a discussion
Apr 15
Gopalji updated their profile
Apr 13
Anna Poorani updated their profile
Apr 12

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

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

© 2026   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp