Magic Suite 3.13

Magic Suite 3.13 has been released with the following changes across all products.

ReportMagic

New Features

• Added the "Advanced Report Studio" help topic (last item under the Writing Reports category).
• The MagicSuite API now returns a Bad Request when a PATCH attempts to change IsCancellationRequested (on a ReportBatchJob or ReportJob) to false from true.
• Report Studio now has a "Stop on" feature, where the report will stop upon encountering the selected macro result status (e.g. warning or above, macro error or above, or system error).
• Implemented the [Slide.MoveTo:] macro, which permits moving a slide in a PowerPoint presentation to another location.
• [Kroki.Image:] macro is now present
• There is now a user Notifications page, accessible via the profile page (click the user icon in the top left corner of the UI, then select Notifications).
• There is now an Admin -> Cached Values page.
• It is now possible to obtain the StartDate, EndDate, and Recurring properties of a Toggl Project, using the [Toggl.ProjectProperty:] and [Toggl.ProjectList:] macros.
• The [ReportMagic.SetReportProperty:] macro now supports the outputFileTypes value for the property= parameter (not applicable in Report Studio) which allows different types of output files to be selected during a report, dynamically. Note that for XLSX output, the XLSX tab MUST however be enabled on a Schedule if you want to output XLSX.
• Fixed various dark mode colour display issues.
• Graph axis font colours are now configurable using the xAxisFontColor and yAxisFontColor parameters in [Xxx.Graph:] macros.

Improvements

• The Files preview panel now previews Word documents (the first page, as an image) with a loading spinner present.
• Added 2 help examples for the [Cisco.SecurityAdvisoryList:] macro.
• On the Progress Page's variables pop-up, numbers are right-aligned. This ONLY applies to numbers that are indicated as Integers / Floats / Doubles and not textual numbers (i.e. those where the data type is text, and the value COULD be parsed as a number)
• Added the [Slide.Link:] macro.
• The [Shape.Format:] macro can now add a hyperlink and tooltip to a PowerPoint or Word shape.
• Added the 'minimumWaitMs' parameter to the [LogicMonitor.Dashboard:] macro. Default is 2 seconds (2,000 milliseconds).
• The [Meraki.OrganizationList:] macro now supports the skip and take parameters.
• The edit / create dialog in the Admin -> Macro Defaults page now presents the available parameters for the selected macro, ordered by Mandatory, Conditional, Optional, then by name for each.
• The [ReportMagic.FeedbackProperty:] macro now supports multiple properties. Help examples have also been updated.
• The [ReportMagic.FeedbackList:] macro now emits a JArray of JObjects each of which contains the property names and values. It also now supports AllAsJObject property and supports multiple properties at once.
• The [ReportMagic.FeedbackProperty:] macro now supports the 'AllAsJObject' property.
• The [ReportMagic.FeedbackProperty:] macro now supports the 'priority' property. In Normal Mode, this macro now emits a JObject that contains the property name and value.
• The [List.Complement:] macro can now output a strict difference between list1 and list2 by using the 'strictListDifference' parameter.
• The [Graph.Update:] macro now adds warning to the macro when any of the specified series names were not found in the charts.
• For [LogicMonitor.Dashboard:] pptxPictureFitType has been deprecated and replaced with PictureFitType which works in both DOCX and PPTX input docs
• The Notifications table (admin -> Notifications for Tenant Admins) now only shows the first 2 recipients in the Recipients column. All recipients are shown when the user double-clicks (or clicks the View button) to open the view dialog. Also minor style changes to Recipients column.
• [LogicMonitor.SummaryValueList:] in normal mode now also emits DataSourceId

Bug Fixes

• The aging table now shows CachedValues and ReportBatchJobs as being aged out
• DataMagicSync Executions are now being aged out
• In the files browser, selecting the parent folder entry and right clicking now only provides the Open option.
• It is now possible to set some JSON configuration in a Toggl Connection's "Configuration" field to set the default Toggl Workspace ID (which can be overridden by setting a macro default, or the 'workspaceId' parameter in the macro).
• Fixed an issue where selecting a file with no file extension could show an error.
• Fixed an issue where 'collapsed' versions in Jira e.g. 3.10 would not shown any release notes in the help.
• All [Object.XXX:] macros now appear in the help in the "Object" category, rather than the "Core" category.
• Added the NCalc "countBy()" function to the [Calculate:] macro help, and 2 more help examples that use it.
• Removed various unused parameters from the [LogicMonitor.ConnectionApiToken:] macro.
• Updated help example for the [CloudHealth.OrganisationAccountsList:] macro, to use the cloudAccount parameter.
• Fixed missing square bracket on 4 example help texts for the [Calculate:] macro.
• Added reportId to [CloudHealth.AvailableReportDimensions:] macro examples.
• Changed the propertyDelimiter parameter default to ';' and the sublistDelimiter parameter default to '^' for the [LogicMonitor.RoleProperty:] macro.
• The [LogicMonitor.RecipientGroupList:] macro correctly lists the available properties.
• The [Calculatae:] macro help example #43 now doesn't show an unprintable unicode character.
• Removed an incorrect / out of place help example for the [ReportMagic.FeedbackProperty:] macro.
• The [Cisco.SoftwareSuggestList:] macro no longer lists the 'errorOnOverflow' and 'calculate' parameters, as they do nothing for this macro.
• Removed the unusable 'errorOnOverflow' and 'calculate' parameters from all [CloudHealth.xxx:] macros as it has no effect.
• [LogicMonitor.CollectorGroupList:] now has a list of valid properties in the Parameters table
• AllAsJObject is now listed in the help for the property parameter, for the [LogicMonitor.CollectorProperty:] macro.
• The [LogicMonitor.ReportGroupList:] macro now lists all the available properties that can be used with the 'property' / 'properties' parameters.
• Remove various unused parameters from all [CloudHealth.xxx:] macros.
• Fixed an issue where the [LogicMonitor.CollectorList:] macro with property=id would not work properly in Legacy Mode.
• Fixed an issue where various macros might display emoji symbols of hearts instead of square brackets in the Output section of the Macro Details tab on progress pages.
• Various [CloudHealth.XXX:] macros now display the correct icon in the help and progress page.
• Fixed an issue where new lines in source file (HTML, RM Script) were being replaced with <br/> tags when loading a file into the Report Studio editor, resulting in far too much whitespace.
• The [Toggl.TimeEntryProperty:] macro now returns the report properties (which contains the single time entry in a JArray).
• Fixed an issue where the [Object.Unpack:] and [Object.UnpackVariables:] macros generated a system error.
• Fixed an issue where enum string values from [EnumMember] and [JsonConverter] attributes were not being serialised correctly.
• Fixed issue with various macros in Normal Mode where the requested properties would be returned as enum integer values (0, 1, 2, etc) rather than the string representation (e.g "CollectorType1", "CollectorType2" etc.
• Fixed an issue where the [HubSpot.List:] macro would only provide the last page (up to 100) of results. It now returns all the results.
• Updated [Toggl.XXX:] macros to a;) run without error b) output normal mode-style arrays and objects (instead of strings), c) use the Toggl V9 API. Breaking changes will result!
• The [Regex:] macro now automatically adds outer set of ( ) parentheses, if the pattern does not already use them.
• The datasourceName/dataSource parameter is now optional for the [LogicMonitor.PercentageAvailability:] macro.
• [Meraki.NetworkEventList:] macro now supports more properties.
• Fixed an issue where a Schedule that was stopped due to the stop on settings would still send an email in the specific case where the notify field (i.e. the recipient(s) was populated.
• List.Complement now works with jObjects in Normal mode
• [Meraki.NetworkList:] macro adheres to the calculate parameter.
• The skip and take parameters now work as expected for the [Meraki.NetworkList:] macro.
• Various [CloudHealth.xxx:] macros now error when mandatory string parameters are empty.
• The [Regex:] macro now supports two new boolean parameters: emitSingleMatch (default false) and emitSingleMatchGroup (default false).
• Fixed an issue where the [LogicMonitor.WebsiteGroupProperty:] macro would cause an error when a leading slash '/' was used in conjunction with the websiteGroup parameter.
• The [LogicMonitor.NetscanProperty:] macro now outputs the credentials correctly in legacy mode.
• The [Meraki.DeviceProperty:] macro now generates a Macro Error rather than a System Error, when the requested device serial number does not exist.
• The [ThrowException:] macro, when type=SystemError, now generates a System Error as expected, rather than a Macro Error.
• The [LogicMonitor.CollectorGroupList:] macro in Legacy Mode now outputs the 'HighestPriorityCollectorStatus' property properly instead of a literal string such as "LogicMonitor.Api.Collectors.RestHighestPriorityCollectorStatus".
• In Normal Mode, the [LogicMonitor.CollectorGroupProperty:] macro now emits a JObject that contains property names and values. Multiple properties are now supported. The 'property' parameter is deprecated in favour of 'properties'. The 'collectorGroupId' parameter is deprecated in favour of just 'id'.
• The [LogicMonitor.CollectorProperty:] macro now emits a JObject that contains property names and values, rather than Legacy Mode-style strings. Also added the 'allAsJson', 'allAsJObject', and 'propertyDelimiter' properties, e.g. use like this: properties=allAsJson.
• The [LogicMonitor.CollectorList:] macro now supports the AllAsJson and AllAsJObject properties.
• In Normal Mode, the [ReportMagic.FeedbackProperty:] macro when used with property=CreatedDateTime now does not give an error.
• In Normal Mode, the [LogicMonitor.IntegrationList:] macro now emits a JArray of JObjects that each contains property names and values. It It also supports multiple properties in Legacy and Normal modes.
• In Normal Mode, the [LogicMonitor.IntegrationProperty:] macro now emits a JObject that contains property names and values. It also support multiple properties in Legacy and Normal modes
• The [ReportMagic.SetReportProperty:] macro now errors when the value parameter is empty or contains a blank type.
• The [StopWatch:] macro can now use format, storeAs, and other parameters.
• Fixed an issue where AllAsJObject property did not work as expected for the [LogicMonitor.Threshold:] macro.
• Fixed an issue where the [ReportMagic.SetReportProperty:] macro did not error when setting duplicate file types for the 'outputFileTypes' parameter.
• DataSourceGraphs and OverviewGraphs database migrations are now applied when a DataMagicSync database is created by ReportMagic.
• [Kroki.Image:] now outputs as a svg as the default file type
• [Kroki.Image: fileExtension=svg] outputs in PowerPoint, Word, HTML, PDF, and Email
• Filtering strings with a space in various tables now does not require the user to wrap it in speech marks

AlertMagic

New Features

• Incident Spec Mappings can now be re-ordered in the Alert Studio Configuration Tree. They also load into the correct order.

Improvements

• Fixed an issue where the mapping between EventManagerProblemSpec and ProblemSpecConfig (and vice versa) was not correct.
• AlertMagic redirects to a "You do not have Permissions" page when accessing a page a user does not have permissions for.
• Removed Tenant selector drop-downs from all edit/create screens.
• Added dropdown to Deployment Target edit/create for Tenant specificity (for SuperAdmins only).
• Changed the processed series colour on the AMS input event count chart on the metrics page to use the same green as the processed on the middle 'ratios' output : input count chart 'processed' series.

Bug Fixes

• The Deployment Targets page now loads without error.
• Fixed an issue where after activating a version then saving as a new version would result in an empty configuration on the Alert Studio page (Configuration Tree).

DataMagic

Improvements

• The "Run" button on the Admin -> DataMagic Sync Executions page now re-runs the sync. A pop-up informs the user to refresh the table. It is not done automatically because it can take a few seconds for the sync to be created and scheduled, hence the user should manually refresh the table after a few seconds to see the sync.

Bug Fixes

• Fixed an issue where it was not possible to add a DataMagicSync when the Connection drop-down was left as the default (i.e. on Create).
• DataMagic Sync Executions durations is now in hours
• DataMagic Syncs Executions page now provides live UI updates about the sync which is currently executing