Jethro v2.9.3

Jethro v2.9.3

This minor release fixes a few bugs and adds some minor extensions.

• Filtering of service components within the service-run-sheet page was broken; now fixed.
• Arrow keys didn't work within number boxes such as the CCLI number; now fixed
• Some problems with CSV import of persons have been fixed
• Some adjustments to CSV export of rosters, to better suit MS Excel

Upgrade Instructions

If you are upgrading from 2.9.0 or later, there are no database changes to make. It is safe just to copy the new files over the top of your old fles.
If you are upgrading from a version older than 2.9.0 you must follow the upgrade instructions for 2.9.0 (but use these files instead of the 2.9.0 files).

Jethro 2.9.2

Jethro v2.9.2

Fixes some small bugs in 2.9.1:

• There were still SQL errors with certain configurations of ATTENDANCE_LIST_ORDER; now fixed better.
• The roster CSV export always exported future roster allocations; it now respects the dates selected at the top of the page.
• Mail merge from report results did not work - now fixed.

Adds one new featurette:

• When showing a roster in the public site, you can add a new parameter ?weeks=n to the URL, to restrict the display to the next n weeks.

If upgrading from 2.9.0 or later, no database changes are needed - just replace your jethro code with the new code.

Jethro 2.9.1

This release fixes some small bugs with v2.9.0.
See the 2.9.0 release notes for details of the new features.

Jethro 2.9

Jethro 2.8 - 2.9 Release Notes

New Features

Member Login Interface

• Accessed by adding /members to the end of your jethro URL
• Church members whose email address is already recorded in your system can register themselves via email validation
• Members who log in can change (some of) their own details
• Person groups can be marked as "share details", so that when somebody in the group logs into the members interface they can see the contact details of the other members of that group.
• This feature needs to be turned on via the MEMBER_LOGIN_ENABLED setting in conf.php

Service Planning

• Jethro previously supported service programming - planning the schedule of the topic and bible readings for services. Now, you can plan service run sheets in detail.
• Users can manage a repertoire of service components including songs, prayers and other regular segments, including by importing them from CSV file.
• Services can then be planned by dragging components into a run sheet.
• Jethro automatically numbers items as appropriate and calculates timings based on the duration of each component.
• Service summaries (run sheets) and full content (handouts) are ready to be copy and pasted into your word processor.
• Links to the CCLI website make it easy to search for songs and quickly access song details.
• This feature needs to be turned on by adding SERVICEDETAILS to the ENABLED_FEATURES setting in conf.php

Other minor features

• The home page now has a single search box which can be used to search for person, family or group names, emails or phone numbers.
• New setting SHOW_SERVICE_NOTES_PUBLICLY to make service notes (from the service program) show up in the public interface.
• It's now possible to delete congregations via the congregations page
• It's now possible to export rosters to CSV (eg to apply precise formatting in a spreadsheet application)
• Long forms are now divided up into sections for easier navigation

Bug fixes

• Service doc generation: Explanatory text now mentions the OTT file extension where it previously mistakenly specified ODT
• CSV person export: Some accented characters previously were mangled; now they aren't.
• Display attendance: Errors when displaying attendance for groups are resolved
• Reports: Errors when running some reports involving date fields are resolved.
• Various other small bug fixes

Upgrade Procedure

1. Back up your Jethro database
2. Move your old Jethro files out of the way (eg rename your "jethro" folder to "jethro-old")
3. Unzip the new Jethro files into the correct location
4. Edit the new conf.php file, copying across the settings from your old conf.php file. (Bear in mind there are several new settings that will be missing from your old file)
5. Run the appropriate upgrade files from the upgrades directory against your Jethro database (probably 2014-upgrade-to-2.8.sql and 2015-upgrade-to-2.9.sql; if you are upgrading from an older version there may be older upgrades you also need to run).
6. If you have trouble upgrading please post on the support forum at http://sourceforge.net/p/jethro-pmm/discussion/679836