Time format import

[Remkot]

Hello all,

I want to transfer some data from weathercloud to meteotemplate. (because weatherunderground is no longer possible I read.)

When I import the csv file and test it I get the message "There seems to be a problem with the date and time."

https://weerstationoosterbeek.nl/2.csv

I think I have the date and time format wrong. Can someone tell me what the right format is?

thank you very much.
Remko

[davidefa]

- converted the file to ansi format ( think it was a 2 byte unicode )
- removed the '.' as separator for thousands

You can import with the following settings:

imp51.png (109.34 KiB) Viewed 1376 times

imp52.png (98.96 KiB) Viewed 1376 times

NOTE ( not super important )
It is better to have an uniform 'database recording interval' ( to prevent a few 'hiccups' in blocks/pages, for example you could end up having two different, although similar, results for the same calculation in two different blocks/pages ).
If your 'database recording interval' is the default 5 minutes, also your imported data should be 'spaced' by 5 minutes.
As your csv file has a data interval of 10 minutes, I created a second copy with time shifted by 5 minutes, import both files and you should be good to go.

[Remkot]

thank you very much for the explanation. It finally worked! Thank you!