Send Koha-devel mailing list submissions to
    koha-devel@lists.koha-community.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
    koha-devel-request@lists.koha-community.org

You can reach the person managing the list at
    koha-devel-owner@lists.koha-community.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."

Today's Topics:

1. Re: Deleting entries from language_descriptions (Katrin Fischer)

----------------------------------------------------------------------

Message: 1
Date: Sat, 24 Apr 2021 10:44:53 +0200
From: Katrin Fischer <katrin.fischer.83@web.de>
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] Deleting entries from language_descriptions
Message-ID: <9024ce9f-1939-d2fc-2d28-1270d8bef5c7@web.de>
Content-Type: text/plain; charset="utf-8"; Format="flowed"

Hi David,

it seems likely that these are unused. It would be nice to update our
structure there, especially for easier translations. Bernardo has been
working on something for this in the past:

*Bug 12017*
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12017> - Move
language description out of database

Katrin

On 23.04.21 04:38, dcook@prosentient.com.au wrote:
>
> Hi all,
>
> I was looking at how to add languages to the Languages drop down in
> the OPAC advanced search and went down an unpleasant C4::Languages
> rabbithole…
>
> But looking at language_descriptions, I’m wondering if perhaps we
> could delete the following data, as I imagine it’s very outdated and
> unused:
>
> MySQL [koha_kohadev]> select * from language_descriptions;
>
> +----------+----------+------+---------------------------------------+-----+
>
> | subtag   | type     | lang | description                           |
> id |
>
> +----------+----------+------+---------------------------------------+-----+
>
> | opac     | i        | en   | OPAC
> |   1 |
>
> | opac     | i        | fr   | OPAC
> |   2 |
>
> | opac     | i        | de   | OPAC
> |   3 |
>
> | intranet | i        | en   | Staff Client
>                    |   4 |
>
> | intranet | i        | fr   | Client personnel
> |   5 |
>
> | intranet | i        | de   | Dienstoberfläche
> |   6 |
>
> | prog     | t        | en   | Prog
> |   7 |
>
> | prog     | t        | fr   | Prog
> |   8 |
>
> | prog     | t        | de   | Prog
> |   9 |
>
> At the moment, it looks like adding a language requires manual SQL
> queries to language_subtag_registry, language_descriptions, and
> language_rfc4646_to_iso639. It’s a shame there is no native interface
> for updating it. I imagine a plugin could work out well for it,
> although I think for the library in mind they’ll probably just do a
> manual insert, as it’s not worth the development cost…
>
> David Cook
>
> 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@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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210424/9acae99e/attachment-0001.htm>

------------------------------

Subject: Digest Footer

_______________________________________________
Koha-devel mailing list
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/

------------------------------

End of Koha-devel Digest, Vol 185, Issue 23
*******************************************