Emailing History trends as CSV

[Boba]

I have a jace with roughly 1500 trends. I’m tasked with figuring out if we can email these trends to specific people daily.

The way this is done usually is by using the series transform module blocks to aggregate the data into a single table, then using the report:ExportSource block to export the table as a csv file and then routing it into an report:emailRecipient block to send it our. This works for older Niagara version. but not the newer ones. I also have too many trends to aggregate individually and the module doesn’t offer any way to mass select histories.

Sooooo… I’m looking for custom solutions. If anyone’s ever done something similar, i’d appreciate bits of code to help me get this done faster. I can probably write code to do this given enough time.

[Rombo]

That’s funny, I legit just posted the following:

History Export Program Object

Hey all, I was attempting to figure out how to provide a whole bunch of trend logs to a CxA out of Niagara, and didn’t want to spend 8 years adding export sources and transforms to accomplish it, so I brute forced a program object that will dump filtered trends into a CSV file and stuff them in a timestamped folder under the following path: C:\ProgramData\Niagara4.14\distech\stations\yourStation\shared\historyExports I am not a dev, it isn’t perfect, I had to put chatgpt through its paces to f…

It won’t do EVERYTHING you want but it will at the very least pull trends without having to do all that linking