I saw some other languages had localization files for specific system preferences. I had my own file before, but now I can share most of it (some things are specific to our organization).
Created attachment 122807 [details] [review] Bug 28708 : fr-CA localization file This patch adds a custom.sql file in localization/fr-CA.
Sorry Caroline, I haven't seen this one before. IMO the localization should not include your own (or company) preferences. See bellow. +UPDATE systempreferences SET value = 'fre|eng' WHERE variable = 'AdvancedSearchLanguages'; +UPDATE systempreferences SET value = 'CA' WHERE variable = 'AmazonLocale'; +UPDATE systempreferences SET value = 'père|mère|grand-parent|tuteur légal|autre' WHERE variable = 'borrowerRelationship'; +UPDATE systempreferences SET value = 'M.|Mme|Mx' WHERE variable = 'BorrowersTitles'; ok +UPDATE systempreferences SET value = 365 WHERE variable = 'ConfirmFutureHolds'; nok +UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat'; +UPDATE systempreferences SET value = 'iso' WHERE variable = 'dateformat'; ok +UPDATE systempreferences SET value = 1 where variable ='FilterBeforeOverdueReport'; +UPDATE systempreferences SET value = 'production' WHERE variable = 'finesMode'; +UPDATE systempreferences SET value = 365 WHERE variable = 'HoldsToPullStartDate'; nok +UPDATE systempreferences SET value = 'fr' WHERE variable = 'KohaManualLanguage'; +UPDATE systempreferences SET value = 'fr-CA,en' WHERE variable = 'language'; +UPDATE systempreferences SET value = 'http://www.marc21.ca/MaJ/BIB/B{FIELD}.pdf' WHERE variable = 'MarcFieldDocURL'; +UPDATE systempreferences SET value = 'pdfformat::layout3pagesfr' WHERE variable = 'OrderPdfFormat'; +UPDATE systempreferences SET value = 'fr-CA,en' WHERE variable = 'OPACLanguages'; ok +UPDATE systempreferences SET value = 0 WHERE variable = 'OpacAllowPublicListCreation'; +UPDATE systempreferences SET value = 1 WHERE variable = 'opaclanguagesdisplay'; +UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav'; +UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom'; +UPDATE systempreferences SET value = 1 WHERE variable = 'OpacSuppression'; nok +UPDATE systempreferences SET value = '0|0.05|0.09975|0.14975' WHERE variable = 'TaxRates'; ok +UPDATE systempreferences SET value = 1 WHERE variable = 'useDefaultReplacementCost'; nok Does it make sense?
I think these would be ok: +UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav'; +UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom'; The default is in English - I think in the German file some have been translated but setting them to empty is valid too.
(In reply to Katrin Fischer from comment #3) > I think these would be ok: > > +UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav'; > +UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom'; > > The default is in English - I think in the German file some have been > translated but setting them to empty is valid too. Those 2 have been removed anyway :)
Created attachment 139215 [details] [review] Bug 28708: fr-CA localization file This patch adds a custom.sql file in localization/fr-CA.
Created attachment 139560 [details] [review] Bug 28708: fr-CA localization file Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Created attachment 140160 [details] [review] Bug 28708: fr-CA localization file Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Pushed to master for 22.11. Nice work everyone, thanks!
Enhancement will not be included in 22.05.x series