Re: [Koha] Problem in importing Patron Records
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 separated values file. You need to save it with the correct formatting. Robin. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Date format
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 MUMBAI. INDIA @@ email: sandeep.bhav...@gmail.com Mob : 9029 345777 elibrary :http://www.vpmthane.org/im/elib/main.htm @@ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Date format
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 desired format i.e. 1999-11-30, the Format Code is -MM-DD for that as you see under the same window, when you select that. 3. Apply or Click OK the whole column now set to ur required format. If you are using MS Office 2007 or 2010 then the steps are like below: 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, where Date format given, the last option is custom format. 3. Select Custom Format and in right pane under Type Text box, type your desired format i.e. -MM-DD, and select that from below as you add that format. 4. Apply or Click OK the whole column now set to ur required format. Hope your problem will solved now. BR// Sunil -- On Sat, Jun 9, 2012 at 5:30 PM, SANDEEP BHAVSAR sandeep.bhav...@gmail.comwrote: 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 MUMBAI. INDIA @@ email: sandeep.bhav...@gmail.com Mob : 9029 345777 elibrary :http://www.vpmthane.org/im/elib/main.htm @@ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Help with sql statement.
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 DATE(dateenrolled) between Date between (-mm-dd) AND DATE(dateenrolled)= and (-mm-dd) and b.code=Pick your branch|branches GROUP BY c.code Thank you for your patience and understanding, James Ghiorzi Data Management Coordinator Martin Luther King Jr. Library San Jose State University ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha