Latest Activity

Kapil Gupta replied to Haskar Ali K.P's discussion How to make fine report in Koha Software
22 hours ago
Dr.Stephen.G posted blog posts
yesterday
Abhishek Kumar Dubey replied to Vikash Ranjan's discussion What is Farmington Plan ?
yesterday
Dr. Bebi updated their profile
Saturday
Dr.Stephen.G posted a blog post
Friday
Sanjeev Kalita and AKASH are now friends
Friday
Sanjeev Kalita joined Badan Barman's group
Friday
Sanjeev Kalita updated their profile
Friday
Jitu Mani Das posted a blog post
Friday
Dr.Santosh Salunkhe posted a status
"ok"
Friday
Prateek Bhardwaj and Priti sharma are now friends
Thursday
Jitu Mani Das and Dr. Sumeet Kumar are now friends
Thursday
A Raghuveer Kumar joined Mohammad Rehan Siddiqui's group
Thursday
Janu Komut might attend Badan Barman's event
Wednesday
Divya Bharti updated their profile
Wednesday
Ancy S Selin and Hari Kishan are now friends
Wednesday
Dr.Santosh Salunkhe and Vasudeo M Rao are now friends
Wednesday
HAIDER AYAZ updated their profile
Jun 9
K.venugopal updated their profile
Jun 9
Dr.Ramesh Rayapudi updated their profile
Jun 9

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

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

© 2021   Created by Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop