Export water parameters from Apex to spreadsheet

[nichthyes]

I've seen in some old threads that its possible to export probe recording data from the apex. I know there are links to do this, but I'm just looking for a few specific parameters (just temp, pH, and ORP). Is anybody savvy to this?

The links I found on some old threads were something like this.... http://(apex IP address):5560/cgi-bin/outlog.xml?sdate=(start date)&days=(number of days desired)

There were different links for different data.

 

[areefer01]

I've seen in some old threads that its possible to export probe recording data from the apex. I know there are links to do this, but I'm just looking for a few specific parameters (just temp, pH, and ORP). Is anybody savvy to this?

The links I found on some old threads were something like this.... http://(apex IP address):5560/cgi-bin/outlog.xml?sdate=(start date)&days=(number of days desired)

There were different links for different data.

It is in the documentation, and example. Just open a browser, swap to your local apex URL, and give it a try. Once done you can move into Grafana or Excel. Their docs give a good example to import to Excel actually.

 

[nichthyes]

Found it in Neptune's outdated "New User Guide/Comprehensive Reference Manual"... page 117

https://www.neptunesystems.com/downloads/docs/Comprehensive_Reference_Manual.pdf

The link format for multiple days of data export is as follows:
http://< Your IP address or DDNS name>:<Port #>/cgi-bin/outlog.xml?sdate=yymmddhhmm&days=n

All bold in the link above is info you have to enter from your system. Your IP address will only work if you're local, and the DDNS or DynDNS as they say in the manual is for remote ... not something I'm familiar with.

I'm going to try to run this link through Excel's web import function. Will post again tomorrow on how it worked.
Crossing fingers...

 

[areefer01]

Found it in Neptune's outdated "New User Guide/Comprehensive Reference Manual"... page 117

https://www.neptunesystems.com/downloads/docs/Comprehensive_Reference_Manual.pdf

The link format for multiple days of data export is as follows:
http://< Your IP address or DDNS name>:<Port #>/cgi-bin/outlog.xml?sdate=yymmddhhmm&days=n

All bold in the link above is info you have to enter from your system. Your IP address will only work if you're local, and the DDNS or DynDNS as they say in the manual is for remote ... not something I'm familiar with.

I'm going to try to run this link through Excel's web import function. Will post again tomorrow on how it worked.
Crossing fingers...

No need to cross fingers, it works. Get it working from a web browser first then copy that request so you can use in Excel. The example below using todays date (10/26) will retrieve two days worth of data. If that works your set to use within Excel.

I've done this many times but now use telgraph, influxdb, and grafana to collect, store, and report on data.

local_address/cgi-bin/datalog.xml?sdate=1026&days=2

 

[nichthyes]

No need to cross fingers, it works. Get it working from a web browser first then copy that request so you can use in Excel. The example below using todays date (10/26) will retrieve two days worth of data. If that works your set to use within Excel.

I've done this many times but now use telgraph, influxdb, and grafana to collect, store, and report on data.

local_address/cgi-bin/datalog.xml?sdate=1026&days=2

Ok I've gotten this far... the port number was throwing me off, but I removed it and it worked in the browser. However it still won't import to Excel as the manual suggests ... it just brings up the outlog data as follows ...

hostname	serial	timezone	Attribute:software	Attribute:hardware
Steve	AC5:78151	-4​	5.10_8F22	1​

I copy and paste the link from the browser that has the data displayed.

 

[tomtsp]

Ok I've gotten this far... the port number was throwing me off, but I removed it and it worked in the browser. However it still won't import to Excel as the manual suggests ... it just brings up the outlog data as follows ...

hostname	serial	timezone	Attribute:software	Attribute:hardware
Steve	AC5:78151	-4​	5.10_8F22	1​

I copy and paste the link from the browser that has the data displayed.

Any luck getting past this? I am at the same spot...LOL.

 

[areefer01]

Any luck getting past this? I am at the same spot...LOL.

What is the exact issue or error? My apologies as I am not sure.

Edit: not sure if you have looked at the documentation but I put the link below if it helps. Section 10 talks about grabbing the data via a browser and then later using the Excel import using a URL. Once you get it working via the URL you will use the same thing in Excel under the data tab, from web.

https://www.neptunesystems.com/downloads/docs/Comprehensive_Reference_Manual.pdf