Latest Activity

Erick Goodman updated their profile
2 hours ago
RAMESH posted an event

Webinar on NDLI E-Resources at Online

December 2, 2020 from 2:30pm to 4pm
3 hours ago
BASANT KUMAR posted a blog post
3 hours ago
Profile IconPRADIP DAJIBA JADHAV, Vishal mishra, Ritu vashisht and 2 more joined LIS Links
3 hours ago
Heman Kidd updated their profile
7 hours ago
Dr.G.Stephen posted blog posts
10 hours ago
RAVIRANJAN KUMAR posted blog posts
11 hours ago
Aditya Kumar posted a status
"Is DIT- Diploma in Information Technology equivalent to Certificate in Computer Application?"
yesterday
Dr.Ramesh Rayapudi updated their profile
yesterday
Nabi Hasan replied to Nabi Hasan's discussion Free Enrollment Open Now for – Emerging Trends & Technologies in Library & Information Services (ETTLIS-ARPIT) for the Session 2020-21
yesterday
KODANDARAMAIAH KANGUNDI replied to Nabi Hasan's discussion Free Enrollment Open Now for – Emerging Trends & Technologies in Library & Information Services (ETTLIS-ARPIT) for the Session 2020-21
yesterday
ABINASH updated their profile
yesterday
Nabi Hasan replied to Nabi Hasan's discussion Free Enrollment Open Now for – Emerging Trends & Technologies in Library & Information Services (ETTLIS-ARPIT) for the Session 2020-21
yesterday
Nabi Hasan replied to Nabi Hasan's discussion Free Enrollment Open Now for – Emerging Trends & Technologies in Library & Information Services (ETTLIS-ARPIT) for the Session 2020-21
yesterday
Nabi Hasan replied to Nabi Hasan's discussion Free Enrollment Open Now for – Emerging Trends & Technologies in Library & Information Services (ETTLIS-ARPIT) for the Session 2020-21
yesterday
Nabi Hasan replied to Nabi Hasan's discussion Free Enrollment Open Now for – Emerging Trends & Technologies in Library & Information Services (ETTLIS-ARPIT) for the Session 2020-21
yesterday
v.srinivasa rao replied to Nabi Hasan's discussion Free Enrollment Open Now for – Emerging Trends & Technologies in Library & Information Services (ETTLIS-ARPIT) for the Session 2020-21
yesterday
Badan Barman and Muskan kesharwani are now friends
Wednesday
Nabi Hasan replied to Nabi Hasan's discussion Free Enrollment Open Now for – Emerging Trends & Technologies in Library & Information Services (ETTLIS-ARPIT) for the Session 2020-21
Wednesday
MD JAWED IQBAL replied to Nabi Hasan's discussion Free Enrollment Open Now for – Emerging Trends & Technologies in Library & Information Services (ETTLIS-ARPIT) for the Session 2020-21
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: 301

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