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@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@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@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.