LIS Links

First and Largest Academic Social Network of LIS Professionals in India

LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

Sebastine Robert updated their profile
Thursday
MAYUR JAIN left a comment for Dev prajapati
Wednesday
Kallol Das Talukdar and Dr. Badan Barman are now friends
Tuesday
Shivaganga salotagi updated their profile
Aug 30
Ankit Jaiswal updated their profile
Aug 26
S RAVI posted a status
""https://drive.google.com/file/d/1PyzFEhsaNBQfNs4bbuMwpwBO0vfDLGC_/view?usp=drive_link""
Aug 24
0 Comments
S RAVI posted a status
""Call for Chapter Contribution in Editorial Book "…"
Aug 24
0 Comments
M Vineesh Kumar joined Dr. Badan Barman's group
Thumbnail

Sample in Library and Information Science

Aug 15
1 Comment
Dr. REKHRAJ SAHU updated their profile
Aug 15
Manju Meerwal updated their profile
Aug 13
dibyajyoti patgiri and BITUPON DOLEY are now friends
Aug 11
preeti verma updated their profile
Aug 11
preeti verma is now friends with Mohit Garg and Pramod S. Kerkar
Aug 11
KAJAL KUMARI RAO shared a profile on Facebook
Thumbnail

Dk

Aug 10
MOHD ASHRAF updated their profile
Aug 10
Dr. Manash Esh updated their profile
Aug 8
Damodar Dashrath Waghmare updated their profile
Aug 8
KADARI NAVEEN KUMAR updated their profile
Aug 7
Dr. Rajesh Chutia updated their profile
Aug 5
Kapil Sunehria updated their profile
Aug 4

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

▶ 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

© 2025   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop