Latest Activity

Dr. Ujjal Marjit posted a status
"How to Check the Reliability of References Using Reference Check https://bit.ly/39IF4sN"
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
yesterday
suman sumi posted a blog post
yesterday
Kimidi Siva Shankar posted a blog post
yesterday
Pompy Deka and Hari Kishan are now friends
yesterday
Dr.G.Stephen posted a blog post
yesterday
Nabi Hasan updated their profile
yesterday
Nabi Hasan and Ritu vashisht are now friends
yesterday
Profile IconPRADYUMN SONI, Lesliebadena and Vaisakhan vb joined LIS Links
yesterday
Kimidi Siva Shankar updated their profile
yesterday
suman sumi updated their profile
yesterday
Surendra Singh is attending Badan Barman's event
Wednesday
Jancy S is attending Preeti Sharda's event
Wednesday
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
Wednesday
Badan Barman posted a blog post
Wednesday

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

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

© 2020   Created by Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop