Release candidate 2 for Jethro 2.19

This is a release candidate. Once it is ready for production it will be released as 2.19.0.

New Features

• Ability to export family contact lists as DOCX
• More configuration options and new layout for family contact lists
• Date-reminder script can now send SMS as well as emails (see scripts/date_reminder_sample.ini)
• Issue #324 - Custom fields can now be included in the add-family form. (Configured from Admin > Custom Fields)
• Issue #22 - You can now add persons to groups in the add-family form. (Configured from edit-group-details page)
• Issue #325 - Person reports can now be grouped by a custom field.
• Issue #279 - Summary of service properties now displayed atop printable run sheet too
• Issue #328 - Users can now create groups which are visible only to them
• Issue #23 - Service run sheets can now be copied from a previous service
• Issue #135 - Custom fields can now be included in searches (Configured from Admin > Custom Fields)
• Issue #15 - Most system configuration settings can now be edited from within Jethro (See Admin > System Configuration)
• Issue #308 - Action plans can now be configured to only execute on persons of certain age brackets
• Issue #337 - Ability to view certain document folders via the members area (Configured in conf.php file)

Bug Fixes

• Issue #306 - family names that start with numbers now visible in paginated all-families page
• Issue #310 - Safari standalone mode now stays logged in correctly
• Issue #314 - Fixed database errors for some person reports
• Issue #316 - Contact list now treats person photo as family photo for single-member photos
• Issue #286 - Links to run sheets are not shown if the user doesn't have permission
• Issue #319 - UK postcode finder URL has been corrected
• Issue #320 - Fixed database error on install
• Issue #329 - Custom field keywords in mail merges are now replaced even if the person has no value for them.
• Issue #338 - Unknown-person photo now shows up correctly in the members area
• Issue #340 - Fixed database errors for some person reports
• Issue #330 - Safari should not longer auto-fill the current user's username and password when editing someone else's user account
• Issue #82 - The 'add members' tool is now not shown if the user lacks permission to add group members
• Bible references to Song of Songs now work correctly.

Upgrade Procedure

1. Log out of Jethro
2. Take a backup of your mysql database. Really, do it.
3. Apply all applicable upgrade SQL files from the upgrades folder to your mysql database, including upgrades/2017-upgrade-to-2.19.sql
4. Move away your old Jethro files (eg. rename your jethro folder to jethro_old)
5. Unzip the new files into the right place (don't just overwrite the old files)
6. Move your old conf.php and files/ subdirectory (if not empty) back into your jethro folder.
7. Important extra step: Open Jethro in your browser. You should see a bunch of messages saying "The setting XYZ has been migrated to the database and can/should be removed from conf.php"
8. Once you've seen the messages above, rename your conf.php to conf-OLD.php. (Make sure you keep the .php extension - otherwise you'll expose your database credentials to the world)
9. Rename conf.php.sample to conf.php
10. Edit conf.php and for each setting that's in there, copy its value from conf-OLD.php. NB that many settings will no longer be in conf.php.
11. Log in to Jethro and check your system configuration at Admin > System Configuration

Credits

Thanks to Coast Evangelical Church, Castle Hill Baptist Church, Sydney Anglicans Safe Ministry and Easy Jethro for sponsoring features in this release.