We want to display current lead times on a TV screen. My first thought was a kinetic dashboard, but that would consume a license constantly. The second thing we tried was a google sheet, which worked great with live updates. But after a few hours the ‘live updates’ connection goes idle and it won’t …

I’ve used grafana for this: [image] Grafana: The open observability platform | Grafana Labs Grafana is the open source analytics & monitoring solution for every database.

Google Charts using Javascript, and the Rest API a BAQ. [image] Jobs running display ERP 10 You can generate the data using a BAQ and the Epicor Rest API I wrote a handler in Visual Studio to take the data and put it into Google Charts to generate the output Google chart…

Using the API would have saved us a butt-ton of trouble. We built a python script to run a query against the DB and used a raspberry pi to call & display it, refreshing it every minute. When the query hit an error causing it to run for 5 minutes instead of 5 seconds, SQL server eventually overloaded…

So does that auto-refresh or do you have a script/plugin that reloads the dashboard?

each dashboard has auto refresh settings you can update.

Right, so this has been tripping me up. There is the data refresh, i.e how often the dashboard imports the data and there is the client screen update. When grafana pulls in new data from the data source, does it push out an update to the TV, or is it up to the TV to check periodically for updates?

If memory serves me right, the data refresh and dashboard refresh are independent. The dashboard refresh is what will refresh the tv.

Seconding Grafana. We use it for a multitude of dashboards displayed throughout the production floor. Works great, very flexible, doesn’t consume an Epicor seat. Use a browser add-on to periodically refresh the screen at whatever interval you determine is applicable.

Hey guys! I am working on setting up Grafana in a Docker container along with Xibo to display some data from Epicor on screens around the shop. We have stick PCs pulling down the data from the Xibo CMS. This works ok. However, we need to pull data from Epicor. I have setup a webservice, api key, an…

I don’t use Granfana, but have used the REST interface quite a bit. Have you tried changing the api-key param to x-api-key? Or removing it from the URI and adding it as a custom HTTP header instead?

Free Live Dashboard?

Off Topic

aclements (Andrew Clements) January 4, 2022, 3:22pm 3

Google Charts using Javascript, and the Rest API a BAQ.

Topic		Replies	Views
Warehouse Digital Signage Kinetic ERP e10	45	4802	September 6, 2022
Considerations for deploying multiple "always on" dashboard priority dispatch displays Epicor ERP 10 customization	17	2627	May 10, 2018
KPI Software for shop floor displays Epicor ERP 10 e10	20	5660	May 1, 2019
Jobs running display Epicor ERP 10 epicor , baq , dashboard	22	4657	January 4, 2024
PowerBI Dashboard integration Epicor ERP 10 rest	39	25514	March 12, 2021

Free Live Dashboard?

Related topics