LIS Links Becoming More Social

Birthdays

Birthdays Today

Latest Activity

Dr. S Pachauri posted a discussion

Call for Research Articles, Papers and Review Papers : Libra-Tech World

4 hours ago
0 Comments
Ayushi Soni posted a discussion

Awareness and Perception of Sustainable Development Goals (SDGs) & Green Libraries among Library Professionals in India

4 hours ago
0 Comments
Amit Suwal posted a discussion

ColonOS – An Initiative to Revive and Modernize Colon Classification

4 hours ago
0 Comments
Profile IconRahul Barman, Antoriksh Roy Choudhury, Dhaneshwar Paikra and 8 more joined LIS Links
4 hours ago
Dr. V. Senthur Velmurugan and Rinku are now friends
12 hours ago
Rinku commented on Dr. V. Senthur Velmurugan's event 'One-Day National Seminar on Artificial Intelligence and Academic Libraries: Issues and Opportunities in the 21st Century'
12 hours ago
Rinku is attending Dr. V. Senthur Velmurugan's event

One-Day National Seminar on Artificial Intelligence and Academic Libraries: Issues and Opportunities in the 21st Century at kongu arts and science college

October 28, 2026 from 9:30am to 4:30pm
12 hours ago
1 Comment
Rinku is attending Dr. Manoj Das's event
Thumbnail

Two-Day Online National Workshop on Library Automation Using Koha at Cooch Behar, West Bengal

October 2, 2026 at 11am to October 3, 2026 at 5pm
13 hours ago
0 Comments
Umasankar Mahata is attending Khadeeja Mohammed Nizam Ansari's event

Librarianship in the AI Era: A 5-Day Practical Skill Development Programme at Online

October 20, 2026 at 7pm to October 24, 2026 at 7pm
yesterday
0 Comments
Samidha Sandeep Yadav and Dr. U. PRAMANATHAN are now friends

Fellow
yesterday
Rinku posted a status
"What are The LIS Portal is a useful platform in the field of Library and Information Science. It helps students, researchers, and librarians"
yesterday
0 Comments
Rinku updated their profile
yesterday

Top Content 

1 One-Day National Seminar on Artificial Intelligence and Academic Libraries: Issues and Opportunities in the 21st Century

One-Day National Seminar on Artificial Intelligence and Academic Libraries: Issues and Opportunities in the 21st Century
2 Call for Papers for International Conference on Emerging Trends in Education - Online

Call for Papers for International Conference on Emerging Trends in Education - Online
3 Assistant Librarian & Information Officer - V.V Giri National Labour Institute

Assistant Librarian & Information Officer - V.V Giri National Labour Institute
4 ColonOS – An Initiative to Revive and Modernize Colon Classification

ColonOS – An Initiative to Revive and Modernize Colon Classification
5 From Library Automation to Digital Repositories: A 5-Day Hands-on Workshop on Koha & DSpace for LIS Professionals

From Library Automation to Digital Repositories: A 5-Day Hands-on Workshop on Koha & DSpace for LIS Professionals

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

▶ 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