ImportCumulusFile: Difference between revisions

From Cumulus Wiki
Jump to navigationJump to search
578 bytes added ,  08:07, 20 October 2016
no edit summary
No edit summary
No edit summary
Line 1: Line 1:
{{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson / Mark Crossley|contact='DAJ' / 'mcrossley' via the forum|updated=23 February 2015|version=2.7}}
{{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson / Mark Crossley|contact='DAJ' / 'mcrossley' via the forum|updated=27 April 2015|version=2.8}}


This is a PHP script designed to run on your webserver and import Cumulus log files into a MySQL database on your server.
This is a PHP script designed to run on your webserver and import Cumulus log files into a MySQL database on your server.
Line 75: Line 75:


= Version Control =
= Version Control =
*2.8 - 27 April 2015 [[http://wiki.sandaysoft.com/files/ImportCumulusFile_v2-8.txt Download]]
**Added addtional configuration parameter $rainUnit, default is 'mm'
**Added 'rain since midnight' to the monthly log file table
**This version is REQUIRED to support CumulusMX direct inserts
**Altered layout the SQL statements to make finding/fixing stuff easier!
**To updated existing monthly tables use the following SQL command [if you use 'mm' for rain change (4,2) to (4,1)]:
***ALTER TABLE <<YOUR_MONTHLY_TABLENAME>> ADD COLUMN RainSinceMidnight DECIMAL(4,2) NULL AFTER RG11rain;
*2.7 - 23 February 2015 [[http://wiki.sandaysoft.com/files/ImportCumulusFile_v2-7.txt Download]]
*2.7 - 23 February 2015 [[http://wiki.sandaysoft.com/files/ImportCumulusFile_v2-7.txt Download]]
**Fixed realtime/monthly/day tables creates, to make rainfall 2dp to allow for inches
**Fixed realtime/monthly/day tables creates, to make rainfall 2dp to allow for inches

Navigation menu