Time format import

Post Reply
Remkot
Newbie
Newbie
Posts: 4
Joined: Fri Jun 17, 2022 8:09 pm
Station model: Ws-5500
Software: Wu

Time format import

Post by Remkot » Thu Jul 21, 2022 8:30 am

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
Expert
Expert
Posts: 658
Joined: Tue Jan 12, 2021 8:03 am
Location: Italy
Station model: WH2650
Software: WH2650 (direct upload)
Contact:

Re: Time format import

Post by davidefa » Thu Jul 21, 2022 8:01 pm

- 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 815 times
imp52.png
imp52.png (98.96 KiB) Viewed 815 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.
Attachments
2.zip
(72.64 KiB) Downloaded 11 times
Image

Remkot
Newbie
Newbie
Posts: 4
Joined: Fri Jun 17, 2022 8:09 pm
Station model: Ws-5500
Software: Wu

Re: Time format import

Post by Remkot » Sat Jul 23, 2022 8:39 am

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

Post Reply