ImportCumulusFile: Difference between revisions

Updated to ver 1.4 - added realtime
(ver 1.3b)
(Updated to ver 1.4 - added realtime)
{{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson|contact='DAJ' via the forum|updated=303 NovemberDecember 2012|version=1.3b4}}
 
This is a PHP script designed to run on your webserver and import Cumulus log files into a MySQL database on your server.
 
=Installation=
*Download the PHP script ... [http://wiki.sandaysoft.com/files/ImportCumulusFile_v1-3b4.txt (right click, Save as)]
*Save the file and edit it using a text editor -- there are five entries to be edited
:servername, username, password, database and security key
 
*type=xxxx
::this must be either the phrase ''dayfile'', ''monthly'' or ''monthlyrealtime''
 
*file=xxxxx
= Version Control =
 
*1.4 - 3 December 2012, Mark Crossley. Added ability to create and log data to a 'realtime' table [[http://wiki.sandaysoft.com/filesImportCumulusFile_v1-4.txt Download]]
*1.3b - 30 Nov 2012, Mark Crossley, changed so ALL missing values from the dayfile are entered into the table as NULL. If you have used the Cumulus editor, then they will be present in the file as blank fields. [[http://wiki.sandaysoft.com/filesImportCumulusFile_v1-3b.txt Download]]
*1.3a - 30 Nov 2012, Mark Crossley, added line breaks to output text [[http://wiki.sandaysoft.com/filesImportCumulusFile_v1-3a.txt Download]]