LIS Links
First and Largest Academic Social Network of LIS Professionals in India
LIS Links Becoming More Social
Birthdays
Birthdays Today
Latest Activity
International Conference on Libraries and Emerging Technologies for Smart Knowledge Ecosystems (ICLET 2025), at Jaipur,Rajasthan
November 14, 2025 at 9am to November 15, 2025 at 6pm
28th National Convention on Knowledge, Library and Information Networking (NACLIN 2025), December 3-5, 2025 at Hotel Lemon Tree Premier, City Center, Pune at Hotel Lemon Tree Premier, City Center, Pune
December 3, 2025 at 9pm to December 5, 2025 at 6pm
4th International Symposium on Knowledge Engineering for Digital Library Design (KEDLD-2025) at Indian Institute of Technology, Kharagpur
November 3, 2025 to November 5, 2025
"Required Library paid Intern @ 8000 PM for 6 Months for “Indexing Database”- in Delhi, 9818180051"
International Conference on Digital and Innovative Advancements for Sustainable Library Services at Bharati Vidyapeeth’s Institute of Computer Applications & Management (BVICAM), New Delhi
August 29, 2025 at 10am to August 31, 2025 at 5pm
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: 1218
Replies to This Forum
-
Permalink Reply by PRAVEEN KUMAR DEWANGAN on
-
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
-
Thank you sir.
© 2025 Created by Dr. Badan Barman.
Powered by
