Top10s

[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

[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.

[Dennisdg]

Steve

Thanks for that - I've just found that out. Last date in the SQL was 13 Jan, that will explain it.

[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

[nitrx]

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

[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.

[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

[Dennisdg]

Ron, Steve and Mark

Thanks all sorted now.

Steve thanks for the edit!