[Koha] SQL help - Bulk Card Number modification

[Hugo Agud]

Hi

the easiest way is to create a temporary table in Koha where you store the
old and the new cardnumber and with a sql statement update the
borrowers.cardnumber with the new value

Kindest Regards

2018-01-18 12:57 GMT+01:00 SATISH <lis4satish at gmail.com>:

> Hi Pedro,
>
> Thank you for the reply.
>
> I try to make my question little clear now,
>
> I am not referring to 'borrowernumber' (assigned by Koha) instead referring
> to 'cardumber'
>
> Temporary cardnumber does not prefix with TMP ( now, I understand it's
> importance)
>
> Current patron "cardnumber "  designed by the library,  is in following
> format: 17ME01, 17ME02, so on (upto 250+)
> 17= 2017, ME =Mechanical Engineering, 01,02 = Serial Number of the student
> as per the List provided by the College Office.
>
> Because, every year, to the 'first semester' admission, it takes few months
> to get the register number assigned by the University.
> Till that, I need to manage with some 'cardnumber' to take care of
> circulation.
>
> I use, University Registration Number as 'cardnumber' in Koha as it is
> easily  trace-able across the various sections/departments when no-dues
> verification needed by each department. If I use my own format, it may
> conflict.
>
> New number assigned by the University is: 4GH17ME18, 4GH17ME19, so
> on....and it is referred as permanent for the patron for future use
> and Library should use this number.
>
> So, my current requirement is:
>
> "cardnumber" = 17ME01, 17ME02, ....to be changed as =  4GH17ME18, 4GH17ME19
> in bulk.
>
> And I request, any scripts or sql to modify in bulk, would be useful.
>
> Thank you
>
> Satish MV
> Librarian
> Govt. Engineering College, Hassan.
> Karnataka.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 

*Hugo Agud - Orex Digital *

*www.orex.es <http://www.orex.es>*


<http://www.orex.es/>    [image: www.orex.es/koha] <http://www.orex.es/koha>
   [image: www.orex.es/vufind] <http://www.orex.es/vufind>


Directo

Calle Sant Joaquin,117, 2º-3ª · 08922 Santa Coloma de Gramanet - Tel: 933
856 138   hagud at orex.es · http://www.orex.es/



No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
implica la tala de 15 árboles y el consumo de 250.000 litros de agua.



Aviso de confidencialidad
Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
está autorizado a recibirlo por el remitente), no está autorizado a copiar,
reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.