Dear Mr. Vimal, The best way to delete these records is by building a SQL Query where u select particular category and check the expiry date and then bulk delete. Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@lists.katipo.co.nz Sent: 11 June 2012 05:30 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 80, Issue 16 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. How to bulk delete the patrons after expiry of membership (Vimal Kumar) 2. Re: Date format (Vimal Kumar) 3. Unable to update form (Stew Wilson) 4. German article on Koha (Mirko) 5. Upgrading Koha 3.4 to Koha 3.8 ?? (jp_powell) 6. Re: Upgrading Koha 3.4 to Koha 3.8 ?? (Olugbenga Adara) ---------------------------------------------------------------------- Message: 1 Date: Sun, 10 Jun 2012 11:48:06 +0530 From: Vimal Kumar <vimal0212@gmail.com> To: Koha-List <koha@lists.katipo.co.nz> Subject: [Koha] How to bulk delete the patrons after expiry of membership Message-ID: <CAEaJrwUV7KeQfe0iuknLE=QsWFyYCKimck_EDmLCOFYmZEa+5w@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 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://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White ------------------------------ Message: 2 Date: Sun, 10 Jun 2012 11:56:13 +0530 From: Vimal Kumar <vimal0212@gmail.com> To: Koha-List <koha@lists.katipo.co.nz>, sandeep bhavsar <sandeep.bhavsar@gmail.com> Subject: Re: [Koha] Date format Message-ID: <CAEaJrwUt4+CKh7-ocd0Z-E0ur9y_ppaTgMv9+n=2Cr_ZZgpdNg@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Dear Sandeep, Another solution is change date format in Koha to YYYY-MM-DD. Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White ------------------------------ Message: 3 Date: Sun, 10 Jun 2012 19:03:33 +0800 From: Stew Wilson <stewartrwilson@gmail.com> To: koha@lists.katipo.co.nz Subject: [Koha] Unable to update form Message-ID: <CAACR0DH9MW7qukLVygJqMnNMJ-bjkcwNppFCwg9h0ykEsDXMhQ@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi everyone, I am very new to Koha - and this seems like a question which is often asked, but I have not yet found a comprehensible response! I tried editing my own MARC framework. This worked well, until I accidentally deleted a tag that I wanted to keep. So, I added it as a new tag, and copy-pasted the information from the existing tag in the default framework. This added fine and looks no different from the information in the default framework. However, when I now try to input information into that tag as I'm adding a new record, I am unable to enter anything in the box. The cursor is there, but nothing is entered in the field. I have a feeling that this something to do with authorities - but I wouldn't know where to start! Is someone able to point me in the right direction? Thanks, Stew ------------------------------ Message: 4 Date: Sun, 10 Jun 2012 17:21:12 +0200 From: Mirko <5p4m@gmx.de> To: Koha-List <koha@lists.katipo.co.nz> Subject: [Koha] German article on Koha Message-ID: <4FD4BB68.4030403@gmx.de> Content-Type: text/plain; charset=ISO-8859-15 It may or may not be of interest that the newsletter of "Arbeitskreis der Sprachenzentren" (June 2012) contains an article on Koha. It is written in German and can be found here: http://www.aks-web.de/newsletter/ - Mirko ------------------------------ Message: 5 Date: Sun, 10 Jun 2012 09:01:06 -0700 (PDT) From: jp_powell <nice2odie@gmail.com> To: koha@lists.katipo.co.nz Subject: [Koha] Upgrading Koha 3.4 to Koha 3.8 ?? Message-ID: <1339344066745-5715857.post@n5.nabble.com> Content-Type: text/plain; charset=us-ascii What is the best and easiest way to upgrade Koha 3.4 to Koha 3.8 running on Debian Squeeze? The key here is NOT to lose the data in the database tables. I am hoping that there are MySQL scripts to move data around if there are table differences between the 3.4 and 3.8. Thank you. jp -- View this message in context: http://koha.1045719.n5.nabble.com/Upgrading-Koha-3-4-to-Koha-3-8-tp5715857.h tml Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 6 Date: Sun, 10 Jun 2012 09:08:29 -0700 (PDT) From: Olugbenga Adara <gbengaadara@yahoo.com> To: koha@lists.katipo.co.nz, jp_powell <nice2odie@gmail.com> Subject: Re: [Koha] Upgrading Koha 3.4 to Koha 3.8 ?? Message-ID: <1339344509.85103.YahooMailClassic@web161002.mail.bf1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Hello Jp, --- On Sun, 6/10/12, jp_powell <nice2odie@gmail.com> wrote:
What is the best and easiest way to upgrade Koha 3.4 to Koha 3.8 running on Debian Squeeze?
The key here is NOT to lose the data in the database tables.? I am hoping that there are MySQL scripts to move data around if there are table differences between the 3.4 and 3.8. /listinfo/koha
I am not sure whether this will work for 3.8 since i have not tested it. But what i do for 3.4 (or 3.2 though that involves running another script after upgrade) to 3.6 is to install 3.6 normally. then delete the 3.6 database and repalce with a dump from 3.4. On a login to the staff client, koha automatically senses the older database and upgrades to 3.6. Hope that helps. Olugbenga Adara ------------------------------ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 80, Issue 16 ************************************