2023.1 - Kinetic web browser system monitor report polling

[shane-at-varley (Shane S)]

Is anyone aware of a way to increase the frequency at which Kinetic will poll for report updates when run in a browser, from what I can tell it defaults to 30 seconds and I have not been able to find a configuration option anywhere for this unlike in the Classic System Monitor where you can change the default and priority polling intervals.

On a related note, does anyone know if the priority polling is still a thing in the Kinetic browser-based menus for 2023.1, in Classic my understanding of this option is that once a report is run it will priority poll more frequently to pick up the report rather than wait until the next long poll timing.

We are trialing the web menus and many of our users live or die by the Copy to Excel functionality which in Kinetic web views is now submitted to the task agent and so is at the mercy of the report polling which can be very annoying when compared to the immediate response in Classic of Right Click > Copy to Excel > Immediately opens in Excel vs Click Three Dots > Export to Excel > Excel sheet opens sometime in the next 30 seconds depending on how lucky you are.

[Mark_Wonsil]

Quick question: Is the Copy To Excel functionality used in a Dashboard that’s dedicated to download data through the clipboard?

If so, consider Mr. Murdock’s solution, which updates Excel tables without even running any Dashboard.

Pull REST data into Excel based on values on excel?

Here is the sample file I presented at Insights. You can use this to generate a full REST url complete with filters, sorting, select columns, and the number of rows to return. EpicorQuery - zHomepage_SOOpen.xlsx (112.7 KB) The key is a function in Power Query Editor to read the full URL from a table and cell value. In the attached Excel example it is reading the URL from the ‘Parameters1’ table, and the 11th row of the ‘Value’ column and passing that into the EpicorBAQ query. [image] [ima…

[shane-at-varley (Shane S)]

We use the OData feeds in a handful of excel sheets at the moment for some specific BAQ’s however it’s not something I want to explore for all grids across Kinetic.

I understand that with 2022.1 or .2 that the Export to Excel option in Kinetic was pushed off to a backend task for most of the dashboards / grids across the system to bypass limitations within the browser however not having it trigger the priority polling or allow changing of these polling intervals for the browser versions seems like a bit of an oversight.

[Mark_Wonsil]

@shane-at-varley

was pushed off to a backend task for most of the dashboards / grids across the system to bypass limitations within the browser

Browser or client, using the clipboard is not the most efficient way to transfer data, but polling has its limitations too:

2023.2 System Monitor Behavior Change

Hey all – I would like to highlight a behavioral change made in 2023.2 that some of you may be interested in. Across all systems – on-prem, hosted, Cloud, etc. – the “GetRowsKeepIdle” calls (GetRowsKeepIdleTime and GetRowsKeepIdleTimeWithBallonInfo [sic]) are by far the most frequently made calls to the Server. As measured by frequency, those calls typically account for 40% or more of the calls made to the Server. By default, those calls are made by the Client every 30 seconds – more frequently…

For small grids, I use the Copy All with Headings and paste into Excel. For larger items, I’ll wait for the download, or like you, use the BAQSvc and OData for frequently used spreadsheets.