Import rainfall data

[WessexWeather]

Hi Guys,

Unfortunately on one of the wettest days of the year, my rain gauge failed yesterday, which now means my daily, monthly and yearly rainfall totals are incorrect.

I have previously been able to import such data from a nearby Weather Underground station, but now that this import function is no longer working, can anyone suggest another way of doing this? For example are there any other sources of data that will allow me to download a .csv file from a nearby station for import into Meteotemplate?

[Dehatter]

Well I have done this myself and you won't like how I did it, and it is not easy, but it works.

On a simple scale I provide the following directions:

First copy the daily data from the station you want into an excel spreadsheet

Annotation 2019-08-14 005718.jpg (103.32 KiB) Viewed 3157 times

then

Annotation 2019-08-14 005937.jpg (30.94 KiB) Viewed 3157 times

then

Annotation 2019-08-14 010138.jpg (44.59 KiB) Viewed 3157 times

.
.
So on to the next post.....

[Dehatter]

From the previous post...

Then

Annotation 2019-08-14 011316.jpg (42.94 KiB) Viewed 3156 times

Now copy these four completed columns, and paste them into a new spreadsheet.

Then save the new spreadsheet as a .csv

now you have this:

Annotation 2019-08-14 011605.jpg (22.94 KiB) Viewed 3156 times

Now you can use the custom import function where date is column 1, Time is column 2, Pricip Rate is column 3, and precip total is Column 4.

One warning - you may have to alter the times in the spreadsheet to match the time stored in your database, and you will have to continue the Precip totals to the end of the day.

I have found that this process considerably faster and far less likely to create an error than simply direct editing the database (that is the other option).

Annotation 2019-08-14 012719.jpg (22.41 KiB) Viewed 3154 times

If you do choose the alter the database using the tool in the template one thing that does help is you can click edit on all the lines showing, make all the changes, then click save (twice) to close each line.

Tom

[WessexWeather]

Thank you Tom, that’s most helpful, and relatively straightforward if one only needs a day of data.

[andyk1]

Hi!

Since you mentioned you imported from Wu from a nearby WU site I assumed you where familiar with an old trick that I still use today when my site goes down overnight or my ObserverIP locks up. Here is the trick I use that goes way back before the IBM and weather channel days.

Code: Select all

[https://api.wunderground.com/weatherstation/WXDailyHistory.asp?ID=KOKNICOM2&day=15&month=8&year=2019&graphspan=day&format=1]

remove the [ ]'s

Change the WU id, month and day for what you need to import and follow Toms suggestion on importing into your own database and wait 5 or more minutes and you should see the results after the 5 minute cache processes.

I almost left out... save to text file... right click your browser, copy.... save. I have a plain txt file called WU-Imports.txt saved as 0 bits using notepad++ "https://notepad-plus-plus.org/". Do not use Microsoft notepad as it adds extra characters.

[WessexWeather]

Wow andyk1, that looks amazing! I wasn’t aware of that old trick, no. Will try it over this weekend.