Latest Activity

Naurin Ashraf posted a discussion
4 hours ago
Bandana Dubey is now a member of LIS Links
4 hours ago
M K Vishwakarma commented on Dr.Stephen.G's blog post Recruitment For Senior Library and Information Officer post at Delhi Public Library, New Delhi
12 hours ago
Naurin Ashraf and Johrul Islam are now friends
12 hours ago
Profile IconShashank Bhandari, Ajit singh, Mansi and 4 more joined LIS Links
yesterday
Dr.Stephen.G posted blog posts
Saturday
Amit Verma posted a discussion
Saturday
Ms Dipika Das posted a discussion
Saturday
Chetan Hegde M posted a discussion
Saturday
Dr.Stephen.G and B.Balajiswaminathan are now friends
Saturday
Banani Das and Arundhati Chatterjee are now friends
Saturday
Siddhartha Shankar Ray is now friends with D RANJITH RAGHAPATHI, MANJUNATH, Shamba Dutta (Shambo) and 3
Saturday
Ms Dipika Das posted a status
"Requesting research paper for GRANTHAKUTI(Vol.-VII):a peer reviewed annual journal on LIS, 2021."
Friday
Dr.Stephen.G posted blog posts
Friday
Dr. Subhash Chandra posted a blog post
Friday
Dr.Stephen.G and Neeraj Mishra are now friends
Friday
Dr. Subhash Chandra is now friends with RAVIRANJAN KUMAR, ABHISHEK KUMAR GAUD and Dr.Rautmale Anand S
Friday
Vineet Jamwal replied to Priyanka's discussion Where LIS Professionals are Heading in Research
Friday
Chetan Hegde M and Rangaswamy are now friends
Friday
Pooja Chaudhary left a comment for Seema Tanwar
Thursday

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

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