Re: [Koha] Barcode Scanners

Hi Wascally, Just about any standard scanner should work with Koha. I have had good success with Zebex usb scanners. Generally the scanner just works 'out of the box' as long as it can read the format of your barcodes you are using. The same scanner can be used for circulation and inventory

Re: [Koha] Koha Digest, Vol 150, Issue 35

Thank you Katrin, I'll do that. In the mean time, someone wrote to me suggesting I put all of the receipt information inside of the tags when modifying the html of ISSUEQSLIP, this turned out as a separate receipt for each item that would normally appear grouped in the checkout section on the

Re: [Koha] Items held by more than one branch

Cab - This is a little (ok..a lot) quick and dirty, but does return results... does this help? SELECT i.biblionumber,b.title, homebranch,itemcallnumber,barcode,itype,location,ccode,itemlost,withdrawn FROM items i LEFT JOIN biblio b USING (biblionumber) where biblionumber in (select biblionumber

Re: [Koha] Items held by more than one branch

Sorry, no dice -- returns a single item :-( The mysteries of SQL ... Cheers, Cab On Mon, Apr 23, 2018 at 5:06 PM, Paul Hoffman wrote: > On Mon, Apr 23, 2018 at 09:19:10AM -0400, Cab Vinton wrote: >> Trying to write a report that will provide details for items held by >> more

[Koha] Barcode Scanners

Is there a generally recommended bar code scanner to use for check-in/check-out? Would that same scanner work for doing inventory? The scanner section of the documentation seems a bit sparse in describing how to configure the scanner to work, perhaps I'm looking in the wrong place? And finally,

Re: [Koha] Items held by more than one branch

On Mon, Apr 23, 2018 at 09:19:10AM -0400, Cab Vinton wrote: > Trying to write a report that will provide details for items held by > more than one branch, with separate output for each library's item. Put the HAVING clause inside a subquery that determines which bibs' items should be included --

Re: [Koha] Set report sort order at runtime

Thanks, Owen. Some quick Googling turned up several solutions that rely on setting a variable & then using CASE WHEN syntax. Tried this but Koha threw an error on the SET statement :-( SET @OrderByColumn = 'AddedDate' . ORDER BY CASE WHEN @OrderByColumn='AddedDate' THEN

Re: [Koha] fighting feature creep and cleaning up Koha

That's quite a list. Thank you for putting it together. I know a couple of those things have been irritating me for years. Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This

Re: [Koha] Items held by more than one branch

Thank you, Jonathan. That fixes one problem (output now appears to be for the right bib numbers), but the GROUP function introduces another issue -- namely, it collapses the results so that just one item is show for each bib number: 14820 PLAISTOW 1572151714 : '20s & '30s style / Horsham,

Re: [Koha] Renew Report

SELECT b.title, b.author, i.itemcallnumber, i.barcode, c.renewaldate FROM (SELECT iss.renewaldate, iss.itemnumber FROM issues iss, (SELECT @StartDate:=<>,@EndDate:=<>) AS var WHERE date(iss.returndate) BETWEEN @StartDate AND @EndDate UNION ALL SELECT oi.renewaldate, oi.itemnumber FROM old_issues

Re: [Koha] Renew Report

How look like the new version of the query? On Mon, 23 Apr 2018 at 12:02 Arshad Iqbal wrote: > I have added reneweddate and renwal as well in sql report but working not > good > On Mon, Apr 23, 2018 at 7:38 PM, Jonathan Druart < > jonathan.dru...@bugs.koha-community.org>

Re: [Koha] Renew Report

I have added reneweddate and renwal as well in sql report but working not good On Mon, Apr 23, 2018 at 7:38 PM, Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Hello Arshad, > > The renew information is in the same tables issues/old_issues, there are > lastreneweddate and

Re: [Koha] Renew Report

Hello Arshad, The renew information is in the same tables issues/old_issues, there are lastreneweddate and renewals. Note that asking the question only once is enough :) Regards, Jonathan On Mon, 23 Apr 2018 at 10:47 Arshad Iqbal wrote: > Hi, > I want to convert this

Re: [Koha] Items held by more than one branch

Hi, I want to convert this checked in sql report into renew sql report. How i can convert this report. guide me. SELECT b.title, b.author, i.itemcallnumber, i.barcode, c.returndate FROM (SELECT iss.returndate, iss.itemnumber FROM issues iss, (SELECT @StartDate:=<>,@EndDate:=<>) AS var WHERE

Re: [Koha] Items held by more than one branch

I'd say you are missing a group by. On Mon, 23 Apr 2018 at 10:19 Cab Vinton wrote: > Hi, all-- > > Another report question... > > Trying to write a report that will provide details for items held by > more than one branch, with separate output for each library's item. > >

[Koha] Renew Report

Hi, I want to convert this checked in sql report into renew sql report. How i can convert this report. guide me. SELECT b.title, b.author, i.itemcallnumber, i.barcode, c.returndate FROM (SELECT iss.returndate, iss.itemnumber FROM issues iss, (SELECT @StartDate:=<>,@EndDate:=<>) AS var WHERE

Re: [Koha] Set report sort order at runtime

> as SQL turned this into: > > ORDER BY 'itemcallnumber' As you have discovered, Koha will try to put your strings into quotes on the assumption that you're submitting something for some kind of matching purposes. I agree that it would be a nice option for parameters. -- Owen -- Web

[Koha] Items held by more than one branch

Hi, all-- Another report question... Trying to write a report that will provide details for items held by more than one branch, with separate output for each library's item. Including the statement HAVING COUNT(i.itemnumber) > 1 collapses the results to just one title. (Strangely, the bib

Re: [Koha] Koha and 2 factor authentication

Hi, What do you think about hardware 2fa tools like Yubikey? Btw great replacement for Google Authentificator is Authy: screen protected by PIN, secure backup. Bye Mike pá 20. 4. 2018 v 15:45 odesílatel Narcis Garcia napsal: > More privacy = More freedom > More

[Koha] Set report sort order at runtime

Is this possible? This code did not work: ORDER BY <> as SQL turned this into: ORDER BY 'itemcallnumber' Think this would be a useful feature if Koha will allow it. Thanks in advance for any guidance, Cab Vinton, Director Plaistow Public Library Plaistow, NH