[Koha] Finding patron's previous card number?

[BRANNON, CHRISTOPHER]

Actually this is a very common problem.  We run into the same issue here, and unless we record the change in patron notes, we have no way to know the old number unless the patron recalls it.

It would be great if the logs recorded these types of changes.

___________________________
Christopher Brannon
IT Coordinator

 
702 E Front Ave
Coeur d'Alene, ID 83814
(208)769-2315 Ext. 456
cbrannon at cdalibrary.org
www.cdalibrary.org
Keep tabs on us at: 
 


-----Original Message-----
Date: Thu, 16 Jun 2016 14:21:13 -0400
From: Barton Chittenden <barton at bywatersolutions.com>
To: Elisa Chandler <echandler at thebluemountains.ca>
Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Finding patron's previous card number?
Message-ID:
	<CAMSJbVsQ=1KgRhUW3VC7nFH+vb9BE+v45yFFJ9Q0bKJPz_js6Q at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

Elisa,

Are the old cardnumbers on an account that you're deleting, or are they simply changed on the borrower's current account?

If they are on a deleted account, you should be able to run a report on the deletedborrowers table. If they're on the current account, there's not much you can do.

--Barton

On Thu, Jun 16, 2016 at 10:36 AM, Elisa Chandler < echandler at thebluemountains.ca> wrote:

> When we issue a replacement card the patron gets a new library card 
> number. Sometimes we realize a day or two later that we have to merge 
> their old and new card numbers in Overdrive, the e-book system. Does 
> anyone know if there is way to retrieve a patron's previous card number?
>
> Thanks!
>
> Elisa Chandler
> Manager of Technical and Virtual Services
>
> The Blue Mountains Public Library
> Leonard E. Shore Memorial Library
> echandler at thebluemountains.ca<mailto:ebarker at thebluemountains.ca>
> Ph. 519-599-3681  Fax 519-599-7951
> www.thebluemountainslibrary.ca<http://www.thebluemountainslibrary.ca/>