Latest Activity

Alka Gohel posted a discussion
21 hours ago
Anna Poorani posted a blog post
21 hours ago
Manoj Kumar posted a blog post
21 hours ago
Mr. Ambaresh H posted a blog post
21 hours ago
Anna Kaushik posted a discussion
21 hours ago
Gopalji updated their profile
Tuesday
Anna Poorani updated their profile
Monday
Anna Poorani is now friends with Sivaprakasam, Dr.K.Murugan and Dr. Badan Barman
Monday
Oriental Library Association updated their profile
Apr 9
Chetan Hegde M updated their profile
Apr 9
AREPALLI MADHAVI joined Dr. Badan Barman's group
Apr 7
Dr.P.KRISHNAN updated their profile
Apr 7
Dhruven Ponkiya updated their profile
Mar 30
sangeeta sharma is attending Dr. Shamim Aktar Munshi's event
Mar 28
Kanika sharma and Ankit Jaiswal are now friends
Mar 27
Nagendra N updated their profile
Mar 25
Pallavi Sushant Sapkal and S. Jaffer Basha are now friends
Mar 22
Dr. Divyanshu Gupta updated their profile
Mar 20
Dr. Gulshan Kumar Sachdeva updated their profile
Mar 17
Dr. Gulshan Kumar Sachdeva and sandeep shukla are now friends
Mar 17

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

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