1,126
edits
ImportCumulusFile: Difference between revisions
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= | {{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 | ||