Re: [Koha] Problem in importing Patron Records

2012-06-09 Thread Robin Sheat
Please reply to the list. Op 08-06-12 05:59, Prajeesh schreef: Hi Robin I used the .csv file given by koha patron upload page and used the same header row. I am attaching sample .csv file that I have tried to upload. The file you attached isn't a "comma separated values" file, it's a "tab s

[Koha] Date format

2012-06-09 Thread SANDEEP BHAVSAR
Dear All Kindly help me in converting date format from DD-MM- to -MM-DD in Excel If possible give the solution step by step. I tried with "Text to Colums" options in Excel. -- Thanks and Regards Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 M

Re: [Koha] Date format

2012-06-09 Thread sunil sharma
Dear Sandeep, Do the following steps in Excel, If you open the excel sheet with open office, then: 1. Select whole column to which you want to apply the required date format. 2. Right click on any cell, and select Format cell, under Number tag option, Select Date format, in right pane select the

[Koha] Help with sql statement.

2012-06-09 Thread James Ghiorzi
Hello everyone, I am trying to get the new patron report developed by Sharon Moreland, to do a date range and have a location selection for San Benito County Free Library. I am sure I am doing something wrong, please advise as necessary, SQL: SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE

Re: [Koha] Help with sql statement.

2012-06-09 Thread Jared Camins-Esakov
James, I am trying to get the new patron report developed by Sharon Moreland, to > do a date range and have a location selection for San Benito County Free > Library. I am sure I am doing something wrong, please advise as necessary, > > SQL: > > SELECT b.code,c.code,COUNT(*) > FROM borrowers WHE

[Koha] How to bulk delete the patrons after expiry of membership

2012-06-09 Thread Vimal Kumar
Dear Friends, How to bulk delete patrons expired membership ? For example, when an academic year ends, we have to delete batch of students. How it possible? Regards -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalw

Re: [Koha] Date format

2012-06-09 Thread Vimal Kumar
Dear Sandeep, Another solution is change date format in Koha to -MM-DD. Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com -