How to can let get excel table from scheduled report consistent with data point in report modules
-
Hi ,Member of forum. Morning.
Please allow me consult a question.When I?setting multi data point in report modules .But I received the email from scheduled report. display multi chart . but only a point excel data(include data, event ,comment 3 excel table).
If I want received multi excel table of data point consistent with data point in report modules when I received email.What should I do?
what we have tried:Add multi data , result:failed. I get 3 excel table (one point) when I received email.?
and set a meta include data. let the meta put in scheduled report. result : failed.I get 3 excel table (one point) when I received email.what we actual results are: still only a datapoint excel table ( include 3 excel table)in received email .
what we expected to happen: get excel table from scheduled report consistent with data point in report modules.Thank deeply in advance.
-
Sorry, Have any suggestion?
-
So your problem is that you want to receive all the points in your report compiled into a single .CSV, rather than individually? Did I understand correctly?
If so then I think that what you're asking for is just not something Mango does, and you would probably have to make a feature request.
-
Thank jeremyhs!
my question is that donot need want to receive all the points in my report compiled into a single .CSV.
my question is when I set multi point in report module . only the first point have .CSV. other point have not .CSV.I want to get other point .CSV too .
Please give a idea.
Thanks
-
I upload the picture for your reference.
Attachment: download link
-
:) :) :) :)
I have found the all data in single .CSV. and all data in "point name" Column.
How can I setting different point name in different Column respectively.Any idea?
-
I have wondered the same thing myself. The answer (from Infinite Automation) is that it is currently not possible. It may be looked into in future.
As a workaround you can create the table in DGLux and export it as a CSV, but it will not work for your scheduled reports obviously.
You seem to have pretty specific requirements (based on other threads). Maybe you should get someone to write a script for you that queries the database and outputs the data in the report format you want.
-
The issue is with getting the time stamps to match up as you can have data with non matching time stamps. We will be building a new watch list module which will have the options to roll up the time stamps with an interval option so you can get all your data in a 5 minute interval for example. Then it will be easy to export in this format which I agree would be really nice.
Joel.
-
excellent!!!
What time will this module will be issued?Thank Joels and jeremyhs!!!!