Posts

ReportMagic 3.9

 New Macros  [Function.Define:] macro lets you store macros and not process them until they are called by [Function:Call:] [LogicMonitor.HistoricSdtList:] macro returns historic SDTs in the chosen date range [LogicMonitor.SdtPercentage:] macro determines the percentage of time that a Website, DeviceDataSource, DeviceGroupDataSource or DeviceDataSourceInstance is in Scheduled Down Time [Random:] macro generates random numbers [ReportMagic.BadgeList:] lists ReportMagic badges achieved by a user Powerpoint macros which can now be inserted into a shape's text or Alt Text: [Shape.Add:] supporting all the built-in shape types [Shape.Clone:]  [Shape.Format:] supporting various manipulations of a shape (fill colour, font size, etc.)  [Shape.Hide:]  [Shape.SetText:] to set entire shape's text Macros that generate images or charts (such as [File.Image:], [LogicMonitor.Graph:], [Web.Image:])  Improvements Significant performance improvements with [ForEach:] macros, as well a

ReportMagic 3.8

New Features PowerPoint enhancements Macros in the Notes field are now processed [Shape.Format:] macro supports various shape manipulations via shape text or shape alt text Macros [Xlsx.Embed:] macro lets you embed the output xlsx  in your DOCX report output [Convert:] can convert to or from base64 [File.Embed:] macro embeds a PPTX or XLSX file in your DOCX report output   [List.Table: convertToWebLink=true] creates clickable links for any items that start with http:// or https:// [Meraki.ReportXXX:] macros were removed as these relied on unsupported Meraki data Improvements Up to 10x generation speed improvements [Jira.IssueLastCommentProperty:] now renders images [Jira.InsertMarkup:] correctly orders multiple images, can insert different image file types Better error message when a Jira macro fails due to authorisation issues [LogicMonitor.DeviceGroupList:] supports the calculate parameter Help Improvements RM Script help / documentation Updated help and examples for macros: [File.Cs

ReportMagic 3.7

New Features User Interface Schedule can now be configured to stop if a warning, macro error, or system error is found using the "Stop On" field in the Schedule Edit/Create dialog box Web Connections now support Basic Authentication Cherwell API 1.0.9 support: Better logging and information for failures You can set MaxAttempts in your Connection LogicMonitor API v3 support Macros [Gravatar.Image:] inserts a gravatar image [Jira.IssueAnalysis:] adds a customizable pivot graph Issue Analysis tab to XLSX output. [Jira.IssueResponseTime:] returns the length of time from ticket creation to ANY type of response such as a comment or status change) for a Jira issue [ReportMagic.ReportConnectionSummary:] provides summary statistics about a Connection's usage as part of a Report Job [Stop:] stops the current Report Job and any further macros from being processed while other Report Jobs in the Report Job will continue to run Improvements User Interface Multiple Schedules can be sele

ReportMagic 3.6

New Features Cherwell support has been added! [Cherwell.XXX:] macros list Cherwell business objects, definitions and properties PowerPoint output - if there is PPTX input, PPTX output is always produced (even if the pptx checkbox is not selected). PPTX input can only produce PPTX output (and not, for example, PDF). Per Schedule you can now choose not to store output text in the database (and not show on the Progress Page. This is for times when intermediate reporting data must not be stored anywhere.  The default is to store and show. Actual output is not affected.  It is now possible to associate multiple email domains with a single tenant using a comma-separated list of domains in the tenant's configuration  [Jira.TimeInState:] macro provides the time spent in a given list of states [Jira.StatusList:] macro fetches a list of available statuses [Object.Unpack:] macro unpacks a JObject and stores variables Improvements You can no longer save a Schedule with incorrect CRON Input for

ReportMagic 3.5

ReportMagic 3.5 is now released and contains the following. New Features and Improvements SFTP File system support - you can now write output to your own SFTP file system, with both RSA certificates and username/password options supported Performance improvements Unicode characters are supported in Word and HTML input templates A new Help page documents changes to the variable dictionary  help/report_variables Updated and corrected many Help examples Added a line in the Help showing which macros do not run in ReportStudio Macro Help shows Updated next to help which has changed in the last 60 days The Progress page now has a Macro Variables tab showing only the variables created by that macro and the other tab is renamed as All Variables Variable names that start with numbers now generate warnings When a macro has a parameter default set, and 'Is Write Only' is set, the actual default value is not shown The Mode parameter All evaluated macros now have a mode parameter. If mode=l

ReportMagic 3.4

Overview ReportMagic 3.4 is now released and contains new features, improvements and bug fixes. New Features Added the [List.Dequeue:] macro which can be uses to process FIFO lists.   The [ForEach:] and [RepeatRow:] macros now work when items contains a backtick.  The regression test feature's diff.png.zip output now shows metrics where pages differ and the severity. The [Shape.SetProperty:] macro now sets Word shape properties. Workers now display heartbeat information including time last detected and a warning triangle when a thirty second threshold is breached. Graph macros now support the axis style controls xAxisLineWidth, xAxisLineColor, xAxisLineStyle, yAxisLineWidth, yAxisLineColor and yAxisLineStyle macro parameters. The API subscriptions endpoint is now available. Improvements The [ServiceNow.List:] macro will now attempt 5 retries (with 10 second delay between each) if the server responds with resource temporarily unavailable. Added more [List.Table:] help examples that

ReportMagic 3.3

Overview ReportMagic 3.3 contains new features, improvements and some bug fixes. New Features 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: [Meraki.ConfigurationChangeList:] [Meraki.NetworkEventList:] New [Shape:] macros are available for use in report templates that use DOCX report templates: [Shape.Delete:] [Shape.SetProperty:] Regression test support for Re