1,154
edits
ImportCumulusFile: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
|
{{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson / Mark Crossley|contact='DAJ' / 'mcrossley' via the forum|updated=
This is a PHP script designed to run on your webserver and import Cumulus log files into a MySQL database on your server.
*a Cumulus Log already uploaded
=IMPORTANT NOTE FOR VERSION 2.0+=
Version 2.0 changes the SQL table structures from version 1.x. If you are currently using version 1.x and wish to upgrade, then you should DROP the existing tables and let the version 2 script recreate them. If this is unacceptable DO NOT UPGRADE, stay with version 1.x
=Installation=
*Download the PHP script ... [http://wiki.sandaysoft.com/files/
*Save the file and edit it using a text editor -- there are five entries to be edited
:servername, username, password, database and security key
= Version Control =
*3.0 - 6 November 2016 [[http://wiki.sandaysoft.com/files/ImportCumulusFile_v3-0.txt Download]]
**Converted to use prepared statements - more efficient for bulk inserts (the main use for script with CumulusMX?)
**SQL injection protection improved - requires the table names to be defined in this script
*2.8 - 27 April 2015 [[http://wiki.sandaysoft.com/files/ImportCumulusFile_v2-8.txt Download]]
**Added addtional configuration parameter $rainUnit, default is 'mm'
| |||