Re: [Koha] SQL Report Coding need.

Assuming you’re running 19.11 or later, accounttype got changed to credit_type_code and debit_type_code. SELECT CONCAT("http://boraccount.pl/?borrowernumber=>", T1.borrowernumber, "\" target=\"_blank\">View Transaction") AS 'Click to view' , DATE_FORMAT(DATE(T1.timestamp), "%d/%m/%Y") AS '

Re: [Koha] Lost item refund

We deal with this issue a lot. If a patron pays for a lost item, they have 90 days to return it for a refund. But that refund is handled outside of Koha, usually via our business office (unless it’s under a certain amount - I think $10 - then it comes out of the drawer and staff make a note on

Re: [Koha] marging same title and ISBN record -SQL query/other options

Hi, Yatheesh - Check out the duplicate reports in the Koha SQL Report Library. https://wiki.koha-community.org/wiki/SQL_Reports_Library#Duplicates Best, Marti Fuerst Systems Librarian and Manager of Technical Services Huntsv

Re: [Koha] Adding new libraries (without re-inventing the wheel)

Seconded! We have done this in the past, as well as closing a branch, but I haven’t written anything up yet. I can add in the closing bit for the FAQ as well? Best, Marti Fuerst Systems Librarian Huntsville-Madison County Public Library 915 Monroe St, Huntsville, AL 35801 http://hmcpl.org/ — mf

Re: [Koha] Batch checkin in 18.05 koha

There is a bug in Bugzilla for this, if you would like to contribute/add your voice. https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19814 There is also a quote on Bywater’s Crowdsourced Development page: http://devs.b

[Koha] Development in Progress - Rental Fees based on Time Period

Hi, all! We recently funded a development that allows rental fees based on time period as opposed to flat fees for each item type. Our plan is to use this to smooth out our workflow when checking out Wi-Fi Hotspots to our patrons. It’s Bug #20912 - https://bugs.koha-community.org/bugzilla3/sho

Re: [Koha-devel] Can we do away with items.onloan?

So this is interesting - with as muddy as some of our data can get, I only got one result. It’s an item that was checked out to a “problems” account back in October 2017 with a due date of April 2nd, 2018. I thought maybe it was due to an extension of the due date from the checkout screen (but t

Re: [Koha-devel] Clear OPAC self-registration form when back button pressed

I’m for it! Thanks for this! Marti Fuerst Systems Librarian Huntsville-Madison County Public Library 915 Monroe St, Huntsville, AL 35801 http://hmcpl.org/ — mfue...@hmcpl.org > On Apr 12, 2018, at 8:55 PM, David Cook wrote: > > What do people think about clearing the OPAC self-registration form

Re: [Koha] Report for holds count by bib record & branch

Do you need the item type just so you can tell AV from print, etc? If so, you might be able to get it via an ExtractValue: ExtractValue(biblioitems.marcxml, '//datafield[@tag=“942"]/subfield[@code=“c"]')) AS “item type” It would be different for 17.05 and newer, which may require some fiddling.

Re: [Koha] ebook report

I cobbled together something quickly by Frankensteining some of our other digital resources reports. We use a different item type for ebooks and downloadable audio, so if you do the same, that would be a way to aggregate them. SELECT bi.biblioitemnumber as 'Item Number’, bi.isbn as 'ISBN’, publ

Re: [Koha] Plugin KOCT for offline circulation updated

Thanks for this info! With the upcoming launch of Firefox Quantum on November 17, has anyone been doing any testing with the available beta and Koha or the KOCT? Best, Marti Fuerst Systems Librarian Huntsville-Madison County Public Library 915 Monroe St, Huntsville, AL 35801 http://hmcpl.org/ —

[Koha] Geo-tagging Collection/Branches for SEO?

Greetings! We learned about Demco’s DiscoverLocal tool, which geo-tags a library’s collection and feeds that info back into search engines so that collection information shows up in search results. This also, apparently, allows devices like Amazon Alexa to place holds and renew items for users.