Page 1 of 1

Time format import

Posted: Thu Jul 21, 2022 8:30 am
by 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

Re: Time format import

Posted: Thu Jul 21, 2022 8:01 pm
by 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
imp51.png (109.34 KiB) Viewed 17366 times
imp52.png
imp52.png (98.96 KiB) Viewed 17366 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.

Re: Time format import

Posted: Sat Jul 23, 2022 8:39 am
by Remkot
thank you very much for the explanation. It finally worked! Thank you!