Latest Activity

Badan Barman posted blog posts
14 hours ago
Profile IconILLYAS K P, shashi and swamy joined LIS Links
15 hours ago
Raj Tilak commented on Raj Tilak's event 'International Conference on Emerging Digital Library Platforms: Shaping Digital Transformation and National Data Exchange'
23 hours ago
Prakash Das replied to Ravi Patel's discussion Question for CBSE School
yesterday
amit sachan updated their profile
yesterday
janani muthusamy updated their profile
yesterday
preeti verma and ashish jain are now friends
yesterday
Badan Barman posted blog posts
yesterday
Profile Iconshilpa kute, Fathima Hiba NK, yasir and 3 more joined LIS Links
yesterday
Ravi Patel posted a discussion
Thursday
Dr. Subhash Chandra posted a blog post
Thursday
soni kumari posted a status
"any one have GOI circular related to library budget to spend how much amount on what heads of library items"
Thursday
Neha Patel and Hari Kishan are now friends
Thursday
Dr.S.Kannan and Shiva Shankari K are now friends
Thursday
sunil kumar updated their profile
Thursday
Profile IconAyesha Mughal, Babi and Dr Namita pareek joined LIS Links
Wednesday
Anil Singh updated their profile
Wednesday
MANI BHUSAN ROY replied to RAMESH KUMAR SHARMA's discussion AEES PREVIOUS YEAR QUESTION PAPER !!!!
Wednesday
MANI BHUSAN ROY replied to RAMESH KUMAR SHARMA's discussion AEES PREVIOUS YEAR QUESTION PAPER !!!!
Wednesday
Mumtaj begum H is attending Raj Tilak's event
Wednesday

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

Reply to This

Replies to This Forum

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.

Thank you sir.

RSS

© 2022   Created by Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop