Update schedule
The update schedule is still a draft.
The pilot libraries are expected to test for 15-19 weeks (excluding the summer holidays). For other libraries we have preliminarily allocated 5 weeks for version upgrade: 3 weeks conversion and testing, 1 week for testing Finna view and moving to production, 1 week for transferring the test server resources to the next library. More accurate schedule estimate as a table.
Library | Migration and testing begins | Deployment week (library is closed for 2h-1day) | Library | Notes |
---|---|---|---|---|
Library 1, pilot | Week 15 (6.4.) | 38 (14.9.-18.9.) | HAMK | Testing at HAMK library has begun on 18.5.2020 |
Library 2, pilot | Week 15 (6.4.) | 39 (21.9.-25.9.) | Kansallisarkisto | |
Library 3, pilot | Week 15 (6.4.) | 40 (28.9.-2.10.) | XAMK | |
Library 4, pilot | Week 15 (6.4.) | 41 (5.10.-9.10.) | DIAK | |
Library 5, pilot | Week 15 (6.4.) | 42 (12.10.-16.10.) | Tritonia | |
Library 6 | Week 40 (28.9.) | 43 (19.10.-23.10.) | 3AMK-libraries | |
Library 7 | Week 41 (5.10.) | 44 (26.10.-30.10.) | Arcada | |
Library 8 | Week 42 (12.10.) | 45 (2.11.-6.11.) | ||
Library 9 | Week 43 (19.10.) | 46 (9.11.-13.11.) | MPKK | |
Library 10 | Week 44 (26.10.) | 47 (16.11.-20.11) | Humak | |
Library 11 | Week 45 (2.11.) | 48 (23.11.-27.11.) | Tilastokirjasto | |
Library 12 | Week 46 (9.11.) | 49 (30.11.-4.12.) | Hanken | |
Library 13 | Week 47 (16.11.) | 50 (7.12.-11.12.) | Varastokirjasto | Varastokirjasto wishes to upgrade in November. |
Library 14 | Week 48 (23.11.) | 51 (14.12.-18.12) | Centria | |
Library 15 | Week 49 (30.11.) | 52-1 (21.12.- | Jyväskylän yliopisto |
Functionalities potentially requiring development in the Community version
Functionality | Libraries that use it | Status | Notes | Priority |
---|---|---|---|---|
Tools => Label printer (labels to be put in backs of books) (/cgi-bin/koha/labels/oplib-label-create.pl) | 3AMK-libraries Centria | Use is being researched Just occassionally | Info on use in libraries urgent, related to a database structure change. | Aim at a plugin solution |
Expired holds tab (/cgi-bin/koha/circ/waitingreserves.pl) | 3AMK-libraries (problems with reliability of the list) | Not started | Info on use in libraries urgent, related to a database structure change. | We'll not work on it now, first test the Community Version functionalities. |
Requiring complex password based on patron category code (usually, higher requirements for staff members) (/cgi-bin/koha/admin/categories.pl => Muokkaa => Tyypin salasanakäytäntö) | Xamk: generally simplenumeric > self-service library PIN is 4 numbers ; and staff > alphanumeric), National Library | Not started | Info on use in libraries urgent, related to a database structure change. In Community Version, requirements may only be made globally. | Not urgent – libraries will direct staff and other users. |
Time that holds will wait for being checked out may be set different according to the patron group, library, or item type. (In Community Version only on sys pref level) | Not started | Is there need to be able to define different time according to the patron group, library, or item type? | ||
Holds not checked out in time: defining different fees according to the patron group, library, or item type (In Community Version on sys prefe level only?) (Making holds may be free but you need to pay a "fine" if you don't come and claim the hold before it expires.) | 3AMK-libraries National Library (fines differ according to the patron group and by item type) XAMK | Koskenee myös asiakasryhmäkohtaiset asetukset? | ||
Component part bibliographic records (e.g. a song on a CD) Also bound volume contains multiple items (several independent works bound together) | 3AMK-libraries, National Library Tritonia (bound volumes, not a priority) Varastokirjasto (also bound volumes, not a priority). Music is important, and how they show in Finna. Jyväskylän yliopisto (bound volumes, music as it comes from Melinda) Kansallisarkiston kirjasto (bound volumes) National Library (both component parts and bound volumes) | Libraries will look at the Community Version and its suitability | How to test component part functionalities - instructions: Osakohdetoiminnallisuuksien testaaminen KV-versiossa
| |
Enable making holds on a bibliographic record when there are items available in the library but these items are not eligible for holds. (Read the bug report for thorough explanation) | Tritonia (Critical) National Library (critical) Diak (Critical) Jyväskylän yliopisto (Critical) | Bug detected in Community Version | https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24683 | |
Shelf hold list (list of holds patrons have made on items in stacks, helps in picking up these items) | HAMK 3AMK | There is a shelf hold list in the National Version. In the Community Version, the list lacks critical pieces of data (like edition, etc.) | ||
Anonymized hold identifiers (when patrons can go and pick up themselves their books on hold from a dedicated shelf, they find them by an identifier in the slip between the book. Name is not used for privacy reasons.) | Tritonia XAMK Diak (Holds identifier / Other name -field in the patron record) |
Migration pipeline
Task | Status |
---|---|
Creating DB schema transformation definitions | Done |
Creating script to run before the Koha DB upgrade script, based on the definitions above | Done mostly, except for those waiting library feedback. Succesfull test conversion done with HAMK |
Script to do post-db-upgrade transformations in DB | Not started (might not be required) |
Notices from testing migration
Date | Description | Note | Reported by | Testing environment |
---|---|---|---|---|
May 26th | all tables show different timestamp (-3 hours) on migration database than on current database (f.ex. action_logs.action_id 1586094 has timestamp 2020-05-12 03:00:17 on current database and 2020-05-12 00:00:17 on migrated database | Minna Kivinen | HAMK | |
May 27th | On current version there is action_logs_cache table containing all actions, such table does not exist in version 19.11. Action_logs -table contains only actions for 6 months. | This might have affects on our current way to calculate last years statistics using action logs. Is it Koha-Suomi version feature that 6 months older action_logs events are moved to action_logs_cache? Should action_logs_cache table to be migrated to action_logs -table? If so, does it have some affects to performance? | Minna Kivinen | HAMK |
May 27th | https://tiketti.koha-suomi.fi/issues/3559 Kuljetustilassa olevan varatun niteen voi lainata automaatilla | This bug fix made to Koha-Suomi is needed. Other borrower can check out a book that is reserved for another borrower when the book is tranferred to pickup branch. | Minna Kivinen | HAMK |
Mey 28th | https://tiketti.koha-suomi.fi/issues/856 Automaatit ja varattu aineisto | This bug fix made to Koha-Suomi is needed. When a book is returned by self service station and there is a reservation, the pickup notice should not be send until the book is returned again by staff. There is a syspreff for this feature in Koha-Suomi RequireSCCheckInBeforeNotifyingPickups. | Minna Kivinen | HAMK |