Release notes for kOOL releases
With every kOOL release you will find notes about the changes and instructions for updating your current version to the newest release.
Release notes for R48
General - Use taxonomy terms to specify access rights
- SPF check to set From address when sending emails
- Update scripts in install/updates. Call install/update.phpsh with parameter -s
- Categories for news entries on front page
Events - Rooms are stored as database entries
- Import absences from Outlook calendar
Addresses / groups - Information lock can be applied to addresses
- mylist: Allow addresses to be stored in presets
- Parents' columns not only in export but in list of addresses
Rota - Amtstage instead of Amtswoche
- Continuous consensus
- New ical export for whole teams
New module Telegram - Send messages to telegram apps instead of SMS.
Special update instructions - Do a normal update, the update scripts will run if you call install/update.phpsh with the -s parameter
- Add new module to config/ko-config.php: telegram
- Update to PHP 7.2
Release notes for R47
General - New checkin for trackings
- List columns can be sorted manually
Events - Manage absences (holidays etc) for all workers
- Manually save moderated event, also as admin
- New columns in list view showing events from other event groups
Addresses / groups - Emails from people module are now sent through the scheduler
- Group assignment history may now be edited by clicking bars
- Filter for group assignment history
- Better household export
- New export filling word templates or calling functions to create PDF etc
- Statistics over time: General metrics and for your filter presets
- Recursively copy groups with assignments
Reservations - Allow new conflicting reservations to be stored for moderation
Rota - Deadline for ical export
- New planning view
New module subscription - Create subscription forms than can be included as iFrames in your webpage
New module taxonomy - Define keywords that can be applied to groups and events
Special update instructions - Do a normal update but then also call kool_update_r46_r47.php from your web root.
- Delete the default plugins map_*
- Don't include config/leute_formular.inc anymore. Instead use KOTA[ko_leute][_form_layout] and adapt it config/kota.inc if necessary
- Add new modules to config/ko-config.php: subscription, taxonomy
- Update to PHP 7.1
Release notes for R46
General - By far the biggest change is the UI which is now based on bootstrap and as such is fully responsive.
- Mailmerge with LaTeX has been removed
- Plugins might need some changes to work in bootstrap again. E.g. the creation of submenus has changed, check out the example plugins.
Events - Don't include Google Calendars anymore but use iCal importer instead
- New access setting to only allow access to certain fields
- Allow events to be imported from a csv file
- Global time filter may be forced for certain users (login settings)
Addresses / groups - Separation of household and family. Parents and spouse are stored separately from household
- Groups may now be copied recursively
- New group export with addresses
- Improved csv import of addresses, better detection of file format
- New charts
Reservations - New version of fullcalendar with resource view
Rota - Allow teams to be manually sorted (global setting to activate it)
New module CRM - New module to store contact entries for your addresses
New module vesr - Allows you to upload payment files from your bank
- Used mainly in combination with donations which can now be read in as moderated
Special update instructions - Do a normal update but then also call kool_update_r45_r46.php from your web root.
- Copy src/install/default/footer.php into your webroot folder overwriting the old footer.php
- Add new modules to config/ko-config.php: crm, vesr
- Stay with PHP 5.6
Old release notes
Release notes for R45
Consensus: Doodle like scheduling for rotas - Send an email to all your team members and let them enter their preferred dates
- See the entered data in color code while scheduling in kOOL
Events - Create automatic reminders for events, sent by email
- Define mandatory fields which have to be entered for new events
- Global time filters may now be forced for logins
Reservations - New PDF export for resource view
Addresses - Add manual lines for label export
- Unlink a person from his family when moderating his address mutation
- New CSV-Export for addresses, mainly for better performance and lower memory consumption
- New columns for trackings and donations
Mailing - No separate cronjob needed for mailing.php anymore, instead activate the corresponding scheduler task
- Send mailing to addresses defined by a filter preset from the address module
- More finetuning of access rights for groups
- Show the original recipient headers in sent mailing mails instead of individual recipients' addresses
Other
» With this the release database changes can be applied using the php script install/update.phpsh from the command line
» Update the source to R44 (easiest with multihost installation by just relinking kOOL_lib)
» For multihost installations: Call kOOL_setup.sh in your webfolder to create the new files and folders.
» Install a cronjob for the new scheduler: */15 * * * * /path/to/php /path/to/kOOL/scheduler.php (no more cronjob needed for mailing.php)
» If one of your plugins uses the global variables $error or $info to show error or info messages you'll have to adapt these to use the new koNotifier class. See any module's index.php to find out how to use it.
Release notes for R44
Events
- New field "title" for events and eventgroups
- Room select only shows rooms of future events (setting)
- New color legend for calendar export
- Moderation: Set fields that can be changed without a new moderation
- Exports: New presets to specify special exports
- Rooltip: Setting to show reservations
- iCal importer with clean integration instead of GoogleCal
- QRCode for iCal links
- iCal: Select fields to be used for description
- New setting to always use shortname in PDF
- New userpref to hide calendars in eventgroup itemlist
- Repetitions: Exclude holidays from event group
- Allow open moderations to be visible to all users (setting)
Reservations
- New resource views
- New color legend for calendar export
- QRCode for iCal links
- Access can be set by groups or items
- Setting to attach ICS file to confirmation emails
- Mail to moderators allow to confirm by link with or without feedback to user
- Allow open moderations to be visible to all users (setting)
- List of res items: Show moderators in new column
- Don't show purpose for guest user (setting)
Addresses
- Column select: Hierarchy view of groups. Show trackings as columns
- Only one edit icon which shows other icons in overlay: GoogleMaps, QRCode, Word, Clipboard
- Copy addresses to clipboard (using flash)
- Fast filters can be set by user
- Word export using config/address.docx
- Allow users to search in all addresses and assign them to own group
- Filter: Manually set OR/AND and parenthesis
- Prevent permanent deletion with setting
- RecType for addresses used in export
- New filter: DOB range
- Label export: Select page format (A4 etc)
Groups
- Set max group members by group
- XLS export: start at current group
- Datafields: Presets can be defined, private datafields
- Datafields: Setting to hide datafields of passed groups
Mailing
- Allow sending without login using different moderation settings
- Reply-To can be set by group
- Setting: Allow double recipients or not
Tracking - New type typecheck
- Add values for all persons
- Set default values
- Allow multiple entries per day of same type
Donations - Added new valuta date which can be different from donation date
- New link to show address in people module
- Better filtering for amount using =, >, <, ranges
Rota - New userpref to allow schedulling of individual members of subgroups
- MyList export for schedulled people
- Filter in people module: More options
- New filter to only show future events
- Sending: Two new recipient options
Other - KOTA filters for lists (right click on column headers)
- Itemlists: ALL and NONE
- Excel export: Defaults to xlsx, can be set to xls
- Set default module to redirect to after login
- Download: Download starts directly (setting)
- Logins: Propagate ALL rights to all items
- New default plugin col_age to add age column to addresses
- swiftmailer: $MAIL_TRANSPORT in ko-config.php can be set to use an SMTP server for sending emails
- New scheduler: Manage tasks in tools module and call scheduler.php from a cron job. New tasks should usually be added with plugins
» Some database changes have been added with this release.
Apply changesR44.sql to your database before updating to the new release. changesR44.sql is contained in your zip file.
» Use the update script to perform the necessary update steps
Have a look at the update script first, there are some steps which can be manually activated if needed.
» Update the source to R44 (easiest with multihost installation by just relinking kOOL_lib)
» For multihost installations: Call kOOL_setup.sh in your webfolder to create the new files and folders.
» Install a cronjob for the new scheduler: */15 * * * * /path/to/php /path/to/kOOL/scheduler.php
» If one of your plugins adds submenu entries you'll have to change your code slightly: Each submenu entry must have it's own key otherwise they will show up multiple times $my_submenu[MODULE][SMKEY][YOURKEY]
Release notes for R42
- Inline editing for most lists
- New weekly PDF export for events and reservations
- List views: +/- signs to increase/decrease number of rows
- Reorganized userprefs and settings (changed many settings to userprefs)
- New access levels: New level 5 for admin module, reservation module,
- Access to certain groups can be defined on login itself, and also admin groups
- vCard export of addresses
- Show small group data as address columns
- Edit members of small groups in small group form
- New default plugin to add age as a new address column
- Bugfixes for mailing module
See new developers platform for details: dev.churchtool.org
» Update your kOOL database by applying changesR42.sql
» Use the update script to perform the following update steps
- Remove constant FORCE_FAM_FIRSTNAME and replace with new setting
- Remove $LEUTE_EXPORT_CHILDREN_COLUMNS and replace with new userpref
- Convert settings into userprefs
- Update access rights for reservation module
» Update the source to R42 (easiest with multihost installation by just relinking kOOL_lib)
Release notes for R41a
- This is only a bugfix release for R41. If you're updating from R40 make sure to update to R41 first and only then to R41a.
Release notes for R41
- New sms provider: aspsms.net (See sms documentation for details) - Sender activation from GUI
- Excel export for small groups
- Labels export: Choose font, multiplier, print image
- Access rights for groups: Access rights are now always inherited by children groups
- Mailing module
» Some database changes have been added with this release.
Apply changesR41.sql to your database before updating to the new release. changesR41.sql is contained in your zip file.
» IMPORTANT: If you are using kOOL to send SMS messages, you'll have to call the update script update_R41.zip. This script takes your registered senderIDs from config/ko-config.php and stores them in the database.
» For multihost installations: Call kOOL_setup.sh in your webfolder to create the new files and folders.
Release notes for R40
- Small groups: Cleaner handling of small group roles (leader, member, etc). See documentation for details about how to add new roles ($SMALLGROUP_ROLES)
- Events: New iCal export links without authentication
- People: Set preferred email address if multiple email fields (See $LEUTE_EMAIL_FIELDS and $LEUTE_MOBILE_FIELDS)
- People: Send info email to kOOL users after editing a person's record
- People: New filter to find duplicates and merge them
- People: Saving a filter preset includes sorting
- People: New layout for filter submenu
- Events: Display Google calendars in your kOOL calendar
- SMS: Choose sender id for SMS
- SMS: Send sms with longer texts than 160 chars
- Tracking: New export options
- Donations: New filter to search for donor
» IMPORTANT: Because of the changes made to the small group module in this release, you'll have to call update_R40.php. This script will convert the current small group assignments into the new role based system of release R40. You must do this before updating the source or your database. Edit the file to adjust some settings at the top.
» Name the new address column "smallgroups" using the tools module's "Edit fields".
» If you have added your own filters for manually added address columns (ko_leute), you might want to assign these filters to one of the new filter groups. You'll have to do this manually in the table ko_filters using phpMyAdmin or such.
» Some database changes have been added with this release.
Apply changesR40.sql to your database before updating to the new release. changesR40.sql is contained in your zip file.
» For multihost installations: Call kOOL_setup.sh in your webfolder to create the new files.
Release notes for R39a
- Bugfixes
- New sms statistics in admin module
- New version of fullcalendar: Days or hours may be selected to create a new event from start to stop
- Rota: New button to send a personal rota directly to the selected person (Christoph Fischer)
- Rota: New setting to allow chosing group role for each rota team
- Rota: Define a list separator between the names serving in a team (Chrisoph Fischer)
- Donations: After submitting a new donation the stored values are shown
- Set access rights for event module using only event groups or calendars and event groups
- Usabilty improvements for the tracking module
- Tracking: New setting to define the ordering of the people (firstname, lastname, group role)
- Tracking: New setting to allow the selection of not only groups but group and role when creating a new tracking
- Tracking: New field description. Shows when entering trackings in the browser and also in the exports
- Better handling of language regions: Define e.g. $WEB_LANGS = array('en_US') in ko-config.php
- New config variable $PDFLATEX_PATH for ko-config.php to set the path to a local LaTeX installation (Christoph Fischer)
» Some database changes have been added with this release.
Apply changesR39a.sql to your database before updating to the new release. changesR39a.sql is contained in your zip file.
Release notes for R39
- Improved speed (reduced overall processing time to about 20% compared to R38)
- Using compressed JS and CSS files where possible
- Include return address when printing address labels
- Bugfixes
- PEAR:Auth and PEAR::DB classes not needed anymore. No more PEAR dependencies at all.
- New access control system (faster and cleaner). Read more
» Make sure to clear your browser's cache to get files' newest versions.
» For multihost installations: Call kOOL_setup.sh in your webfolder to create the new and delete the old links.
Release notes for R38
- New module tracking to track attendance of people in courses, small groups etc. (See documentation for details)
- Removed news module (IMPORTANT: Read details below)
- New (faster) fullCalendar (v1.4.5) for event and reservation modules
- Important bugfix: Ajax calls sometimes ended the PHP session which led to users being logged out
- New filter submenu for small groups
- New filters: Find person who have made donations in a given year. AddParents and AddChildren filters.
- Better birthday list which allows selection of columns and export
- New column with number of members and link to show them in list of groups
- Added links to names in front module
- New option to order birthdays by age or month/day
- New family email address used when exporting families with email addresses
- Speedup for front module today
- Some small CSS cleanup
- iCal export now uses UTC times
- Better support for kOOL on shared hosting servers ($INCLUDE_PATH_PEAR and $INCLUDE_PATH_SMARTY in config/ko-config.php)
- PEAR classes Spreadsheet_Excel_Writer and OLE are not needed anymore, replaced by excelwriter class
» IMPORTANT: With this release the news module disappears. Newsletters should now be handled with groups and the news for the front page are managed in the admin module (access level 2).
There is a PHP script available to convert all current newsletters into groups. It creates a new group for each newsletter and assigns all newsletter recipients to these new groups. This script must be called before the database is being updated with the below mentioned changesR38.sql!
Download update_R38.phps
» Some database changes have been added with this release.
Apply changesR38.sql to your database before updating to the new release. changesR38.sql is contained in your zip file.
» For multihost installations: Call kOOL_setup.sh in your webfolder to create the new directories and files. This script will delete the news folder in your kOOL webroot.
» Go to the tools module and add a name for the new family field "famemail".
» Add the new constant EMAIL_SET_RETURN_PATH to your config/ko-config.php. Set it to TRUE to have the email header Return-Path set for email sent from kOOL. (See install/default/config/ko-config.php for an example and the documentation for more details.)
Release notes for R37a
- Select month/week/day for calendar
- XLS export of events/reservations was buggy
- New constant FORCE_FAM_FIRSTNAME: If set family export always includes first names
- Bugfixes for new calender for IE7/6
- Bugfix: Sorting of addresses for some columns didn't work correctly
- Bugfix for install tool
No special steps are needed for an upgrade from R37 to R37a. Just make sure to clean the cache of your browser.
Release notes for R37
- New drag&drop calendar view for events and reservations (day, week, month)
- Mail merge letters directly from within kOOL as PDF file
- Send notification email to group members upon event changes
- Set admin email for logins to overwrite email from address
- New frontmodule "Find address" which works as the fast filter of the people module
- Select a filter preset for the people select when adding donations
- ko_guest may not store presets in itemlists anymore
- ko_guest may not export reservations
» Some database changes have been added with this release.
Apply changesR37.sql to your database before updating to the new release. changesR37.sql is contained in your zip file.
» For multihost installations: Call kOOL_setup.sh in your webfolder to create the new directories and files.
LaTeX: The new mail merge export is based on LaTeX, KOMA-scripts and pdflatex. Make sure you have those installed on your server if you want to use the mail merge.
» The PEAR class Calendar is no longer needed for R37.
Release notes for R36
- iCal export for reservations
- Three separate fields for family salutation
- New button "save as new" when editing an event, reservation or donation
- Admins may store global filter and itemlist presets for all modules
- XLS export of groups has columns aligned now
» Some database changes have been added with this release.
Apply changesR36.sql to your database before updating to the new release. changesR36.sql is contained in your zip file.
» For multihost installations: Call kOOL_setup.sh in your webfolder to create the new directory resical.
Release notes for R35
- Graphical statistics for addresses and small groups (You'll need PHP's GD library installed on your webserver for these to work)
- Logged in users can see their own reservation and event requests which still await moderation
- Use groups to manage recipients of ezmlm mailinglists
- Dark colors for event groups are now possible, as the text will be rendered in white
- Some important bugfixes: Access rights for addresses, donations, rota
Make sure to rename your config/ko-config.inc file to config/ko-config.php if you haven't updated to R34a yet.
Some database changes have been added with this release.
Apply changesR35.sql to your database before updating to the new release. changesR35.sql is contained in your zip file.
For multihost installations: As this release contains two new files you'll have to copy install/kOOL_setup.sh to your kOOL web directory and run it from there to create the new links.
Release notes for R34a
This release only fixes a security issue in R34. Make sure you update to R34a if you're running any previous version of kOOL.
After updating to R34a you have to rename the file config/ko-config.inc to config/ko-config.php.
Release notes for R34
- Combine event groups in calendars
- Event moderation
- Reservation groups are beeing used in item selection lists
- New settings to choose title field for calendar view
- Rota export: New setting to mark empty entries
- Rota: Display event titles/comments in rota
- Submenu color legend removed and integrated into itemlist
- More help texts and list titles
- Reworked schedule form for rotas and PDF export
- Assigning addresses to rota teams and logins is not done with the buttons beneath the address list anymore but directly in the login or person form
- Dummy groups show subgroup entries instead of just "x" in address list
- Speed improvements
- Slow access to address changes improved by adding the right index to the db table
- Code cleanup for reservation and event module
Some database changes have been added with this release.
Apply changesR34.sql to your database before updating to the new release. changesR34.sql is contained in your zip file.
For multihost installations: As this release contains a new file you'll have to copy install/kOOL_setup.sh to your kOOL web directory and run it from there to create the new links.
Releasenotes for R33a
- Set custom timeout for session in ko-config.inc and automatic warning upon logout.
- Some speedups in the people module
- Bugfixes for new versioning feature for addresses in people module
Releasenotes for R33
- Version history for person's records in people module
- New column "creation date" for person's records including filter for this column
- Allow sorting for multiple columns in people module
- All group datafields may be edited
- New option for logins to allow moderation of group subscriptions withouth level 4 rights
- Address export for children with additional columns containing information from their parents
- Export yearly donations statistics to Excel
Some database changes have been added with this release.
Apply changesR33.sql to your database before updating to the new release. changesR33.sql is contained in your zip file.
You can use the update script to transfer the creation dates for person records from the log data in DB.ko_log over into the column DB.ko_leute.crdate. This is not a necessary step but enables you to filter the person records for their creation date. Please read the instructions contained in the update script before you run it.
Releasenotes for R32
- Group subscriptions: Assign subscription to any person from the database not just those found by the fuzzy search
- New field "comments" for reservations
- New color picker
- Replaced overlib with smaller js-code
- Automatically assign addresses added by a certain login to a given group
- Use people assigned to groups in rota scheduling
- Disabled old fileshare module (webfolders are still enabled)
- Allow additional email fields which will be considered when exporting to email
- Display comments in monthly PDF export for events and reservations
- Export groups hierarchy to an excel file
Some database changes have been added with this release.
Apply changesR32.sql to your database before updating to the new release. changesR32.sql is contained in your zip file.
For multihost installations: As this release contains new files you'll have to copy install/kOOL_setup.sh to your kOOL web directory and run it from there to create the new links.
Releasenotes for R31
- Possibility to hide addresses (db update needed)
- New consistent iconset
- Context sensitive help (db update needed)
- "Apply to all" for multiedit
- SQL optimizations for often used SQL queries
- XML-GET interface to retrieve data from kOOL through get.php
- Many bugfixes
Some database changes have been added with this release.
Apply changesR31.sql to your database before updating to the new release. changesR31.sql is contained in your zip file.
The new column ko_leute.hidden must be given a name manually through the tools module for it to appear in the people module. (EN: Hidden, DE: Versteckt, NL: Verborgen)
For multihost installations: As this release contains two new files (get.php, inc/class.mcrypt.php) you'll have to copy install/kOOL_setup.sh to your kOOL web directory and run it from there to create the new links.
Releasenotes for R30
- New language: Dutch (thanks to Johan)
- New filter to apply filter presets as a single filter (can be combined with others)
- Allow users to change their own password
- API for map plugins to display address on online maps
- Mutations: Better search to find possible matches in db. Checkbox "new" removed.
- Bugfixes: Group datafields, Permission problems with reservations, children calculation was wrong, webfolder names
- Multiedit for reservations that are awaiting moderation
- Mark sundays in list view for events and reservations
- Display LDAP errors if connection fails (thanks to PaulH)
- Open webfolders by clicking on fileshare menu (only in IE)
- Allow setting of en_UK or en_US and others with different ll-files
Some database changes have been added with this release.
Apply changesR30.sql to your database before updating to the new release. changesR30.sql is contained in your zip file.
Releasenotes for R29a
This is a bugfix release fixing some critical bugs that where discovered in R29 after the release.
- Missing database column for new module donations in db table ko_admin_groups
- Filter for families, rota teams, groups, roles didn't work properly anymore
- Filter link (OR, AND) for groups didn't work anymore
- Rota checkbox didn't update correctly when editing a single event
- Better support for sending sms from different countries
Release notes for R29
- New module "donations": Different accounts, repeated donations, filters, graphical analysis, export to xls
- New PDF export functionality for address data (people module). Layouts can be defined in admin module
- Multi-row editing is now also available for group datafields (people module).
- English translation of kOOL and documentation (thanks to PaulH).
- New filter for events and reservations: Starting and ending today.
New database tables are needed for the donations module and for the pdf export.
Apply changesR29.sql to your database before updating to the new release. changesR29.sql is contained in your zip file.
Releasenotes for R28
- The installation of kOOL has been improved a lot. It should now be a lot easier and more stable to install kOOL on a new server. - Check out the adapted installation instructions.
- Better sorting of groups, smallgroups and rota teams
- Filling out the forms has become easier
- PDF export of yearly calendar
- Filter for groups applies role to subgroups as well
- Fill pages with addresses when printing labels
Make sure, smarty is installed before updating. As of this release, smarty is not part of the kOOL package anymore.
Update your database with the file changesR28.sql. This file is for a German installation. Adapt it before you use it for a kOOL in a different language.
Releasenotes for R27b
- Bugfixes concerning PHP5 and the use of admingroups
- The assignement to groups while importing addresses didn't work always
- DB change: lastchange in ko_leute changed from DATE to DATETIME (see changesR27b.sql)
- New class for display of lists (beta)
Releasenotes for R27a
- Some important bugfixes (e.g. multiediting group columns)
- Values are stored differently in LDAP to better cooperate with Outlook. Manual Export in Tools module is needed to update all LDAP entries.
- New field (item number) for tapes demands a DB update (see changesR27a.sql)
- New filters for smallgroup data and group datafields (see changesR27a.sql)
|