LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

vasudev tiwari updated their profile
7 hours ago
Monali Mitra Paladhi updated their profile
10 hours ago
Dr. Mahendra Patel updated their profile
12 hours ago
Rahul chetri updated their profile
14 hours ago
Dr.Stephen.G is now friends with CHANDRASEKAR M and Mahadev Ghosh
17 hours ago
Dr.Stephen.G posted a discussion

Call for Papers - Bridging Knowledge, Technology, and Society through Libraries

17 hours ago
0 Comments
Vinay Kumar updated their profile
18 hours ago
MANGESH RAMRAO BHITRE updated their profile
20 hours ago
AYYAPPAN .Z updated their profile
yesterday
Sachin K updated their profile
yesterday
Chanlang ki Bareh updated their profile
yesterday
Punjab singh and Dr. Badan Barman are now friends
yesterday
sri maya sugasini updated their profile
yesterday
ALTAF ALI updated their profile
yesterday
Chetna Khera updated their profile
yesterday
Chetna Khera might attend Sunita Pareek's event
Thumbnail

*International Conference on Transformative Libraries and the Digital Future – ICTLDF 2026* at ONLINE

August 20, 2026 at 10pm to August 21, 2026 at 7pm
yesterday
0 Comments
Dr Sudhir Kumar Jena updated their profile
yesterday
ANJAN KUMAR VERMA updated their profile
yesterday
Ishan Jaydev Varma updated their profile
yesterday
Ishan Jaydev Varma and priyanka vyas are now friends
yesterday

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

▶ 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

© 2026   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp