Public Talks

11.3.4 - 2011 Edition (released 2nd November 2011)

• Bug: Export custom report scripts to Microsoft Word were hanging (MantisBT: 0000018).

11.3.3 - 2011 Edition (released 1st November 2011)

• Update: Implemented 64-bit edition (requires 64-bit ODBC drivers).
• Update: Now you report bugs and submit feature requests using the Mantis Bug Tracker.
• Update: Synchronize with Google calendar. See also: Manual Update.
• Update: Show list of speakers who give selected talk.
  This used to be a multiline tooltip control but it was limited to 1024 characters. This limitation has now been removed by using a normal pop-up window.
• Database: Implemented Tagalog database.
• Database: Implemented Swahili database.
• Bug: Minor bug fixes.

11.3.2 - 2011 Edition (released 23rd September 2011)

• Bug: Minor bug fixes.

11.3.1 - 2011 Edition (released 14th September 2011)

• Database: Implemented Twi database.
• Bug: Minor bug fixes.

11.3.0 - 2011 Edition (released 1st September 2011)

• Database: Implemented Bulgarian database.
• Update: Finnish context help - partial translation completed.
• Update: Albanian context help - partial translation completed.
• Update: Implemented Keyword, Function and Variable text colour options.
• Update: You can now specify custom colours on the Text colour options page.
• Update: Buttons on the custom script editor control panel have been re-organized.
• Update: Implemented a new script error indication system.
• Update: Implemented a new Option / Counter Loop command.
• Update: Implemented a new Lookup Field command.
• Update: Implemented a new Insert Script INCLUDE command.
• Update: Improvements made to the Insert Image command.
• Update: Improvements made to the Insert Blank Lines command.
• Update: Improvements made to the Insert TAB command.
• Update: Improvements made to the Linespacing command.
• Update: Improvements made to the Separator command.
• Update: Expression Editor for custom report scripting.
• Update: Implemented Variable Set command and it has been added to the control panel.
• Update: Several new script functions for use in expressions.
• Update: Journal Entry pop-up menu implemented on Home / Away maintenance page.
• Update: #COUNT and #TTCOUNT added to save number of characters in database fields to a variable.
• Update: $LastYear predefined variable implemented.
• Update: $RangeStart predefined variable implemented.
• Update: $RangeEnd predefined variable implemented.
• Update: You can now use CURRENT.[Field] within raw SQL LOOP queries.
• Bug: Minor bug fixes.

11.2.1 - 2011 Edition (released 11th March 2011)

• Language: French context help completed.
• Bug: Minor bug fixes to LOOP SQL command.

11.2.0 - 2011 Edition (released 1st March 2011)

• Update: Microsoft Access Runtime bit mode setting removed from program preferences.
• Update: You can now filter by speaker on the Talk Request List.
• Update: You can now insert and update flexible criteria within IF and LOOP custom report script commands using the control panel.
• Update: You can now insert and update raw SQL LOOP custom report script commands using the control panel.
• Update: A speakers favourite talks are now indicated with a # prefix when exporting/importing Congregation data.
• Update: You can now indicate whether a speaker is serving as an appointed Ministerial Servant. As a result the following adjustments have been made:
• Ministerial Servant check box added the Congregations maintenance page.
• Ministerial Servant check box added to the New / Modify Speaker window.
• Ministerial Servant colour setting added to the Text Colours preference page.
• Ministerial Servant is added in parenthesis after a speakers name on the Talk Request List window.
• Ministerial Servant added to the Congregations Import facility.
• Ministerial Servant added to the congregation Synchronize facility.
• Speakers who are appointed as Ministerial Servants now show in the speaker drop lists in your chosen colour (example).
• Update: You can now assign an Interpreter for each meeting. As a result, the decision was made to combine four existing database tables: Watchtower Readers, Chairmen, Hospitality and WT Conductors into one table called Brothers. The migration of your data will be managed by the program automatically (note that any custom field data will be discarded). Any custom report scripts that listed the aforementioned tables will need to be changed to use the Brothers table with the relevant criteria to restrict the list. None of the standard reports have been adjusted, so if you want to start maintaining this information you will have to use custom report scripting. As a result of implementing Interpreter the following adjustments have been made:
• Interpreter and Hospitality added to the brothers Import facility.
• Interpreter and Hospitality added to the Brothers maintenance page.
• Interpreter added to home / away talk Import facility.
• Interpreter added to Home Talk entry window.
• Interpreter added to Home Talks Report setup page.
• Interpreter added the the Rearrange Dates wizard.
• Interpreter added to the Summary Info settings window.
• Interpreter added to the Assignments window.
• Interpreter now included when Sending to Microsoft Outlook.
  Note: Some of the field mappings will have reset to <Do not send>. Adjust as required.
• The Hospitality property page has been removed.
• Update: Journal entries can now be displayed on the home / away maintenance calendar in pop-up tooltips. See the help topic for an example.
• Update: All FIELD related commands in the custom report script editor now support true SQL loops. If you use JOIN etc. keep in mind that each field in the resulting record set must be unique.
• Language: Turkish context help completed.
• Language: French implemented (context help still in translation).
• Bug: Minor bug fixes.

11.1.0 - 2011 Edition (released 16th January 2011)

• Update: New predefined variables LastWeek, LastMonth, NextSixMonths. See here.
• Update: LOOP now supports a true SQL facility. This is very powerful and should only be used by advanced database users. Using SQL you can build queries that combine the results of one or more tables. So you can collate details together and simplify your script/report process. Using an SQL statement in this way could reduce the need for some inner LOOP constructs. At the moment such script must be typed manually with a text editor (e.g. Notepad) and then pasted into the script editor. All FIELD related commands will also need to be pasted in manually from a text editor. The next version of Public Talks will include the required changes to the user interface.
• Update: LOOP and IF now support improved criteria. You can now use any combination of AND, OR, NOT and brackets ( ... ). So your LOOP and IF comparisons can now be more flexible and you will find instances where you can now use one LOOP or IF instead of two or more. At the moment you must type such script in your own text editor (e.g. Notepad) and then paste it into the script editor. The next version of Public Talks will include the required changes to the user interface.
• Update: Resetting variables to specific text values. The edit control will now word wrap correctly rather than scroll to the right.
• Update: VARIABLE_FIELD command now word-wraps in the custom script editor's script source box (this does not affect how it renders in the final report).
• Update: TEXT command now word-wraps in the custom script editor's script source box (this does not affect how it renders in the final report).
• Update: COMMENT command now word-wraps in the custom script editor's script source box (this does not affect how it renders in the final report).
• Update: PARAGRAPH command now word-wraps in the custom script editor's script source box (this does not affect how it renders in the final report).
• Update: LOOP command now word-wraps in the custom script editor's script source box (this does not affect how it renders in the final report).
• Update: IF command now word-wraps in the custom script editor's script source box (this does not affect how it renders in the final report).
• Update: You can now reset variables to fixed variable values (e.g.: NextYear)
• Language: Albanian.
• Language: Turkish (now complete and verified).
• Bug: Minor bug fixes.

11.0.0 - 2010 Edition (released 13th December 2010)

• Bug: DatabaseUtility (used for several database operations) needed to have a dedicated 32bit edition of the utility. The existing would fail when you have 64 bit operating system and 32 bit Microsoft Access (or runtime). The program General Preferences window has a new setting to let you change this mode.

Archive Revision History 10.0 - 9.0