Koha-US / SIG - System Admin Special Interest Group

00:13:27 NEKLS Zoom 3 / George Williams: It's awesome
00:15:17 NEKLS Zoom 3 / George Williams: WEll documented and backed up is the way to go
00:16:35 Mike Barrette: Our Batch Patron Permissions Modifier is not at the end of the IntranetUserJS. Sounds like I should move it to the end?
00:16:57 Rebecca Coert - APL (VA): Reacted to "Our Batch Patron Per..." with 👏🏻
00:17:15 Mike Barrette: I try to stay away from that box. It scares me.
00:25:01 Andrew Fuerste-Henry: Bug 27779 - Cashup summary 'refunds' should denote what the refund was actioned against - this is in 22.11
00:25:08 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27779
00:30:57 NEKLS Zoom 3 / George Williams: Remove HTML from downloaded reports: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5920
00:32:01 Michelle, CLAMS Library Network: We've been working directly with Kyle on the Overdue notices plugin. Poor thing must regret he ever made that
00:39:19 Rebecca Coert - APL (VA): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31557
00:39:29 Rebecca Coert - APL (VA): Bug 31557 - Add ability for holds queue builder to prioritize either matching a patron's home library to the item's home or holding library
00:40:13 Michelle, CLAMS Library Network: There is a holds meeting on August 24th
00:40:40 Michelle, CLAMS Library Network: Yes!
00:45:03 Michelle, CLAMS Library Network: We are seeing the same thing
00:45:51 Andrew Fuerste-Henry: Bug 29002 - Add ability to book items ahead of time - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29002
00:46:44 juliet.heltibridle: Our book clubs would like that
00:46:50 Wally DesChamps - Prosper Comm Lib: Reacted to "Our book clubs would..." with 👍
00:46:58 Mike Barrette: Library Police
00:47:04 Barbara Johnson - Bedford: And for Library of things
00:47:13 Wally DesChamps - Prosper Comm Lib: This would also be helpful with room or equipment "reservations"
00:47:32 Rebecca Coert - APL (VA): Reacted to "This would also be h..." with 👍🏻
00:48:14 Mike Barrette: BAHAHA
00:48:21 Wally DesChamps - Prosper Comm Lib: Reacted to "BAHAHA" with 😂
00:49:09 Lori Schlernitzauer: We had the same problem at Williamson County.
00:49:33 Lori Schlernitzauer: With our EDI invoices
00:51:50 Lori Schlernitzauer: Are the plug-ins updated on a certain schedule? My apologies, I'm new to Koha.
00:53:20 Lori Schlernitzauer: Thank you!
00:56:08 Michelle, CLAMS Library Network: Does anyone know what happened Friday afternoon with searching?
00:59:49 Mike Barrette: We had an outage of some sort a week prior. They said it was "all set", and I asked Bywater for a post-mortem, but I never received a response.
01:05:10 Wally DesChamps - Prosper Comm Lib: Thank you all!
01:05:33 Mike Barrette: Thank you!
01:05:34 Rebecca Coert - APL (VA): Thanks All!
01:05:36 Sally - Knox County Public Library: Thanks all. Have fun in NH.

00:28:04 Christopher Brannon: There's a lot to choo choo on
00:28:09 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30708
00:29:36 Jason - SEKLS: https://wiki.koha-community.org/wiki/SQL_Reports_Patrons#Patron_branchcode_change_counts_in_a_date_range
00:30:42 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25159
00:33:01 Christopher Brannon: no
00:33:16 Christopher Brannon: okay, yes
00:39:40 Andrew Fuerste-Henry: SELECT title, subtitle,itemnumber, itemtype, sum(if(type='issue',1,0)), sum(if(type='localuse',1,0))FROM statistics left join items using (itemnumber) left join biblio using (biblionumber)GROUP BY itemnumber
00:43:20 Andrew Fuerste-Henry: https://www.w3schools.com/sql/func_mysql_round.asp
00:44:54 Christopher Brannon: CONCAT("$",FORMAT(a.amountoutstanding,2)) AS owes
00:47:19 Juliet Heltibridle: FORMAT(ABS(o.amount), 2) as "Amount Collected",
00:47:54 Fred King: Does your library have a photo of what's available?
01:00:47 Juliet Heltibridle: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34149
01:02:50 Juliet Heltibridle: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28307

00:13:30 Andrew Fuerste-Henry: https://support.google.com/mail/answer/7436150?hl=en#:~:text=If%20someone%20accidentally%20adds%20dots,john.smith%40gmail.com
00:16:19 Rebecca Coert: https://gizmodo.com/how-to-use-the-infinite-number-of-email-addresses-gmail-1609458192
00:16:30 Jason: https://support.google.com/a/users/answer/9282734?hl=en#multiple
00:25:00 Andrew Fuerste-Henry: https://github.com/Koha-Community/Koha/tree/master/misc/cronjobs
00:29:39 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31269
00:51:40 Jason: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32274
00:55:36 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31329
00:56:05 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32444
01:02:59 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12446

00:19:04 Andrew Fuerste-Henry: I can't unmute :(
00:19:12 Andrew Fuerste-Henry: mean ol' host won't let me
00:21:08 Andrew Fuerste-Henry: mysterious. brb
00:21:24 Andrew Fuerste-Henry: I clicked the unmute and it didn't do anything. weird. par for week.
00:23:29 Rebecca Coert: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29719Here's the bug I mentioned - fixed in 22.05
00:26:17 Jason - SEKLS: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29792
00:28:53 Andrew Fuerste-Henry: I believe it didn't use to show at all
00:29:01 Andrew Fuerste-Henry: the status, I mean
00:32:50 Jason - SEKLS: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22827
00:33:25 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28640
00:39:13 Christie: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31092
00:41:36 Andrew Fuerste-Henry: related to Christie's bug: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28486
00:49:11 Juliet Heltibridle: SELECT
CONCAT_WS('',LEFT(surname,1),RIGHT(cardnumber,5)) AS 'Patron',
-- action_logs.interface,
CASE
WHEN action_logs.interface='opac' THEN 'patron'
WHEN action_logs.interface='cron' THEN 'automatic'
WHEN action_logs.user = '264555' THEN 'self check'
WHEN action_logs.user = '264556' THEN 'self check'
WHEN action_logs.user = '264557' THEN 'self check'
WHEN action_logs.user = '264558' THEN 'self check'
ELSE 'staff'
END AS 'Canceled By',
biblio.title,
author,
itemcallnumber,
barcode,
ifnull(r.holds_count,'None') AS holds_count,
old_reserves.reservedate
FROM action_logs
LEFT JOIN old_reserves ON (action_logs.object=old_reserves.reserve_id AND action_logs.module='holds')
LEFT JOIN biblio USING (biblionumber)
LEFT JOIN items ON (old_reserves.itemnumber=items.itemnumber)
LEFT JOIN borrowers USING (borrowernumber)
LEFT JOIN (SELECT biblionumber, count(reserve_id) AS holds_count FROM reserves WHERE found IS NULL GROUP BY
00:49:34 Juliet Heltibridle: This is my canceled holds report
00:50:24 Juliet Heltibridle: I wanted it to tell me when someone canceled from the self check
00:51:36 Michael Adamyk (CKLS): CASE is my favorite
01:03:05 Juliet Heltibridle: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26591
01:03:26 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26591
01:04:43 Ann Flournoy: I have to go work the info desk. Thanks everyone!

00:14:18 Heather (she/her): Koha IRC info: https://koha-community.org/get-involved/irc/
00:17:00 George Williams - NEKLS: Yeah, cancelling the hold doesn't cancel a transfer that's already been initiated.
00:17:20 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25426
00:24:55 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28841
00:25:43 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30411
00:25:58 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29079
00:26:16 Rebecca Coert - APL: Yes George! That's a great idea1
00:33:25 Christie: Can someone post a link to the meeting agenda in the chat? I am unable to access Google Docs....
00:33:37 Andrew Fuerste-Henry: https://docs.google.com/document/d/147fWoAR9z7gafThOB8WYaczi5gUc9ka-EXS1bapI6V0/edit
00:36:37 Juliet Heltibridle: I also have a Lisa who I leave the Aspen problems to.
00:37:06 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7972
00:38:08 Heather (she/her): The syspref to turn on the "Most Popular" search is OPACTopIssue, https://koha-community.org/manual//21.05/en/html/opacpreferences.html?highlight=most%20popular#opactopissue
00:38:39 Andrew Fuerste-Henry: https://github.com/Koha-Community/Koha/tree/master/misc/cronjobs
00:51:41 Andrew Fuerste-Henry: https://wiki.koha-community.org/wiki/Community_Roles#22.11_Team
00:56:45 Heather (she/her): Good thing you'll share the report on the Wiki, then, George!!:)
00:57:13 Dwight Walker: please share that SQL on wiki
00:57:34 Juliet Heltibridle: https://pastebin.com/Y2N8VvUW
00:57:40 Heather (she/her): Please also share it on the Wiki, Juliet!
00:57:59 George Williams - NEKLS: Here's a link to the circ by list name report
00:57:59 George Williams - NEKLS: https://paste.nomagic.uk/?3af0b27a4e2470b2#F3DedmmEbJtBBxY4u2i9LmSsqtT7hKawo4XkaMzFwZCo
00:58:49 Dwight Walker: great script - thanks
01:02:34 Heather (she/her): Thanks, everyone!
01:02:35 Daphne Hoolahan: Thanks Andrew
01:02:37 Dwight Walker: what is email for agenda?
01:03:30 Andrew Fuerste-Henry: https://koha-us.org/special-interest-groups/

Leaders:
- Andrew Fuerste-Henry (Dubuque County Library District)
- Jason Robb (Southeast Kansas Library System)

Agenda/Notes: https://docs.google.com/document/d/1zlznNa_q63woxTXBP1o1HU9xjQVbqOg30KengJupeSo/edit?usp=sharing

00:12:23 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27841
00:12:28 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25847
00:18:39 NEKLS Zoom 3 / George Williams: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27663
00:27:06 NEKLS Zoom 3 / George Williams: I already commented
00:27:39 Rebecca Coert (APL-VA): Thanks George!
00:32:16 NEKLS Zoom 3 / George Williams: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27663
00:32:34 Rebecca Coert (APL-VA): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28863
00:35:51 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30230
00:38:03 Rebecca Coert (APL-VA): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29918
00:39:33 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31216
00:42:22 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31250
00:43:50 Daniel Gaghan: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31220
00:45:26 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31179
00:59:02 Andrew FH (he/they): OPACResultsMaxItems OPACResultsMaxItemsUnavailable OPACResultsUnavailableGroupingBy
00:59:58 Daphne Hoolahan: Thanks

00:09:18 Jason (SEKLS): https://docs.google.com/document/d/1YqmOVW3BVZJKwECPPQY-l_DOh043Z9k7Q-VHh8YrWMU/edit?usp=sharing
00:11:21 Jason (SEKLS): https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Circulation_and_fine_rules_by_branch
00:28:28 Juliet Heltibridle: Whenever we get error 500, it is because there was no item type in the 942 field.
00:30:55 NEKLS Zoom 3 / George Williams: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30952
00:40:44 NEKLS Zoom 3 / George Williams: //Embiggen item search fields $('#catalog_itemsearch #itemsearchform select[multiple="multiple"]').attr('size', '50%');
00:42:05 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12733
00:46:28 Daniel: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18217
01:02:41 Jason (SEKLS): https://koha-us.org/events/conferences/kohacon22/
01:02:45 NEKLS Zoom 3 / George Williams: https://koha-us.org/events/conferences/kohacon22/

00:06:37 Jason (SEKLS): https://docs.google.com/document/d/1B32uTIA4NIdz4XoSvLvaynvpBJsJ1e3FjvTTddXvqac/edit?usp=sharing
00:48:32 Daphne Hoolahan: If you are using the HOLD REMINDER you must copy out from All Libraries to your own library
00:54:34 Kristen Ortelli (Martinez): I have a stupid question I haven't had a chance to look into yet. I don't suppose anyone can do a quick demo of how to change the wrong cover art or upload new cover art in Koha?
00:56:58 Kristen Ortelli (Martinez): Good to know! Thank you

00:09:54 Lisette: https://docs.google.com/document/d/18_-ptFDr8TO_GcR8iMWNjEkERWO-3CTxeX04tu2loNE/edit
00:12:46 George - laptop: If you run this what's the result look like?
00:13:13 George - laptop: Sorry I'm late to the party
00:22:32 Jason (SEKLS): https://www.seknfind.org/cgi-bin/koha/opac-course-details.pl?course_id=1
00:24:01 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12141
00:35:35 Lisette: LEFT JOIN action_logs a ON a.object = b.borrowernumber AND a.module='MEMBERS' AND ((a.info LIKE CONCAT('%', '"before" : "SELFREG"', '%')) OR ((a.info NOT LIKE CONCAT('%', '"before" : "SELFREG"', '%')) AND (a.action LIKE "creat%") AND (b.categorycode!="SELFREG") AND (a.interface="intranet")))
00:41:50 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26440
00:43:10 bjohnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30647
00:48:18 Jason (SEKLS): https://koha-us.org/events/conferences/kohacon22/
00:48:33 Kristen Martinez: Will Koha con be a hybrid event?
00:49:00 Kristen Martinez: Thank you! :)

00:14:12 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18428
00:14:19 Jason (SEKLS): https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
00:55:40 SUNITA PAREEK: can we replace check in to returned and checkout to issue
00:57:27 SUNITA PAREEK: yes in msgs
00:57:36 SUNITA PAREEK: email alerts
00:57:40 SUNITA PAREEK: and reports
00:57:45 SUNITA PAREEK: every where
00:58:09 SUNITA PAREEK: becaue checkin seems we chein in a hotel
00:59:16 SUNITA PAREEK: any video available if yes please share the link
01:00:46 Jason (SEKLS): https://www.youtube.com/watch?v=SqMqM6iRgvg&list=PLV58VVGJH5V0mnWRmwgYxtZvK5-xjfD3k
01:01:02 SUNITA PAREEK: thanks
01:01:22 Barbara Johnson: //BEGIN Change Surname to Last Name opac-memberentry.pl $("#memberentry_identity li label:contains('Surname:')").text("Last name:");
01:01:58 Jason (SEKLS): $(this).html().replace("color","colour")
01:02:20 Jason (SEKLS): $(this).html().replace(/color/g,"colour");
01:06:40 SUNITA PAREEK: it is very hot in indis
01:06:43 SUNITA PAREEK: india
01:06:56 SUNITA PAREEK: 45 degree temp
01:07:05 SUNITA PAREEK: in Rajastha
01:07:11 SUNITA PAREEK: pink city jaipur

00:26:32 Kristi Krueger: https://wiki.koha-community.org/wiki/Multipart_Bibliographics"Enhanced Analytics WorkflowDeveloped by Colin Campbel.Affects the cataloguing interface only.Adds 'New child record' to the 'New' dropdown of existing records (Can be used to create new child records linked to parents via the 001)Warning: This option appears only when 'UseControlNumber' is set and 'EasyAnalytics' is disabled.EasyAnalyticalRecordsDeveloped by Labs.Creates a link to a specific Item as opposed to bibliographic, enabling availability information in the analytic.Affects BOTH cataloguing interface and searching/linkingAdds 'Analyze items' to 'New' dropdown of existing records (Can be used to create new child records linked to specific parent items)Adds 'Link to host item' to 'Edit' dropdown of existing records (Can be used to link existing records to a parent item)If enabled: In either case above (Analyze items or Link to host item) the 773 of the child record will be filled as follows: subfield 0 = biblionumber of parent
00:30:12 Jason - SEKLS: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13529
00:35:58 Jason - SEKLS: https://wiki.koha-community.org/wiki/Analytic_Record_support
00:36:17 Christopher Brannon: Definitely get involved on that bug and give feedback.
00:36:31 Christopher Brannon: Otherwise, it looks unimportant.
00:39:28 NEKLS Zoom 3 / George Williams: https://koha-community.org/manual/22.11/en/html/catalogingpreferences.html#usecontrolnumber
00:39:34 NEKLS Zoom 3 / George Williams: https://koha-community.org/manual/22.11/en/html/cataloging.html#analytics-enhanced-workflow-label
00:39:34 Lauren Denny: UseControlNumberEasyAnalyticalRecords
00:39:58 NEKLS Zoom 3 / George Williams: https://koha-community.org/manual/22.11/en/html/catalogingpreferences.html#easyanalyticalrecords-label
00:41:03 Kristi Krueger: Reacted to "https://koha-communi..." with 👍
00:48:33 Christie: I see that 22.11 was released on April 9. If we are supported by Bywater, will we be automatically upgraded?
00:49:47 juliet.heltibridle: There's usually a message put on your homescreen, but we've had libraries in our consortium delete the message before I've seen it in the past.
00:50:17 Christopher Brannon: Tell them to STOP IT
00:50:39 juliet.heltibridle: lol.
00:51:22 juliet.heltibridle: I'm excited about the pretty new look in 22.11
00:51:32 Rebecca (APL-VA): Reacted to "I'm excited about th..." with 🥳
00:52:57 Christopher Brannon: 22.11 has a LOT of new stuff
00:53:10 Christopher Brannon: I'm still reviewing the release page.
00:53:28 Kristi Krueger: Roundtable question: Any system settings/global preferences you have set up to help with your daily (multi times a day?) holds clearing?
00:53:35 NEKLS Zoom 3 / George Williams: https://koha-community.org/koha-22-11-released/
00:53:47 Christopher Brannon: They have been pretty good with preserving old behaviors.
01:01:46 Rebecca (APL-VA): https://wiki.koha-community.org/wiki/Notices_and_Slips_Library
01:12:05 NEKLS Zoom 3 / George Williams: I've got to go. See you all later.
01:20:34 Lauren Denny: I've got to go. Thanks for your help!
01:20:53 Kristi Krueger: Same for me. Thanks again for all the helpful info!
01:22:02 Jason - SEKLS: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33172
01:25:05 Christopher Brannon: Got to go
01:27:11 Christie: Need to run...thanks everyone!
01:27:47 Rebecca (APL-VA): https://koha-community.org/download-koha/
01:27:50 Aida Djikic: Got it, already a member of the main mailing list! Got some great help so far :)
01:28:01 Andrew Fuerste-Henry: https://wiki.koha-community.org/wiki/Main_Page
01:28:29 Andrew Fuerste-Henry: https://wiki.koha-community.org/wiki/IRC_Channel
01:28:40 Rebecca (APL-VA): https://www.youtube.com/@RAFLIMTS

00:26:16 Fred King: use Modern:😛erl;
00:26:31 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15522
00:26:54 Fred King: that should be use Modern : : Perl; but without spaces
00:27:21 Bob Bennhoff: Here comes a bunch of jquery
00:27:24 Bob Bennhoff: (See notes: https://docs.google.com/document/d/1t1dhGHK_kmbgjcl4Bkc8CtOFfUUH1ehv6nYAN7VbGNI/edit?usp=share_link)
00:30:38 Rebecca Coert (APL-VA): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33120
00:34:28 Jason - SEKLS: https://bywatersolutions.com/education/monday-minutes-using-regex-in-batch-item-modification
00:37:46 Emily Lamancusa she/her MCPL: I like this regex cheat sheet too if I'm trying to do something a little more complicated - even if I don't know what I'm looking for it gives me something to google https://cheatography.com/davechild/cheat-sheets/regular-expressions/

00:10:12 Lisette: https://docs.google.com/document/d/1PMJFXzkmQQCe4xLMxXgpqEwwb77H450-65ISsZFQGBg/edit?usp=sharing
00:19:15 Christie B: George, Is your report, or something like it, available on wiki? I came in late, so I apologize if you addressed this already.
00:21:56 Jason (SEKLS): https://pastebin.com/7SJ1ARhZ
00:29:16 George Williams - NEKLS: https://paste.nomagic.uk/?6dda82c5ec413e5a#7MXiyUgErCWZ215K5kMdWPN9tzfCYbzvCFWmfEqKnz5V
00:30:15 George Williams - NEKLS: https://bywatersolutions.com/education/setting-up-mana
00:34:54 Heather Hernandez (she/her): I use Mana! I also try to put A LOT of quality, metadata-tastic words in the notes when I contribute.
00:35:26 Barbara Johnson: love metadata-tastic !
00:36:04 Heather Hernandez (she/her): We need a tshirt: Love Metadatatastic!
00:44:01 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26355
00:47:55 Jennifer Marlatt: We're still having problems.
00:51:29 Jason (SEKLS): ReturnpathDefault
00:54:57 Jennifer Marlatt: Have to go. See you next month!
00:56:30 SUNITA PAREEK: we used to take day back up and get email
00:57:28 SUNITA PAREEK: so if I have taken koha back up today
00:57:50 SUNITA PAREEK: so can I delete yesterday's back up
00:58:04 SUNITA PAREEK: or keep all back up foles
00:58:08 SUNITA PAREEK: files
01:00:51 SUNITA PAREEK: thanks
01:01:15 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16149
01:03:46 Heather Hernandez (she/her): Gotta run--thank you all!
01:10:17 Barbara Johnson: gotta go - thanks for the email ideas you gave me

00:09:36 Emily Lamancusa she/her MCPL: Hi! I'm Emily Lamancusa, with Montgomery County Public Library. We migrated to Koha in October 2021, but I've only been here since October 2022. I'm teleworking while sick so keeping voice/camera off for today
00:12:58 Emily Lamancusa she/her MCPL: I've noticed that too - at least in terms of line breaks. I've noticed that the preview in the Koha account for all notices has about twice as many line breaks as what goes out through email
00:13:20 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30287
00:28:20 Andrew Fuerste-Henry: Bug 30250 - Configure when to apply framework defaults when cataloguing
00:28:33 Andrew Fuerste-Henry: Bug 29146 - Default values from the framework should only be applied at biblio/item creation
00:29:38 Emily Lamancusa she/her MCPL: Lucas is RM, I believe
00:31:29 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11071
00:37:35 Andrew Fuerste-Henry: Bug 31995 - build_holds_queue.pl should check to see if the RealTime syspref is on
00:39:43 Andrew Fuerste-Henry: Bug 32565 - Holds placed when all libraries are closed do not get added to holds queue if HoldsQueueSkipClosed and RealTimeHoldsQueue are enabled
00:47:21 Rebecca Coert (APL-VA): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31557
00:48:59 Emily Lamancusa she/her MCPL: Yes, the RT holds queue checks all the holds on the bib whenever it's touched
00:54:11 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25426
00:54:48 Rebecca Coert (APL-VA): Reacted to "https://bugs.koha-co..." with 🥳
00:59:22 Rebecca Coert (APL-VA): timestampdiff(year,dateofbirth,curdate())FLOOR(DATEDIFF (NOW(), dateofbirth)/365)
01:02:27 Jason (SEKLS): MarcFieldForCreatorId MarcFieldForCreatorName MarcFieldForModifierId MarcFieldForModifierName
01:02:46 Andrew Fuerste-Henry: helpful stuff: https://wiki.koha-community.org/wiki/SQL_Reports_Library#action_logs
01:09:22 Andrew Fuerste-Henry: SELECT a.timestamp, b.title, b.subtitle, p.surname, p.firstnameFROM action_logs a LEFT JOIN biblio b ON (a.object=b.biblionumber) LEFT JOIN borrowers p ON (a.user=p.borrowernumber)WHERE module like 'catal%' and action='add' and info like 'biblio%' and date(a.timestamp) BETWEEN date_add(last_day(date_sub(curdate(), interval 2 month)),interval 1 day) AND last_day(date_sub(curdate(),interval 1 month))
01:11:17 Emily Lamancusa she/her MCPL: Sharing my TemplateToolkit from earlier too: https://paste.koha-community.org/1357
01:11:48 Daphne Hoolahan: Thanks Andew

00:05:12 Lisette: https://docs.google.com/document/d/1OMwwivg688I2QG8yevcaj19aoXH0eFyO6FzpzD4_b9w/edit?usp=sharing
00:08:16 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28852
00:08:21 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29952
00:09:33 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26440
00:11:12 George Williams: sorry I'm late
00:11:17 George Williams: What bug are we looking at?
00:11:23 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26440
00:11:29 George Williams: Thanks
00:12:09 Lisette: https://docs.google.com/document/d/1OMwwivg688I2QG8yevcaj19aoXH0eFyO6FzpzD4_b9w/edit?usp=sharing
00:15:39 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28633
00:54:34 Heather Hernandez (she/her): I really like "Mending" vs. "Damaged," so just changed "Damaged" to "Mending (Technical Services")--it's more positive!
00:56:38 Heather Hernandez (she/her): https://keys.bywatersolutions.com/cgi-bin/koha/opac-detail.pl?biblionumber=9545
00:57:48 Michael Adamyk (CKLS): I’m an hour late again, aren’t I? haha
00:58:25 SUNITA PAREEK: sorry for disturbance
00:59:10 Heather Hernandez (she/her): No problem, Sunita--we've all done that sometime!
01:02:14 Heather Hernandez (she/her): We don't even have a "Director!"
01:03:40 Heather Hernandez (she/her): Bywater has a new video on it: https://bywatersolutions.com/education/experience-the-koha-to-koha-ill-module

No description provided.

Chat logs:
00:13:46 Heather Hernandez (she/her): SELECT items.itemcallnumber AS CallNo, ExtractValue(metadata,'//controlfield[@tag="001"]/*') AS OCLCnumber,ExtractValue(metadata,'//datafield[@tag="245"]/*') AS Title,ExtractValue(metadata,'//datafield[@tag="300"]/*') AS PhysicalDesc FROM biblio_metadataLEFT JOIN items ON (biblio_metadata.biblionumber=items.biblionumber)WHERE items.homebranch ='SFMARITIME' AND items.location='HDD'ORDER BY LPAD(items.barcode,40,' '), biblio_metadata.biblionumber ASC
00:21:47 Jason Robb (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29792
00:26:52 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29808
00:28:02 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27320
00:32:03 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26058
00:39:28 Heather Hernandez (she/her): "TwoFourSixEight…":)
00:42:26 Heather Hernandez (she/her): Oh Em Gee...Athena flashbacks...

Chat logs -

00:08:20 Heather Hernandez (she/her): I'll be right over, Lisette!
00:09:10 George Williams: It won't get above freezing again this year -- and people wonder why I moved to Kansas
00:30:32 Lisette: https://docs.google.com/document/d/1x9Wm4-mrbLmuXKIz3fZ_LL8YO70La6C9HaArB9MYXGs/edit?usp=sharing
00:31:15 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28900
00:31:55 George Williams: SELECT Coalesce(statistics.branch, "NEKLS") AS branch, Coalesce(statistics.itemtype, "BOOK") AS itemtype, Count(*) AS CKO_REN FROM statistics LEFT JOIN items ON items.itemnumber = statistics.itemnumber WHERE (statistics.type = 'issue' OR statistics.type = 'renew') AND Year(statistics.datetime) = Year(Now() - INTERVAL 1 MONTH) AND Month(statistics.datetime) = Month(Now() - INTERVAL 1 MONTH) AND If( Coalesce(statistics.location, "PROC") = "CART", Coalesce(items.permanent_location, "PROC"), Coalesce(statistics.location, "PROC") ) LIKE "%ADULT%" GROUP BY Coalesce(statistics.branch, "NEKLS"), Coalesce(statistics.itemtype, "BOOK")
00:35:46 Heather Hernandez (she/her): I'd totally watch that movie!
00:45:13 Heather Hernandez (she/her): Journals are engaging puzzles!:)
00:49:29 Jason: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29411
00:49:29 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29411
00:54:02 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26058
00:55:59 Lauren Denny: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28800
01:03:52 Lisette: FacetMaxCount

Chat logs -

00:09:52 Lisette Scheer: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
00:40:36 Lisette Scheer: SELECT tobranch AS "Send item to", items.location, items.itemcallnumber, biblio.title,barcode,homebranch, holdingbranch, daterequested, stockrotationrotas.title AS "Stock rotation rota",branchcode_id AS "Stock rotation stage", items.datelastseenFROM branchtransfersJOIN items USING (itemnumber)JOIN biblio USING (biblionumber)LEFT JOIN stockrotationitems ON items.itemnumber=itemnumber_idLEFT JOIN stockrotationstages USING (stage_id)LEFT JOIN stockrotationrotas USING (rota_id)LEFT JOIN reserves ON items.itemnumber=reserves.itemnumberWHERE datearrived IS NULL AND frombranch=BRANCHCODE AND ((branchtransfers.reason="StockrotationRepatriation") OR (branchtransfers.reason="StockrotationAdvance")) AND items.onloan IS NULL and items.itemlost='0' and items.damaged ='0' AND datesent IS NULL AND reserves.waitingdate IS NULL AND holdingbranch=BRANCHCODE AND homebranch != holdingbranchGROUP BY items.barcodeORDER BY items.itemcallnumber

Chat logs:

00:25:41 George Williams: UpdateNotForLoanStatusOnCheckin

Recorded during the Fresh Perspectives conference.

Chat logs:
07:23:44 Rebecca Coert - APL: I have a report question :)
07:25:31 Lisette Scheer: SELECT LEFT (fieldname, 5)
07:30:16 Carol Pham: Is there a SQL library for ACQ?
07:31:16 Carol Pham: Omg, I can't believe I missed these. Thank You!
07:39:40 Rebecca Coert - APL: If you use Tab Separated Text (second option) you can format those when importing in Excel.
07:40:34 Rebecca Coert - APL: I find it cleaner than CSV
07:40:48 Heather Hernandez (she/her): Oh, come on--Slow Koha-US Cleanup TV!!!
07:42:48 Bob Bennhoff: Gotta run and go explain how lost items work to one of our libraries
07:43:04 Jason: Thanks Bob!
07:43:04 George - laptop: See you later Bob
07:49:11 Rebecca Coert - APL: that's great! Is this on the wiki?
07:51:04 Rebecca Coert - APL: LOVE the warning triangle!
07:54:20 George - laptop: Warning triangle video: https://youtu.be/__9M-tKxGdI
07:54:40 Barbara Johnson: /*BEGIN Re-sort Invoice table in desc order - RT 56230 1.31.19 lg*/$(document).ready(function () { if (window.location.href.indexOf("invoices.pl") [rightangledbracket] -1) { $(window).load(function () { var table = $('#resultst').DataTable(); // Sort by column 2 and then re-draw table .order( [ 2, 'desc' ] ) .draw(); }); }});
08:00:54 Jason: $("td[id^= + value +]")
08:01:28 Rebecca Coert - APL: [adorable!]
08:02:51 George - laptop: [attribute^=value]
08:03:09 George - laptop: selects everything with the attribute starting with "value"
08:05:04 Wally DesChamps: You all are blowing my mind with this...and I am loving it! I wish I was as adept as you are. I'm looking forward to continuing to learn more!!!
08:05:59 Heather Hernandez (she/her): It shows the community in action--that there's always support and help!!
08:06:20 Wally DesChamps: @heather … yes, indeed!
08:08:47 Rebecca Coert - APL: These meetings are so helpful and informative! Thank you!
08:09:39 Heather Hernandez (she/her): Kitteh!! ❤️
08:10:50 Victor Zuniga: Any tips/lessons learned on upgrading from an older Koha version (16.05.02.000) to the latest one? I think I read somewhere MySQL was replaced for a different DB server. Anything I should be aware of with compatibility/Schema issues?
08:15:07 Victor Zuniga: Thanks George!
08:15:13 Victor Zuniga: Thanks everyone!!

Chat logs:

00:00:00 Intro
00:23:49 Jason: https://docs.google.com/document/d/1PbdTPFPX2Bm3J7UBiT1MqEyqLdQ0_Orzf_Ak-oC4fAE/edit?usp=sharing
00:28:03 Jason: https://bywatersolutions.com/education/monday-minutes-offline-circulation-tool
00:48:26 Jason: https://bywatersolutions.com/education/to-log-or-not-to-log
00:49:20 Jason: https://wiki.koha-community.org/wiki/SQL_Reports_Library#action_logs

00:16:39 Jason: https://github.com/bywatersolutions/koha-plugin-drivers-license-scanner
00:20:06 Brenda: Same for Washoe. We require DOB since we have Juv and Adult cards.
00:35:09 Jason: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26626
00:43:21 Brenda: For those of you using claims return, do any of you have AMH or smart chutes?
00:44:42 Brenda: Thank you!
00:45:05 Brenda: That is our concern too Rebecca. And wondering how AMH would impact.
00:48:19 Brenda: Is autoresolve something that is coming?
00:48:53 Brenda: I'll send some votes towards that!
00:49:02 Jason: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27753
00:49:56 Latah County Library District: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25809
00:51:01 Latah County Library District: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25901
00:51:03 Brenda: We are!
00:52:04 Brenda: Yes, March?
00:54:51 Jason: https://koha-us.org/conference2021/

Chat logs:
00:00:00 - Intro
00:41:03 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28309
00:44:58 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26815
00:46:01 Heather Hernandez (she/her): We're on Elastic, and for, e.g., the authority record for Ship-railroads (it has a hyphen), it works to search it surrounded by quotes: "ship-railroads"
00:46:53 Heather Hernandez (she/her): Yes--in a keyword search.
00:48:03 Heather Hernandez (she/her): Yes! Same here.
01:00:22 Heather Hernandez (she/her): ByWater has a 20.11 notes page up with good info: https://bywatersolutions.com/education/koha-20-11-upgrade-notes
01:03:01 Jason: https://drive.google.com/file/d/1oPetcu7eBKgs0HU4TXKdWrqddabSvuFm/view?usp=sharing
01:07:43 Heather Hernandez (she/her): Our Zebra printers are little workhorses, too, with thermal printing, and we use the free Zebra software for printing the spine labels (copy-paste from Koha) and printing the barcodes.
01:18:17 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12733
01:20:05 Jason: https://drive.google.com/file/d/1LF88hrX71T9YDZsENhZrkMLoMMCKCHZf/view?usp=sharing
01:20:08 Heather Hernandez (she/her): Also this bug for a batch check in might relate: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19814
01:21:12 Yan Yu: Thank you so much!!!!
01:21:18 Heather Hernandez (she/her): Gotta run--thank you, everyone!
01:22:02 Daniel Gaghan (PPLD): I have to go see you next meeting.
01:23:08 Stephanie D.: Have another meeting. Thank you!
01:23:37 Brenda Owens : Thank you!

Chat logs:
00:00:00 - Intro
00:09:23 Lisette Scheer: https://docs.google.com/document/d/1DgDE90fEGuEBlFwG_1C9TymUtxksSAGGwXkg4NRTxAY/edit
00:12:02 Brenda Owens: Sorry - no mic todayBrenda - Library Tech Manager - Washoe County Library - Reno/Sparks NV
00:17:51 Jason Robb: https://northeast-kansas-library-system.github.io/next/statistics/analysis.tools.html#spreadsheet-tool-2
00:50:59 Lisette Scheer: 11350
00:52:42 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26861
00:52:56 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27320
00:54:54 Daniel Gaghan (PPLD): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23012
00:57:27 Brenda Owens: expiration dates on holds? I see at least four bugs in Bugzilla - 25619, 25631, 26656 and 21729
00:59:21 Rebecca Coert - Arlington PL: I've been asking for help on 25619 from everyone in our system :)
01:00:49 Brenda Owens: Exactly
01:09:32 Heather Hernandez (she/her): Gotta run--thank you all!
01:09:58 Lisette Scheer: https://www.freecarrierlookup.com/
01:10:21 Rhonda Kuiper: Have a great day! See you next week at the Koha-US General Meeting!
01:10:58 Brenda Owens: I need to run as well. Thank you All.
01:12:19 James Mitchell: Bye, everyone. Have a great day!

00:27:43 Jason Robb: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24786
00:28:29 Lisette Scheer: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27845
00:40:05 Jason Robb: https://will1410.github.io/notebook/presentations/itemdashboard.html
00:40:28 Jason Robb: https://www.youtube.com/watch?v=eY-oGqIQXGA
00:42:01 Jason Robb: http://koha-us.org/bugs/
00:44:58 Rebecca Coert: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18631https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27841
00:50:40 Rhonda Kuiper: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27367

Chat logs:
00:00:00 Intro
00:10:47 Brenda: Morning everyone
00:13:22 Heather Hernandez (she/her): North Dakota State Library, Public Library Director Toolkit resources for going fine-free might be useful: https://library-nd.libguides.com/publib/finefree
00:15:43 Brenda: Thank you Heather
00:17:15 Heather Hernandez (she/her): No prob! Hope it's helpful!
00:18:42 Fred King: Sorry to keep running away--I'm the only librarian here today.
00:20:00 Jason Robb: Force checkout if a limitation exists (force_checkout)

00:09:43 Brenda Owens: Washoe has not yet
00:10:32 Brenda Owens: No date yet
00:20:47 Lisette Scheer: IF(reserves.itemnumber IS NULL, 'Next Available', barcode ) AS 'Specific Item'
00:26:34 Holly Cooper: We've had a few requests for reports on patron permissions and creating them was a bit more complicated than I was anticipating. Does anyone have experience creating reports related to patron permissions?
00:28:11 Holly Cooper: That looks really useful, Lisette!
00:30:45 Jason Robb: https://wiki.koha-community.org/wiki/SQL_Reports_Patrons#Permissions_Check
00:32:21 Holly Cooper: On a related note, we found this plugin but haven't been able to get it to work. Is anyone familiar with it?https://github.com/biblibre/koha-plugin-users-with-permissions
00:33:04 Holly Cooper: I think it is a different plugin
00:33:27 Jason Robb: https://github.com/bywatersolutions/koha-plugin-batch-permissions-modifier
00:37:16 Brenda Owens: He used the grace period for fine free
00:48:04 Lisette Scheer: https://wiki.koha-community.org/wiki/Notices_with_Template_Toolkit
00:48:46 Lisette Scheer: https://wiki.koha-community.org/wiki/Notices_and_Slips_Library#Notices_and_slips_using_template_toolkit
00:51:14 Lisette Scheer: https://docs.google.com/document/d/1yuWJujTNxzgAIQE7we7vedNNgJvAfv1Ga0POqY_j-E8/edit
00:54:26 Daphne Hoolahan: Thank you Lisette
00:54:34 Brenda Owens: Thank you! Take care everyone.

Chat logs:
00:11:37 Jenice Tate: We don't send emails
00:17:18 George Williams: Sorting is overrated
00:23:17 Daniel Gaghan: We are trying to move users over to email but phone is still the most preferred method of notification.
00:23:54 Stephanie D'Angelico: We as well, Daniel, a significant number of our patrons don't even have an email listed, still.
00:39:43 Heather Hernandez: Allow to have different password strength and length settings for different patron categories, bug 23816, https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23816
00:41:38 George Williams: https://wiki.koha-community.org/wiki/Koha_Versioning
00:46:29 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27097
00:49:13 Jason Robb: http://sekls.net/Documents/kohaversion.php
01:00:13 Jason Robb: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26961

Chat logs:
00:09:33 George Williams: https://github.com/northeast-kansas-library-system/nextimages
00:22:52 jtate: I got the same message about my upgrade.
00:38:23 George Williams: NewsToolEditor
00:40:19 Barbara Johnson: Display SMS providers in alphabetical order - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26837
00:41:20 Barbara Johnson: Add ability for libraries to be able to restart the SIP server - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26877
00:41:59 George Williams: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20439
00:43:09 Barbara Johnson: Add SQL popup when hovering over name of report - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26708
00:50:59 Barbara Johnson: Add syspref controls for cronjobs - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24968

Chat logs:

00:15:58 Brandi Ledferd: Hi all, I don't know if this is the correct group to ask this, but I came here to ask if anyone has been able to set up a direct SQL connection to their Koha data from a 3rd party reporting program. We are hosted so that's likely an issue. I asked Bywater and got no response.
00:16:10 Jason Robb: https://groups.google.com/a/koha-us.org/g/sysadmin/c/8KOnbKXOcvQ/m/T3xFjk33CgAJ
00:17:35 Brandi Ledferd: Thanks, I will pursue this with Bywater again. I am using Power BI.
00:18:24 Brandi Ledferd: Thank you!
00:19:57 Brandi Ledferd: Oh right...it's MY IP address.
00:38:56 George Williams: https://framabin.org/p/?4ead1017588bb60b#WP8rJhe5SPmh4ALC2wtHY/QfbJIdkscMr8YY3C0OC3o=
00:39:21 George Williams: Here's the SQL for the report I use to determine who "owns" a late fee
00:40:43 Barbara Johnson: Thanks George
00:45:26 Heather Hernandez: There's a Bywater blog post w/some OPAC & pub svcs features: https://bywatersolutions.com/education/20-05-opac-and-public-services-updates
00:48:21 jtate: Thanks for discussion. I have another meeting. Have a good day!
01:00:37 George Williams: RefundLostOnReturnControl
01:02:29 Heather Hernandez: I'm totally dependent on timeanddate.com for figuring out the times!
01:02:46 Heather Hernandez: I'll be watching a lot of recordings.:)
01:03:38 Heather Hernandez: Gotta run--thank you, everyone!
01:05:14 Brandi Ledferd: Goodbye. Thank you!

Chat logs:

00:26:14 Jason Robb, SEKLS: conference info: http://koha-us.org/learn/conferences/onlinetogether2020/
00:29:29 Heather Hernandez: KohaCon 2020, https://2020.kohacon.org/
00:31:51 Lisette Scheer: https://github.com/bywatersolutions/koha-plugin-curbside-pickup
00:36:09 Brandi Ledferd: I'm taking off. Thanks for the info about the Koha US and the Con!
00:41:03 Heather Hernandez: 20.05 release notes, https://koha-community.org/koha-20-05-released/
00:47:48 Jason Robb, SEKLS: https://sekls.org/services/youth-services/puppet-kits
00:51:02 Jason Robb, SEKLS: https://www.seknfind.org/cgi-bin/koha/opac-detail.pl?biblionumber=98851
00:56:23 Rebecca Coert - Arlington Public: https://libcat.arlingtonva.us/Union/Search?basicType=Keyword&lookfor=&view=covers
00:58:14 Rebecca Coert - Arlington Public: Oops - wrong link: this is the "new" items in our catalog: https://libcat.arlingtonva.us/
01:00:49 Jason Robb, SEKLS: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22774
01:05:34 Jason Robb, SEKLS: https://groups.google.com/a/koha-us.org/forum/#!forum/sysadmin
01:05:47 Jason Robb, SEKLS: http://koha-us.org/special-interest-groups/

Chat logs:
00:26:17 Lisette Scheer: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12450
00:31:45 Heather: We migrated to Koha in 2012.
00:32:04 Jennifer Marlatt: We migrated in 2013.
00:32:04 jtate: We migrated to Koha in 2011. I'm with MS Dept of Archives and History.
00:32:14 Heather: We went live in June, so a little "younger" than Lisette's!
00:33:15 Heather: (I'm at San Francisco Maritime National Historical Park Research Center)
00:45:42 Lisette Scheer: I have another meeting to go to. Thanks everyone!
00:50:27 Jason Robb, SEKLS: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25724
00:58:51 Jennifer Marlatt: We have it disabled and you don't see phone as an option.
01:05:55 Heather: A printed bookmark on colored paper might be an old school solution, included with their picked up holds?
01:08:11 jtate: Thanks! Everyone stay safe. Have a good day!

00:10:15 Lisette Scheer: https://github.com/ldjamison/koha-plugin-room-reservations
00:11:22 Lisette Scheer: https://bywatersolutions.com/education/room-reservation-plugin-in-koha
00:13:47 Jason Robb, SEKLS: https://github.com/ldjamison/koha-plugin-room-reservations/wiki
00:14:58 yuyan - WOD -- TRENCHANT: Do you guys ever use LISTS in Koha? one of our staff made one by taking Marc field, I try to do by using sql, but mine doesn’t work. I looked at the manual, but it doesn’t give enough information, went to Wiki, cannot find useful stuff on Lists, maybe I didn’t look in right place. any one knows if there is documents on how to work with LISTS in koha etc.? Thank you
00:15:27 Heather: We use lists!
00:15:38 Heather: https://keys.bywatersolutions.com/cgi-bin/koha/opac-shelves.pl?op=list&category=2
00:16:33 Heather: Most of our lists are built record by record--slow, but sure.
00:16:41 Jason Robb, SEKLS: https://koha-community.org/manual//19.11/en/html/lists.html#lists
00:16:55 Jennifer Marlatt: We use lists, ours are a bit all over the place because our patrons can also create lists.
00:17:02 Lisette Scheer: https://bywatersolutions.com/education/creating-a-public-list-in-koha
00:17:50 Heather: Our staff uses a lot of lists for projects--we hide those lists from the public.:)
00:18:36 yuyan - WOD -- TRENCHANT: I created a list to group all the title with certain subject. we want to expand our use of LISTS so that we can help different practice group in our Firm, I am in a law firm library.
00:19:23 Jennifer Marlatt: https://corona.bywatersolutions.com/cgi-bin/koha/opac-shelves.pl?op=list&category=2
00:24:30 yuyan - WOD -- TRENCHANT: wonderful, thank you for sharing, Jason.
00:24:43 Jason Robb, SEKLS: SELECT items.itemcallnumber, biblio.biblionumber, biblio.title, biblio.author, ExtractValue( biblio_metadata.metadata, '//datafield[@tag="650"]/subfield[@code="a"]' ) AS 'lcsh'FROM biblio_metadataJOIN biblio ON ( biblio_metadata.biblionumber = biblio.biblionumber )JOIN items ON ( biblio_metadata.biblionumber = items.biblionumber )WHERE items.homebranch = 'IOLA'AND ExtractValue( biblio_metadata.metadata, '//datafield[@tag="650"]/subfield[@code="a"]' ) LIKE '%Graphic novel%'
00:27:07 Heather: https://keys.bywatersolutions.com/cgi-bin/koha/opac-shelves.pl?op=view&shelfnumber=26
00:28:48 Jason Robb, SEKLS: https://www.seknfind.org/cgi-bin/koha/opac-shelves.pl?op=view&shelfnumber=3965&sortfield=title
00:30:17 Jason Robb, SEKLS: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18147
00:30:55 George Williams: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25869
00:33:33 George Williams: OPACAmazonCoverImages
00:33:45 George Williams: AmazonCoverImages
00:38:18 George Williams: IntranetUserCSS
00:38:24 George Williams: /* - Catalog › Search for SEARCHTERMS- Removes "No image available" placeholders in search results */.no-image {display: none;}
00:39:34 Lisette Scheer: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9991
00:40:34 George Williams: IntranetUserCSS
00:41:58 George Williams: -
00:41:59 George Williams: -
00:42:00 George Williams: /* - Catalog › Search for SEARCHTERMS- Removes "No image available" placeholders in search results */.no-image {display: none;}

00:46:18 George Williams: #bookcoverimg img {max-width: 100px;}
00:48:02 Lisette Scheer: https://bywatersolutions.com/education/koha-tutorial-cover-images-koha-opac-coce-server
00:48:06 George Williams: CoceHost
00:48:25 George Williams: https://coce.bywatersolutions.com
00:48:53 George Williams: CoceProviders
00:49:44 Heather: In the manual, the info on the Coce sysprefs starts here: https://koha-community.org/manual/19.11/en/html/systempreferences.html?highlight=coce#coce-cover-images-cache
00:52:08 yuyan - WOD -- TRENCHANT: I applied George's code, and the two NocoverImage signs disappeared. Should I still keep one?
00:52:41 Heather: We don't miss the "no cover image" image/message, because it's pretty obvious that there's no cover image displaying.:)
00:52:55 yuyan - WOD -- TRENCHANT: Ok
00:54:17 yuyan - WOD -- TRENCHANT: agreed
00:57:34 Lisette Scheer: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25980
00:58:45 Lisette Scheer: https://zivotdesign.com/p/#1/15934747011658
00:59:13 Lisette Scheer: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25025
01:05:02 Fred King: Passwords: https://xkcd.com/936/
01:08:25 yuyan - WOD -- TRENCHANT: Thank you, everyone for sharing

Chat logs: https://drive.google.com/file/d/1Gx8nvEa9iFmsgmlUdGQzLmobt5QFV1zS/view?usp=sharing

Chat logs: https://drive.google.com/file/d/13IJWYgp1ruEoHFopThA3hPf-S9DWjDZX/view?usp=sharing

Chat logs:

00:37:38 Michael Adamyk: Makes sense, thanks
00:38:51 Holly: Yes, makes sense. Thanks!
00:39:01 Caroline Cyr La Rose: Here's the plugin https://inlibro.com/en/changeduedate-instructions/
00:39:12 Caroline Cyr La Rose: I think the Koha tool is based on this
00:39:27 jtate: We are working to give staff access to the client from home. We aren't comfortable with giving the staff access to the VPN on their home PC.
00:39:47 jennie evans: That's a great idea!
00:39:58 Holly: Some of our sites have enabled renewals on the OPAC, so patrons can renew as they need.
00:40:06 jtate: We are using a certain IP range for the client. With their IPs changing periodically we are having trouble. If anyone has any ideas, please let me know.
00:40:24 jennie evans: we are
00:40:27 Michael Adamyk: We are
00:40:28 Corona: Yes!
00:40:40 Marta Ambroziak: yes
00:40:52 Barbara Johnson: we've always used it. But we created a new Digital Use Only patron type.
00:41:42 Edward Veal: @jtate, is that just for staff?
00:41:50 Edward Veal: access to the staff client?
00:42:03 jtate: yes. I submitted a ticket.
00:42:50 Edward Veal: Good, there might be a way to just turn that off and then back on when you open back up. The issue would be that it would open access to anyone with the URL.
00:45:20 George: http://koha-us.org/2020/02/27/kohathon2020/ Kohathon next week - Thursday, April 23
00:46:26 Jason Robb: https://bywatersolutions.com/education/set-items-to-quarantine-status-upon-return
00:49:57 Barbara Johnson: We're doing elder checks and offering delivery of holds for those patrons.
00:50:42 Holly: I have one or two sites which, for a variety of reasons, have duplicate patron accounts, so they have been using this time to merge these records
00:51:22 Michael Adamyk (CKLS): Some of our staff have been helping me out with reports cleanup. They’re running reports to make sure they work properly, and are still relevant
00:51:37 Corona: We're adding 520s and cleaning up diacritics
00:54:01 Tami Wilkerson: Our cataloger is investigating different records with the same OCLC number. Past cataloging practice here was...not standard to say the least.
00:54:44 Lisette Scheer: If the Idaho stay-at-home order is extended tomorrow we will probably have some circ staff start working on cleaning up patron notes and messages.
00:56:56 Michael Adamyk (CKLS): You’re just using a report to pull accounts with patron notes, right?
00:59:55 Michael Adamyk (CKLS): I’ve seen several patron accounts with a note that just says, “No.” Not sure what that’s all about
01:00:09 Caroline Cyr La Rose: lol!
01:02:53 Michael Adamyk (CKLS): Thanks Lisette
01:03:00 Corona: Thanks
01:04:16 jtate: I was in the process of moving and had to stop due to the stay at home order.
01:04:18 Barbara Johnson: Cat keeps trying to mess with my stuff
01:05:30 Heather Hernandez: We have three adults telecommuting in a 1-bedroom apartment, but luckily we had fiberoptic installed! We try to do phone calls in the back yard.:)
01:06:50 Michael Adamyk (CKLS): 3 hours! wow
01:06:57 jtate: 3 hours, omg!
01:07:08 jennie evans: that's so long!
01:07:38 jennie evans: is that via car? or public transport?
01:08:13 Michael Adamyk (CKLS): One of the times I’m so thankful to live in a rural area. Can’t stand bad traffic
01:11:24 jtate: That's our policy also.
01:11:45 jennie evans: as of right now we are not allowed to work from home.
01:12:04 jtate: We only have a set number of laptops available, so staff is rotating them.
01:12:06 jennie evans: lol
01:12:10 jennie evans: i'm still here at the library
01:12:19 jennie evans: us and 7 other "essential" people
01:13:06 jtate: We are logging hours also.
01:15:41 Heather Hernandez: Maybe he could get internship/practicum credits for working with you on Koha, Ed?
01:16:20 Jason Robb: http://koha-us.org/kohathon-2020/
01:16:24 jennie evans: see you all later!!
01:16:32 Heather Hernandez: Really looking forward to Kohathon!
01:16:36 patricia: Thank You. Stay Safe
01:16:50 jtate: Thank you. Stay safe.
01:16:56 Heather Hernandez: Thanks so much!!

Chat logs: https://drive.google.com/a/koha-us.org/file/d/1hChhFos71WcAUGstnLUJmK5Ptd-D8enM/view?usp=sharing

More info on special interest groups: http://koha-us.org/special-interest-groups/

Chat logs from this meeting: https://drive.google.com/a/koha-us.org/file/d/1Nswp2Z3QLJWRS7oUMYRCqkDIsaIAKsOJ/view?usp=sharing