What I’m trying to do:
Display our On-Time Delivery report on a signage player that displays on a TV on the shop floor.
What I’ve Done so far:
Created the BAQ and SSRS report. Setup an automated task to email the report as a PDF to our key leadership team and myself. On my PC, I setup a script in Outlook to save the attached PDF to a specific location. Created a task, in task scheduler on my PC, that runs a batch file, that runs a VB script, to convert the PDF into a PNG and overwrite the old file that the signage player displays.
The signage player restarts every morning, after the process above runs, to refresh the display with new data.
The problem:
This is a convoluted setup with multiple pieces of code running at different points, in different software, to accomplish a task that could probably be done with less. This solution works but it’s not ideal and definitely not a best business practice. If I die tomorrow no one would be able to replicate or trace these steps without access to my specific Windows profile and PC.
What I would like to do:
Have Epicor email the report, which is already done, but also store the PDF somewhere specific on our network.
OR, if possible, have Epicor create an PNG or JPG and store it where it needs to be, removing the Outlook script and conversion script, I’m using on my pc, from the process.
The Questions:
Is it possible to create a file output format in Epicor for PNG or JPG images?
How do I setup an automated routing that places the file where I want, when I want?
Am I expecting too much from Epicor? lol
Thank you!