- Koha - lists.katipo.co.nz

SQL report
by Сычев Игорь Алексеевич 20 Feb '25

20 Feb '25

Hi! How do I find only four digits at the beginning of a string? Example, there are values. 1234 2345 123456 25-1 24-11 VK-2 -123 123* At the exit, I need to get 1234 2345 regexp '^[0-9]{4}' does not give the desired result. My test: SELECT itemnumber, biblionumber, barcode, stocknumber, withdrawn, itemnotes_nonpublic, itype FROM items WHERE stocknumber regexp '^[0-9]{4}' AND itype = "BK" Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru

2 1

export_records.pl
by Сычев Игорь Алексеевич 20 Feb '25

20 Feb '25

Hi! How do I find these records? root@koha:~# /usr/share/koha/bin/export_records.pl --record-type=bibs --filename=koha-bibs.mrc Record length of 112264 is larger than the MARC spec allows (99999 bytes). at /usr/share/perl5/MARC/File/USMARC.pm line 314. Record length of 113375 is larger than the MARC spec allows (99999 bytes). at /usr/share/perl5/MARC/File/USMARC.pm line 314. Record length of 107982 is larger than the MARC spec allows (99999 bytes). at /usr/share/perl5/MARC/File/USMARC.pm line 314. Record length of 101864 is larger than the MARC spec allows (99999 bytes). at /usr/share/perl5/MARC/File/USMARC.pm line 314. Record length of 110662 is larger than the MARC spec allows (99999 bytes). at /usr/share/perl5/MARC/File/USMARC.pm line 314. Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru/

5 8

Reminder: Tuesday, February 25: "Developing Koha Together: a forum to connect Koha’s end-users and Koha’s developers"
by Sarah B. Cornell 20 Feb '25

20 Feb '25

Greetings! The Koha-US<https://koha-us.org/> Education Committee will host an online forum on Tuesday, February 25 at 5:00-6:30 PM, UTC. (Noon Eastern, 9 AM Pacific.) During this meeting Koha developers and users will learn about each other’s interests and areas of expertise as they relate to Koha. Please join us for a moderated discussion that will answer questions like these: * What are some key blockers that keep you from getting involved in developments? * What reports and tools do you find useful for data cleanup? * What is a development that you’d like to work on but is hard to get prioritized? * How can end users help developers? Use this link to join us on zoom: https://us02web.zoom.us/j/87096463879?pwd=OrhzK4YsqkrlGPXASdwiAeYI2pPbnd.1 Please share this event with your colleagues! On behalf of the Education Committee, Sarah Sarah B. Cornell Supervisor of Technical Services Portsmouth Public Library 175 Parrott Avenue Portsmouth, NH 03801 603-766-1730 https://portsmouthnh.gov/library Please note my new email address: sbcornell(a)cityofportsmouth.com<mailto:sbcornell@cityofportsmouth.com> is now sbcornell(a)portsmouthnh.gov<mailto:sbcornell@portsmouthnh.gov>. Please update your address book. ________________________________ Notice: Email Address Change Our email domain has changed. Please use @portsmouthnh.gov instead of @cityofportsmouth.com for future communications. Thank you for your attention!

1 0

Problem printing notices with Panda FK-80
by Keith Sorbo 19 Feb '25

19 Feb '25

Further info: When we print using the Print Quick Slip, the printing works correctly. There has to be something sending a formatting css that I cannot locate.

1 0

Problem printing notices with Panda FK-80
by Keith Sorbo 18 Feb '25

18 Feb '25

We are having an issue when printing notices (e.g., checkout notice) on our thermal paper printer (Panda FK-80) on Windows OS. The problem is that the printer* ejects a full 200-230 mm of paper BEFORE printing the notice. *In other words, the printer ejects a full page before beginning to print. As you might imagine, this wastes a lot of paper and is very annoying. Here are what I have determined: - When the notice is *initially displayed* on the screen with the print menu, it appears correctly - When we do a *print preview *with the appropriate print driver selected it appears correctly - When we use the printer to print from *another application* (e.g., MS Word), it does not eject a full page before printing. From this I conclude that the *problem is not with the printer or printer driver, but from Koha.* I have concluded that something in Koha is sending a new page command before the print begins. Is there* CSS which is controlling thi*s? Where would I look for the relevant CSS? Thanks in advance for your help

2 1

LINKED DATA
by Kazım ŞENTÜRK 17 Feb '25

17 Feb '25

Hello, Do you use LINKED DATA application in Koha Library Automation? Kazım ŞENTÜRK Kütüphane Müdür V. Bursa Uludağ Üniversitesi Kütüphane ve Dokümantasyon Daire Başkanlığı Prof. Dr. Fuat Sezgin Merkez Kütüphanesi Görükle Yerleşkesi Nilüfer / Bursa 0224 294 04 75 0224 294 04 99 ksenturk(a)uludag.edu.tr Bu mesajı yazdırmadan önce çevreye verebileceğiniz zararları bir kez daha düşününüz. Think of the environment once more before printing out this message.

1 0

koha zebra
by Cybermon 14 Feb '25

14 Feb '25

Dear all, We have koha 22.11.08 for Ubuntu 22 I have a problem related to /var/lib/koha/library/biblios/tmp, this folder have too many files, and the harddisk quickly full /please see zebra-temp.jpg in attached file/. Also running many zebra process via ps aux | grep zebra /please see zebra.jpg in the attached file/. Please advise or give me any comments. Best regards Gana

3 3

Is the wiki down inaccessible for anyone else?
by Indranil Das Gupta 14 Feb '25

14 Feb '25

Hi all, I'm unable to access https://wiki.koha-community.org/ is it inaccessible for anyone else as well? -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 WWW : http://www.l2c2.co.in Blog : http://blog.l2c2.co.in IRC : indradg on irc://irc.freenode.net Twitter : indradg

2 1

The Terrific Every-Other-Thursday Training Video | 511
by BRANNON, CHRISTOPHER 13 Feb '25

13 Feb '25

George and Christopher visit this week with ByWater Solutions' CEO Brendan Gallagher and CRO Nathan Curulla to talk about ByWater Solutions, how it started, what's happening now, and where they see it going down the road. https://youtu.be/sLV8caz6EOk Respectfully, Christopher Brannon koha-US Admin

1 0

Call for news - Newsletter February 2025
by Michael Kuhn 13 Feb '25

13 Feb '25

Hi I'm collecting news for the February 2025 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format criteria: * Just structured plain text, or * HTML text to include tables or similar For events: * Consider adding your event to the Koha Community calendar at https://koha-community.org/calendar/ Thank you! Michael Kuhn Editor, Koha Community Newsletter

1 0