ImportCumulusFile: Difference between revisions

288 bytes added ,  23:01, 5 June 2013
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=29 March 2013|version=2.1}}
{{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson / Mark Crossley|contact='DAJ' / 'mcrossley' via the forum|updated=05 June 2013|version=2.3}}


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 20: Line 20:


=Installation=
=Installation=
*Download the PHP script ... [http://wiki.sandaysoft.com/files/ImportCumulusFile_v2-1.txt (right click, Save as)] and then rename the .txt to .php
*Download the PHP script ... [http://wiki.sandaysoft.com/files/ImportCumulusFile_v2-3.txt (right click, Save as)] and then rename the .txt to .php
*Save the file and edit it using a text editor --  there are five entries to be edited
*Save the file and edit it using a text editor --  there are five entries to be edited
:servername, username, password, database and security key
:servername, username, password, database and security key
Line 75: Line 75:


= Version Control =
= Version Control =
*2.3 - 05 June 2013, Mark Crossley [[http://wiki.sandaysoft.com/files/ImportCumulusFile_v2-3.txt Download]]
**Fixed dayfile & monthfile table column HoursSun was decimal(2,1) to decimal(3,1)
*2.2 - 21 April 2013, Mark Crossley
**Made dayfile UV a decimal(3,1) field rather than varchar(4)
*2.1 - 29 March 2013, Mark Crossley [[http://wiki.sandaysoft.com/files/ImportCumulusFile_v2-1.txt Download]]
*2.1 - 29 March 2013, Mark Crossley [[http://wiki.sandaysoft.com/files/ImportCumulusFile_v2-1.txt Download]]
**Fixed typo in day file table field name LowDewPint -> LowDewPoint
**Fixed typo in day file table field name LowDewPint -> LowDewPoint