Does anyone has worked on Generating a tabular format report from the PI Vision symbol and automatically sending it via an email? The report could be in any of the format .csv or excel.
Any feedback would be highly appreciated.
In theory this would be possible, but this is not a common scenario to achieve reporting functions. Why not use e.g. OLEDB Enterprise and SQLserver Reporting Services? Or through PI Integrator for BA and PowerBI or similar?
Pi Vision is client-side, so although you could string together some code to collect data from PI and send in to an email, i don't think using PI Vision is the easiest platform to achieve that. No visualisation -> don't use PI Vision.
Thanks Roger ,
Do add more details and to clarify .
The vision screen is dashboard few KPI for user monitoring ( daily total for a month ).
ON demand(Button click) the user requires to email himself the timseries data of the KPI for chosen interval on the PI vision screen ,
The email generated would have a excel attachment containing data report in tabular format.
Planning to implement emailing and data query functionality using Webservice and provide required call to teh service via PI vision button click.
Let us know your thoughts on the solution
Retrieving data ...