- Koha-devel - lists.koha-community.org

Help needed
by Tomas Cohen Arazi 10 Jul '22

10 Jul '22

Hi all, I've been trying to track down a problem with TestBuilder tests. The are failing (almost) randomly but I narrow it down to: - Koha::Checkouts::Renewals - Koha::Biblio::ItemGroup::Items I ran out of fuel today, but it would be great if some more eyes were put on this, so I can move on with pushing new stuffs with a happy test suite. This is the subset of TestBuilder.t that I'm looking at (put it in t/db_dependent/test.t): https://paste.koha-community.org/10864 My feeling is TestBuilder->_should_be_fk is not working as it should (for Koha::Checkouts::Renewals) and about Koha::Biblio::ItemGroup::Items, all I can say is that the table is a linking table, pretty much like the club holds one. Thanks in advance and have a great weekend! -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

2 1

Sign off request
by Marcel de Rooy 06 Jul '22

06 Jul '22

Hi all, This is about bug 30933 Add a designated owner for shared and public lists at patron deletion <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30933> It is imo a nice extension to the two PQA list bugs 11889 and 25498. But it still needs a signoff ! And after that some QA obviously.. It would be really great if those three reports could be pushed soon. Your help is appreciated. Thanks, Marcel

1 0

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

Using Template::Toolkit MACRO in notice templates
by dcook＠prosentient.com.au 04 Jul '22

04 Jul '22

Hi all, I noticed that https://wiki.koha-community.org/wiki/Notices_with_Template_Toolkit didn't have a section on macros, so I thought I'd write one: https://wiki.koha-community.org/wiki/Notices_with_Template_Toolkit#Macros I needed to print the 880 $6 245-01 in a few notices, so I figured I'd just define my own function that I could stick at the top of the template, and then just call as necessary throughout the template. That's what I've used as an initial example in the wiki as well: https://wiki.koha-community.org/wiki/Notices_with_Template_Toolkit#Example:_ Fetch_880_.246245-01_titles -- It actually got me thinking how it could be interesting to have a system preference like "NoticeGlobalTemplate" where we could define macros or includes or whatever that could be applied to all notice templates like "NoticeCSS". Do folk think that would be useful? At the moment, I have to copy and paste my macros across all the notices I want, but if I could just have 1 place to define them. that would be pretty cool. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

1 0

Koha OS support 32bits
by Fridolin SOMERS 04 Jul '22

04 Jul '22

Hi, Someone on IRC pointed that current phrase in OS support is not very clear to understand : - we support 64 bits Ubuntu - we recommend Debian before Ubuntu I've moved it to a general note : https://wiki.koha-community.org/wiki/System_requirements_and_recommendation… Best regards, -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 0

Re: [Koha-devel] Multilingual label printing in Koha (praise be to Bywater!)
by dcook＠prosentient.com.au 03 Jul '22

03 Jul '22

Thanks, Kyle! Yeah, it looks like Noto is Open Font and WenQuanYi is GPL. My understanding with the OFL is that you can embed the fonts in software you sell, and you can share fonts but you can’t sell them standalone as fonts. So yeah I probably could share the custom font file. It could be interesting to set up a Koha Community font repository. I was thinking of posting something to the general Koha listserv on this topic as well… David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 From: Kyle Hall <kyle(a)bywatersolutions.com> Sent: Friday, 1 July 2022 8:23 PM To: dcook(a)prosentient.com.au Cc: Indranil Das Gupta <indradg(a)l2c2.co.in>; Koha-devel <koha-devel(a)lists.koha-community.org> Subject: Re: [Koha-devel] Multilingual label printing in Koha (praise be to Bywater!) Dang! Nice work! I wonder if the licenses allow you to publish your custom font file for others to use. It looks like one is Open Font and the other is GPL? On Fri, Jul 1, 2022 at 1:17 AM <dcook(a)prosentient.com.au <mailto:dcook@prosentient.com.au> > wrote: While this has consumed more of my day than I would’ve anticipated, it’s been a very useful exercise! I downloaded NotoSansTC.otf from Google (although you can just install it from Debian/Ubuntu too although they supply .ttc files), and opened it in FontForge. I used “CID > Flatten”, “Encoding > Reencode > UnicodeBmp”, and then I noticed that the “space” and “hyphen” characters were missing, so I copied them in from the WenQuanYi font. I used “File > Generate Fonts” and chose the “TrueType” export format, which exports as a “.ttf” file. I loaded that into Koha via the “ttf” section of koha-conf.xml, and now I have Noto fonts rendering English and Chinese via the Koha Label Creator. It’s taken a few hours to learn the basics of FontForge and font files, but now I feel fairly comfortable. I am sure that many other Koha libraries could leverage the same tool and processes to get TTF font files that are able to meet their multilingual needs. Browsing through the font file, I see a fair number of European symbols from French, Spanish, and Norwegian in the font file. Anyway… get in touch if you want more information about working with font files I guess! These past 48 hours have been very illuminating! David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 From: dcook(a)prosentient.com.au <mailto:dcook@prosentient.com.au> <dcook(a)prosentient.com.au <mailto:dcook@prosentient.com.au> > Sent: Friday, 1 July 2022 1:32 PM To: 'Kyle Hall' <kyle(a)bywatersolutions.com <mailto:kyle@bywatersolutions.com> >; 'Indranil Das Gupta' <indradg(a)l2c2.co.in <mailto:indradg@l2c2.co.in> > Cc: 'Koha-devel' <koha-devel(a)lists.koha-community.org <mailto:koha-devel@lists.koha-community.org> >; 'Brendan Gallagher' <brendan(a)bywatersolutions.com <mailto:brendan@bywatersolutions.com> > Subject: RE: [Koha-devel] Multilingual label printing in Koha (praise be to Bywater!) Kyle: TIL a new word! I don’t think that I’d ever heard “yinz” before. Thanks for keeping life interesting, Kyle! Once you start going down that path of trying to turn HTML and CSS into a PDF programmatically, I think that you need to start using a proper rendering engine. I’ve used “wkhtmltopdf” (Qt Webkit engine), Puppeteer, Playwright, and headless Chrome. There are a few CPAN modules for working with “wkhtmltopdf” although it looks like they all wrap the binary rather than being Perl bindings for the C library but that’s probably OK. https://metacpan.org/pod/WKHTMLTOPDF https://metacpan.org/pod/PDF::WebKit Looks like it’s also available in Debian and Ubuntu: https://packages.debian.org/search?keywords=wkhtmltopdf https://packages.ubuntu.com/bionic/wkhtmltopdf. -- Indranil: I think that you may be right about PDF::Reuse (and friends) not being up to the task overall… However, I discovered that a number of Chinese fonts like Noto CJK fonts (e.g. Noto Sans TC) and WenQuanYi (https://packages.ubuntu.com/bionic/fonts-wqy-zenhei) actually contain glyphs for both English and Chinese. Using “fontforge”, I was able to create a TTF file from the WenQuanYi TTC file, which can be used by Koha’s Label Creator to print both English and Chinese on the same label using the same font. I just referenced my new TTF via koha-conf.xml and voila! (I did notice that if I copy the text from the PDF and paste it elsewhere, it will just show gibberish, but apparently that’s a pre-existing problem with the PDF generator…) Unfortunately, I wasn’t able to get a good quality TTF from the Noto Sans TC. It worked well on the Chinese and English but it couldn’t display space characters, so I couldn’t use that in the end. I find this whole font business very interesting. Personally, I’d love to know how browsers and word processors decide which font to apply. I keep thinking that they must have maps based off of Unicode code points and then choose an appropriate font based on that. But I don’t know for sure. In theory, PDF::Reuse could be changed to use “fontconfig” to see what font is available on the OS for a particular Unicode codepoint, so we could write a simple algorithm combined with a hash map to provide better font support for Koha’s Label Creator… but yeah it would take some time and energy. While I find it interesting, I’m not sure that I find it interesting enough to devote my free time to it. I guess we’ll see how long this tickles my brain. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 From: Kyle Hall <kyle(a)bywatersolutions.com <mailto:kyle@bywatersolutions.com> > Sent: Thursday, 30 June 2022 9:27 PM To: Indranil Das Gupta <indradg(a)l2c2.co.in <mailto:indradg@l2c2.co.in> > Cc: dcook(a)prosentient.com.au <mailto:dcook@prosentient.com.au> ; Koha-devel <koha-devel(a)lists.koha-community.org <mailto:koha-devel@lists.koha-community.org> >; Brendan Gallagher <brendan(a)bywatersolutions.com <mailto:brendan@bywatersolutions.com> > Subject: Re: [Koha-devel] Multilingual label printing in Koha (praise be to Bywater!) That's awesome! Thanks Yinz! I think the unicorn we need is something like https://metacpan.org/pod/PDF::FromHTML but with support for CSS. AFAIK such a thing doesn't exist :/ Kyle On Thu, Jun 30, 2022 at 5:48 AM Indranil Das Gupta <indradg(a)l2c2.co.in <mailto:indradg@l2c2.co.in> > wrote: Yep! the Bywater Solutions plugin by Kyle does the job nicely "outside the box" :-) IIRC the label printing code was last worked on by Chris N a long long time back. As far as I can tell the non Latin printing issue is due to the PDF library we are using. Prolly needs a rewrite for that part which requires both time and funds :-( -Indranil On Thu, 30 Jun, 2022, 12:34 pm , <dcook(a)prosentient.com.au <mailto:dcook@prosentient.com.au> > wrote: Hi all, I had a problem where I couldn't print Chinese and English on barcode labels using Koha's built-in Label Creator, since it uses individual font files and I couldn't find a free and open individual font that supports both European and Chinese scripts. Fortunately, I recalled that Kyle @ ByWater Solutions created this plugin: https://github.com/bywatersolutions/koha-plugin-label-maker. It uses HTML and CSS to generate labels in the browser, and the browser is already capable of using multiple different fonts to support multiple different scripts. The plugin did a great job of rendering barcodes with both Chinese and English written on them! Thanks, Bywater Solutions, for saving the day! -- Nerdy thoughts: If I look at the "Computed" styles in the F12 tools in Chrome on Windows 10, it says the English is rendered using the "Times New Roman" font, and it says that the Chinese is rendered using the "Microsoft YaHei" font. If I do the same thing in Microsoft Word, the English is in "Calibri" and the Chinese is in "DengXian". If you read https://fonts.google.com/noto/use#how-are-noto-fonts-organized it says "If you have text in multiple languages that use different scripts, either the app or the person who typesets the text needs to switch between the different fonts accordingly." I'm not an expert on fonts, so I'm not sure what would be involved with getting Koha's PDF libraries to use different fonts for different scripts. I don't know how Chrome and Word detect that they need to use a different font. I don't know if it's a map of Unicode codepoints to existing font mappings, or if it iterates through a list of fallbacks, or what. I probably won't go too far down this rabbit hole, since the ByWater Koha Plugin solved my immediate use case, but it's an interesting topic, and this is a major limitation with Koha's Label Creator, so we might want to think about a change in the future... David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha-community.org <mailto:Koha-devel@lists.koha-community.org> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/ -- Kyle M. Hall Loose Cannon, ByWater Solutions <mailto:kyle@bywatersolutions.com> kyle(a)bywatersolutions.com <http://bywatersolutions.com/> https://bywatersolutions.com <http://bywatersolutions.com/what-is-koha/> What is Koha? -- Kyle M. Hall Loose Cannon, ByWater Solutions <mailto:kyle@bywatersolutions.com> kyle(a)bywatersolutions.com <http://bywatersolutions.com/> https://bywatersolutions.com <http://bywatersolutions.com/what-is-koha/> What is Koha?

1 0

How can I improve this report?
by Doug Kingston 03 Jul '22

03 Jul '22

Report: Authors not in Authorities SELECT DISTINCT(author) AS heading FROM biblio WHERE author NOT IN (SELECT ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code="a"]') AS heading FROM auth_header WHERE authtypecode='PERSO_NAME')ORDER BY heading I am not a SQL expert, but I believe this is doing an unkeyed troll through every authority record for every biblio (O(Nbibs * Mauths), which is pretty bad). I suspect we can do better by trolling Auths once to create a set and then compare Bib authors against it. How can we do this? -Doug-

3 2

ElasticSearch Geoserch
by Thomas Klausner 01 Jul '22

01 Jul '22

Hi! We are currently discussing a project where a customer wants to add a geosearch to Koha (store lat/lng in biblio, use Elastic geo queries [0] together with a leaflet.js map to find biblios in a certain area). I assume that might be of interest to Koha in general? I also assume that this will only be possible via some changes to Koha core code (i.e. adding a new search field to ES and Koha, define mappings), while some things might be doable as a plugin (the "frontend" map etc). Before we start hacking I'd like to get some feedback from you: * Would something like this be considered to be added to future Koha versions? * Do you think it's feasable / possible to add to Koha? * Has anybody maybe done a geosearch before? (I couldn't find anything..) Greetings, domm 0: https://www.elastic.co/guide/en/elasticsearch/reference/6.8/geo-queries.html -- #!/usr/bin/perl https://domm.plix.at eor(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/}

4 5

Re: [Koha-devel] Multilingual label printing in Koha (praise be to Bywater!)
by dcook＠prosentient.com.au 01 Jul '22

01 Jul '22

While this has consumed more of my day than I would’ve anticipated, it’s been a very useful exercise! I downloaded NotoSansTC.otf from Google (although you can just install it from Debian/Ubuntu too although they supply .ttc files), and opened it in FontForge. I used “CID > Flatten”, “Encoding > Reencode > UnicodeBmp”, and then I noticed that the “space” and “hyphen” characters were missing, so I copied them in from the WenQuanYi font. I used “File > Generate Fonts” and chose the “TrueType” export format, which exports as a “.ttf” file. I loaded that into Koha via the “ttf” section of koha-conf.xml, and now I have Noto fonts rendering English and Chinese via the Koha Label Creator. It’s taken a few hours to learn the basics of FontForge and font files, but now I feel fairly comfortable. I am sure that many other Koha libraries could leverage the same tool and processes to get TTF font files that are able to meet their multilingual needs. Browsing through the font file, I see a fair number of European symbols from French, Spanish, and Norwegian in the font file. Anyway… get in touch if you want more information about working with font files I guess! These past 48 hours have been very illuminating! David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 From: dcook(a)prosentient.com.au <dcook(a)prosentient.com.au> Sent: Friday, 1 July 2022 1:32 PM To: 'Kyle Hall' <kyle(a)bywatersolutions.com>; 'Indranil Das Gupta' <indradg(a)l2c2.co.in> Cc: 'Koha-devel' <koha-devel(a)lists.koha-community.org>; 'Brendan Gallagher' <brendan(a)bywatersolutions.com> Subject: RE: [Koha-devel] Multilingual label printing in Koha (praise be to Bywater!) Kyle: TIL a new word! I don’t think that I’d ever heard “yinz” before. Thanks for keeping life interesting, Kyle! Once you start going down that path of trying to turn HTML and CSS into a PDF programmatically, I think that you need to start using a proper rendering engine. I’ve used “wkhtmltopdf” (Qt Webkit engine), Puppeteer, Playwright, and headless Chrome. There are a few CPAN modules for working with “wkhtmltopdf” although it looks like they all wrap the binary rather than being Perl bindings for the C library but that’s probably OK. https://metacpan.org/pod/WKHTMLTOPDF https://metacpan.org/pod/PDF::WebKit Looks like it’s also available in Debian and Ubuntu: https://packages.debian.org/search?keywords=wkhtmltopdf https://packages.ubuntu.com/bionic/wkhtmltopdf. -- Indranil: I think that you may be right about PDF::Reuse (and friends) not being up to the task overall… However, I discovered that a number of Chinese fonts like Noto CJK fonts (e.g. Noto Sans TC) and WenQuanYi (https://packages.ubuntu.com/bionic/fonts-wqy-zenhei) actually contain glyphs for both English and Chinese. Using “fontforge”, I was able to create a TTF file from the WenQuanYi TTC file, which can be used by Koha’s Label Creator to print both English and Chinese on the same label using the same font. I just referenced my new TTF via koha-conf.xml and voila! (I did notice that if I copy the text from the PDF and paste it elsewhere, it will just show gibberish, but apparently that’s a pre-existing problem with the PDF generator…) Unfortunately, I wasn’t able to get a good quality TTF from the Noto Sans TC. It worked well on the Chinese and English but it couldn’t display space characters, so I couldn’t use that in the end. I find this whole font business very interesting. Personally, I’d love to know how browsers and word processors decide which font to apply. I keep thinking that they must have maps based off of Unicode code points and then choose an appropriate font based on that. But I don’t know for sure. In theory, PDF::Reuse could be changed to use “fontconfig” to see what font is available on the OS for a particular Unicode codepoint, so we could write a simple algorithm combined with a hash map to provide better font support for Koha’s Label Creator… but yeah it would take some time and energy. While I find it interesting, I’m not sure that I find it interesting enough to devote my free time to it. I guess we’ll see how long this tickles my brain. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 From: Kyle Hall <kyle(a)bywatersolutions.com <mailto:kyle@bywatersolutions.com> > Sent: Thursday, 30 June 2022 9:27 PM To: Indranil Das Gupta <indradg(a)l2c2.co.in <mailto:indradg@l2c2.co.in> > Cc: dcook(a)prosentient.com.au <mailto:dcook@prosentient.com.au> ; Koha-devel <koha-devel(a)lists.koha-community.org <mailto:koha-devel@lists.koha-community.org> >; Brendan Gallagher <brendan(a)bywatersolutions.com <mailto:brendan@bywatersolutions.com> > Subject: Re: [Koha-devel] Multilingual label printing in Koha (praise be to Bywater!) That's awesome! Thanks Yinz! I think the unicorn we need is something like https://metacpan.org/pod/PDF::FromHTML but with support for CSS. AFAIK such a thing doesn't exist :/ Kyle On Thu, Jun 30, 2022 at 5:48 AM Indranil Das Gupta <indradg(a)l2c2.co.in <mailto:indradg@l2c2.co.in> > wrote: Yep! the Bywater Solutions plugin by Kyle does the job nicely "outside the box" :-) IIRC the label printing code was last worked on by Chris N a long long time back. As far as I can tell the non Latin printing issue is due to the PDF library we are using. Prolly needs a rewrite for that part which requires both time and funds :-( -Indranil On Thu, 30 Jun, 2022, 12:34 pm , <dcook(a)prosentient.com.au <mailto:dcook@prosentient.com.au> > wrote: Hi all, I had a problem where I couldn't print Chinese and English on barcode labels using Koha's built-in Label Creator, since it uses individual font files and I couldn't find a free and open individual font that supports both European and Chinese scripts. Fortunately, I recalled that Kyle @ ByWater Solutions created this plugin: https://github.com/bywatersolutions/koha-plugin-label-maker. It uses HTML and CSS to generate labels in the browser, and the browser is already capable of using multiple different fonts to support multiple different scripts. The plugin did a great job of rendering barcodes with both Chinese and English written on them! Thanks, Bywater Solutions, for saving the day! -- Nerdy thoughts: If I look at the "Computed" styles in the F12 tools in Chrome on Windows 10, it says the English is rendered using the "Times New Roman" font, and it says that the Chinese is rendered using the "Microsoft YaHei" font. If I do the same thing in Microsoft Word, the English is in "Calibri" and the Chinese is in "DengXian". If you read https://fonts.google.com/noto/use#how-are-noto-fonts-organized it says "If you have text in multiple languages that use different scripts, either the app or the person who typesets the text needs to switch between the different fonts accordingly." I'm not an expert on fonts, so I'm not sure what would be involved with getting Koha's PDF libraries to use different fonts for different scripts. I don't know how Chrome and Word detect that they need to use a different font. I don't know if it's a map of Unicode codepoints to existing font mappings, or if it iterates through a list of fallbacks, or what. I probably won't go too far down this rabbit hole, since the ByWater Koha Plugin solved my immediate use case, but it's an interesting topic, and this is a major limitation with Koha's Label Creator, so we might want to think about a change in the future... David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha-community.org <mailto:Koha-devel@lists.koha-community.org> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/ -- Kyle M. Hall Loose Cannon, ByWater Solutions <mailto:kyle@bywatersolutions.com> kyle(a)bywatersolutions.com <http://bywatersolutions.com/> https://bywatersolutions.com <http://bywatersolutions.com/what-is-koha/> What is Koha?

1 0

Re: [Koha-devel] Multilingual label printing in Koha (praise be to Bywater!)
by dcook＠prosentient.com.au 30 Jun '22

30 Jun '22

Kyle: TIL a new word! I don’t think that I’d ever heard “yinz” before. Thanks for keeping life interesting, Kyle! Once you start going down that path of trying to turn HTML and CSS into a PDF programmatically, I think that you need to start using a proper rendering engine. I’ve used “wkhtmltopdf” (Qt Webkit engine), Puppeteer, Playwright, and headless Chrome. There are a few CPAN modules for working with “wkhtmltopdf” although it looks like they all wrap the binary rather than being Perl bindings for the C library but that’s probably OK. https://metacpan.org/pod/WKHTMLTOPDF https://metacpan.org/pod/PDF::WebKit Looks like it’s also available in Debian and Ubuntu: https://packages.debian.org/search?keywords=wkhtmltopdf https://packages.ubuntu.com/bionic/wkhtmltopdf. -- Indranil: I think that you may be right about PDF::Reuse (and friends) not being up to the task overall… However, I discovered that a number of Chinese fonts like Noto CJK fonts (e.g. Noto Sans TC) and WenQuanYi (https://packages.ubuntu.com/bionic/fonts-wqy-zenhei) actually contain glyphs for both English and Chinese. Using “fontforge”, I was able to create a TTF file from the WenQuanYi TTC file, which can be used by Koha’s Label Creator to print both English and Chinese on the same label using the same font. I just referenced my new TTF via koha-conf.xml and voila! (I did notice that if I copy the text from the PDF and paste it elsewhere, it will just show gibberish, but apparently that’s a pre-existing problem with the PDF generator…) Unfortunately, I wasn’t able to get a good quality TTF from the Noto Sans TC. It worked well on the Chinese and English but it couldn’t display space characters, so I couldn’t use that in the end. I find this whole font business very interesting. Personally, I’d love to know how browsers and word processors decide which font to apply. I keep thinking that they must have maps based off of Unicode code points and then choose an appropriate font based on that. But I don’t know for sure. In theory, PDF::Reuse could be changed to use “fontconfig” to see what font is available on the OS for a particular Unicode codepoint, so we could write a simple algorithm combined with a hash map to provide better font support for Koha’s Label Creator… but yeah it would take some time and energy. While I find it interesting, I’m not sure that I find it interesting enough to devote my free time to it. I guess we’ll see how long this tickles my brain. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 From: Kyle Hall <kyle(a)bywatersolutions.com> Sent: Thursday, 30 June 2022 9:27 PM To: Indranil Das Gupta <indradg(a)l2c2.co.in> Cc: dcook(a)prosentient.com.au; Koha-devel <koha-devel(a)lists.koha-community.org>; Brendan Gallagher <brendan(a)bywatersolutions.com> Subject: Re: [Koha-devel] Multilingual label printing in Koha (praise be to Bywater!) That's awesome! Thanks Yinz! I think the unicorn we need is something like https://metacpan.org/pod/PDF::FromHTML but with support for CSS. AFAIK such a thing doesn't exist :/ Kyle On Thu, Jun 30, 2022 at 5:48 AM Indranil Das Gupta <indradg(a)l2c2.co.in <mailto:indradg@l2c2.co.in> > wrote: Yep! the Bywater Solutions plugin by Kyle does the job nicely "outside the box" :-) IIRC the label printing code was last worked on by Chris N a long long time back. As far as I can tell the non Latin printing issue is due to the PDF library we are using. Prolly needs a rewrite for that part which requires both time and funds :-( -Indranil On Thu, 30 Jun, 2022, 12:34 pm , <dcook(a)prosentient.com.au <mailto:dcook@prosentient.com.au> > wrote: Hi all, I had a problem where I couldn't print Chinese and English on barcode labels using Koha's built-in Label Creator, since it uses individual font files and I couldn't find a free and open individual font that supports both European and Chinese scripts. Fortunately, I recalled that Kyle @ ByWater Solutions created this plugin: https://github.com/bywatersolutions/koha-plugin-label-maker. It uses HTML and CSS to generate labels in the browser, and the browser is already capable of using multiple different fonts to support multiple different scripts. The plugin did a great job of rendering barcodes with both Chinese and English written on them! Thanks, Bywater Solutions, for saving the day! -- Nerdy thoughts: If I look at the "Computed" styles in the F12 tools in Chrome on Windows 10, it says the English is rendered using the "Times New Roman" font, and it says that the Chinese is rendered using the "Microsoft YaHei" font. If I do the same thing in Microsoft Word, the English is in "Calibri" and the Chinese is in "DengXian". If you read https://fonts.google.com/noto/use#how-are-noto-fonts-organized it says "If you have text in multiple languages that use different scripts, either the app or the person who typesets the text needs to switch between the different fonts accordingly." I'm not an expert on fonts, so I'm not sure what would be involved with getting Koha's PDF libraries to use different fonts for different scripts. I don't know how Chrome and Word detect that they need to use a different font. I don't know if it's a map of Unicode codepoints to existing font mappings, or if it iterates through a list of fallbacks, or what. I probably won't go too far down this rabbit hole, since the ByWater Koha Plugin solved my immediate use case, but it's an interesting topic, and this is a major limitation with Koha's Label Creator, so we might want to think about a change in the future... David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha-community.org <mailto:Koha-devel@lists.koha-community.org> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/ -- Kyle M. Hall Loose Cannon, ByWater Solutions <mailto:kyle@bywatersolutions.com> kyle(a)bywatersolutions.com <http://bywatersolutions.com/> https://bywatersolutions.com <http://bywatersolutions.com/what-is-koha/> What is Koha?

1 0