https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12146

--- Comment #9 from Martin Renvoize (ashimema) 
<[email protected]> ---
Created attachment 206835
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=206835&action=edit
Bug 12146: Add full ISO 4217 currency list to sample currency data

The "Some basic currencies" optional sample dataset
(installer/data/mysql/en/optional/parameters.yml) only offered four
currencies (USD, GBP, CAD, EUR) and never populated currency.isocode,
so every sample currency's ISO code was blank after install.

Keep the existing curated set as-is (USD active by default, GBP/CAD/
EUR with their existing rates and symbols) and add the remaining
active ISO 4217 currency codes as inactive options, each with isocode
set to its own code. Precious-metal and special codes (XAU, XAG, XPD,
XPT, XTS, XXX, XDR, XBA-XBD, XSU, XUA) are excluded as they don't
represent real acquisitions currencies. rate is set to a neutral 1.0
placeholder for the generated entries, since a static sample file
can't hold meaningful live exchange rates for 150+ currencies.

Relies on the earlier commit in this series resizing currency.isocode
to CHAR(3), so every isocode value here is guaranteed to fit.

Test plan:
1) Run a fresh web installer, select "Some basic currencies..." under
   Optional data at the Default Settings step
2) Go to Administration > Currencies & Exchange rates
3) Confirm ~154 currencies are listed, each with a 3-letter ISO code,
   and only USD is active

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to