<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 18790 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 185, Issue 23<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Deleting entries from language_descriptions (Katrin Fischer)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Sat, 24 Apr 2021 10:44:53 +0200<br>From: Katrin Fischer <katrin.fischer.83@web.de><br>To: koha-devel@lists.koha-community.org<br>Subject: Re: [Koha-devel] Deleting entries from language_descriptions<br>Message-ID: <9024ce9f-1939-d2fc-2d28-1270d8bef5c7@web.de><br>Content-Type: text/plain; charset="utf-8"; Format="flowed"<br><br>Hi David,
<br>
<br>it seems likely that these are unused. It would be nice to update our
<br>structure there, especially for easier translations. Bernardo has been
<br>working on something for this in the past:
<br>
<br>*Bug 12017*
<br><https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12017> - Move
<br>language description out of database
<br>
<br>Katrin
<br>
<br>On 23.04.21 04:38, dcook@prosentient.com.au wrote:
<br>>
<br>> Hi all,
<br>>
<br>> I was looking at how to add languages to the Languages drop down in
<br>> the OPAC advanced search and went down an unpleasant C4::Languages
<br>> rabbithole…
<br>>
<br>> But looking at language_descriptions, I’m wondering if perhaps we
<br>> could delete the following data, as I imagine it’s very outdated and
<br>> unused:
<br>>
<br>> MySQL [koha_kohadev]> select * from language_descriptions;
<br>>
<br>> +----------+----------+------+---------------------------------------+-----+
<br>>
<br>> | subtag | type | lang | description |
<br>> id |
<br>>
<br>> +----------+----------+------+---------------------------------------+-----+
<br>>
<br>> | opac | i | en | OPAC
<br>> | 1 |
<br>>
<br>> | opac | i | fr | OPAC
<br>> | 2 |
<br>>
<br>> | opac | i | de | OPAC
<br>> | 3 |
<br>>
<br>> | intranet | i | en | Staff Client
<br>> | 4 |
<br>>
<br>> | intranet | i | fr | Client personnel
<br>> | 5 |
<br>>
<br>> | intranet | i | de | Dienstoberfläche
<br>> | 6 |
<br>>
<br>> | prog | t | en | Prog
<br>> | 7 |
<br>>
<br>> | prog | t | fr | Prog
<br>> | 8 |
<br>>
<br>> | prog | t | de | Prog
<br>> | 9 |
<br>>
<br>> At the moment, it looks like adding a language requires manual SQL
<br>> queries to language_subtag_registry, language_descriptions, and
<br>> language_rfc4646_to_iso639. It’s a shame there is no native interface
<br>> for updating it. I imagine a plugin could work out well for it,
<br>> although I think for the library in mind they’ll probably just do a
<br>> manual insert, as it’s not worth the development cost…
<br>>
<br>> David Cook
<br>>
<br>> Software Engineer
<br>>
<br>> Prosentient Systems
<br>>
<br>> Suite 7.03
<br>>
<br>> 6a Glen St
<br>>
<br>> Milsons Point NSW 2061
<br>>
<br>> Australia
<br>>
<br>> Office: 02 9212 0899
<br>>
<br>> Online: 02 8005 0595
<br>>
<br>>
<br>> _______________________________________________
<br>> Koha-devel mailing list
<br>> Koha-devel@lists.koha-community.org
<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
<br>> website : https://www.koha-community.org/
<br>> git : https://git.koha-community.org/
<br>> bugs : https://bugs.koha-community.org/
<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210424/9acae99e/attachment-0001.htm><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 185, Issue 23<br>*******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>