Hi Satish,
maybe this piece of SQL code could help you... Please adjust the
parameters @prefix and @offset. In the case you're satisfied with
results, use the formulas in your UPDATE command.
Regards,
Radek
select * FROM (
SELECT
@prefix:="4GH" as cardnumber,
@offset:=17
Dear Ramakant,
Yes, I did the same way for modification of a single cardnumber.
but how to do it for bulk? and also data is in excel.
with thanks
satish
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/
Dear Satish,
With the help of sql query you will resolve your problem.
Make your data in excel sheet then use below query for the same and resolve
your query in bulk
e.g. update borrowers set cardnumber = '4GH17ME18' where cardnumber =
'17ME01';
Regards,
==
Excellent, thank you Bob and Tomas. That did the trick.
Daniel
On 1/18/18 6:33 PM, Bob Birchall wrote:
Clear your browser cache. I think that's all you need to do. We saw
that problem or one very similar on upgrading from 16.11 to 17.05.
HTH,
Bob Birchall,
Calyx
On 18/01/18 19:18, Daniel Owen
I am also looking for a user friendly way to import records and have found
a few, but most are out-of-date or require detailed knowledge of MARC
formats.
I think I understand what you are suggesting about using a z39.50 server,
but are there example sites that provide more explanation or a working
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 eit
Hello Hugo,
Can you please do little elaborate it, how to go step by step.
-satish
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
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 :
> Hi Pedro,
>
> Thank you for the reply.
>
> I try to make my
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
Clear your browser cache. I think that's all you need to do. We saw that
problem or one very similar on upgrading from 16.11 to 17.05.
HTH,
Bob Birchall,
Calyx
On 18/01/18 19:18, Daniel Owens wrote:
Working with 17.11 (after upgrading from 3.22 or some other earlier
version, which version I can
Hello Satish,
I'm not sure I fully understand your situation but I'll try to provide help
based on what I could figure out:
*We use, students' register number as card number for circulation.
Andregarding bulk 'card number' modifications :*
Does this mean you use the patrons' borrowernumber as ca
Hey Vinod,
Could the ID for that hold (reserve) be already present in old_reserves?
If so, that error will occur when the item is actually checked out, I'm
afraid, because the ID from reserves gets moved to old_reserves.
The bug is documented here:
https://wiki.koha-community.org/wiki/DBMS_auto_i
Clean your browser's cache
El jue., 18 de ene. de 2018 5:19 a. m., Daniel Owens
escribió:
> Working with 17.11 (after upgrading from 3.22 or some other earlier
> version, which version I cannot recall), in several places windows pop
> up unexpectedly.
>
> 1. Our librarian noticed this when she w
Working with 17.11 (after upgrading from 3.22 or some other earlier
version, which version I cannot recall), in several places windows pop
up unexpectedly.
1. Our librarian noticed this when she went to check a book out for a
student. A window pops up called "Leave a message". The window canno
We hold one book for a user, after it was check in, we tried to issue that
particular
Software error:
DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '1' for key
'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 121
For help, please send mail to the webmaster ([no address given])
15 matches
Mail list logo
