Release notes
Analytics and ACL for Windows are desktop applications. When new versions are released, you or your system administrator can download the latest version from HighBond and install it on your machine.
| Type | Date | App | Description | Ticket Number for SOC 2 Compliance |
|---|---|---|---|---|
| Important | August 21, 2020 |
Analytics 14.1 Analytics 14 Robots Agent 14.1 Robots Agent 14 Analytics Exchange 14.1 Analytics Exchange 14 |
SAP Connector issue related to licensing Using the SAP Connector in Analytics 14.0.x or 14.1.x may result in a "SapDriverLicenseInvalid" error. If you encounter this error, upgrading to Analytics 14.2.x will resolve the problem. If you are experiencing the same issue with Robots or Analytics Exchange, contact Support for assistance. |
CS-10562 |
| Fixed | August 2019 | Analytics 14.1.2 | Delimited file import Characters were being omitted from the import of a delimited file if the file contained a delimiter character at the end of the line (end of the record). The issue has now been resolved. (AN-7700) | |
| Fixed | June 2019 | Analytics 14.1.1 | ACL connector for Oracle The ACL connector for Oracle was failing to import a portion of the specified data, resulting in blank values in some fields. An issue with the driver used by the connector was causing the problem. The issue has now been resolved. (AN-7653) | |
| Fixed | June 2019 | Analytics 14.1.1 | Oracle import WebSocket error Certain imports containing integer fields performed by the ACL connector for Oracle were failing with a WebSocket error. An issue with the driver used by the connector was causing the problem. The issue has now been resolved. (AN-7672) | |
| Fixed | June 2019 | Analytics 14.1.1 | Data Access window connections If a large number of connections were saved in the Data Access window, the saved connections were not loaded when subsequently opening the Data Access window, and new connections could not be saved. This issue has now been resolved and the Data Access window has been tested with 120 connections and verified to work properly. (ADA-1459) | |
| General Comments | May 2019 | Analytics 14.1 |
Rebranding and product name changes ACL Services is now Galvanize, and our cloud-based platform, ACL GRC, is now called HighBond. ACL Analytics is now simply Analytics. For more information, see We rebranded. How do these rebranding changes affect Analytics? The short answer is that Analytics 14.1 continues to function in the same way as previous versions of Analytics, with the addition of the new features and enhancements described in these release notes. Analytics scripts No change. Scripts authored in previous versions of Analytics continue to run in Analytics 14.1. Analytics subscription Analytics subscriptions are now part of the subscription for ACL Robotics, a Galvanize solution containing Analytics, and lite versions of Robots and Results. |
|
| New | May 2019 | Analytics 14.1 | Expanded machine learning capabilities Train and Predict are two new related commands that expanded the automated machine learning capabilities in Analytics. You can use the commands to develop predictive models and predict classes or numeric values associated with unlabeled data. The new commands join the Cluster command, the other machine learning command in Analytics.
|
|
| New | May 2019 | Analytics 14.1 | New data connectors You can now connect to these external data sources using newly added data connectors:
|
|
| New | May 2019 | Analytics 14.1 | IMPORT MULTIDELIMITED The new IMPORT MULTIDELIMITED command allows you to use a single command to script the import of multiple delimited files. You reference multiple files by using a wildcard character (*) in file names. Learn more > | |
| Enhanced | May 2019 | Analytics 14.1 | Export to Excel field length The field-length limit of 254 characters when exporting from Analytics to an Excel file has been removed. Export to Excel now supports any field lengths that in combination do not exceed the overall record length limitation of 32 KB. Learn more > | |
| Enhanced | May 2019 | Analytics 14.1 | Classify key field length The maximum key field length has been increased from 64 characters to 2048 characters. Learn more > | |
| Enhanced | May 2019 | Analytics 14.1 | Accessibility improvements Keyboard-only access, and screen reader text, have been significantly expanded and improved throughout the Analytics user interface. | |
| Enhanced | May 2019 | Analytics 14.1 | Include display names with HighBond export You can include column display names when you export from Analytics to Results. Learn more > | |
| Enhanced | May 2019 | Analytics 14.1 | Retry Command Attempts The configuration option Retry Import Attempts has been renamed Retry Command Attempts and has been extended to include exports to HighBond Results. Learn more > | |
| Fixed | May 2019 | Analytics 14.1 | Tabs in scripts Tabs in Analytics scripts are now automatically replaced by four spaces, which preserves the intended indentation or formatting without interfering with script execution. Previously, tabs were replaced with a single space. (AN-7371) | |
| Fixed | May 2019 | Analytics 14.1 | Redundant confirmation prompt A redundant confirmation prompt no longer appears when you manually close a table that was created and opened by a script. (AN-7307) | |
| Fixed | May 2019 | Analytics 14.1 | Outliers command no longer runs immediately When you double-click an entry for the Outliers command in the log, the command no longer runs immediately. Double-clicking a command in the log should only populate the command syntax in the View tab. (AN-7239) | |
| Fixed | May 2019 | Analytics 14.1 | Outliers command correctly populates the WRITE1 variable The Outliers command now correctly populates the WRITE1 system variable with the number of records in the output table. Previously, it was populating the variable with a value of zero (0). (AN-7131) | |
| Fixed | May 2019 | Analytics 14.1 | Empty last field in *.csv and *.dat files correctly imported An empty last field in *.csv and *.dat files is now correctly imported. Previously, a empty last field was dropped from the import. (AN-6859) | |
| Fixed | May 2019 | Analytics 14.1 | EXTRACT command handling missing field correctly If the EXTRACT command specifies a field that is not present in the target table, an appropriate error message appears. Previously, Analytics entered an infinite loop, or crashed. (AN-6523) | |
| Unresolved | May 2019 | Analytics 14.1 | Canceling the Train command on Windows 7 On the Windows 7 operating system, if you cancel the Train command from the progress dialog, the underlying main Python process is closed, but Python sub-threads continue to run. Workaround: If you want to stop these sub-threads, end them in Task Manager, or restart your computer. (AN-7570) |
|
| Unresolved | May 2019 | Analytics 14.1 | Training a model using regression Training a predictive model using regression algorithms on a large data set can cause the training process to run for a long time. In addition to overall data size, run times can be affected by the number of specified feature fields, and the processing capacity of the computer running the command. Workaround: Consider using sampling to reduce the size of the training data set, and do not include feature fields that do not contribute to predictive accuracy. (AN-7563) |
|
| Unresolved | May 2019 | Analytics 14.1 |
Analytics Update notification The notification that normally appears in the Windows taskbar alerting users to a new version of Analytics is currently not working. Workaround: Users or a company’s HighBond account administrator can periodically sign in to Launchpad (www.highbond.com) and check for an updated ACL for Windows installation package. (AN-7676) |
|
| New | November 2018 | Analytics 14 | Robots Analytic scripts, authored in ACL, can now be uploaded to Robots, a new, easy-to-use, cloud-based option for scheduling and running analytic scripts. Existing analytic scripts used in Analytics Exchange or the Analysis App window can be run in Robots with little or no modification. |
|
| New | November 2018 | Analytics 14 | Machine learning command The new Cluster command is the first of a planned set of machine learning commands in ACL. With Cluster, you can discover groupings in a data set that may have gone undetected with traditional approaches.
|
|
| New | November 2018 | Analytics 14 | SAP data connector The integrated Data Access window in ACL now includes an SAP data connector, which provides an easy way of connecting to an SAP system and importing data. SQL-like queries are easier to edit than comparable queries in Direct Link. The SAP data connector requires a separate subscription entitlement beyond the basic ACL subscription. Learn more > |
|
| New | November 2018 | Analytics 14 | New ACL data connectors You can now connect to these external data sources using newly added ACL data connectors:
|
|
| New | November 2018 | Analytics 14 | Outliers The new outliers feature (OUTLIERS command) identifies statistical outliers in a specified numeric field in an ACL table. You have the option of identifying outliers by group, or for the entire table.
|
|
| New | November 2018 | Analytics 14 | Fuzzy joins You can now join two tables on key field values that are nearly identical. You can choose between two fuzzy matching algorithms: Dice coefficient or Levenshtein distance. Existing joins in ACL require that key field values be exactly identical to constitute a match.
|
|
| New | November 2018 | Analytics 14 | Retry imports A new configuration option, Retry Import Attempts, allows you to specify that ACL will retry failed imports from certain types of data sources, and to specify the number of repeated attempts. Learn more > | |
| Enhanced | November 2018 | Analytics 14 | Security upgrades To improve overall application security, ACL contains updated versions of several components that are installed along with the application. These changes were first made in version 13.1. | |
| Enhanced | November 2018 | Analytics 14 | Excel import You can now import Excel worksheets from multiple Excel files simultaneously. This latest enhancement builds on the ability, introduced in version 13.0, to import multiple Excel worksheets simultaneously from a single Excel file. Learn more > |
|
| Enhanced | November 2018 | Analytics 14 | IMPORT MULTIEXCEL The new IMPORT MULTIEXCEL command allows you to use a single command to script the import of multiple Excel worksheets. You reference multiple worksheets by using a wildcard character (*) in file or worksheet names. Learn more > | |
| Enhanced | November 2018 | Analytics 14 | Improved Join dialog box The Join dialog box has been redesigned, with a more logical arrangement of fields, and icons for each join type. The new design makes selecting the correct join type easier and more intuitive. Learn more > | |
| Enhanced | November 2018 | Analytics 14 | Improved harmonizing in Append Two new options for the Append command support harmonizing common fields on the Character data type, or importing all fields as Character data.
|
|
| Enhanced | November 2018 | Analytics 14 | Resize the DDW The Data Definition Wizard, used for defining data and importing it to ACL, can now be resized, or maximized. The ability to use your full screen for previewing and working with data makes the experience of importing files such as Excel, delimited text, and PDF much more user-friendly. |
|
| Enhanced | November 2018 | Analytics 14 | Auto-add new fields Newly created physical or computed fields can optionally be added to the table view automatically. The Add created field to current view option is now available in the Table Layout dialog box. | |
| Enhanced | November 2018 | Analytics 14 | Data Access window improvements Two improvements have been made to the Data Access window:
|
|
| Fixed | November 2018 | Analytics 14 | Scrolling Scrolling in views for large tables has improved responsiveness. | |
| Fixed | November 2018 | Analytics 14 | Resize columns The menu option Resize All Columns now correctly adjusts the column widths in a table view. (AN-6282) | |
| Unresolved | November 2018 | Analytics 14 | In the SAP connector in the Data Access window, using a SQL OR operation to reference two different fields within a single filter group does not work. (ADA-1186) | |
| Unresolved | November 2018 | Analytics 14 | A connection for the ACL ServiceNow connector saved in ACL 13 does not work in ACL 14. Users need to create a new ServiceNow connection in ACL 14. (ADA-1329) | |
| Unresolved | November 2018 | Analytics 14 | In the Jira connector in the Data Access window, data in custom Jira fields is not shown in the Import Preview. The data in the custom fields is imported correctly. (AN-7032) | |
| Fixed | September 2018 | Analytics 13.1.1 | The SQL Server connector only supports the default instance when specifying the server name in version 13.1. It does not support named instances and you cannot use the format "serverName\instanceName" when establishing a connection. You must specify "serverName" only. After running the 13.1.1 patch installer, you can connect to named instances using the format "serverName\instanceName". |
|
| Important | August 2018 | Analytics 13.1 | The following Microsoft components, installed by previous versions of ACL Analytics, have known vulnerabilities:
ACL Analytics 13.1 does not use these components and uninstalling them does not impact the application. Caution Only uninstall the Microsoft components if you know that they are not used by any other application on your computer. Consult your IT department if you are uncertain whether to uninstall the components. |
|
| Important | August 2018 | Analytics 13.1 |
Uninstall Microsoft Access Database Engine 2010 before you install ACL Analytics 13.1. If you install ACL Analytics 13.1 first, before uninstalling Microsoft Access Database Engine 2010, Excel imports and exports do not work in any previous version of ACL installed side by side with version 13.1. Note To fix this situation, in the Windows Control Panel, Repair the Microsoft Access Database Engine 2016 installation. |
|
| Important | August 2018 | Analytics 13.1 |
The Concur connector no longer supports authentication without a Concur access token. Any scripts currently configured with user credentials that do not include a token must be updated to use a Concur access token. You can obtain a token directly from Concur, or by entering your user credentials in the Data Access window and clicking Get Token. Make note of your token's expiry date when you obtain it. Concur tokens expire after one year. Learn more > |
|
| Important | August 2018 | Analytics 13.1 |
The Concur connector now requires that you specify the host name of Concur's API server when connecting. As of the 13.1 release, this value is "https://www.concursolutions.com". Existing scripts that use the native Concur connector and an access token continue to work. However, if you are using a DSN connection or you open the Data Access window, you must specify a host name in the Host field for the connection to succeed. Learn more > |
|
| Important | August 2018 | Analytics 13.1 | If you intend to silently install or upgrade to ACL Analytics 13.1, use the setup.exe installer file. Do not use the ACL for Windows.msi installer file. setup.exe installs the updated, more secure versions of all required software prerequisites on the target computer, if they are not already installed. ACL for Windows.msi does not install prerequisites. |
|
| Enhanced | August 2018 | Analytics 13.1 | The following third-party components that are installed along with ACL for Windows have been updated to more secure versions:
|
|
| Enhanced | August 2018 | Analytics 13.1 | The following ACL data connectors have been updated to improve security:
|
|
| Fixed | August 2018 | Analytics 13.1 | When attempting to activate a newly installed version of ACL, the user can be stuck in a sign-in loop and be unable to activate the software. (AN-6493) | |
| Fixed | August 2018 | Analytics 13.1 | Python commands are running twice when called from ACL. (AN-6436) | |
| Fixed | August 2018 | Analytics 13.1 | Concur connector performance is improved when filtering data using '<', '>', and '>=' operators on the following fields: Last_Modified_Date, Create_Date, User_Defined_Date, Submit_Date, Processing_Payment_Date, Paid_Date. (ADA-1226) | |
| Unresolved | August 2018 | Analytics 13.1 | After upgrading ACL from version 13.1.0 to 13.1.1, the version number remains unchanged in the splash screen that appears when you open ACL, or select Help > About. The correct version number does appear in the Windows Control Panel. |
|
| Fixed | April 2018 | Analytics 13.0.3 | Using the RECOFFSET( ) function on a table with an index applied can produce unreliable results. (AN-6357/AN-6351) | |
| Fixed | April 2018 | Analytics 13.0.3 | The SAVE TABLELIST command doesn't display all the tables after a manual import of multiple Excel worksheets. (AN-6275) | |
| Fixed | April 2018 | Analytics 13.0.3 | The UNMATCHED join type fails with certain combinations of data and ACLScript syntax. (AN-6207) | |
| Fixed | April 2018 | Analytics 13.0.3 | Output results from the many-to-many join are inconsistent with different buffer sizes, or reversed primary and secondary table order. (AN-6134) | |
| Fixed | April 2018 | Analytics 13.0.3 | Garbled text appears when using the ACCESSDATA command to import Arabic data from an IBM AS/400 server. (ADA-1142) | |
| Fixed | N/A | Analytics 13.0.2 | Not a general release. | |
| Fixed | December 2017 | Analytics 13.0.1 | The APPEND command is duplicating a single record after every block of 10,000 records in the output table. (AN-6154) | |
| Fixed | December 2017 | Analytics 13.0.1 | The dialog box that appears when overwriting an index on a table is not showing the correct information. (AN-6155) | |
| Fixed | December 2017 | Analytics 13.0.1 | In the ACCESSDATA command, removing a system-generated space before the SOURCE or SQL_QUERY keywords causes the command to fail. (AN-5692) | |
| New | November 2017 | Analytics 13.0 | The new append operation (APPEND command) adds the ability to combine records from multiple ACL tables simultaneously. You have the option of including all the fields from all the tables being combined, or just those fields that are common to all the tables.
|
|
| New | November 2017 | Analytics 13.0 | You can now connect to these external data sources using newly added ACL data connectors:
|
|
| New | November 2017 | Analytics 13.0 | The addition of classical variables sampling (CVS) means that ACL now supports all three major types of audit sampling:
The CVS feature set includes the ability to stratify a population based on a statistical formula that optimizes strata boundaries, which helps create efficient sample sizes. |
|
| New | November 2017 | Analytics 13.0 | The new RCOMMAND command passes a list of ACL fields to an external R script for analysis and creates a new table in the ACL project with the data returned from R. Learn more > | |
| New | November 2017 | Analytics 13.0 | A new system variable AXRunByUser is available in scripts and stores the user name of the account that runs an analytic, in the format "domain\username". Note The AXRunByUser variable is only available when running analytic scripts on AX Server. It is unrecognized when running scripts in ACL Analytics. |
|
| Enhanced | November 2017 | Analytics 13.0 | Importing data from Excel now supports importing multiple Excel worksheets simultaneously. Learn more > | |
| Enhanced | November 2017 | Analytics 13.0 | The ALLFIELDS parameter has been added to the IMPORT EXCEL command, allowing you to import all fields in an Excel worksheet without having to define them individually. Learn more > | |
| Enhanced | November 2017 | Analytics 13.0 | The Presort option on the Join command now uses the specified-field approach to sorting introduced in ACL 12.5. Only those fields specified in the join operation are involved in the Presort. If you specify a small subset of fields for joining, the join operation executes more quickly. | |
| Enhanced | November 2017 | Analytics 13.0 | Cross-tabulating now supports numeric key fields. Previously only character key fields were supported. | |
| Enhanced | November 2017 | Analytics 13.0 | The Any Not Equal option has been added to Quick Filter when filtering by multiple values in a record. Learn more > | |
| Enhanced | November 2017 | Analytics 13.0 | R functions now accept variables when specifying the R script or R code to run. | |
| Enhanced | November 2017 | Analytics 13.0 | Limited support for Python versions other than the default supported version 3.5.x. Learn more > | |
| Enhanced | November 2017 | Analytics 13.0 | Connections to Concur now include a User Param setting that imports data from the expense module for specific user accounts, or for all accounts. Learn more > | |
| Fixed | November 2017 | Analytics 13.0 | Salesforce and Amazon Redshift connectors now support SSL version 1.0.2. | |
| Fixed | November 2017 | Analytics 13.0 | Accessing ScriptHub through ACL causes a blank screen to appear. (AN-5789) | |
| Fixed | November 2017 | Analytics 13.0 | Installing ACL 12 replaces Windows system fonts with shortcuts to older versions of the fonts in the ACL installation directory. (AN-5550) | |
| Fixed | November 2017 | Analytics 13.0 | For ACL analytics run across the boundary of midnight, the DATETIME( ) and TODAY( ) functions are not correctly incrementing the date value. (AN-5032) | |
| Fixed | November 2017 | Analytics 13.0 | A variable with an empty space in place of "COMMENT" text causes commands to be skipped. (AN-4072) | |
| Fixed | November 2017 | Analytics 13.0 | During the import of a delimited file, manually adjusting the width of a blank field is not preserved in the resulting ACL table. (AN-5496) | |
| Fixed | November 2017 | Analytics 13.0 | Previewing a report with the Presort option causes ACL to crash. (AN-5526) | |
| Fixed | November 2017 | Analytics 13.0 | Export to Excel is not working with Arabic characters. (AN-5399) | |
| Unresolved | November 2017 | Analytics 13.0 | The NEXT parameter of the RCOMMAND may not behave as intended in some cases. Avoid using this parameter as the record reference may reset to the first record regardless of which record is currently selected. |
Historical release notes are available on request.
Analytics 14.1 Help