Meteotemplate Forum

Hello to you all,

I try to import data from the past into the Meteotemplate database. I succieded in the past but now I get stuck on a date error. The import file contains data from 1951 until 2017 with one data entry for eacht day.

When starting the test it shows the correct date:

>> 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: 1951-01-01 01:05

But at the end of the test I get this error message:

>> Parsing line 0 finished.
>> Checking validity of data based on your limits in Main settings...
>> 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.

I already tried a smaller import file, but with the same result.

Maybe someone has a clue what can cause this problem .....

Many thanks,

Marcel
Meteo Helmond

Hi marcelh

I don't know if that helps: In "Data Import" section is a notice concerning php and Date/Time formats:

Date/time: 2020-11-24 16:45
Format: Y-m-d H:i

Cheers, Martin

Thanks for your reply Martin, but the format is correct according to the PHP settings (as shown in the most upper quote).
So this should be OK.

Regards,

Marcel

Hi

I think you need to include seconds as well. So the format must be:

YYYY-MM-DD HH:MM:SS

That worked for me.

Gert

Thanks Gand

With a previous import it worked OK in the way I mentioned above, so this should be OK (don't need seconds).

Regards,

Marcel

So since there seems to be no sollution data import isn't possible anymore .......
Good to know

Please attach the data you are trying to import ( or a part ), I can give a try

Sorry for the late reply.

Please find attached the import file. Thanks a lot.

I have uploaded the document to google spreadsheet, lots of data present:

1) you should fill the first and second row ( only for the fields to import in the main table )
2) there are several '#WAARDE!' ( 125 ) across the spreadsheet, we should decide what to do with these cells, only for columns to be imported ( simple solution is to remove these warning or substitute with some data, a quick and dirty solution is remove these data and in a second time 'fill in the blanks' )
3) the table contains data from 1970 Jan 1 to 2019 Jan 22 ( I mean it does not contain data from 1951 to 1969 )

P.S.
The 'main' table ( alldata ) on meteotemplate contains only these fields ( and we should import all these fields if available ):
Date Time, T ,Tmin, Tmax, H, D, W, G, B, RR, R, P, S, A ( metric units )

P.P.S.
Other data may be imported in a 'second pass' to the extra table ( alldataExtra )

Thanks for the reply.
I'll remove all rows which are not used and give it another try.

I removed all extra rows and empty or false values. Still no luck ......

Ok, but you have to add a couple of heading rows:
- first row is the column name
- the second row is the unit of measure of the column ( I mean °C, Km/h, hPa... )