Bug 12250

Summary: Update descriptions for languages, scripts and regions
Product: Koha Reporter: Bernardo Gonzalez Kriegel <bgkriegel>
Component: I18N/L10NAssignee: Bernardo Gonzalez Kriegel <bgkriegel>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: f.demians, fridolin.somers, nengard, novamcccharles, tomascohen
Version: Main   
Hardware: All   
OS: All   
See Also: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9056
Change sponsored?: --- Patch complexity: Medium patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on:    
Bug Blocks: 13328    
Attachments: Bug 12250 - Add Kurdish Language
Bug 12250: Update descriptions for languages, scripts and regions
Bug 12250: Update descriptions for languages, scripts and regions
[PASSED QA] Bug 12250: Update descriptions for languages, scripts and regions

Description Bernardo Gonzalez Kriegel 2014-05-13 19:48:28 UTC
Add Kurdish language
[+] Comment 1 Bernardo Gonzalez Kriegel 2014-05-13 21:03:21 UTC Comment hidden (obsolete)
Comment 2 Fridolin Somers 2014-05-14 09:02:14 UTC
Sounds great.

Just a question, should the description always be in plain text or in HTML-encoded ?
For example the patch adds :
VALUES( 'lo', 'language', 'lo', '&#3742;&#3762;&#3754;&#3762;&#3749;&#3762;&#3751;');
Comment 3 Bernardo Gonzalez Kriegel 2014-05-14 11:12:07 UTC
(In reply to Fridolin SOMERS from comment #2)
> Just a question, should the description always be in plain text or in
> HTML-encoded ?
> For example the patch adds :
> VALUES( 'lo', 'language', 'lo',
> '&#3742;&#3762;&#3754;&#3762;&#3749;&#3762;&#3751;');

That value and similar ones are present on EN version of file, not added by me.

I prefer plain text, and have a patch to complete/update language descriptions.
But also have Bug 12017 to remove language descriptions from database. 
Until I get a comment on it (against or for), I will not update lang descriptions on database, but anyone can :)
Comment 4 Bernardo Gonzalez Kriegel 2014-11-02 01:40:55 UTC
Changing description to reflect broader scope
[+] Comment 5 Bernardo Gonzalez Kriegel 2014-11-02 01:43:05 UTC Comment hidden (obsolete)
Comment 6 Bernardo Gonzalez Kriegel 2014-11-02 11:35:45 UTC
*** Bug 5686 has been marked as a duplicate of this bug. ***
[+] Comment 7 Tomás Cohen Arazi (tcohen) 2014-11-06 17:02:31 UTC Comment hidden (obsolete)
Comment 8 Katrin Fischer 2014-11-06 20:49:59 UTC
Created attachment 33348 [details] [review]
[PASSED QA] Bug 12250: Update descriptions for languages, scripts and regions

This patch adds/updates languages, scripts and regions to
reflect what we currently have on translation server.

Languages, scripts and regions are ordered by respective code

To test:
1. Apply the patch
2. run updatedatabase.pl, must run without errors
3. Go to advanced search (opac/staff), more options, and check
language pulldown (verify you have an empty AdvancedSearchLanguages
syspref)
4. Remove contents from language_descriptions, language_rfc4646_to_iso639,
language_script_bidi, language_script_mappin and language_subtag_registry
5. Load installer/data/mysql/mandatory/subtag_registry.sql,
must load without errors
6. Repeat 3

Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Tested the SQL, no problems found.
Comment 9 Tomás Cohen Arazi (tcohen) 2014-11-07 18:23:48 UTC
Patch pushed to master.

Thanks Bernardo!
Comment 10 Nick Clemens (kidclamp) 2023-04-26 18:13:17 UTC
*** Bug 13015 has been marked as a duplicate of this bug. ***