MySource Matrix Developer

MySource Matrix Changelog - 3.20.2 to 3.20.3

Featured Changes

Authentication Filtering for LDAP

A new option, "Auth Filter", has been added to the LDAP Bridge to restrict the users who are allowed to authenticate by LDAP user attributes. Filter specifications such as "ou=Sydney" (for users within a Sydney office) or boolean combinations "&(ou=Sydney)(ou=Developers)" (Sydney developers) can be specified here.

Form CAPTCHA Enhancements

Some new options are now available for CAPTCHA fields on the "Form Contents" screen in Custom Form. This has been graciously contributed to the Matrix core by Nic Hubbard.

These new options - available from the "Details" screen in Asset Builder and Account Manager, and the "Contents" screen in Custom Form - include the ability to specify a TrueType font from a TTF file, the character angle range and use of arc shapes across the characters. Uppercase letters and numbers are also available as options for CAPTCHA fields.

Search Page: Dynamic Date Range search result restriction

A date range can now be to be specified in which all search results must fall. This date range is configured from the "Restrict Results Date Range" section of the "Search Fields" screen of the Search Page asset, and uses a standard asset date field as a reference point.

For example, a Search Page can be configured to return assets which have been updated in the last two weeks. The Dynamic Date Range is only a backend feature and as such cannot be configured or included in the Search Page form for user control.

Check Database Indexes System Integrity Script

A new command line script, "system_integrity_check_indexes.php", included in the "scripts" directory has been added. This script checks for any missing indexes in the Matrix database.

The SQL statements for any missing indexes are printed for copying and manual intervention. This is a manual process as adding keys automatically may result in SQL errors depending on the current system state, or an unexpected change of tables which were reconfigured for a particular purpose.

This script also checks for unique database indexes. The index definition is also checked on PostGres systems. For example, when Matrix is expecting an index on columns "a", "b" and "c", but the database only has the first two columns indexed, an incorrect index will be reported.

Accessible CAPTCHA

A new switch is provided in the "CAPTCHA" section of the "Details" screen of Account Manager and Asset Builder assets and the "Contents" screen of Custom Form to enable an Accessible CAPTCHA. When enabled, a link will appear next to the CAPTCHA image, whether used in isolation or within a "%form_captcha%", to toggle between using the CAPTCHA image or an email address field.

When clicked, the image CAPTCHA interface will be replaced with a text field and button, prompting for input of the user's email address. A verification email will be sent to the specified address once the "Submit Address" button is clicked. The user's session and the resultant email is populated with a key which is used to match the intention to submit the form to the corresponding user.

A link is provided in the email which when clicked will verify the key against that stored in the session and flag the form as verified for CAPTCHA purposes.

Once the form is submitted, the contents is accepted. The Accessible CAPTCHA process must be restarted for subsequent forms or upon verification failure of fields in the same form, as is the case with the traditional CAPTCHA.

Drag-and-Drop Step re-ordering in Workflow Schema

The list of Workflow Steps on the Details screen of Workflow Schema assets now provides a drag-and-drop interface for re-ordering these steps. In order to re-order steps, drag the Step number at the left of each entry, above or below other Step entries. The dragged step will become slightly transparent and provide docking points (similar to re-ordering assets in the Asset Map). Release the mouse button and when the steps are in the desired order, click "Commit" to complete this action.

Connections to Oracle Databases from DB Data Source / Connector assets

An "oci:" prefix is now added from the separate fields and recognised when a DSN is manually entered for DB Data Source and DB Connector assets. The DSN supplied can be in simple PDO_OCI format, with a "dbname=" specification.

It is now valid to provide an Oracle connection by one of the following methods:

• From the separate fields: Hostname is optional if a tnsnames entry is to be used (in which case this is specified as the database name)
• From the DSN field: As an "oci:"-prefixed specification as follows:
  • oci:dbname=hostname
  • oci:dbname=hostname/dbname
  • oci:dbname=tnsname

Please note that the "oci:dbname=" notation is only supported to the point of providing access to an Oracle database and is not designed for or intended to emulate the full PDO_OCI DSN specification for Oracle connections

Change to Permission structure for Pending User Accounts in Account Manager

Pending User accounts are now stripped of any permissions cascaded to them by the Pending Accounts folder. The only permission they will keep by default is its own Admin Permission, as is standard across all users.

Customisable Workflow Emails

Introduced a new "Custom Messages" screen to the Workflow Step asset for entering a custom Workflow message body for a Workflow Step. The following workflow messages can be customised: invitation, approval, rejection, stale workflow, and escalation.

Additional Changes and Bug Fixes

Core

• Fixed Bug #3519: Form Question - Tickbox Table screen Incomplete
• Fixed Bug #3534: Asset Builder Dynamic create locations - assets not appearing in list when not at top level
• Fixed Bug #3547: MP3 File Attributes Should Be Float
• Fixed Bug #3554: WYSIWYG Metadata not working in Simple Edit Layout
• Fixed Bug #3555: "Fatal error" when running import_asset_csv_to_matrix.php under PHP 5
• Fixed Bug #3558: Cannot change WYSIWYG Metadata Field from default on backend
• Fixed Bug #3560: Multi text fields not saving all data
• Fixed Bug #3562: Cannot add new select field options in Custom Form on Safari
• Fixed Bug #3563: Set Paint Layout trigger action throws PHP Notice errors when optional items omitted
• Fixed Bug #3564: Workflow email does not contain a link to the preview screen
• Fixed Bug #3565: Safe-Editing Metadata does not work
• Fixed Bug #3569: Simple Edit Layout assignments only apply to one asset URL
• Fixed Bug #3574: Unable to create Notice links from linking screen
• Fixed Bug #3579: Hex URL encodings stripped
• Fixed Bug #3580: Lineage of NOTICE links in linking screen is missing
• Fixed Bug #3584: Asset builder creating assets fails if any Create screen attribute values are omitted - only affects Oracle systems
• Fixed Bug #3586: "Edit Metadata Threshold" appears twice on the HIPO Configuration screen
• Fixed Bug #3589: "Cascade schema" option shown on Set Permission and Set Future Permission Trigger Actions
• Asset Manager performance improvements

CMS

• Fixed Bug #3483: Search keyword group_total_child_asset_count always returns 0
• Fixed Bug #3498: Not caching all nested asset listings
• Fixed Bug #3523: %nested_asset_% keywords not working
• Fixed Bug #3525: When having Thesaurus terms tagged under a Form Asset, upgrading throws error "Undefined index: options"
• Fixed Bug #3544: Custom Form Keyword %form_captcha% does not display customised CAPTCHA colours
• Fixed Bug #3552: Second-level grouping on a Metadata Field or Standard Field in Asset Listing causes listing to be blank
• Fixed Bug #3557: Question note error on multiple page custom form
• Fixed Bug #3588: Asset builder will not create asset if attributes contain any HTML special characters
• Fixed Bug #3590: Form action save as XML not saving existing files
• Form and Form Submission asset IDs and submission date now exported in default Form Submission XML output
• Listing Engine performance improvements

Data

• Fixed Bug #3515: DB Data Source causes Matrix SQL Execution Error
• Fixed Bug #3539: Cannot connect to Oracle DB with DB data source

Search

• Fixed Bug #3538: Multiple word keys search with select/multiselect on search issue
• Fixed Bug #3587: Search log Report breaks when user has searched for terms with slashes