Re: [Koha] SQL report 650 a

2014-01-03 Thread Holger Meissner
yoonus para wrote: > Dear all, > > How to create a SQL report using field 650 a with barcode and title,Please > help me to create this report. > > Thanks > Yoonus Did you find a solution? I thought it might be interesting, but I also can't figure it out. When I run SELECT * FROM marc_subfield_s

Re: [Koha] How to print checked out items and news from the quick

2014-01-03 Thread magmatic
I just got it working the way I wanted it to work. I want to print Slips instead of Quick Slips when enter is pressed. This is how: Edit the file: /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/circ/circulation.tt On line 79 or so, replace printx_window('qslip'); with printx_win

[Koha] Status of item = Checked out ...and waiting?

2014-01-03 Thread Chad Roseburg
Wondering what scenario would result in the following: * Patron places hold on item * Item arrives at branch ...placed on holds shelf * Patron arrives at branch and checks out item Item status for the last week appears as follows in the staff interface: "Checked out to JOE D PATRON : due 01/04/2

Re: [Koha] SQL report 650 a

2014-01-03 Thread Bob Birchall
On 03/01/14 23:31, Holger Meissner wrote: yoonus para wrote: Dear all, How to create a SQL report using field 650 a with barcode and title,Please help me to create this report. Thanks Yoonus Did you find a solution? I thought it might be interesting, but I also can't figure it out. When I

Re: [Koha] Koha 3.8.21 released

2014-01-03 Thread Kyle Hall
Correction: I linked to the incorrect release notes! The correct release notes are here: http://koha-community.org/koha-3-8-21-released/ Kyle On Thu, Jan 2, 2014 at 1:54 PM, Kyle Hall wrote: > The Koha community is proud to announce the release of 3.8.21. > > This is a maintenance release and c

Re: [Koha] SQL report 650 a

2014-01-03 Thread nikunj1
We are using following sql report, change your barcode range and try SELECT items.barcode, biblio.author, CONCAT(biblio.title, ", ",IF( LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE(' LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.ma

[Koha] Add order to basket by uploading from an excel file in Acquisition.

2014-01-03 Thread Prajeesh
Anyone know any facility available in koha to upload excel file in "add order to basket " (Acquisition) . Now the following options are available. >From an existing record >From a suggestion >From a subscription >From a new (empty) record >From an external source >From a staged file We are using

[Koha] Report for Fine collection in date ranges

2014-01-03 Thread Prajeesh
Hi What is the problem with this Report for getting the fine collection in between date ranges. The result is showing minus amounts. Eg: -6, -5 etc. SELECT borrowers.cardnumber,borrowers.surname,accountlines.date,accountlines.amount FROM borrowers LEFT JOIN accountlines on (borrowers.borrowernumbe