[Koha] sql statement to show fine payment, the patron and the staff that paid with the amount

Hello All,Pls i need a sql query that will list out from the fines paid during a period, the patrons that pay and the staff that paid the fine on koha. thanks ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz

Re: [Koha] FW: Biblioitems table

The records I bulk imported had this 942: =942 \\$2lcc$cEBK So, if biblioitems.cn_sort was going to be generated by Koha the way items.cnsort is generated it should be populated? Guess I’ll be doing item records, after all. Thanks! From: Joy Nelson [mailto:j...@bywatersolutions.com] Sent:

[Koha] Koha MARC modification template and field 008 position 07-10

Good day to all! I am trying out batch record modification in 3.22 which uses MARC modification template. I see that in the action interface of the tool, we can copy fields to another field as based from the Koha 3.22 manual. I see two text boxes after the 'to field' just before 'Regex' checkbox.

Re: [Koha] FW: Biblioitems table

It worked! I added the $hCALL NUMBER to my 942 tag in MarcEdit and when it updated, biblioitems.cn_sort was populated. Thanks for your help. Also, thanks Cecil and Thomas for your interest and willingness to help. Lezlie From: Joy Nelson [mailto:j...@bywatersolutions.com] Sent: Thursday,

Re: [Koha] FW: Biblioitems table

2016-02-11 15:48 GMT-03:00 Hillyard, Cecil : > What is the matching rules search index for the 999? > Local-Number ? -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F ___ Koha mailing

Re: [Koha] FW: Biblioitems table

Lezlie- You could try exporting the marc records from Koha and then moving the 050 data to the 942 callnumber field (h and m?) using your favorite marc editor. Then reimport the records matching and overlaying on the biblionumber 999c. The cn_sort in items is autogenerated by the value in

Re: [Koha] FW: Biblioitems table

Glad to hear that! joy On Thu, Feb 11, 2016 at 2:28 PM, Shell, Lezlie < lezlie.sh...@contractor.cengage.com> wrote: > It worked! > > > > I added the $hCALL NUMBER to my 942 tag in MarcEdit and when it updated, > biblioitems.cn_sort was populated. > > > > Thanks for your help. > > > > Also,

Re: [Koha] FW: Biblioitems table

What is the matching rules search index for the 999? __ Cecil Hillyard Washoe County Library Technical Services 775-327-8338 -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Joy Nelson Sent: Thursday, February 11, 2016 7:46 AM To: Shell,