ReportMagic 3.3

Overview

ReportMagic 3.3 contains new features, improvements and some bug fixes.

For Microsoft SQL or Postgres databases with Internet accessibility, a series of new [Database:] macros are available which bypass the need to install the ReportMagic Agent. The Help pages describe how to configure such a Database connection and how to use the new [Database.Graph:], [Database.List:], [Database.Table:], [Database.Value:] and [Database.Values:] macros. Organisations that use this feature are advised to use an IP Safelist to restrict access to just the ReportMagic IP address range.
PDF output of the LogicMonitor HealthCheck is free for all users, as stated on the homepage
Two additional [Meraki.Xxx:] macros are available and documented in the Help section:

New [Shape:] macros are available for use in report templates that use DOCX report templates:

Regression test support for Report Schedules is now available, creating a .png image of every page of output and storing it in a .png.zip file. The regression system compares the baseline .png.zip file with the .png.zip file just created in order to identify differences. These differences are stored in a .diff.png.zip file (when applicable). To use this feature, ensure that your Report Schedule's name starts with the string "Regression "

Various [AutoTask.Xxx:] macros, including [AutoTask.List:], now support multiple properties via the properties= parameter. E.g. 'properties=property1;property2;property3...'
The API now allows file conversion between docx to DOCX/PDF/HTML/PNG/PNG.ZIP:

The Progress Page now includes an additional button to go to the Schedule's current input folder via the Files page (opening a new browser tab), and the report job panel now includes two new icons to go to the input / output folders (again opening a new browser tab); it is the folders from the time the report job ran that are opened

Fixed an issue expanding the User Files folder from the Files page as well as via the File picker pop-up
The Progress bar variables panel now shows empty variables as empty instead of saying "Not set"
Fixed an issue that was causing Report Studio to report a System Error upon the successful execution of macros
Improved the reporting of a transient error that can occur during the processing of [LogicMonitor.Xxx:] macros in a report schedule
Users are now emailed when their account has been approved
Moved Certification help topic from "Advanced" help category to "Miscellaneous"
Several issues have been address with SharePoint filesystems:

Fixed an issue in the API that was causing some output documents to fail to be copied to their SharePoint location
Fixed an issue with SharePoint output folder locations where a System Error with the message 'Conflict' was being reported upon the successful execution of a report schedule
Fixed an issue in the API with bulk file upload to SharePoint folders that was resulting in gateway and conflict errors
It is now possible to move or copy files between SharePoint and ReportMagic filesystems

Fixed an issue where edits to Schedules are lost if the schedule is edited whilst the schedule is running
Fixed an issue that was causing report schedules to hang
Forms that are opened when a schedule is run will now take notice of the 'required' HTML attribute on inputs, preventing empty values from being submitted if desired by the form author
Addressing the failure to age Report Schedules and Report Macro Results

Fixed an issue with the [If:] [Else:] [EndIf:] macros whereby an empty first cell (first row) in a table with a condition that evaluates to false would result in a system error / exception
Fixed an issue where an exception error would occur when using an [If:] macro before a Table of Contents
Fixed an issue where, in a Word document, when a hyperlink is the last item in a paragraph (i.e. there are no spaces or other characters after it), then when used between an [If:] / [Else:] macro, all macros between them would execute

List.Table macro now allows Infinity values (+/-) only when format=AllStrings is used
When format=AllStrings is used on [List.Table:] macro, values that are numbers (but treated as strings) will be left-justified

[Table.Graph:] palette parameter now correctly specifies colour of the graph
A 'timeout exceeded' error message is now reported when Agent connectivity times out during the execution of an [Agent:] macro
Fixed several issues with the API including: