Import older data from Weatherlink software to Weather34 template

[bantonis]

I recently installed meteobridge and weather34 template.
My station has been operating since 2008. I have exported the data from the weatherlink software to .txt files from 2008
is there a way to import them into weather34?

Thanks

[jasonmfarrow]

I do not believe that there is code written into Brian's Weather34 platform to perform an import of legacy weather data.

All the files used in the w34 template for the charts and statistics are held in the ../weather34charts folder.
Each year has a <yyyy>.csv file. There are also subfolders for each year containing <mmmm>.csv and <ddmmmyyyy>.csv files. Each file contains a date/time and then the various weather metrics (min, max, etc) in a certain order. You can see this order documented in the weather34-chart-end-of-day.php and chartstoday.php files for Year & Month and Day data respectively.

It would be possble to use excel visual basic (or any other progamming language of your choice) to read in your weatherlink text files and then write out each of the above .csv files for each of the year, month and day files you so require. You probably need not recreate the month and day .csv files outside of the present year but you can go back several years (to 2020/2019 I believe) depending on what version your w34 template supports to view previous yearly data. A lot of this would depend on what your Weatherlink text files contain. It might be a fair bit of trial and error and providing of null data to fill in the gaps for w34 template data not provided by your Weatherlink export.

You certainly would not be writing any data to your live template until you are certain that the import/export has successfuly converted all the data you need. It would be quite a task and perhaps others on this forum have attempted a legacy import, but I've not see that on the forum to date.

[weatherist34]

Hello if you can export the data from weather link into a text with commas or csv format file I can simply apply a local script that will convert your old data to a weather34 csv chart format .please note the template only supports data from 2018 onwards unfortunately not all the way back to 2008 .
I see your using TPLINK so Im guessing there is no capability to have all that data stored in Meteobridge itself if you were using a Meteobridge pro or nanosd or rpi then there is a one click Meteobridge script Boris came up with last year to export data stored in year format that aligns perfectly with the weather34 charts .
This method is preferred when for whatever reasons the charts become corrupted on website servers or there is an issue of loss of data .

format expect each value separated with a comma
position number and data type the position is critical

0 time,
1 max day temp,
2 min day temp,
3 max day dew,
4 min day dew,
5 rain day total,
6 wind speed day max,
7 wind speed day average,
8 not used,
9 max day pressure,
10 min day pressure,
11 max day uv,
12 max day solar,
13 24 hour avg air quality,
14 day average davis airlink,
15 wind direction avg,
16 max day humidity,
17 min day humidity

17 values and it should resemble something like below (don't worry about if you don't use airlink or purple air quality

Code: Select all

1 Mar,7.2,3.8,4.4,-2.0,0.8,8.5,1.8,**,1035.9,1028.0,1.7,171.0,8.3,22.5,40.0,92.0,79.0
2 Mar,5.5,1.8,2.5,-0.8,0.0,5.4,0.7,**,1029.9,1027.1,1.5,171.0,31.7,53.8,76.0,93.0,72.0
3 Mar,5.8,2.1,1.7,-0.6,0.0,5.8,0.9,**,1032.7,1029.8,1.1,149.0,28.3,37.9,58.0,85.0,72.0
4 Mar,4.3,1.7,0.7,-1.6,0.0,3.6,0.4,**,1032.6,1026.7,0.8,130.0,39.2,77.4,16.0,83.0,73.0
5 Mar,5.4,1.0,2.4,-1.3,0.2,5.4,0.4,**,1026.7,1010.5,1.5,169.0,42.5,60.2,298.0,93.0,71.0
6 Mar,7.5,2.4,5.9,-2.4,2.2,10.7,1.7,**,1017.1,1012.9,3.4,336.0,45.8,3.8,311.0,100.0,89.0

image below examples what the structure is when viewed in CSV editor .

csvtt.png (189.59 KiB) Viewed 1421 times

ps I have a common interest with your particular region , my wife ancestors are from Thessaloniki whilst you maybe some miles/km away but we live in a similar climate and liking of food also I enjoy the Thessaloniki traditional dancing .. hope the above info doesn't seem to complex but the simplest way is to create an export going back to 2018 and send it to me and wait a few days till its done.

Brian

[bantonis]

Τhank you for your answers.
I now understand how weather34 works
I will try to make the conversions from Wetherlink. For the time being saving meteobridge data to mySql.
I'm so glad you know my area, Veria is 65 kilometers away from Thessaloniki.
I'll be back soon, thank you very much!!

[1fcmrYpC2Nw8]

Hi

I read from Weatherist34’s post that Brian produced a template to export data from MeteoBridge in year format which will drop right into Weather34.

I would be very pleased to download this if someone would be kind enough to provide a link.

Thanks


Chris