Latest Activity

Kriti Chaudhary is attending Gurmeet Singh's event
19 hours ago
Kriti Chaudhary updated their profile
19 hours ago
Swati is attending Ram Singh Bairwa's event

Conference on Knowledge Organisation in Academic Library (I-KOAL 2023) at Centre for Development of Advanced Computing (CDAC)Raintree Marg, near Bharati Vidyapeeth, Sector 7, CBD Belapur, Navi Mumbai, Maharashtra 400614

January 20, 2023 to January 21, 2023
Rohidas Bhimrao Rathod posted a status
"Develop Reading Habits and Skills in Children"

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.


Views: 1068

Reply to This

Replies to This Forum


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.


© 2023   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop