Testing CSV/text file...

Errors will be highlighted in red...

Loading CSV/text file from http://kocher.es/cajon/112016lg.txt

File loaded successfully.
Header row in the file, skipping first line.

The tested file has 1379 data sets. This import test will load only the first line.



Starting to parse data.

Loading line 1...
Separating fields...
Decimal separator is a period, no need to do anything, can be parsed by PHP.


Parsing date and time...Date and time parameters all in separate fields.
MySQL accepts date and time in format YYYY-MM-DD HH:MM, the parsed date and time is: 2016-11-1 0:00



Parsing variables...

Temperature
Raw value: 16.6
Database temperature units: C
File temperature units: C
Same units, no need to do any conversion.
Final temperature value: 16.6 C

Humidity
Final humidity value: 60 %

Pressure
Raw value: 1020.7
Database pressure units: hpa
File pressure units: hpa
Same units, no need to do any conversion.
Final pressure value: 1020.70 hpa

Wind speed
Raw value: 60
Database wind speed units: kmh
File wind speed units: kts
Converting...
Final wind speed value: 111.1 kmh

Wind gust
Raw value: 08.8
Database wind speed units: kmh
File wind gust units: kts
Converting...
Final wind speed value: 16.3 kmh

Precipitation
Raw value: 7.8
Database precipitation units: mm
File precipitation units: mm
Same units, no need to do any conversion.
Final precipitation value: 7.80 mm

Rain rate
Raw value: 7.8
Database precipitation units: mm/h
Rain rate is saved in the database in units per hour.
File rain rate units: mm
Same units, no need to do any conversion.
Final rain rate value: 0.00 mm/h

Wind direction
Final wind direction value: 192 degrees

Solar sensor disabled in main settings, ignoring.

Parsing line 1 finished.
Checking validity of data based on your limits in Main settings...
Checking date and time...
Date/time seems sensible.
Minimum temperature allowed: -100 C
Maximum temperature allowed: 100 C
Temperature OK.
Minimum humidity allowed: 0 %
Maximum humidity allowed: 100 %
Humidity OK.
Minimum pressure allowed: 950 hpa
Maximum pressure allowed: 1100 hpa
Pressure OK.
Minimum wind speed allowed: 0 kmh
Maximum wind speed allowed: 200 kmh
Wind speed OK.
Minimum wind gust allowed: 0 kmh
Maximum wind gust allowed: 200 kmh
Wind gust OK.
Minimum daily precipitation allowed: 0 mm
Maximum daily precipitation allowed: 200 mm
Daily precipitation OK.
Minimum rain rate allowed: 0 mm/h
Maximum rain rate allowed: 500 mm/h
Rain rate OK.
Minimum wind direction allowed: 0 degrees
Maximum wind direction allowed: 360 degrees
Wind direction OK.

Calculating dew point based on parsed values...
Temperature and humidity both valid... converting and calculating dew point....
Dew point calculated: 8.7 C
Calculating apparent temperature based on parsed values...
Temperature, humidity, and wind speed all valid... converting and calculating apparent temperature....
Apparent temperature calculated: -5.3 C

Summary
The following would be imported to database: