I am working on importing data which has been exported from MySQL and is generated by a Meteobridge unit. The CSV file has a header line and I have checked that box.
The Show Filed Numbers returns this:
Loading file...
Loading CSV/text file from /Users/house/Documents/Software/Weather/SQLexport/spweather-export.csv
File loaded successfully.
Header row in the file, skipping first line, using for field labels.
Starting to parse data....
Loaded data:
Field Field Number Value (first data set)
0
One line of the CSV file data looks like this:
2,"2016-09-07 12:02:15",72.1,84,30.09,67.1,72.1,72.1,80.4,58,0.0,0.9,57,"ENE",2.9,104,"ESE",0.00,0.00,0.00,0.00,0.00
where that first number is an ID nbr.
The Meteotemplate Test Import gives me two results:
1)
Checking date and time...
There seems to be a problem with the date and time. Either it has not been parsed correctly or it is a date/time in the future! Check the format you specified and also the actual values.
My time settings on the import page are:
Y-m-d H:i:s
2)
Minimum pressure allowed: 25 inhg
Maximum pressure allowed: 32 inhg
Pressure is outside the allowed limits! Pressure value will be ignored!
As you can see in the line above the pressure readings in the data are around 30 (30.09)and some lower but all within that range.
Advice would be most welcome