[Koha] Koha-US System Administration SIG
Time continues to hurtle forward in a manner both terrifying and inescapable, which means we're due for another meeting of the Koha-US System Administration Special Interest Group! Join us to discuss the Administration module, system preferences, reports & SQL, and any other topics of great universal import. Our next meeting will to tomorrow, 10/10, at 8 PT / 9 MT / 10 CT / 11 ET. Join us on Zoom here: https://us02web.zoom.us/j/955473977?pwd=S3RGaW90SmxVVkRSaHk3ZERMOExBZz09 See more details here: https://koha-us.org/event/system-administration-special-interest-group/?instance_id=12865 Andrew Fuerste-Henry Assistant Library Director Dubuque County Library District www.dubcolib.org | 563-582-0008 he|they<https://www.mypronouns.org/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha-US System Administration Special Interest Group, 7/11/23
Good morning! The Koha-US System Administraiton Special Interest Group will meet Tuesday, July 11, 8 PT / 9 MT / 10 CT / 11 ET. We discuss system preferences and all the other fun nonsense that lives in the Administration module, along with SQL questions, bugs of note, and whatever other mad schemes folks want to talk up. Come join us! The meeting will be held on Zoom at https://us02web.zoom.us/j/955473977?pwd=S3RGaW90SmxVVkRSaHk3ZERMOExBZz09. For full details, visit https://koha-us.org/event/system-administration-special-interest-group/?instance_id=12862 Andrew Fuerste-Henry Assistant Library Director Dubuque County Library District www.dubcolib.org | 563-582-0008 he|they<https://www.mypronouns.org/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha-US System Administration and Reports SIG, 6/13
Hello Koha-people! Next Tuesday, 6/13, will be the next meeting of the Koha-US Special Interest Group for administration and reports. Come chat with us about system preferences, all the other junk in the Admin module, and whatever fun SQL/data things come up. WHEN: June 13, 2023 @ 10:00 am – 11:00 am America/Chicago Timezone WHERE: https://us02web.zoom.us/j/955473977?pwd=S3RGaW90SmxVVkRSaHk3ZERMOExBZz09 For more details: https://koha-us.org/event/system-administration-special-interest-group/?instance_id=12861 Andrew Fuerste-Henry Assistant Library Director Dubuque County Library District www.dubcolib.org | 563-582-0008 he|they<https://www.mypronouns.org/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] April Koha-US System Admin and Reports SIG, 4/11
The Koha-US Sys Admin and Reports SIG will meet next week to discuss whatever's fun and interesting in the Administration and Reports modules. Please join us and bring along your questions (and answers)! To join the meeting on Zoom: https://us02web.zoom.us/j/955473977?pwd=S3RGaW90SmxVVkRSaHk3ZERMOExBZz09 For full details: https://koha-us.org/event/system-administration-special-interest-group/?instance_id=12859 Andrew Fuerste-Henry Assistant Library Director Dubuque County Library District www.dubcolib.org | 563-582-0008 he|they<https://www.mypronouns.org/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Click Tracker
Hello! The notation is table.column, so itype is a column in the items table. You can see the database schema here: https://schema.koha-community.org/ So you'd want to join in the items table to get your query to limit by itemtype: SELECT count(DISTINCT biblionumber) AS 'No. of Times Clicked', biblio.title AS 'Title', URL FROM linktracker JOIN biblio USING(biblionumber) JOIN items USING (biblionumber) WHERE date(timeclicked) BETWEEN <> AND <> AND items.itype=<> Hope that helps! Andrew From: Koha on behalf of Ma. Victoria H. Silva-Manuel Sent: Monday, March 27, 2023 7:36 PM To: Alvaro Cornejo Cc: koha Subject: Re: [Koha] Click Tracker Thank you for responding, unfortunately it still didn't work. On Mon, Mar 27, 2023, 9:32 PM Alvaro Cornejo wrote: > Hi Victoria > > > I don't recall koha's tables content, but in mysql the dot delimit column > and table. Therefore, items.itype means column "items" from table "itype" > and in your query you are not calling table itype. > > So you can add a join with itype table or, if column "items" exist, in > linktracker or biblio tables, you can use items.linktracker > =<> or items.biblio=<> > > Regards, > > Alvaro > > > > > || > Stay safe / Cuídate/ Reste sécurisé > *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à > mesure. > *q *Recycle always / Recicla siempre / Recyclez toujours > P Print only if absolutely necessary / Imprime solo si es necesario / > Imprimez seulement si nécessaire > > > Le lun. 27 mars 2023 à 00:31, Ma. Victoria H. Silva-Manuel < > mavicsi...@gmail.com> a écrit : > >> I am using this SQL to generate Click Tracker report: >> >> SELECT count(*) AS 'No. of Times Clicked', biblio.title AS 'Title', URL >> > FROM linktracker >> > >> JOIN biblio USING(biblionumber) >> >> WHERE date(timeclicked) BETWEEN <> AND >> > <> >> >> GROUP BY url >> >> >> I want to add a drop down list for item type. I tried >> adding items.itype=<> in WHERE part, but I'm getting the >> following error when I run the report: >> >> The following error was encountered: >> > The database returned the following error: >> > Unknown column 'items.itype' in 'where clause' >> > Please check the log for further details. >> >> >> What should I do? >> >> >> -- >> Ma. Victoria H. Silva-Manuel >> Registered Librarian, 3892 >> ___ >> >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [EXTERNAL] Circulating non-specific items
I really want itemBarcodeFallbackSearch <https://koha-community.org/manual//22.11/en/html/circulationpreferences.html#itembarcodefallbacksearch> to work for this: You make just one bib and add an item per dino, giving each item a barcode "dino 1," "dino 2," and so on. At checkout, the staff member enters "dino" for the barcode, gets presented with a list of dino items, and selects the first available one. Ideally, you'd replace "dino" with a word that's easily memorable for staff but doesn't appear in any other records. Maybe just "dinotoy"? But this scheme runs into two issues that might really need to be addressed as bugs. First, the search results for the fallback search don't filter out items that are currently checked out. Second, it doesn't even show you which are checked out and which are available. So really staff get an unusable list of all the dino toys. But either of those things might be correctable via jQuery? Andrew Fuerste-Henry Assistant Library Director Dubuque County Library District www.dubcolib.org | 563-582-0008 he|they<https://www.mypronouns.org/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha-US System Administrator SIG
Good morning! The Koha-US System Administration Special Interest Group will meet tomorrow, 3/14, at 8 PT / 9 MT / 10 CT / 11 ET. We'll discuss whatever fun stuff folks have been getting up to in the admin module and with SQL queries. Feel free to show up with questions or send them to me ahead of time. For full details see https://koha-us.org/event/system-administration-special-interest-group/?instance_id=12858 Join us on Zoom at https://us02web.zoom.us/j/955473977?pwd=S3RGaW90SmxVVkRSaHk3ZERMOExBZz09 Andrew Fuerste-Henry Assistant Library Director Dubuque County Library District www.dubcolib.org | 563-582-0008 he|they<https://www.mypronouns.org/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 21.05.15 release
The Koha community is pleased to announce the release of version 21.05.15. For full release notes, please visit https://koha-community.org/koha-version-21-05-15-released/ Thanks! -- Andrew Fuerste-Henry Educator (he/they) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Time to translate: string freeze to prepare Koha 21.05.15 has begun
Hi folks! String freeze is now in effect for the 21.05.x maintenance branch. This means it's the right time to head over to the translation platform: https://translate.koha-community.org/projects/ Thanks! Andrew -- Andrew Fuerste-Henry Educator (he/they) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 21.05.14 Release
The Koha community is proud to announce the release of version 21.05.14. This is a maintenance release and contains bug fixes. For full details and release notes, please see https://koha-community.org/koha-version-21-05-14-released/ Thanks! Andrew -- Andrew Fuerste-Henry Educator (he/they) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 21.05.14 String Freeze
Good morning! String freeze is in effect for Koha version 21.05.x in preparation for the release of 21.05.14. This release is scheduled for around April 23. This means it's the right time to head over to the translation platform: https://translate.koha-community.org/projects/ Thanks! Andrew -- Andrew Fuerste-Henry Educator (he/they) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 21.05.13 released
The Koha community is proud to announce the release of version 21.05.13. This is a maintenance release and contains many bug fixes and enhancements. As always you can download the release from: https://download.koha-community.org Thank you very much to everyone involved in this release. For further details, please see this blog post <https://koha-community.org/koha-version-21-05-13-released/>. -- Andrew Fuerste-Henry Educator (he/they) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 21.05.11 Released
The Koha community is proud to announce the release of version 21.05.11! You can see the full release notes here: https://koha-community.org/koha-21-05-11-released/ As always you can download the release from: https://download.koha-community.org Thank you very much to everyone involved in this release! -- Andrew Fuerste-Henry Educator (he/they) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha version 21.05.10 released
Hello Koha! The Koha community is proud to announce the release of version 21.05.10. This is a maintenance release to correct an error in 21.05.09. You can see the release notes here: https://koha-community.org/koha-21-05-10-released/ Or you can see the bug detailing the error here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30065 Thanks! Andrew -- Andrew Fuerste-Henry Educator (he/they) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 21.05.08 Released
The Koha community is proud to announce the release of version 21.05.08. This is a maintenance release and contains many bug fixes and enhancements. As always you can download the release from: https://download.koha-community.org Thank you very much to everyone involved in this release. You can view the release notes at https://koha-community.org/koha-21-05-08-released/ Thanks! Andrew -- Andrew Fuerste-Henry Educator (he/they) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fwd: Release of Koha 20.05.12
Hi all! The Koha community is pleased to announce the release of Koha 20.05.12! The full release notes can be found here: https://koha-community.org/koha-20-05-12-released/ Thanks! Andrew -- Andrew Fuerste-Henry Educator (he/him/his) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 20.05.07 released
Hello! The Koha Community is pleased to announce the release of Koha 20.05.07! The full release notes can be found here: https://koha-community.org/koha-20-05-07-released/ Debian packages will be available shortly. Thanks to everyone involved! -- Andrew Fuerste-Henry Educator (he/him/his) ByWater Solutions bywatersolutions.com Phone:(888)900-8944 <(888)%20900-8944> What is Koha? <http://bywatersolutions.com/what-is-koha/> ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Overdrive Integration
Hi! We're just about to go live with Koha. We've got our Overdrive integration set up, but in the Overdrive search results page all of the titles come up with links that start with http// rather than http://. In the list archive I see a discussion from March 2014 of a bug arising from a change in Overdrive's APIs. Was that the same issue I'm seeing? Anything I can do about it from my end? Thanks, Andrew Fuerste-Henry Adult Services Librarian Carnegie-Stout Public Library 360 West 11th Street Dubuque, IA 52001 (563) 589-4225 This message has been scanned for malware by Websense. www.websense.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha