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 <[email protected]>: > 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 > [email protected] > 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 [email protected] · 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. _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
