Bugzilla – Attachment 55552 Details for
Bug 14707
Change UsageStatsCountry from free text to a dropdown list
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14707: Update existing installations and correct wrong values
Bug-14707-Update-existing-installations-and-correc.patch (text/plain), 3.31 KB, created by
Jonathan Druart
on 2016-09-14 12:00:58 UTC
(
hide
)
Description:
Bug 14707: Update existing installations and correct wrong values
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2016-09-14 12:00:58 UTC
Size:
3.31 KB
patch
obsolete
>From 40e3d6843df9058e53f52b0bceeecde4e7dd59be Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Wed, 14 Sep 2016 11:07:58 +0100 >Subject: [PATCH] Bug 14707: Update existing installations and correct wrong > values > >See http://hea.koha-community.org/, the countries are filled is wrong >values. >If we decide to update the free text with a dropdown list, we need to >handle these wrong data. > >Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >--- > installer/data/mysql/atomicupdate/bug_14707.sql | 18 ++++++++++++++++++ > .../prog/en/modules/admin/preferences/admin.pref | 2 +- > 2 files changed, 19 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_14707.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_14707.sql b/installer/data/mysql/atomicupdate/bug_14707.sql >new file mode 100644 >index 0000000..21c8709 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_14707.sql >@@ -0,0 +1,18 @@ >+UPDATE systempreferences SET type="Choice" where variable="UsageStatsLibraryType"; >+ >+UPDATE systempreferences SET value="Canada" WHERE variable="UsageStatsCountry" AND value="CANADA"; >+UPDATE systempreferences SET value="Czech Republic" WHERE variable="UsageStatsCountry" AND value="CZ"; >+UPDATE systempreferences SET value="United Kingdom" WHERE variable="UsageStatsCountry" AND (value="England" OR value="UK"); >+UPDATE systempreferences SET value="Spain" WHERE variable="UsageStatsCountry" AND value="España"; >+UPDATE systempreferences SET value="Greece" WHERE variable="UsageStatsCountry" AND value="GR"; >+UPDATE systempreferences SET value="Ireland" WHERE variable="UsageStatsCountry" AND value="Irelanbd"; >+UPDATE systempreferences SET value="Mexico" WHERE variable="UsageStatsCountry" AND value="México"; >+UPDATE systempreferences SET value="Peru" WHERE variable="UsageStatsCountry" AND value="Perú"; >+UPDATE systempreferences SET value="Dominican Rep." WHERE variable="UsageStatsCountry" AND value="República Dominicana"; >+UPDATE systempreferences SET value="Trinidad & Tob." WHERE variable="UsageStatsCountry" AND value="Trinidad"; >+UPDATE systempreferences SET value="Turkey" WHERE variable="UsageStatsCountry" AND value="Türkiye"; >+UPDATE systempreferences SET value="USA" WHERE variable="UsageStatsCountry" AND (value="United States" OR value="United States of America" OR value="US"); >+UPDATE systempreferences SET value="Zimbabwe" WHERE variable="UsageStatsCountry" AND value="Zimbabbwe"; >+ >+ >+ >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref >index 8a8aee5..4f3fb14 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref >@@ -402,7 +402,7 @@ Administration: > academic : "academic" > research : "research" > private : "private" >- societyAssoc: "society or association" >+ societyAssociation: "society or association" > corporate : "corporate" > government : "government" > religiousOrg: "religious organization" >-- >2.8.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14707
:
41789
|
44929
|
55550
|
55551
|
55552
|
55637
|
55638