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:

Ensured anonymous users have access to restricted set of API endpoints only.
A fix to make sure DateTimes in OData are now back to UTC
Resolving an issue that could prevent the download of files from the Files page.