Page 1 of 1
Top10s
Posted: Fri 24 Jan 2014 11:33 am
by Dennisdg
I see a discrepancy between Cumulus 'standard pages' and Top10s.
Rainfall this month (also year) which shows 137.8mm on the 'standard' cumulus pages and also in the Cumulus software. The amount seem in the right order for this park of the UK so far this year!
Top10s is showing Wettest Months 95.8 Jan 2014 and Wettest Years 96 2014.
My Web server is showing the correct daily date/time stamp for the Dayfile.txt is being uploaded to the Web server daily at 00:10.
Any thoughts as to where the error might be please.
Thanks
Re: Top10s
Posted: Fri 24 Jan 2014 11:47 am
by steve
137.8 is the correct total according to the dayfile.txt on your web site. 95.8 is the total up to and including 13th Jan. So my guess would be that whatever it is that is supposed to update your SQL database hasn't run successfully since then.
Re: Top10s
Posted: Fri 24 Jan 2014 11:50 am
by Dennisdg
Steve
Thanks for that - I've just found that out. Last date in the SQL was 13 Jan, that will explain it.
Re: Top10s
Posted: Fri 24 Jan 2014 2:42 pm
by Dennisdg
Steve, Mark
I obviously managed to upload correctly once to populate the sql database but I can't for the life of me get it to work again.
I'm trying to use Toolbox's Remote Command with the following
http://g4glp.co.uk/public_html/php ImportCumulusFile_v2-3.php?type=dayfile&key=****&table=dayfile&file=./data/dayfile.txt
where **** is my secret key.
Then I try to Execute Now (in Toolbox) to test the script.
I get Error: The remote server returned an error: 404 (Not found).
I guess there's a syntax problem but I seem to be getting nowhere fast.
Can you help please?
Thanks
Re: Top10s
Posted: Fri 24 Jan 2014 2:56 pm
by nitrx
Dennisdg wrote:Steve, Mark
I obviously managed to upload correctly once to populate the sql database but I can't for the life of me get it to work again.
I'm trying to use Toolbox's Remote Command with the following
http://g4glp.co.uk/public_html/php ImportCumulusFile_v2-3.php?type=dayfile&key=****&table=dayfile&file=./data/dayfile.txt
where **** is my secret key.
Then I try to Execute Now (in Toolbox) to test the script.
I get Error: The remote server returned an error: 404 (Not found).
I guess there's a syntax problem but I seem to be getting nowhere fast.
Can you help please?
Thanks
Try this (data are in the database now I think
http://g4glp.co.uk/ImportCumulusFile_v2 ... ayfile.txt
Re: Top10s
Posted: Fri 24 Jan 2014 3:40 pm
by mcrossley
Thanks Ron. Yes it looks like you were trying to use a combination of command line PHP and URL rather than one or the other.
Re: Top10s
Posted: Fri 24 Jan 2014 4:09 pm
by steve
I think the key that was supposed to be secret was actually there, so I've taken the liberty of editing a couple of posts

Re: Top10s
Posted: Fri 24 Jan 2014 4:14 pm
by Dennisdg
Ron, Steve and Mark
Thanks all sorted now.
Steve thanks for the edit!