Import Data into WSWin

This section covers the Meteobridge PRO, PRO2, NANO SD, Raspberry Pi and VM platforms exclusively

Moderator: Mattk

Post Reply
Expalmi
Junior Boarder
Junior Boarder
Posts: 26
Joined: Tue Jun 16, 2015 8:39 pm

Import Data into WSWin

Post by Expalmi »

I successfully switched from Meteohub to Meteobridge pro, thank you Boris for quick software buck fixes.

I also could get Meteobridge PRO and WSWin work together.

I have three days missing in WSWin so I tried to export the data and import them into WSWin
Bildschirmfoto 2020-10-04 um 14.28.25.png
Bildschirmfoto 2020-10-04 um 14.28.25.png (145.31 KiB) Viewed 2657 times
I used the Minutes button.

Importing this file does not show any data within WSWin.

What could be my error?

Andreas
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: Import Data into WSWin

Post by admin »

If you post the first lines of the export file here, we would have a chance to say something useful about it.

I really like the idea of "buck fixes", sorry for picking this as I am also a non-native speaker and struggle myself...
but this is really a lovely one... would be great if fixes bring me bucks, currently it looks more like work :lol:
Expalmi
Junior Boarder
Junior Boarder
Posts: 26
Joined: Tue Jun 16, 2015 8:39 pm

Re: Import Data into WSWin

Post by Expalmi »

Hi Boris,

you are right, I am also not a native speaker, and I often trust the autocorection of my Mac, and do not read my posting a second time

I also can laugh with this nice bug.

Here are the first rows of my export file

,,1,2,13,17,18,133,34,35,36,45,41,42
01.10.2020,00:00,22.3,14.2,--,59,94,1008.8,0.000,0.0,228,3.2,0.0,0
01.10.2020,01:00,22.3,13.9,--,59,93,1008.1,0.000,0.0,214,8.0,0.0,0
01.10.2020,02:00,22.3,13.2,--,59,91,1007.2,0.000,0.0,139,4.8,0.0,0
01.10.2020,03:00,22.2,12.5,--,59,92,1006.5,0.000,0.0,158,9.7,0.0,0
01.10.2020,04:00,22.2,12.0,--,59,92,1005.6,0.000,0.5,123,6.5,0.0,0
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: Import Data into WSWin

Post by admin »

Data is separated by comma (not semicolon). Are there options in WSWIN to define which kind of format is used?
Rule of thumb: comma is US, semicolon is German.
Expalmi
Junior Boarder
Junior Boarder
Posts: 26
Joined: Tue Jun 16, 2015 8:39 pm

Re: Import Data into WSWin

Post by Expalmi »

I did not find any setting, within WSWin, to set the type of separator.

The template Wswin-monthly is build with comma.

Could it be, I am the first testing this feature?
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: Import Data into WSWin

Post by admin »

No, for sure not. :D

Can you please send the file to be imported to info(at)smartbedded.com? I might reach out to Werner to ask, what makes WSWIN not to accept the import. Does "Dateiüberwachung" for current data work?
Expalmi
Junior Boarder
Junior Boarder
Posts: 26
Joined: Tue Jun 16, 2015 8:39 pm

Re: Import Data into WSWin

Post by Expalmi »

ok, when others can import the data, it may take time, but I will find the problem.
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: Import Data into WSWin

Post by admin »

Werner gave me some hints:
>... was einstellen um ";" oder "," als Trennzeichen zu akzeptieren oder geht beides automatisch?
geht alles automatisch nur nicht gemischt in einer Zeile 😉

So wie es aussieht, gibt es keine Daten für die ID=13 -> Wert = "--" (irgendwas mit Bodentemperatur)
,,1,2,13,17,18,133,34,35,36,45,41,42
01.10.2020,00:00,22.3,14.2,--,59,94,1008.8,0.000,0.0,228,3.2,0.0,0

Eigentlich werden Daten mit "--" ignoriert, in älteren Wswin - Versionen aber nicht.
Möglicherweise nutzt er eine ältere Version.

Meine Empfehlung Daten von 13 in diesem Fall nicht in csv-Datei schreiben lassen.
habe gerade gelesen:
> I have three days missing in WSWin so I tried to export the data and import them into WSWin

Wenn für Oktober schon Daten vorhanden sind, werden beim Import nur neuere Daten übernommen.
Das scheint hier der Fall zu sein:
er muss in diesem Fall, die vorhandenen Daten exportieren, Datei umbenennen/sichern,
Die Daten der ersten 3 Tage importieren und die vorher exportierten Daten wieder importieren.
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: Import Data into WSWin

Post by admin »

Please try this "wswin-monthly-new.exp" file to be located in the templates folder:

Code: Select all

#pragma exportfile=EXP[MM]_[YY].csv
#pragma crlf=y
#pragma fillgap=300
## Datum, Zeit, Innentemperatur[C], Aussentemperatur [C], Innenfeuchte [%], Aussenfeuchte [%], LuftdruckMeereshoehe [hPa], Regen [mm], Windgeschwindigkeit[km/h], Windrichtung, Böen[km/h], UV-Index, Solarstrahlung [W]
$,,1,2,13,17,18,133,34,35,36,45,41,42
[DD].[MM].[YYYY],[hh]:[mm],[thb0temp-avg.1:],[th0temp-avg.1:],[th10temp-avg.1:],[thb0hum-avg.0:],[th0hum-avg.0:],[thb0seapress-avg.1:],[rain0total-sum.3:],[wind0avgwind-avg=kmh.1:],[wind0dir-avg.0:],[wind0wind-max=kmh.1:],[uv0index-avg.1:],[sol0rad-avg.0:]
It does not output the "--" in case a sensor is missing but just returns nothing in that case. If this cures the problem, I will make it the WSWIN export default file.
Post Reply