Polling Aquacontroller 3 Pro for log data

[bconn]

Hello,

Here is what I am set out to accomplish. I plan on setting up a intranet page that I can access when I travel to monitor system. The page will only be available inside when I VPN into my network. The AC data will be stored in a db I will create in an MS SQL server I am running. I will use something like VB or Java to display and report data.

I have not spent much time reviewing the AC os and the possible commands. There is not much information available from what I can find on the web about the available commands. I know this is possible since I have noticed some Yahoo status widgets that were created by a few individuals. I would like to avoid this as well as Aquaweb if possible. Anyone have any luck in dumping AC data to a local system? I would like to poll for data every few minutes so the GUI will be as up to date as possible.

Thanks in advance.

Bill

 

[MikeNapoli]

Bill,

Contact Carlo. I'm sure he'll see this thread, but if not, PM him and ask him directly.

 

[bconn]

Mike,

Thank you very much.

Bill

 

[Carlo]

Hello bconn,

I do something very similar with data from my AC3 although I've got the page down at the moment as I'm playing with 3 other controllers at the moment (not Neptune).

If you can wait until after the holidays I can help you out with your project and show you what I've done which you might want to use as a foundation and then build from there.

One thing I'll mention is that I'd recommend using Aquanotes software to gather the data for you. It is stored in Microsoft Access database format which makes gathering the data simple since it's already done for you. At that point you can just use any programming techniques you want to display or modify the data from a webpage.

Carlo

 

[pgordemer]

I have not spent much time reviewing the AC os and the possible commands. There is not much information available from what I can find on the web about the available commands. I know this is possible since I have noticed some Yahoo status widgets that were created by a few individuals. I would like to avoid this as well as Aquaweb if possible. Anyone have any luck in dumping AC data to a local system? I would like to poll for data every few minutes so the GUI will be as up to date as possible.

The AC series has a telnet server in it, so you can have a service issue a telnet command and get the status, capture the display and then parse it. You can also dump the log, but again then you would have to parse it yourself. If you are only doing status, then just telnet it, if you want to do historical database/charting, then like Carlo said, don't reinvent the wheel, let Aquanotes do it since can poll and load the Acess databasae.

Telnet Commands:
l = list command will display all defined timer names and program statements
c = current status
d = data log
r = reset data log
on xxx turns the device on in manual mode
off xxx turns the device off in manual mode
auto xxx puts the device in auto mode

I use a very simple process for a remote control Feed button. My AC is in the basement, and I have a seperate remote USB unit upstairs attach to a computer. When I hit a button on it, it issues telnet commands to shut down the items I want off for Feed, the other button turns them back on.