Download Historical Table from viewON

Mihir · June 15, 2018, 12:54pm

Hi Joe,

I am trying to integrate a button to download historical table. Somehow, it’s not working. It just opens a blank screen. I tried to connect the eWON using ecatcher and m2web. None is working.

With EBD helper, I am able to download historical table.

…/…/rcgi.bin/ParamForm?AST_Param=$dtHT$ftH$fnChillerData$st_h24$et_h0

hms_support · June 15, 2018, 1:44pm

@Mihir

I used your EBD and successfully downloaded a historical table while connected to my device.
Please ensure you are using 2 periods and not 3.

../../rcgi.bin/ParamForm?AST_Param=$dtHT$ftH$fnChillerData$st_h24$et_h0

Mihir · June 15, 2018, 1:54pm

Thanks Joe.

It’s working now.

Is it possible to create a trigger in the eWON (BASIC IDE)) to send this data by email every day morning…say 8:00 am? Its like a daily report.

hms_support · June 15, 2018, 2:06pm

@Mihir

Yes, this is possible.

You can use the eWON task planner to send your EBD or use an ONDATE listener in the basic IDE that goes to a label that sends an email with your EBD.

Information on Task Planner:


InitSection
ONDATE 1, "0 8 * * *", "GOTO SendData" // Every day at 8 AM
SendData:
emails$= "TestEmail@gmail.com" // fake email for example
Data$ = "$dtHT$ftH$fnChillerData$st_h24$et_h0"

SENDMAIL emails$, "", "Daily Report", Data$

Crontime examples:
https://crontab.guru/examples.html

If you have any more questions regarding the script, i’d check out our programming ref guide.
rg-0006-01-en-programming-reference-guide.pdf (888.8 KB)