LIS Links

First and Largest Academic Social Network of LIS Professionals in India

LIS Links Becoming More Social

LIS Links whatsApp

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

Priyatama Sharma updated their profile
6 hours ago
Rituraj Borkakoti updated their profile
16 hours ago
Rainika sharma is now friends with Mr. S Kumar UGC-NET and prasidh kumar mishra
yesterday
Joydip Barman shared a profile on Facebook
Thumbnail

Joydip Barman

yesterday
Prangyasini Nayak is attending SHEIK MAIDEEN's event

Webinar on DELNET: Resources and Services at Online

September 9, 2026 from 3pm to 4pm
Saturday
0 Comments
Profile IconManoj K L, Kailash Belel, Deepa M H and 1 more joined LIS Links
Friday
Sourav Barman left a comment for NISHA
Thursday
Priyanka Roy and Sourav Barman are now friends
Thursday
AKSHAY KUMAR updated their profile
Thursday
Profile IconRASALA SUDHAKAR, Priyanka Roy and Sourav Barman joined LIS Links
Thursday
Kapil Sunehria updated an event

UGC-MMTTP Online Two Week Refresher Course in Library and Information Science at RAMANUJAN COLLEGE, UNIVERSITY OF DELHI

August 31, 2026 at 10:30am to September 14, 2026 at 5:30pm
Wednesday
0 Comments
Sourav Barman updated their profile
Wednesday
sangita mazumdar updated their profile
Wednesday
Profile IconLIS Links now has job
Wednesday
Murtuza Akhtar updated their profile
Tuesday
Dr Chanchal Chaudhary is now a member of LIS Links
Tuesday
Welcome Them!
chinnadurai.D and Dr MANIKANDAN T are now friends
Aug 24
Profile IconPriyanka Beniwal, Khushi Jain, Meghna S and 10 more joined LIS Links
Aug 23
Dr. A. Madhava Rao posted a blog post

Desktop Publishing (DTP) Executive

Aug 23
0 Comments
Gopal Pandey posted an event
Thumbnail

National Conference on "Bharatiya Knowledge System: Bridging Traditional Wisdom and Modern Challenges for Viksit Bharat at Jhunsi,

October 10, 2026 all day
Aug 23
0 Comments

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

▶ Reply to This

Replies to This Forum

Permalink Reply by PRAVEEN KUMAR DEWANGAN on October 28, 2020 at 23:40

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 9, 2020 at 19:03

Thank you sir.

RSS

© 2026   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp