https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12146 --- Comment #9 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- 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.