Topic: Exporting Weatherlink Data

[hksacks]

I want to be able to export "cooling degree days" and "heating degree days" data based on my personal reference points (not 65 deg.).  It seems that using the the Browse Copy or Export command always uses the built-in 65 deg reference points.  The NOAA reports do use the user specified reference points, but I can't figure out how to export the generated tables.  Do I have to create templates and upload reports to a file?

[dalecoy]

As far as I can determine, there is no WeatherLink "Tag" for either of those items. 

So, unless someone else has an idea, you're going to be limited to parsing the NOAA report. 

You might try calling Davis support - and if you do, please let us know how that goes.

And giving more details on what you mean by "export" might spur somebody to suggest a better idea.

[hksacks]

I found an answer.  To be clear, I want to export the data to an Excel spreadsheet.  The software Help file explains how to create uploads to a web site and suggests you test it by uploading the created HTML files to your local PC.  I don't have a web site and am using the serial version of the Davis Weatherlink, but that doesn't matter.  One option under Setup, Internet Settings is to create one of several upload profiles.  This can contain the NOAA monthly report.  I attached the resulting text file.   Not elegant, but it contains what I need.

[dalecoy]

I'm glad you found that.  I was aware that the NOAAMO.TXT (and other reports) can be unploaded (and captured locally).  I just wasn't sure whether that's what you meant by "export".  And of course those reports contain a lot of data that you do not need.

Thanks for the confirmation.

[hksacks]

Davis tech support confirmed there is no way to "export" NOAA reports in a csv format.  But I also missed the fact that when you view the NOAA report it automatically creates the text file in the Station directory - no need to fuss with the internet options at all!

[dalecoy]

Davis tech support confirmed there is no way to "export" NOAA reports in a csv format.  But I also missed the fact that when you view the NOAA report it automatically creates the text file in the Station directory - no need to fuss with the internet options at all!

The "internet options" provide a way to automatically control when (and how often) it is created, of course.

[Bushman]

You CAN create a .csv file using standard html templates.  Plus calculating heat/cool DDs is easy and you could change from the base 65F.  All in the same report.  And none of those silly NOAA headers.

[hksacks]

Do you have any example programs (.htx files)?

[Bushman]

You just need to have the tags inside the HTX file.  Like

<!--stationTime-->,<!--stationDate-->,<!--outsideTemp-->,<!--outsideHeatIndex-->,<!--windChill-->,  etc. 

If you want to calculate the DD values you will need PHP (server) or Javascript (client)-side.  Still really easy to do that part, too.

[dalecoy]

You just need to have the tags inside the HTX file.  Like

<!--stationTime-->,<!--stationDate-->,<!--outsideTemp-->,<!--outsideHeatIndex-->,<!--windChill-->,  etc. 

If you want to calculate the DD values you will need PHP (server) or Javascript (client)-side.  Still really easy to do that part, too.

Perhaps you could easily provide a complete .htx and complete program.  That would be quite useful to folks in the future, as complete examples to easily use.

[Bushman]

I would have to have complete specs since everyone likely wants something slightly different.  There are many, many .htx examples already on the Interwebs you know.