Meteobridge Nano - missing values in wswin csv export
Posted: Sun Dec 01, 2019 12:49 am
Hi everybody
since a few month I have a meteobridge Nano for recording the weather data of my Vantage Pro 2 weather station.
Now I want to make a wswin csv export every hour and push the file with ftp to my webserver.
The process is working fine but I have problems with missing data values in the csv File.
Distributed over the whole day I have missing values for all of my sensors and especially the values of the last two records are missing all the time.
The missing values are represented with hyphens. That's a problem for me because on the webserver I want to import the data records in a Postgres Database. And hyphens throw an error when importing them in float attributes.
So my questions are:
1.) Is it possible to have other character then hyphens for missing values? Maybe something like -999 or Null values.
2.) Formerly I had meteohub for recording my weather data. There were never missing values in the exported csv files. What is the reason that I have these missing values with meteobridge? When I make a export with NOAA-monthly-iso I can see that the missing values are recorded two times with the same time one minute earlier (see the example files). For example 1:59 and 3:37 are doubled in NOAA and 2:00 and 3:38 are missing in csv. In meteohub I can see that I have values for 3:36:58 and 3:38:06. So perhaps this is the problem?
3.) Is it possible to run the csv export 5 minutes after the full hour? So the last two missing records wouldn't trouble me for importing the values in the database because I'm always importing the values from :00 to :59 for the last hour.
The missing values a very uncomfortable for me because they need a lot of extrawork for the import in the database.
So any help would be much appreciated
Thx in advance
Michael
since a few month I have a meteobridge Nano for recording the weather data of my Vantage Pro 2 weather station.
Now I want to make a wswin csv export every hour and push the file with ftp to my webserver.
The process is working fine but I have problems with missing data values in the csv File.
Distributed over the whole day I have missing values for all of my sensors and especially the values of the last two records are missing all the time.
The missing values are represented with hyphens. That's a problem for me because on the webserver I want to import the data records in a Postgres Database. And hyphens throw an error when importing them in float attributes.
So my questions are:
1.) Is it possible to have other character then hyphens for missing values? Maybe something like -999 or Null values.
2.) Formerly I had meteohub for recording my weather data. There were never missing values in the exported csv files. What is the reason that I have these missing values with meteobridge? When I make a export with NOAA-monthly-iso I can see that the missing values are recorded two times with the same time one minute earlier (see the example files). For example 1:59 and 3:37 are doubled in NOAA and 2:00 and 3:38 are missing in csv. In meteohub I can see that I have values for 3:36:58 and 3:38:06. So perhaps this is the problem?
3.) Is it possible to run the csv export 5 minutes after the full hour? So the last two missing records wouldn't trouble me for importing the values in the database because I'm always importing the values from :00 to :59 for the last hour.
The missing values a very uncomfortable for me because they need a lot of extrawork for the import in the database.
So any help would be much appreciated
Thx in advance
Michael