- Koha-bugs - lists.koha-community.org

[Bug 42509] New: Use API to retrieve and update patrons via Batch patron deletion and anonymization tool
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42509 Bug ID: 42509 Summary: Use API to retrieve and update patrons via Batch patron deletion and anonymization tool Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The Batch patron deletion and anonymization tool (cleanborrowers.pl) can be slow for larger systems. It should be updated to use the API. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 11

[Bug 42444] New: Update waitingreserves.pl to use API to fetch data
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42444 Bug ID: 42444 Summary: Update waitingreserves.pl to use API to fetch data Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle(a)bywatersolutions.com The Holds Awaiting Pickup page is a pain point for larger systems with many holds. We should update how it fetches, displays, and interacts with data. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 86

[Bug 42443] New: Update transferstoreceive.pl to use the API to fetch transfer information
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42443 Bug ID: 42443 Summary: Update transferstoreceive.pl to use the API to fetch transfer information Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle(a)bywatersolutions.com The Transfers to Receive page is a pain point for larger systems with many transfers. We should update it to fetch data via API. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 59

[Bug 43616] New: Add core support for scheduled/automated patron import (RFC)
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43616 Bug ID: 43616 Summary: Add core support for scheduled/automated patron import (RFC) Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)openfifth.co.uk QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle(a)bywatersolutions.com Target Milestone: --- This bug proposes adding native support to Koha core for scheduled, unattended patron imports -- something core currently lacks entirely. Today, Koha's patron import tooling (tools/import_borrowers.pl, misc/import_patrons.pl, Koha::Patrons::Import) is manual-trigger only. There is no way to configure a remote source and have Koha fetch and import an updated patron file on a schedule without a human clicking "import" or a hand-rolled external script. In practice, this gap has been filled by third-party plugins -- most notably koha-plugin-patrons-importer-advanced, which has real production customers depending on scheduled SFTP-sourced patron imports, including requests to run more than once per day. That plugin work highlighted exactly what's missing from core. This RFC proposes closing the gap with the same pattern Koha already uses for a very similar problem: bug 43603 (scheduled article request scan import), which polls a configured Koha::File::Transport (bug 35761) for new files and imports them, with a DB-backed idempotency log so repeated/frequent polling is safe. Proposed for core: - New tables patron_import_accounts and patron_import_log, mirroring the article_request_scan_accounts / article_request_scan_log pattern from bug 43603 (an account references a Koha::File::Transport, a matchpoint, defaults/preserve-fields, and an active flag; the log table records per-file processed/error status keyed by account and filename for idempotency). - A new admin config page, admin/patron_import_accounts.pl, modeled on admin/article_request_scan_accounts.pl, for configuring named import sources. - A new cronjob, misc/cronjobs/patron_imports.pl, modeled on misc/cronjobs/article_request_scans.pl, that polls active accounts, fetches new files via their configured file transport, and imports them via the existing Koha::Patrons::Import engine (no changes needed to the import engine itself -- this only adds scheduling/fetch infrastructure around it). This is Phase B of a small roadmap; a follow-up bug (Phase C) would apply the same pattern to scheduled patron photo import. This bug's scope is Phase B only: scheduled patron record import. No patch is attached yet. This bug is filed to open discussion on the design (in particular, whether the article-request-scan pattern from bug 43603 is the right one to reuse here) before implementation begins. Depends on: bug 35761 (Koha::File::Transport) See also: bug 43603 (article request scan import -- the precedent this design follows) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 15

[Bug 12146] Add new ISO code column to currency sample files
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12146 --- Comment #15 from Martin Renvoize (ashimema) <martin.renvoize(a)openfifth.co.uk> --- Revised series (4 patches now): - Added the common currency symbol/abbreviation for each generated ISO 4217 entry (not just the four originally curated ones). - Added a 4th patch: pl-PL, ru-RU, nb-NO and uk-UA's localization/ custom.sql each insert their own region currency (PLN/UAH/RUB/NOK). Since those codes are now also in the base optional set, a locale install that selects both would hit a primary key collision on the plain INSERT and silently lose the locale's rate/symbol/active override. Switched those to INSERT ... ON DUPLICATE KEY UPDATE and set isocode on them too. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12146] Add new ISO code column to currency sample files
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12146 --- Comment #14 from Martin Renvoize (ashimema) <martin.renvoize(a)openfifth.co.uk> --- Created attachment 206840 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=206840&action=e… Bug 12146: Set isocode on locale-specific sample currencies, and avoid collisions with the base currency set pl-PL, ru-RU, nb-NO, and uk-UA's localization/custom.sql each insert their own region-specific currencies (PLN, UAH, RUB, NOK) on top of whatever sample data set the installer user selected. Since the previous commit in this series added every active ISO 4217 code (including these four) to the base "Some basic currencies" optional dataset, an installer run in one of these locales that also selects that optional dataset would now hit a primary key collision: the locale file's plain INSERT would fail silently (load_sql just warns and moves on), leaving the generic blank-symbol/inactive row from the base set in place instead of the locale's own rate/symbol/active values. Switch these INSERTs to INSERT ... ON DUPLICATE KEY UPDATE so they correctly override the base set's entry for the same currency regardless of load order, and set isocode on each of them - the original ask of this bug, just never delivered for anything beyond the English dataset. Test plan: 1) Load installer/data/mysql/en/optional/parameters.yml, then run one of these localization/*/custom.sql files against the same database and confirm no errors and the currency ends up active with its locale-specific rate/symbol (e.g. for pl-PL: SELECT * FROM currency WHERE currency = 'PLN' should show isocode='PLN', symbol='zł', active=1) 2) Run a fresh web installer choosing the pl-PL (or ru-RU/nb-NO/uk-UA) language and the "Some basic currencies..." optional dataset, confirm the locale's currency ends up active with the right symbol -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12146] Add new ISO code column to currency sample files
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12146 --- Comment #13 from Martin Renvoize (ashimema) <martin.renvoize(a)openfifth.co.uk> --- Created attachment 206839 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=206839&action=e… 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 and its common currency symbol/abbreviation (sourced from Wikipedia's "List of circulating currencies", with a handful of targeted lookups for entries missing there). A number of currencies legitimately share the same symbol (e.g. "$" is used by over twenty of them) - that's harmless here since only the single active currency's symbol is ever used for price formatting; the rest are purely informational in the admin currency list. 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 a currency symbol, and only USD is active -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12146] Add new ISO code column to currency sample files
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12146 --- Comment #12 from Martin Renvoize (ashimema) <martin.renvoize(a)openfifth.co.uk> --- Created attachment 206838 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=206838&action=e… Bug 12146: Automated Schema Update -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12146] Add new ISO code column to currency sample files
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12146 --- Comment #11 from Martin Renvoize (ashimema) <martin.renvoize(a)openfifth.co.uk> --- Created attachment 206837 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=206837&action=e… Bug 12146: Resize currency.isocode to CHAR(3) ISO 4217 alpha currency codes are always exactly three letters, but currency.isocode was a free-text varchar(5) with no format enforcement on the admin Currencies form (just maxlength="5", matching the column). That mismatch meant code relying on isocode being a valid ISO 4217 code (e.g. SIP2's fixed-width BH currency field) couldn't trust it. Resize the column to CHAR(3), normalizing existing data first: uppercase any value that already fits, and clear anything that doesn't so the resize can't silently truncate bad data. Shrink the admin form's ISO code field to match (maxlength="3"). Also fixes two Currencies.t test fixtures ('isoc1'/'isoc2') that no longer fit the new column width. Test plan: 1) prove t/db_dependent/Koha/Acquisition/Currencies.t 2) perl installer/data/mysql/updatedatabase.pl 3) Go to Administration > Currencies, edit a currency, confirm the ISO code field only accepts 3 characters -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12146] Add new ISO code column to currency sample files
by bugzilla-daemon＠bugs.koha-community.org 25 Sep '26

25 Sep '26

1 0