- Koha - lists.katipo.co.nz

Re: [Koha] Debian koha-common_22.05.02-1_all.deb package dependencies conflict
by skaman.tx＠gmail.com 06 Jul '22

06 Jul '22

Thank you, Rainer. Unfortunately, I do not find a lock file there on my instance. Fortunately, we are running our Debian Buster instance as a VM, so reverting to “pre-broken” status is a quick fix for now. So, I just ran “apt upgrade -y” again, and it still gives me the same libmarc-xml-perl package install/overwrite error. Scott From: Stowasser Rainer <rainer.stowasser(a)zamg.ac.at> Sent: Wednesday, July 06, 2022 12:18 PM To: skaman.tx(a)gmail.com Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Debian koha-common_22.05.02-1_all.deb package dependencies conflict Dear Scott I ve think I was one of the first to mention the „problem“ its fixed but Debian has a /var/cache/apt/ lock file just rm it and after that it worked for me Kind regards Hofrat Mag. Rainer Stowasser Head of Library and Archives ZAMG Am 06.07.2022 um 19:03 schrieb skaman.tx(a)gmail.com <mailto:skaman.tx@gmail.com> : I am running an up-to-date version of Debian Buster. Doing a routine "apt update" today and I encountered the following package upgrade for koha-common (koha-common_22.05.02-1_all.deb) that appears to have surfaced in the past for others. :[user]# apt upgrade -y ... Preconfiguring packages ... /tmp/koha-common.config.kjvlf5: 49: koha-list: not found .. Unpacking libmarc-xml-perl (1.0.5-1) ... dpkg: error processing archive /tmp/apt-dpkg-install-E4Zp2O/1-libmarc-xml-perl_1.0.5-1_all.deb (--unpack): trying to overwrite '/usr/bin/marc2xml', which is also in package libmarc-file-xml-perl 1.0.5-1~koha+1 .... Errors were encountered while processing: /tmp/apt-dpkg-install-sNNjK2/1-libmarc-xml-perl_1.0.5-1_all.deb E: Sub-process /usr/bin/dpkg returned an error code (1) >From past bug reports it appears there is a libmarc-xml-perl package in both the Debian repo and the Koha repo. I tried putting an apt hold on libmarc-xml-perl and then completing the apt upgrade, but this breaks my koha system. So, I'm unable to upgrade koha-common at present. Any suggestions to fix this would be helpful. Scott Leafe Scriptel Ministries _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha EXTERNAL EMAIL: Do not click any links or open any attachments unless you trust the sender and know the content is safe.

1 0

CatalogingSIG July 7
by Hernandez, Heather H 05 Jul '22

05 Jul '22

Hi, all! The next Koha-US Cataloging Special Interest Group ("CatSIG") meeting is this Thursday, July 7, 2022, at 8 PT, 9 MT, 10 CT, 11 ET (16:00 UTC) and you don't have to be a member of Koha-US to join us! You don't even need to self-identify as a cataloger! Join us for our usual roundtable of questions, solutions and resource brainstorming, tips, tricks, suggestions, bug & development awareness, and the usual laughter, fun, and fellowship to discuss anything cataloging, authority, or metadata related in Koha. Not sure if it's cataloging related? It probably is! Actual catalogers do attend, as well as the cataloging curious and those who have had cataloging thrust upon them! Information on joining us is on the Koha-US calendar: Events – koha-US<https://koha-us.org/events/> Can't make it? No worries--it will be recorded and available on the Koha-US YouTube Channel: https://www.youtube.com/c/kohaUS/playlists (See the Cataloging Special Interest Group's playlist for more cataloging fun!) As ever, feel free to send me any questions or topics for discussion ahead of time! See you there! --h2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian Library catalog: https://keys.bywatersolutions.com/<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fkeys.bywa…> San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032 (office generally Tu-W & F, telecommuting M&Th) heather_hernandez(a)nps.gov<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwebmail.l…>

1 0

Koha pluging for linking fields and RDA -76X-78X fields
by Mercedes Portugal 05 Jul '22

05 Jul '22

Hi eveyone! We are a specialized library in Argentina, Buenos Aires and we are right now updating to the last Koha version and at the same time implementing RDA with MARC21 fields. Where can we download the following plugin for linking records? mar21_linking_records.pl And who is actually implementing RDA in full? using relationships fields 76x-78x? Thanks a lot! -- Mg. Mercedes Portugal Biblioteca Cnl. Manuel José Olascoaga Instituto Geográfico Nacional [ http://www.ign.gob.ar/ | http://www.ign.gob.ar ] Av. Cabildo 381 – C.A.B.A. – CP: 1426 Tel: [ callto:011 4576 5576 | 011 4576 5576 ] interno 172

3 7

koha-US Board Meeting reminder: Wednesday, July 6, 2022
by Jennifer Marlatt 05 Jul '22

05 Jul '22

The next koha-US Board Meeting is Wednesday, July 6, 2022. When: 8:30a PT / 11:30a ET (time converter <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.timea…> ) Where: https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 Agenda: https://docs.google.com/document/d/1yxDRnf-JBGe9a6-EbbO4M3Q2zSaHj1OscKxkAl1… If you have additional topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsupport.z…> These meetings are always free and open to any and all. Jennifer Marlatt koha-US Secretary secretary(a)koha-us.org

1 0

Rotating IP Address and Koha Logout
by Charles Kelley 05 Jul '22

05 Jul '22

Hi, all! My library is moving its Koha ILS to an AWS-based server. In development, it was on a standalone laptop. In the testing phase on the AWS server, we have noted that the IP address for logins changes every thirty seconds and staff are signed out from Koha. The staff have to sign in anew and refresh. Whatever the staff were working on -- search, record editing, uploading new records, etc. -- may or may not survive intact. We don't know what causes this, but it's like IP 42.0.2.35 Staff types a search query. IP 42.0.2.35 Staff selects Edit Record from dropdown menu. Sudden change to IP 42.0.2.29 Record vanishes. Login screen appears. New IP 42.0.2.34 Staff logs in anew Staff backs up two tabs (or windows) and continues. New IP 42.02.31 Repeat of what staff intervention at New IP 42.0.2.34 Eventually whatever the staff were working on is accomplished, but logging in anew and reentering the previous steps so often are a bit inconvenient, to state the least. My IT staff doesn't understand this phenomenon. We checked the system preferences, but we haven't changed the timeouts since Koha was initially installed. Has this been reported to the Koha development teams or on this discussion group before? Does anyone have an idea what would be causing this? -- よろしくお願いします。 -- Charles. Until 2022-07-15: Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 +81-80-4356-2178 [JPN cell] From 2022-07-18: Charles Kelley c/o Bob and Ronni DiGioia 147 Mitchel Drive Oakland, MD 21550 USA +1-301-741-7122 [US cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls Meeting Your Information Needs. Virtually.

3 2

Koha packages are available 🎁
by Mason James 05 Jul '22

05 Jul '22

kia ora community, the latest Koha packages are available (sorry for the late email) an installation guide is below... https://wiki.koha-community.org/wiki/Koha_on_Debian cheers, Mason

1 0

Options of "export database" and "export settings" are not available
by Victor Barroso Oliveira 05 Jul '22

05 Jul '22

In Ubuntu 20.5 and Koha 22.05.02.000 I enabled in instance-conf.xml <backup_db_via_tools>1</backup_db_via_tools> <backup_conf_via_tools>1</backup_conf_via_tools> In Tools --> Export Data The option tohe option of "export database" and "export settings" are not available. Here's the information that appears: "Note: This generated file will be very large, and will be generated daily." "Unfortunately, there are no backups available."

2 1

Fonts for "Label creator"
by dcook＠prosentient.com.au 05 Jul '22

05 Jul '22

Hi all, Do folk ever need to print labels in multiple languages with different scripts and find that the “Label creator” doesn’t work? European scripts will print but Chinese, Japanese, Korean and others don’t? Well I have a story about how to make it work... -- Recently, I needed to print labels that had both English and Chinese, but the Chinese was showing up as an empty box like ▯ while the English appeared correctly. Initially I turned to the Koha plugin https://github.com/bywatersolutions/koha-plugin-label-maker which worked great, because it leverages the browser's ability to detect different scripts and dynamically choses appropriate fonts to match them (on Chrome on Windows 10 the browser would use Times New Roman for the English and use "Microsoft YaHei" for the Chinese). However, the problem itched my brain, so I kept looking for answers in core Koha. In the "koha-conf.xml" file, there is a "ttf" element. Within that XML, there are font elements where font codes get mapped to "ttf" TrueType font files. While it's not the most elegant solution, you can choose to replace these font files, so that "Courier Bold" can actually be something else. Unfortunately, I still had a problem. While the browser could switch fonts, Koha can only use 1 font. Currently, it can't dynamically switch between different fonts. Adding that support would require time and money which I didn't have. Fortunately, Chinese fonts like Noto Sans CJK TC contain not only Chinese but also English! I didn't need Koha to change fonts; I could just use one font! However, the Noto fonts on Debian/Ubuntu come as large "ttc" files which are collections of font files and not as individual "ttf" files. Even downloading particular fonts like Noto Sans CJK TC Bold from Google, they came as "otf" files, which aren't compatible with Koha. After a lot of reading, I downloaded a tool called "FontForge". I could open the "otf" file, "flatten" it, re-encode it using a Unicode option, and then export as a "ttf" file. I replaced the "Courier Bold" file of /usr/share/fonts/truetype/dejavu/DejaVuSansMono-Bold.ttf in Koha with my newly generated Noto ttf file. It printed out the Chinese text, but I noticed instead of spaces in English it was now showing the empty box ▯ again. Ubuntu had a package called "fonts-wqy-zenhei" which provides another Chinese font, so I ran that through the same process and that worked perfectly. Since Noto is a very popular font and I am very stubborn, I decided to keep trying with the Noto. Using FontForge, I was able to manually add in the missing space definition in the font file, so I was able to export a Noto Sans CJK TC Bold "ttf" file, which also worked perfectly. I got Koha to print barcode labels with English and Chinese text! -- If people want to know more specifics, I'm happy to provide more technical/specific information. I figured I'd share this story though, as I imagine that other people must bump into this same problem. I'm personally familiar with the English, French, Chinese, and Korean languages so those are the languages I'm best capable to help with, but I imagine I could still help with any language. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia

1 0

Non letter character in searching
by Toni Afandi 04 Jul '22

04 Jul '22

Dear all, I vobe Koha, but there is an annoying matter that I've experienced when do searching in Koha. If I included a non-letter character, for example a colon, I got no results. But if I remove it, then the results show up. Anyone can help? I use Koha 20.11.18.000 with Zebra. I have not tried using ElasticSearch yet, due to failed installation in the first attempts, two years ago. Thank you in advance. Regards, *Toni Afandi* *Librarian* *STT SAAT* *(Southeast Asia Bible Seminary)*

1 0

Koha SQL report with MARC field
by Tadas G 04 Jul '22

04 Jul '22

Hello, My Koha 21.05.11 version. I use this report to view the inventory. It works well. The question would be how would I go about adding a MARC field from Record e.g 675$3 Maybe someone has an idea how to add it? SELECT items.dateaccessioned AS Pridėjimas,items.barcode AS Barkodas,biblio.author AS Autorius,biblio.title AS Pavadinimas,biblioitems.publishercode AS Leidykla,items.copynumber AS Inventorinis,biblioitems.isbn AS ISBN,items.itemnotes AS Uzrasai,items.itype AS Išteklis,items.homebranch AS Lokacija FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.dateaccessioned BETWEEN <<Between Date (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> ORDER BY items.barcode DESC I think you need to add lines: CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',b.biblionumber, '\">', b.title, '</a>' ) AS Title, ExtractValue(bi.metadata, '//datafield[@tag="675"]/subfield[@code="3"]') AS "Informacija", But I don't know how to add them to work Thanks for the help

2 1