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

Thu Jul 26 21:11:27 NZST 2012

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 at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
koha-request at lists.katipo.co.nz
Sent: 11 June 2012 05:30
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 80, Issue 16

Send Koha mailing list submissions to
	koha at 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 at lists.katipo.co.nz

You can reach the person managing the list at
	koha-owner at 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 at gmail.com>
To: Koha-List <koha at lists.katipo.co.nz>
Subject: [Koha] How to bulk delete the patrons after expiry of
	membership
Message-ID:
	<CAEaJrwUV7KeQfe0iuknLE=QsWFyYCKimck_EDmLCOFYmZEa+5w at 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 at gmail.com>
To: Koha-List <koha at lists.katipo.co.nz>,	sandeep bhavsar
	<sandeep.bhavsar at gmail.com>
Subject: Re: [Koha] Date format
Message-ID:
	<CAEaJrwUt4+CKh7-ocd0Z-E0ur9y_ppaTgMv9+n=2Cr_ZZgpdNg at 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 at gmail.com>
To: koha at lists.katipo.co.nz
Subject: [Koha]  Unable to update form
Message-ID:
	<CAACR0DH9MW7qukLVygJqMnNMJ-bjkcwNppFCwg9h0ykEsDXMhQ at 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 at gmx.de>
To: Koha-List <koha at lists.katipo.co.nz>
Subject: [Koha] German article on Koha
Message-ID: <4FD4BB68.4030403 at 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 at gmail.com>
To: koha at lists.katipo.co.nz
Subject: [Koha] Upgrading Koha 3.4 to Koha 3.8 ??
Message-ID: <1339344066745-5715857.post at 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 at yahoo.com>
To: koha at lists.katipo.co.nz, jp_powell <nice2odie at gmail.com>
Subject: Re: [Koha] Upgrading Koha 3.4 to Koha 3.8 ??
Message-ID:
	<1339344509.85103.YahooMailClassic at web161002.mail.bf1.yahoo.com>
Content-Type: text/plain; charset=iso-8859-1

Hello Jp,

--- On Sun, 6/10/12, jp_powell <nice2odie at 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 at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

End of Koha Digest, Vol 80, Issue 16
************************************