Rain import csv

Post Reply
Gerrit
Observer
Observer
Posts: 39
Joined: Wed Feb 06, 2019 1:31 pm
Station model: Vantage pro 2 plus
Software: Meteobridge
Contact:

Rain import csv

Post by Gerrit » Wed Feb 13, 2019 7:18 pm

Hello.

I recently started working with meteotemplate and have some problems with data import, specifically with the rain value.
2018 was in Weathercloud and went without any problems.

For 2017 I made a csv file in meteoplug, this gives far too low rain value.
I also know what the problem is, but I don't know how to solve it.
The rain values are not cumulative, and so the highest hourly rate is seen as the daily rate.
December 2017 gives 40.6 that its should be almost 200.

Is there a possibility to adjust this
on my site you can see the low value.


https://www.natuurrondleidingen.nl/mete ... .php?var=R

Gerrit

User avatar
Jachym
Site Admin
Site Admin
Posts: 1686
Joined: Fri Aug 18, 2017 10:12 pm
Location: Brno, Czech Republic
Station model: WH1080
Software: Meteobridge
Contact:

Re: Rain import csv

Post by Jachym » Wed Feb 13, 2019 10:10 pm

Hi,
the only way to adjust this would be deleting the records, adjusting the CSV and then re-importing it, Meteotemplate requires cumulative values and if they are not the statistics are incorrect.

Gerrit
Observer
Observer
Posts: 39
Joined: Wed Feb 06, 2019 1:31 pm
Station model: Vantage pro 2 plus
Software: Meteobridge
Contact:

Re: Rain import csv

Post by Gerrit » Fri Feb 15, 2019 8:54 am

Hello.

I didn't know if I could use the excel or the Mysql database.
I succeeded with an Excel formula.
Almost everything from meteoplug are now in the new database.

Gerrit

Post Reply