What other Open and free tools do you use in your library? Let us know at info@koha-us.org. Also let us know if we can list you as a contact for other libraries who have questions.

Latest Episode

Season 2: Episode 6

Koha jQuery, VBA & Git: Backing Up Notices & Reports

When it’s time to change then it’s time to change. Don’t fight the tide, go along for the ride. Don’t ya see? When it’s time to change, you’ve got to rearrange what you report and how you’re gonna communicate. (Sha na na na na na na na na, Sha na na na na!) Just make sure you have good backups! George will show you how to git ‘er done, and help you save a “bunch” of your work.

Supplemental Links:

Season 2

Season 2: Episode 5

Koha jQuery & REST API: Advanced Credential Reset

Whoa! Hold on a moment. Let’s just take a moment and let this soak in… you mean to say there is MORE? Like, we can do better? Well apparently that is exactly what George is showing us this week. He took the challenge and came back full force by trying out the REST API with his code, applying it to his unique setup, and coming up with some great code. George applies the REST API to multiple scenario dropdowns. As an added bonus, he was able to improve his code and layout on another page. It just keeps getting better and better!

Season 2: Episode 4

Koha jQuery & REST API: Resetting Credentials

Stressed about patron credentials? You can rest easy with this week’s hack. Christopher shows how to add a couple of quick reset buttons for patron credentials using Koha REST API. This video shows off a tool which allows you to grab information that isn’t normally available on the page you are modifying, without relying on public reports. This is definitely a video worth checking out.

Season 2: Episode 3

Koha jQuery & CSS: Alert Enhancement

It’s time for another alarming video! This time we give you a short but impactful enhancement that will make your Moderation Alerts on the home page stand out and get noticed. Didn’t know you needed this? That’s because the alerts are probably not getting noticed! So, take a peek at what we’ve done here, and make your Koha just a little more productive, beautiful, and readable.

Season 2: Episode 2

Koha jQuery: Displaying Overdues in Checkout

This video is long overdue, both literally and figuratively! Need to get a better handle on overdues, and see them a little more clearly? Tired of the hunt through dozens of checkouts? Well then, feast your eyes on this helpful video! George and Christopher share their work on some eye-opening modifications that will make dealing with overdues just a little bit easier.

Season 2: Episode 1
jQuery: Blocking Checkouts

Halt! Don’t go any further! This is the perfect jQuery to learn about if you want to stop people in their tracks. Well, at least if you want to stop certain accounts from checking out when they shouldn’t. Christopher and George each share their own version of helpful code to keep both staff and patrons on track with checkouts. And when you’re done, be sure to like the video or add a comment. Now…proceed with watching!

Season 1

Episode 24
SQL & Frameworks: Alternative Authorized Values

A day late but not short on content. Today George dazzles us with a clever way to limit parameters in SQL reports AND bib frameworks using Authorized Values. You are authorized to use this in whatever way it works best for you. Really. You don’t need our permission. Unless you want it. Then yes, we permit you to do this.

Supplemental Links:

Episode 23
Plugins: cloudLibrary

This week our lofty goal has our heads in the clouds as special guest Jason Robb goes over the plugin for Bibliotheca’s cloudLibrary content. If you are in a fog about this plugin, be sure to watch this episode.

Episode 22
Plugins: Hoopla

Time to get excited for this event! What’s all the hoopla? Well, it’s actually Hoopla! Today George walks us through the setup and use of the Hoopla plugin in Koha. And as an added bonus, he shows off how to enhance the Hoopla results so they stand out. So, make a big racket. Otherwise, you’ll just look silly standing (or sitting) there during this Hoopla.

Episode 21

Koha jQuery Hackdown: Cataloging Labels vs Automatic Library Setting

It was bound to happen. Not just one, but TWO great hacks in today’s video. George and Christopher go head-to-head with a couple short, but helpful hacks in this week’s special Koha Hackdown episode. Which hack is more helpful? You decide.

Episode 20

jQuery: Handling Bad E-mails

There is just no getting around it. Bad e-mails exist. And we all have to deal with them in our own way. Christopher shows how he takes care of these nasty buggers in an efficient way. And George plots to use this idea for his own nefarious purpose. What will he do?

Supplemental Links:

Episode 19

Q&A: Following Up on Episodes 15 & 17

Someone had a question, and guess what! We had an answer! Not only that, we had two! Join us as we go over 2 past episodes and provide some new content for one of our past hacks and a WordPress plugin we featured recently. There is always something new to learn with The Terrific Ever-Other-Thursday Training Videos.

Episode 18

jQuery: Quick Permissions

We give you permission to ooh and aah over this gem of jQuery. We’ll show you how to setup quick permission buttons in your user permissions, so you don’t have to scramble, trying to remember the same settings you’ve set for every other staff member. And as an added bonus, a button to copy permissions from one user to another, just to make it that much more exciting and spectacular. Are you drooling yet?

Episode 17

Library Bookshelves: A WordPress Plugin

This week we escape from the norm, and look at a WordPress plugin to display book covers based on reports from Koha. And our video editing is slightly improved as well. But don’t let that distract you from this awesome plugin.

Supplemental Links:

Episode 16

Notices & Slips: Template Toolkit

This week we welcome our very first special guest, the awesome Lisette Scheer! Lisette will be dazzling us with her wicked skills in Template Toolkit, making notices and slips better for the entire world. She will also bring an extra sparkle to the usual witty banter.

Episode 15

jQuery & CSS: Placards

It’s time to boldly go where no man has gone before – or at least no Koha OPAC has gone before. Join us this week as we explore strange, new worlds with our hosts while they show you how to add placards (information panels) to OPAC search results for items outside of your normal collection. This is an episode that even Jean Luc Picard would be proud of. (Or is that Jean Luc Placard?)

Supplemental Links:

Episode 14

jQuery & CSS: Enhanced Suspended Hold Listings

Holy enhanced features, Batman! This is the feature you’ve all been waiting for. No more delays! This week, Christopher shows of a brand new tweak that will really make those suspended holds stand out, and even shed some light on future holds.

Episode 13

jQuery: Enhanced Search Facets

Hold on to your facets, because you ain’t seen nothing yet! This week Christopher takes the helm as he navigates viewers through the bizarre world of search facets. One could almost say it’s “facet”-nating!

Episode 12

SQL: The Dashboard Finale

You’ve watched the life-sucking training videos that led you step-by-step through each detail of George’s twisted mind. Now watch the video that brings it all together in a slow, unrelenting madness as you take control of Koha and become the master of SQL and item records. (Maniacal laughing inserted here.)

Episode 11

SQL: ExtractValue

In this exciting, action-packed episode, George goes in for an extraction – of subtitles in Marc records. Will he get them out in one piece? Watch, and find out!

Supplemental Links:

Episode 10

SQL: Unions

In order to form a more perfect union… you need to watch this video! We’ll go over how to show the results of multiple queries in a single report.

Episode 9

SQL: Coelesce

You can’t get something out of nothing – unless perhaps you understand the essence of coalesce, more or less. This is good stuff.

Supplemental Links:

Episode 8

SQL: Dates and Subqueries

Continuing on with the SQL saga, George freaks Christopher out with his geeky date voodoo and Subquery magic.

Supplemental Links:

Episode 7

SQL: Like vs Equals

There is no tutorial that equals this bi-weekly mayhem. And if you enjoy it, be sure to like it too! George will dazzle you with his straight-forward explanation of these two comparison operators. And is there any thing else he might add this week?
Episode 6

Concatenation and If Statements in Reports

Hey, its a SQL sequel! If that hasn’t blown your mind, George certainly will when he combines Concatenating and If Statements into one glorious training video.

Supplemental Links:

Episode 5

Links in Reports

Excite your noodle on this fantastic episode, where George adds links to reports (Not the Jimmy Dean kind).

Supplemental Links:

Episode 4

HTML Messages

In this shorter, more riveting episode, George shows how to restore HTML functionality to patron messages and more. He also figures out how to stop the recording.

Supplemental Links:

Episode 3

Slip Logic

This frightening episode highlights the magical code that can add logic to your slips, making them smarter, powerful, and maybe even a little more attractive – much like the hosts.
Episode 2

jQuery: Status Enhancements

In this week’s terrifying episode, Christopher and George monkey around with the statuses in the detail page so staff can see jaw dropping detail between different statuses. Christopher also learns how to correctly spell TERRIFIC on the title screen.
Episode 1

jQuery: Cart Enhancement

In this thrilling video, George and Christopher walk you through the jQuery needed to make the “CART” shelving location more visible in the OPAC and the staff client.