[Koha] SQL help - Bulk Card Number modification

[Jens Weber (PHSH)]

Hello Satish

To me it seems the easiest way to proceed might be to use the "Import patrons" feature (in the 'Tools' section). This can also be used to *update* patron information -- and this can be single fields, including cardnumber. 

The only caveat here is that the records to update are either selected by cardnumber or by username (field "userid"). Because you want to change cardnumbers you will have to select by usernames -- and in case you haven't set these you will need to do so in a first step where you select by cardnumber.

Hope that is of help --
Best regards

Jens



_________________________________________
Jens Weber
Pädagogische Hochschule Schaffhausen
Didaktisches Zentrum
Ebnatstrasse 80
8200 Schaffhausen
www.phsh.ch 





> -----Ursprüngliche Nachricht-----
> Von: SATISH [mailto:lis4satish at gmail.com]
> Gesendet: Donnerstag, 18. Januar 2018 06:58
> An: Koha
> Betreff: [Koha] SQL help - Bulk Card Number modification
> 
> Hi,
> 
> With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with
> MySQL -  mysql Ver 14.14 Distrib 5.5.57
> 
> We use, students' register number as card number for circulation. And
> regarding bulk 'card number' modifications :
> 
> I have a situation, where, first semester borrowers will only get
> 'permanent register number' during the time of examinations.
> Till that, I should manage borrowers' circulation with 'temporary card
> number' (assigned by me). After receiving 'permanent register number from
> the college office, I have to replace 'temporary number' by 'permanent card
> number'.
> 
> Going editing/modifying each patron one by one is very tedious and time
> consuming, therefore, Is there any way I could use sql and some kind of
> script to replace card number? (at the terminal)
> 
> Your suggesstions or best practices would be very helpful.
> 
> Thank You.
> 
> Satish MV
> Librarian
> Govt. Engineering College, Hassan
> www.gechassan.ac.in
> 
> 
> --