LIS Links Becoming More Social

Latest Activity

Naurin Ashraf posted a discussion

Data Needed on Indian National Bibliography (INB)

4 hours ago
0 Comments
Bandana Dubey is now a member of LIS Links
4 hours ago
Welcome Them!
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

Call for Papers for the Edited Book Entitled “LIBRARIES AND OPEN SCIENCE: ISSUES, CHALLENGES AND OPPORTUNITIES"

Saturday
0 Comments
Ms Dipika Das posted a discussion

Call for research paper for the research journal "GRANTHAKUTI: a peer-reviewed annual journal on LIS". ISSN:2349-7386.

Saturday
0 Comments
Chetan Hegde M posted a discussion

Bibliography of Literature published in English Language - how to get access

Saturday
0 Comments
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
0 Comments
Dr.Stephen.G posted blog posts
1 more…
Friday
Dr. Subhash Chandra posted a blog post

Recruitment for Deputy Librarian and Assistant Librarian Post at Jamia Hamdard, New Delhi

Friday
0 Comments
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

Importing Excel Data to Koha Software

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

Permalink Reply by PRAVEEN KUMAR DEWANGAN on October 29, 2020 at 16:10

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.

Permalink Reply by Mukhedkar M. V. on November 10, 2020 at 11:33

Thank you sir.

RSS

© 2021   Created by Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop