Page 1 of 1
Import Data into WSWin
Posted: Sun Oct 04, 2020 2:34 pm
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 (145.31 KiB) Viewed 2661 times
I used the Minutes button.
Importing this file does not show any data within WSWin.
What could be my error?
Andreas
Re: Import Data into WSWin
Posted: Sun Oct 04, 2020 3:39 pm
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
Re: Import Data into WSWin
Posted: Sun Oct 04, 2020 5:09 pm
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
Re: Import Data into WSWin
Posted: Sun Oct 04, 2020 5:15 pm
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.
Re: Import Data into WSWin
Posted: Sun Oct 04, 2020 5:31 pm
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?
Re: Import Data into WSWin
Posted: Sun Oct 04, 2020 7:19 pm
by admin
No, for sure not.
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?
Re: Import Data into WSWin
Posted: Sun Oct 04, 2020 7:28 pm
by Expalmi
ok, when others can import the data, it may take time, but I will find the problem.
Re: Import Data into WSWin
Posted: Mon Oct 05, 2020 11:03 pm
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.
Re: Import Data into WSWin
Posted: Mon Oct 05, 2020 11:12 pm
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.
