LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Dr. Manash Esh updated their profile
4 hours ago
Damodar Dashrath Waghmare updated their profile
6 hours ago
KADARI NAVEEN KUMAR updated their profile
Thursday
Dr. Rajesh Chutia updated their profile
Tuesday
Kapil Sunehria updated their profile
Monday
Kapil Sunehria and Millan Krushna Dutta are now friends
Monday
Dr. N. Kadiresan left a comment for Dr. Badan Barman
Aug 3
Chavda Jitendra Kumar Ambalal updated their profile
Aug 1
Chavda Jitendra Kumar Ambalal joined Dr. Badan Barman's group
Aug 1
Chavda Jitendra Kumar Ambalal joined Dr. Badan Barman's group
Aug 1
Jeffrey Epstein commented on Jeffrey Epstein's album
Aug 1
Jeffrey Epstein commented on Jeffrey Epstein's album
Aug 1
S RAVI posted a status
""Call for Chapter Contribution in Editorial Book…"
Jul 31
S RAVI posted a status
Jul 31
S RAVI posted a status
"Call for Chapter Contribution in Editorial Book "Introduction to Metrics Studies" https://drive.google.com/drive/home"
Jul 31
Jeffrey Epstein commented on Jeffrey Epstein's album
Jul 31
LAITHANGBAM NEPOLEAN SINGH is attending Dr. U. PRAMANATHAN's event
Jul 30
SHWETHA KV updated their profile
Jul 29
Dr. Tarvinder Singh Handa updated their profile
Jul 29
RP Raaj updated their profile
Jul 29

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

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

© 2025   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop