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 estimates as a table.
Library | Migration and testing begins | Deployment week (library is closed for 2h-1day) | Library | Notes |
---|---|---|---|---|
Library 1, pilot | Week 21 (18.5.) | 38 (14.9.-18.9.) | HAMK | Test migrations started on 18.5.2020 |
Library 2, pilot | Week 24 (11.6.) | 40 (28.9.-2.10.) | XAMK | Test migrations started on 11.6.2020 |
Library 3, pilot | Week 30 (20.7.) | 39 (21.9.-25.9.) | Kansallisarkisto | Test migrations started on 07.08.2020 |
Library 4, pilot | Week 33 (10.8.) | 41 (5.10.-9.10.) | DIAK | Test migrations started on 07.08.2020 |
Library 5, pilot | Week 35 (24.8.) | 42 (12.10.-16.10.) | Tritonia | Test migrations started on 07.08.2020 |
Library 6 | Week 40 (28.9.) | 43 (19.10.-23.10.) | 3AMK-libraries | Not started |
Library 7 | Week 41 (5.10.) | 44 (26.10.-30.10.) | Arcada | Not started |
Library 8 | Week 42 (12.10.) | 45 (2.11.-6.11.) | ||
Library 9 | Week 43 (19.10.) | 46 (9.11.-13.11.) | MPKK | Not started |
Library 10 | Week 44 (26.10.) | 47 (16.11.-20.11) | Humak | Not started |
Library 11 | Week 45 (2.11.) | 48 (23.11.-27.11.) | Tilastokirjasto | Not started |
Library 12 | Week 46 (9.11.) | 49 (30.11.-4.12.) | Hanken | Not started |
Library 13 | Week 47 (16.11.) | 50 (7.12.-11.12.) | Varastokirjasto | Not started, Varastokirjasto wishes to upgrade in November. |
Library 14 | Week 48 (23.11.) | 51 (14.12.-18.12) | Centria | Not started |
Library 15 | Week 49 (30.11.) | 52-1 (21.12.- | Jyväskylän yliopisto | Not started |
ROWS COLORS LEGEND FOR TABLE BELOW:
white (new task) | a freshly added task, undecided (it even might be a proposal, which "in discussion" and might be even rejected) |
red (to do / in progress) | accepted task: to be implemented, or in progress but not yet finished, i.e. "in development or in queue" |
yellow (done locally, KCMinni) | implemented, pushed to our KCMinni fork for testing in preproduction and/or using in KohaCommunity SUOMI fork already. note: such tasks might stay forever or for a long time if they won't be accepted by KC for various reasons. |
green (done worldwide) | implemented, and also accepted into KC-master (KohaCommunity master), i.e. "worldwide version" or can be achieved in another way (plugin, etc) |
Functionalities potentially requiring development in the Community version
p r i o | #NN: TASK NAME | Libraries that use/requested it | Notes | STATUSES Tech expertise message |
---|---|---|---|---|
2.1 | #01: LABEL PRINTER – TARRATULOSTIMET Tools => Label printer (labels to be put in backs of books) (/cgi-bin/koha/labels/oplib-label-create.pl) KC BUGZILLA: none, aim at a plugin solution | 3AMK-libraries Centria | Use is being researched. Just occasionally Info on use in libraries urgent, related to a database structure change. Testing of current options: Label printing in Koha | DEVELOPMENT STATUS: EXTERNAL solved as an external plugin: proper configuration needed, tech assistance will be provided. |
3.2 | #02: EXPIRED HOLDS TAB – VANHENTUNEIDEN VARAUSTEN VÄLILEHTI Circulation → Holds awaiting pickup / Expired holds (list of items someone has made a hold request on but does not check it out before the hold expires; handy for easy clearing of these items off the holds shelf). (/cgi-bin/koha/circ/waitingreserves.pl) KC BUGZILLA: none | 3AMK-libraries XAMK Centria Diak | Info on use in libraries urgent, related to a database structure change. On community version there is missing system preference: ExpireReservesMaxPickUpDelay system preference allow holds to expire automatically if they have not been picked by within the time period specified in ReservesMaxPickUpDelay. 3AMK-libraries: problems with the reliability of the list | DEVELOPMENT STATUS: IN QUEUE Not started We'll not work on it now, first test the Community Version functionalities. |
3.2 | #03: COMPLEX PASSWORDS / POLICIES CHECK – VAIKEAN SALASANAN VAATIMINEN Requiring complex password based on patron category code (usually, higher requirements for staff members) Administration → Patron categories / Password policy for category (/cgi-bin/koha/admin/categories.pl => Muokkaa => Tyypin salasanakäytäntö) KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23816 | XAMK National Library | Info on use in libraries urgent, related to a database structure change. XAMK: generally simplenumeric > self-service library PIN is 4 numbers; and staff > alphanumeric) | DEVELOPMENT STATUS: IN QUEUE Not started Not urgent – libraries will direct staff and other users. |
3.4 | #04: HOLDS WAITING DEPENDING ON RULES – VARAUSTEN VOIMASSAOLON PITUUDEN SÄÄNNÖT The time that holds will wait for being checked out may be set differently according to the patron group, library, or item type. (In Community Version only on sys pref level) KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8367 | There is a very old bug report and fix-suggestion for this in Bugzilla: How long is a hold waiting for pickup at a more granular level Is there need to be able to define different time according to the patron group, library, or item type? | DEVELOPMENT STATUS: DEBATES Not needed? | |
1.3 | #05: DEFINING DIFFERENT FEES ACCORDING TO THE RULES – MAKSUJEN SUURUUDEN SÄÄNNÖT Holds not checked out in time: defining different fees according to the patron category, branch (library), or item type (In Community Version on sys pref 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.) KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25711 | 3AMK-libraries National Library XAMK | Koskenee myös asiakasryhmäkohtaiset asetukset? - MinnaK: Mitä tällä tarkoitetaan. Asiakastyyppien määrityksissä on hold fee, jolla tarkoitetaan varausmaksua joka peritään varauksesta joka tapauksessa. Tässä toiminnossa tarkoitetaan maksua, joka peritään, jos asiakas ei nouda varaustaan ajoissa. and this discussion in english There is a hold fee -setting in patron categories, but it is a different thing. Patron category hold fee is charged when making a hold or when hold is picked up depending on system preference HoldFeeMode. In this case we are discussing about fee that is charged if a patron does not pick up hold in time. National Library: fines differ according to the patron category and by item type | DEVELOPMENT STATUS: DONE Minna will try to test and sign off in bugzilla - Not able to test on sandbox, because there is not possible to update the expiration date. |
2.2 | #06: COMPONENT PART BIBLIOGRAPHIC RECORDS – OSAKOHTEIDEN BIBLIOGRAFISET TIETUEET (e.g. a song on a CD) Also, bound volume contains multiple items (several independent works bound together) KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11175 | 3AMK-libraries National Library Tritonia Varastokirjasto Jyväskylän yliopisto Kansallisarkisto Library of Statistics | How to test component part functionalities - instructions: Osakohdetoiminnallisuuksien testaaminen KV-versiossa
National Library: both component parts and bound volumes 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 Kansallisarkisto: bound volumes | DEVELOPMENT STATUS: DONE Implemented but missing review, see Bug 11175 Johanna asks from Metropolia testing for this: for sign off, community bug must be tested according to test plan in bugzilla and also Koha OPAC must be tested. |
1 | #07: HOLDS ON BIBLIOS WITH DIFFERENT ITEM TYPES – VARAUS MAHDOLLINEN, JOS KIRJASTOSSA VAIN EI-LAINATTAVIA 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) KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24683 | Tritonia National Library Diak Jyväskylän yliopisto Hanken 3AMK | Tritonia, National Library, Diak, Jyväskylän yliopisto, Hanken: Critical 3AMK: We allow on shelf holds, but this is critical if unholdable item type prevents making holds for other item types of the same biblio | DEVELOPMENT STATUS: DONE Implemented. In testing on pilot servers. Tested in Koha3 and Tritonia testing environment. Must be tested with Finna, when able to make holds |
1 | #08: "HOLDS TO PULL" LIST PART1: – POISTETTAVIEN VARATTUJEN LISTA printing of "edition" under the title in the same field. KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25699 | HAMK 3AMK | Edition can be add to biblioitems -table by modifying Koha to MARC mapping settings. | DEVELOPMENT STATUS: DONE Implemented. In testing on pilot servers. |
1 | #09: ANONYMIZED HOLD IDENTIFIERS – VARATTUJEN ANONYYMIT TUNNISTEET 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. KC BUGZILLA: none | Tritonia XAMK Diak | On Koha-Suomi there is a systempreference AnonymizeOtherNames use for generating an anonymized code to Patron record Other names -field. The anonymized code is in the format xxxx-xxxx-xxxx (e.g. 1561-9855-2076) and is based on UNIX timestamp. Other names -field is used for hold identifier. Diak: Holds identifier / Other name -field in the patron record | DEVELOPMENT STATUS: DONE Implemented. In testing on pilot servers. requires pasting code snippet to system preference IntranetUserJS. Code is found HERE |
1.1 | #10: SELF CHECK MACHINE STARTS THE HOLD INSTANTLY – SAAPUMISILMOITUS LÄHETETTÄVÄ VASTA HENKILÖKUNNAN KÄSITTELYN JÄLKEEN RequireSCCheckInBeforeNotifyingPickups –pick-up notifications for holds not sent to patrons until an item has been handled by staff in intranet, even though the item has been returned using a self-service machine KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12556 | Tritonia HAMK National Library XAMK Jyväskylän yliopisto 3AMK | 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 https://tiketti.koha-suomi.fi/issues/856 / Automaatit ja varattu aineisto There are some ideas of how to fix already discussed in KC BZ. | DEVELOPMENT STATUS: DONE Waiting for someone in Koha community to sign off. Minna asks Koha-Suomi if they would be able to test and sign off. - asked, Koha-Suomi has no environment for testing this at the moment. Adrii has published in KCMinni Minna has tested in SRV1, but did not work. Test results informed in slack. |
1.2 | #11: DO NOT ALLOW SELF SERVICE CHECK OUT WHEN ON HOLD AND IN TRANSFER – KULJETUTUSTILAISTEN LAINAAMINEN AUTOMAATILLA ESTETTÄVÄ https://tiketti.koha-suomi.fi/issues/3559 / Kuljetustilassa olevan varatun niteen voi lainata automaatilla When book is returned on self service station and there is a hold to another branch for that book, the item is put to transfer. When AllowItemsOnHoldCheckout -syspreff is set Allow, any borrower can check out the item with self service station despite of the hold. Item stays attached to hold and items stays in transfer -state. KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25690 | HAMK XAMK 3AMK | Bug fix needed: The system should not allow item check out on self service station when item is attached to hold and item is in transfer -state (item is in BranchTransfers -table and . | DEVELOPMENT STATUS: DOING in development |
1 | #12: CCODE AND SHELVING LOCATION IN CIRCULATION RULES – CCODE JA HYLLYPAIKAT LAINAUSSÄÄNTÖJEN PERUSTAKSI Add new ccode and shelving location based circulation rules. This was including db, filtering, and tests. KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17593 | There is a new feature in community version relating to this issue: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21946 | DEVELOPMENT STATUS: DONE, TEST Implemented. In testing on pilot servers. | |
3.1 | #13: LOG OF READING PATRON PERSONAL INFORMATION – ASIAKKAIDEN HENKILÖTIETOJEN KATSELUN LOKITTAMINEN Is Koha-Suomi version there is logged every view of patron personal information. That is not happening in the community version KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25673 | More information on viewing patron information is gathered here Viewing of patron information. We ought to make a decision on what to log when viewing personal information. | DEVELOPMENT STATUS: IN QUEUE | |
1.5 | #14: "HOLDS TO PULL" LIST: FURTHER CHANGES – POISTETTAVIEN VARATTUJEN LISTA, LISÄMUUTOKSIA The publication year should be shown. MARC fields 260c, 264c. KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25798 | (list of holds patrons have made on items in stacks, helps in picking up these items) Circulation → Holds to pull /cgi-bin/koha/circ/pendingreserves2.pl (Koha Suomi -version) | DEVELOPMENT STATUS: DONE Implemented. In testing on pilot servers. | |
1.4 | #15: HOLDS QUEUE LIST – VARAUSJONO The edition should be shown. KC BUGZILLA: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25799 | Edition can be add to biblioitems -table by modifying Koha to MARC mapping settings. After change, biblioitems -table must be rebuild in order to apply change to older records! | DEVELOPMENT STATUS: DONE Implemented. In testing on pilot servers. | |
3.3. | #16: Link to Finna from Koha biblio-record – KOHAN BIB-TIETUEESTA LINKKI FINNAAN Link to Finna from Koha biblio-record. <Finna-view address>/Record/<Finna local database>.biblionumber | IntranetUserJS solution 3AMK: Possibility to add more than one Finna-view link?
| DEVELOPMENT STATUS: DONE Implemented as IntranetUserJS: https://tiketti.koha-suomi.fi/projects/koha-suomen-dokumentaatio/wiki/IntranetUserJS#Linkki-Finna-n%C3%A4kym%C3%A4%C3%A4n | |
1.6 | #17 Holds to available items should not show all items reserved in Finna When making holds to items available all items show reserved even when there is just one hold. Instead on showing all items reserved, they items not having item level hold should show available. | |||
#18 Export holdings-option missing in export.pl |
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. Successful 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&number | Description | Note | Reported by | Testing environment | Statuses |
---|---|---|---|---|---|
May 26th #T1 | 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 | System time on HAMK testing server is set on wrong time zone. | Minna Kivinen | HAMK | |
May 27th #T2 | 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 | ||
Aug 19th #T3 | Acquisitions > Click Spent > Internal server error | toimii viimeisimmässä master-versiossa. josko yhteisössä on ollut väliaikaisesti joku ongelma tai sitten migraatiossa on ongelma | Mia Kujala | Xamk | |
Aug 19th #T4 | In Finnish interface: Hankinta (Acquisitions) - Uusi toimittaja (New vendor) > Internal server error. But in English interface it is working. | I re-checked and forced translations to update, but it is still there, it is extra % in template (%</li>) | Mia Kujala | Xamk | |
Aug 19th #T5 | Patron - Accounting - Create manual invoice - Type > there is two selections: Unexpected type found during upgrade | replied to a thread: Patron - Accounting - Create manual invoice - Type > there is two selections: Unexpected type found during upgrade we have these values in debit types admin database: .../admin/debit_types.pl so they can be edited, but seems these are differs from old KohaSuomi? Which ones should be? NOTE 4 all srv1-srv5 servers: this varies across our test servers, but seems most except arkisto some had some extra ODUE/Pay/W/ODUEC/Kauko types before | Mia Kujala | Xamk | |
Aug 19th #T6 | In circulation and fines rules the information in the columns is under the wrong title and rules cannot edit. Click Edit and existing values do not appear. Insert new value and save > Value doesn't change. | Mia Kujala | Xamk | ||
Aug 19th #T7 | Finnassa havaitut ongelmat:
| Mia Kujala | Xamk | ||
Aug 19th #T8 | <<borrowers.totalfine>> is no longer working in the receipts | Mia Kujala | Xamk | ||
Aug 19th #T9 | Patron information > Print menu > Print fines -receipt is missing | Mia Kujala | Xamk | ||
Aug 19th #T10 | Patron information > Accounting > Transactions > Print (individual payment information) > blank view, no receipt | The default receipt base was empty | Mia Kujala | Xamk | Problem solved |
Aug 21st #T11 | Finna: Migrated patron fines are not showing right in Finna. Sometimes total amount is showing, but not detailed information and sometimes it is not showing any fines. Bug found in master: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26271 Call to /api/v1/patrons/<patron_id>/account returns 500 error if manager_id is NULL | Minna Kivinen | HAMK | Bug fixed in master (needs sign off) |