Latest Activity

Dr. Ujjal Marjit posted a status
"How to Check the Reliability of References Using Reference Check"
1 hour ago
SMN DB and Badan Barman are now friends
2 hours ago
Swati yadav and Priyanka are now friends
13 hours ago
nagesh kumar pandey replied to Avinash Sharma's discussion Download PGDLAN Project Guide (Booklet) of IGNOU
20 hours ago
DAYAL SINGH BHATI and Mahima Sharma are now friends
22 hours ago
DAYAL SINGH BHATI is attending Badan Barman's event
22 hours ago
RAVIRANJAN KUMAR updated their profile
suman sumi posted a blog post
Kimidi Siva Shankar posted a blog post
Pompy Deka and Hari Kishan are now friends
Dr.G.Stephen posted a blog post
Nabi Hasan updated their profile
Nabi Hasan and Ritu vashisht are now friends
Profile IconPRADYUMN SONI, Lesliebadena and Vaisakhan vb joined LIS Links
Kimidi Siva Shankar updated their profile
suman sumi updated their profile
Surendra Singh is attending Badan Barman's event
Jancy S is attending Preeti Sharda's event
Linsha M posted an event

International Webinar on Building Smart Cities: Role of Libraries at DLIS,Kannur University

December 5, 2020 from 7pm to 8pm
Badan Barman posted a blog post

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.


Views: 321

Reply to This

Replies to This Forum


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.


© 2020   Created by Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop