Release Notes ============== 6.7.23.7( 7 Oct 2024) - include index at start of User Guide 6.7.23.6(27 Aug 2024) - refactor more sparse collection handling in summary job (ml_trunk_24_005) 6.7.23.5(26 Aug 2024) - refactor sparse collection handling in summary job (ml_trunk_24_004) 6.7.23.4( 4 Aug 2024) - User Guide updated (attribute groups) 6.7.23.3(30 Jun 2024) - new label type Q-Connect KF26051 (ml_trunk_24_003) 6.7.23.2(10 Jun 2024) - further simplify flexilist logic (ml_fir_24_006) 6.7.23.1(10 Jun 2024) - simplify flexilist logic (ml_fir_24_005) 6.7.23 ( 8 Jun 2024) - refactor main listing page bind-vars and session-vars 6.7.22 (31 May 2024) - include row-filtering in Flexi-download (ml_fir_24_004) 6.7.21.4(14 May 2024) - fixed bug in previous release (ml_trunk_24_002.2) 6.7.21.3(14 May 2024) - improved fix so duplicate-partset works consistently (ml_trunk_24_002) 6.7.21.2( 5 May 2024) - fix bug in add-partset (ml_trunk_24_001) 6.7.21.1(14 Apr 2024) - use end loop labels for clarity (ml_rose_24_002) 6.7.21 ( 5 Apr 2024) - fixes/improvements to consistency in flexi-download and screen formatting (ml_fir_24_003) 6.7.20.1(29 Mar 2024) - fix subtitle in flexi download (ml_fir_24_002) 6.7.20 (18 Mar 2024) - new displayable column LAST_ISSUE_DATE (ml_fir_24_001) 6.7.19 ( 3 Mar 2024) - pieces loop further optimisation 6.7.18 ( 7 Jan 2024) - administrator can set default label type (ml_rose_24_001) 6.7.17.2(30 Dec 2023) - fix bug in flexilist download (ml_fir_23_005) 6.7.17.1(24 Nov 2023) - extra info about issue status in labelled-copy checkin quick-summary (ml_fir_23_004) 6.7.17 (16 Nov 2023) - include PROG_NOTES in programmes csv download (requested by FBCSA) 6.7.16.7(24 Sep 2023) - drop redundant layout column (ml_rose_23_008) 6.7.16.6(12 Aug 2023) - remove redundant non-JSON-type summary columns (ml_rose_23_007) 6.7.16.5(11 Aug 2023) - JSON summary columns (ml_rose_23_006) 6.7.16.4(26 Jul 2023) - remove duplicates from bible-refs JSON (ml_trunk_23_006) 6.7.16.3(19 Jul 2023) - csv loader auto-allocate store_locn (ml_trunk_23_005) 6.7.16.2(17 Jul 2023) - new label definition (LABELS4U33) (ml_trunk_23_004) 6.7.16.1( 9 Jul 2023) - new cols on STAGE_TBL (ATTR_VAL1-9) and modified loader script, package. (ml_trunk_23_003) 6.7.16 (17 Jun 2023) - clear-filter menu shortcut 6.7.15.1(22 May 2023) - shorten text in piece title on label (ml_trunk_23_002) 6.7.15 (21 May 2023) - PHP loop optimisations (pieces, mlfuncs) 6.7.14 (21 May 2023) - minor tidy-up of pieces.php 6.7.13 (13 May 2023) - extended function for comp/arr/lyrics/editor names 6.7.12c (13 May 2023) - category pkg fix (ml_fir_23_003) 6.7.12b (13 May 2023) - category description uniqueness & data-fix (ml_fir_23_002) 6.7.12 ( 8 May 2023) - minor enhancements - (ml_rose_23_005) extend attr_code size to 120 CHAR 6.7.11 ( 4 May 2023) - data fixes to replace & in some strings (ml_rose_23_004), plus code fixes 6.7.10.1( 3 May 2023) - stored proc to consolidate attributes (ml_rose_23_003) 6.7.10 ( 1 May 2023) - consolidate columns available in main screen layout and flexi-download. 2 new cols inclulded (ml_rose_23_002) 6.7.9 (30 Apr 2023) - switch to SFTP with Python 3.9 (removing need for Perl) for backups 6.7.8 (29 Apr 2023) - post upgrade to Oracle 21c - preparation for Attribute-Columns & user-defined screen & csv-file layouts (ml_rose_23_001) 6.7.7 (14 Apr 2023) - define attributes screen - option to disable add & delete buttons (prep for MLv7) 6.7.6.1 (13 Mar 2023) - stage_tbl col defn change (ml_trunk_23_001) 6.7.6 (19 Feb 2023) - list sort orders on filter screen 6.7.5.1 ( 2 Jan 2023) - extended set of flexi-download columns (ml_fir_23_001) 6.7.5 (31 Dec 2022) - pilot of "flexi-download" (ml_fir_22_006) 6.7.4.2 (19 Nov 2022) - Performance tuning for labels (ml_fir_22_005) 6.7.4 (13 Nov 2022) - Fix to composer/arranger names containing "&" (ml_trunk_22_006 datafix) 6.7.3 ( 4 Aug 2022) - library number generally available on piece summary page, import albums (ml_fir_22_004) 6.7.2.1 (30 Jul 2022) - (ml_fir_22_003) 6.7.2 (30 Jul 2022) - fix for screen layouts when creating new account (ml_fir_22_002) 6.7.1 (25 Jul 2022) - new field ORCHESTRATION_CODE for pieces (ml_fir_22_001) 6.6.12 (16 Jul 2022) - fix deferred label screen bug 6.6.11 (22 Jun 2022) - fix screen bug when no labels selected for printing; more query tuning (ml_trunk_22_005) 6.6.10 (22 Jun 2022) - query tuning (ml_trunk_22_004) 6.6.9 (20 May 2022) - "tarpit" invalid DB connection requests 6.6.8 (15 May 2022) - extra info on copies list when (re)adding copy to issue (ml_trunk_22_003) 6.6.7 (22 Apr 2022) - text on category/part-type association screen 6.6.6 (21 Mar 2022) - summary queue - queue processing order (ml_trunk_22_002) 6.6.5 (24 Feb 2022) - sheet tag formatting enhancement (ml_trunk_22_001) 6.6.4 (13 Feb 2022) - return to home page if unsuccessful DB connection 6.6.3 ( 8 Jan 2022) - initialise session variable 6.6.2 ( 7 Jan 2022) - documentation update 6.6.1 ( 6 Jan 2022) - experimental Group Search feature (ml_pear_21_001) 6.5.30 (27 Nov 2021) - Home page updated 6.5.29 (10 Nov 2021) - Feedback consistency (ml_trunk_21_014) 6.5.28 ( 9 Nov 2021) - Tidy up (ml_trunk_21_013) 6.5.27 ( 8 Nov 2021) - check-in queries performance tuning (ml_trunk_21_012) 6.5.26 ( 6 Nov 2021) - refactor package (ml_trunk_21_011) 6.5.25 (25 Oct 2021) - remove callback logic (ml_trunk_21_010) 6.5.24 (19 Oct 2021) - Python scripts tidy-up 6.5.23 (18 Oct 2021) - further summary jobs performance tuning (ml_trunk_21_009) 6.5.22 (18 Oct 2021) - summary jobs performance tuning (ml_trunk_21_008) 6.5.21 (17 Oct 2021) - simplify summary jobs (ml_fir_21_005) 6.5.20 (16 Oct 2021) - improvements to part-types/categories screen 6.5.19 ( 7 Oct 2021) - internal variable size increases for larger loads (ml_trunk_21_007) 6.5.18 ( 1 Oct 2021) - tag-format for generic checkin form, fix cascading revoke-checkin (ml_trunk_21_006) 6.5.17 (24 Sep 2021) - check-in performance tuning (ml_trunk_21_005) 6.5.16 (23 Sep 2021) - borrowed set revoke check-in fix (ml_trunk_21_004) 6.5.15 (21 Sep 2021) - Oracle DRCP enabled / PHP connection pooling 6.5.14 ( 7 Aug 2021) - changes to support FTPS 6.5.13 ( 6 Jun 2021) - new oracle aud/trc/trm removal script 6.5.12 (19 May 2021) - new back-up archive manager 6.5.11 (27 Apr 2021) - increase size of LIBRARY_NUMBER field (user_partset_id) (ml_trunk_21_003) 6.5.10 (03 Apr 2021) - add_piece modifications 6.5.8 (31 Mar 2021) - Additional input validation on forms 6.5.7 (27 Mar 2021) - New AddPiece screen, other minor forms validation checks 6.5.6 (20 Mar 2021) - Customisable main library page (ml_fir_21_004) - (without doc changes) 6.5.5 (13 Mar 2021) - fix weblinks query for borrowed sets (ml_trunk_21_002) 6.5.4 ( 3 Mar 2021) - refactoring JSON for picklists (ml_trunk_21_001) 6.5.3 (28 Feb 2021) - code changes in preparation for PHP8 6.5.2 (14 Feb 2021) - fix (ml_fir_21_003 build 2) 6.5.1 (14 Feb 2021) - Category-Aliases (ml_fir_21_003) 6.4.8 ( 7 Feb 2021) - Last Performance Date on main page (experimental) (ml_fir_21_002) - suggested by prospective user 6.4.7 (31 Jan 2021) - Category-Aliases (experimental) (ml_fir_21_001) 6.4.6 (16 Jan 2021) - Main page store-locn sortable by both Alpha and Number (requested by BRYO) 6.4.5 (12 Dec 2020) - Display attributes & bible-refs for piece with cursor over Category. Main listing layout changes (ml_fir_20_001) 6.4.4 (28 Nov 2020) - Main library listing can be sorted in reverse order (ml_trunk_20_005) 6.4.3 (15 Nov 2020) - Downloadable CSV of contact details (only accessible by Admin user) 6.4.2 (09 Nov 2020) - (ml_trunk_20_004) - Thor snapshot column resize (internal change for latest Thor) 6.4.1 (08 Nov 2020) - assign copies to contacts (ml_elm_20_001) + new sfx in the config.inc.php. [Idea from CPB] 6.3.2 (05 Nov 2020) - Thor work table for invalidations report (ml_trunk_20_003) 6.3.1 (15 Oct 2020) - include partset-cost in data-load; THOR release (ml_trunk_20_002) 6.2.18 (14 Aug 2020) - exclude test accounts from expiry emails (mla_trunk_01_016) 6.2.17 (09 Feb 2020) - account setup changes (mla_trunk_01_015) 6.2.16 (25 Jan 2020) - new DB trigger for data-load (mlo_trunk_01_113) 6.2.15 ( 1 Jan 2020) - additional logging 6.2.14 (31 Dec 2019) - correct config 6.2.13 (31 Dec 2019) - backup config changes 6.2.12 (14 Dec 2019) - label optional field (library No) consistently. Hide on set_edit when not used 6.2.11 ( 8 Dec 2019) - login page library ordering (mla_trunk_01_014) 6.2.10 ( 7 Dec 2019) - include "Set" identified on add-piece screen (mlo_trunk_01_112) (requested by PDR) 6.2.9 ( 7 Dec 2019) - internal DB changes (JSON summary column - mlo_trunk_01_110,111) 6.2.8 ( 2 Nov 2019) - label checkin feedback (mlo_trunk_01_109) (requested by KWO) 6.2.7 (27 Oct 2019) - Programme running-time (mlo_trunk_01_108) (requested by TELC) 6.2.6 (19 Oct 2019) - Internal config change (Copyright notice) 6.2.5 (28 Sep 2019) - Overdue Pieces screen changes (mlo_trunk_01_107) and OS updates for VMs 6.2.4 ( 7 Sep 2019) - "Latest News" link on home-page for announcements etc. Better Web handling when DB unavailable 6.2.3 ( 5 Sep 2019) - allow update of contact email address (mla_trunk_01_013, mlo_trunk_01_106) PHP 7.3.9 (php.ini change to PATH) 6.2.2 ( 2 Sep 2019) - piece subtitle on main library page now displayed in italics instead of in separate column 6.2.1 ( 1 Sep 2019) - (fir_rc5) Move to Oracle 18c database and separate VMs for Webserver and DB. No functional changes 6.1.57 ( 6 Aug 2019) - Fix display of borrowed set which is loaned out (mlo_trunk_01_105). PHP 7.3.8 6.1.56 (28 Jul 2019) - change piece-menu description. User Guide updated 6.1.55 (20 Jul 2019) - change menu description. User Guide updated 6.1.54 (19 Jul 2019) - changes to account expiry logic (mla_01_012) 6.1.53 (19 Jul 2019) - set default match-type to "ANY" for attribute filter 6.1.52 (19 Jul 2019) - Immediately apply filters if OK, and return to filtered library list. 6.1.51 (18 Jul 2019) - Simplify 2 shellscript jobs. Simplify virtual column defn (mlo_trunk_01_104) 6.1.50 (10 Jul 2019) - Change virtual column defn to be forward compatible with Oracle18 (mlo_trunk_01_103). 6.1.49 (10 Jul 2019) - Extend loader to add copies for sets with single part-type (mlo_trunk_01_102). Remove redundant barcode-39 logic/files. 6.1.48 ( 9 Jul 2019) - Switch to using code-128 barcodes from TCPDF built-in methods. Minor change to deferred label print screen. 6.1.47 (28 Jun 2019) - More importable fields added (partset_code) (mlo_trunk_01_101) 6.1.46 (26 Jun 2019) - More importable fields added (Weblinks 1-5) (mlo_trunk_01_100) 6.1.44 ( 9 Jun 2019) - Fix ordering options on main library page 6.1.43 ( 1 Jun 2019) - Fix box-grouping in new store-locn inventory sheet (mlo_trunk_01_099) 6.1.42 (31 May 2019) - Fix missing account info on Labels. New "Box Labels" feature (mlo_trunk_01_098) 6.1.41 (25 May 2019) - store-location inventory sheets (mlo_trunk_01_097) 6.1.40 ( 8 May 2019) - restructuring set-summary job (mlo_trunk_01_096) 6.1.39 ( 8 May 2019) - query tuning(mlo_trunk_01_095) and new scheduler job 6.1.38 ( 4 May 2019) - database query improvement, menu fixes for borrowed sets 6.1.37 (14 Apr 2019) - minor change to validation on AddPiece. Fix to OCN script 6.1.36 (13 Apr 2019) - Improve validation on AddPiece screen 6.1.35 (13 Apr 2019) - DB constraint changes (01-93), DB-export logging, change default input method for add copies 6.1.34 (22 Mar 2019) - text change in expiry notice email 6.1.33 (17 Feb 2019) - DB constraint change (category-instruments->categories) 6.1.32 ( 8 Dec 2018) - Reinstate multi-piece album loading from data import 6.1.31 ( 6 Oct 2018) - Correction on overdue copies detail screen 6.1.30 ( 6 Oct 2018) - Optional sorting on Overdue Copies Detail screen (KWO) 6.1.29 (30 Sep 2018) - Optional sorting on Overdue Pieces screen (KWO) 6.1.28 (29 Sep 2018) - Performance improvements for Copies summaries 6.1.27 (27 Sep 2018) - PHP bugs fixed 6.1.26 (27 Sep 2018) - query simplification and new index 6.1.25 (25 Sep 2018) - PHP bugfixes 6.1.24 (25 Sep 2018) - various bugfixes / PHP 7.2 compatibility changes 6.1.23 (23 Sep 2018) - more query performance improvements(partset part copy counts) 6.1.22 (22 Sep 2018) - more query performance improvements(overdue copies) 6.1.21 (21 Sep 2018) - more query performance improvements 6.1.20 (18 Sep 2018) - replace other call to proc with new version 6.1.19 (18 Sep 2018) - query performance improvement for piece summary (M-sets) 6.1.18 (17 Sep 2018) - external links on home page updated 6.1.17 (17 Sep 2018) - re-implement stat counter on home page 6.1.16 (17 Sep 2018) - fix weblinks on homepage 6.1.15 (17 Sep 2018) - Bug fix for Publishers; switch to HTTPS 6.1.14 ( 6 Sep 2018) - Include category in summary page (KWO) 6.1.13 ( 2 Aug 2018) - minor changes 6.1.12 ( 1 Jul 2018) - TCPDF class change for PHP7.2 6.1.11 (24 May 2018) - fix another related bug in generic-undo-checkin-for-issue 6.1.10 (23 May 2018) - fix another related bug in undo-checkin-for-issue 6.1.9 (21 May 2018) - fix bug in undo-checkin-for-issue 6.1.8 (29 Apr 2018) - quick link from entry on Issue Summary page to issued copies (KWO) 6.1.7 ( 7 Apr 2018) - weblinks updated 6.1.6 (17 Feb 2018) - include PUBLISHER_REF in loadable fields 6.1.5 ( 2 Feb 2018) - simplify delete actions 6.1.4 ( 1 Feb 2018) - bug fix (add text to issued copies from Admin menu option) 6.1.3 (20 Dec 2017) - index column re-ordering 6.1.2 (19 Dec 2017) - minor performance updates and fixes 6.1.1 (18 Dec 2017) - labelled-copy checkin "undo last check-in" button (KWO) - other fixes for inter-account lending - PHP compatibility changes - updated user-guide 6.0.19 (15 Dec 2017) fix bug with cascading check-ins (KWO) 6.0.18 (12 Dec 2017) display copy tag in scan feedback (KWO) 6.0.17 (21 Nov 2017) minor corrections 6.0.15 (19 Nov 2017) internal changes for new data-loader 6.0.12 ( 8 May 2017) change text in account expiry emails 6.0.11 ( 6 May 2017) db code tidy-up 6.0.10 ( 2 May 2017) trigger code performance improvements 6.0.9 ( 1 May 2017) query performance improvement for overdue pieces 6.0.8 (23 Apr 2017) more query improvements for part-status info 6.0.7 (19 Apr 2017) issued set query performance improvement 6.0.6 (19 Mar 2017) query improvements 6.0.5 (12 Feb 2017) ** NEW SERVER, OS/PHP/APACHE, correction to db export config 6.0.4 (10 Feb 2017) database performance enhancements 6.0.2 (03 Jan 2017) Fix composer/arranger summary display for piece in collection 6.0.1 (02 Jan 2017) Re-introduce Albums (collections of pieces) feature ======= 5.0.39 (24 Dec 2016) check-in alert on change of set also default for generic checkin 5.0.38 ( 8 Oct 2016) check-in labelled copy - Alert on change of set now the default (suggested by H.Hendron / Kew Wind Orchestra) 5.0.37 ( 4 Sep 2016) Minor improvement to add-copies screen (reduce number of TAB presses needed) 5.0.36 ( 1 Jun 2016) Bug fix - menu permissions 5.0.35 (31 May 2016) check-in unlabelled copies from an issue using barcode scanner (for Kew Wind Orchestra) 5.0.34 (10 Apr 2016) data-pump export 5.0.32 ( 7 Feb 2016) more efficient code for previous fix 5.0.31 ( 5 Feb 2016) Cursor over store-locn on main library page will show Locn_Text if there is any for that store-location. (for Kew Wind Orchestra) 5.0.30 ( 6 Jan 2016) Some minor fixes (PL/SQL) 5.0.29 (24 Dec 2015) PHP-7.0.1 and minor fixes 5.0.28 (18 Jul 2015) Include COST on library pieces csv download file 5.0.27 (18 Mar 2015) New field for publisher's catalogue reference 5.0.26 (17 Mar 2015) Include publisher info on overdue copies report 5.0.25 ( 7 Mar 2015) Button on AddCopies screen to add a new piece. Fix to login expiry handling. 5.0.23 (22 Dec 2014) display contact name in overdue copies screen (if present) 5.0.22 (18 Dec 2014) suppress blank fields on PDF files 5.0.21 (17 Dec 2014) Accounts can specify terms & conditions to borrowers when lending sets (requested by KWO) 5.0.20 ( 2 Dec 2014) include data-pump export scripts alongside older export scripts 5.0.19 (24 Nov 2014) Fix piece summary so principal ensemble name shows in performance history if no piece-level override provided 5.0.18 (17 Aug 2014) Include scripture-refs in library csv download file (requested by COTC) 5.0.17 (16 Apr 2014) Hide Library Number if not used by the account 5.0.14 (16 Mar 2014) Optional setup for user-defined partset identifier 5.0.11 (18 Nov 2013) New sort option for main library page (subtitle/title) 5.0.9 (26 Jun 2013) automatically send email when account about to expire and again when account expires 5.0.5 (17 May 2013) minor internal changes 5.0.4 (16 May 2013) New download file (issued_set_history csv) 5.0.3 (10 May 2013) PHP/Apache upgraded 5.0.2 (07 May 2013) minor internal changes 5.0.1 (04 May 2013) Allow multiple composers/arrangers/lyricists/editors per album/piece Changes to add_piece and edit piece/album screens 4.0.6 (24 Jan 2013) Fix bug when deleting partset issue history 4.0.5 ( 2 Jan 2013) Duplicate partset with option to include copies 4.0.4 ( Nov 2012) Update PHP version 4.0.3 (23 Oct 2012) Faster method of updating summary (OCN instead of scheduled job) 4.0.2 (29 Sep 2012) Fix bug on summary page where fields sometimes not editable when they should be. Documentation changes 4.0.1 ( 8 Sep 2012) New features including Scripture References, Web-links, extended searching capability and a quicker way of creating and assigning attributes to pieces. 3.3.6 ( 4 Aug 2012) Fix bug when adding new attribute 3.3.2 (18 Jun 2012) More performance improvements 3.3.1a (17 Jun 2012) Performance improvements (especially to ALL COPIES download) 3.3.1 (10 Jun 2012) New Server (and new versions of all core software components) 3.2.1 (23 Mar 2012) * Use JQuery-UI AutoCompleters for AddPiece (composer, arranger, publisher, owner) and for AddCopy (part-type). Note : Users may need to disable "AutoFill" feature in Google Chrome as the list of previously entered data values for a field may obscure the AutoCompleter's list of matching items. Microsoft IE shows strange behaviour with Autocompleter, but this browser is NOT supported with the Admin login. * Update user-guide. 3.1.15 (21 Mar 2012) - fix for add-copy for Google Chrome 3.1.13 ( 4 Feb 2012) * New versions of PHP (5.3.10) and Apache (2.2.22) * Minor changes to connect script * Fix to issue-summary query (copies-in-set) 3.1.12 (27 Nov 2011) * new download file (All Copies) - administrator menu only * additional columns added to other download files to enable them to be joined together (requested by GMS and others) * allow suppression of the zero-copy warning colour for partsets (ie, instead of having a yellow background on the main screen, t they will show as green as if "complete" (requested by CC) * notes on the above added to user guide * minor changes to the login screen layout and wording 3.1.11 (19 Nov 2011) * "quick summary" button on check-in labelled copies screen (requested by KWO) 3.1.7 (18 Oct 2011) * fixes to summary page queries for borrowed sets (BUG) 3.1.5 (1 Oct 2011) * New label type AV8066 (requested by MSC) 3.1.4 (6 Sep 2011) * internal performance tuning changes (summary builder) 3.1 (Aug 2011) * changes to enable barcode scanner use when assigning text to issued copies (requested by MSC) 3.0 (May 2011) * Major database changes to support inter-account lending