1,126
edits
ImportCumulusFile: Difference between revisions
Updated to ver 1.4 - added realtime
(ver 1.3b) |
(Updated to ver 1.4 - added realtime) |
||
| Line 1: | Line 1: | ||
{{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson|contact='DAJ' via the forum|updated= | {{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson|contact='DAJ' via the forum|updated=3 December 2012|version=1.4}} | ||
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 12: | Line 12: | ||
=Installation= | =Installation= | ||
*Download the PHP script ... [http://wiki.sandaysoft.com/files/ImportCumulusFile_v1- | *Download the PHP script ... [http://wiki.sandaysoft.com/files/ImportCumulusFile_v1-4.txt (right click, Save as)] | ||
*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 36: | Line 36: | ||
*type=xxxx | *type=xxxx | ||
::this must be either the phrase ''dayfile'' or '' | ::this must be either the phrase ''dayfile'', ''monthly'' or ''realtime'' | ||
*file=xxxxx | *file=xxxxx | ||
| Line 65: | Line 65: | ||
= Version Control = | = 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.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]] | *1.3a - 30 Nov 2012, Mark Crossley, added line breaks to output text [[http://wiki.sandaysoft.com/filesImportCumulusFile_v1-3a.txt Download]] | ||