1,127
edits
ImportCumulusFile: Difference between revisions
version 1.4a
(Updated to ver 1.4 - added realtime) |
(version 1.4a) |
||
| Line 1: | Line 1: | ||
{{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson|contact='DAJ' via the forum|updated=3 December 2012|version=1. | {{AddOnBanner|name=ImportCumulusFile|type=PHP|author=David A Jamieson|contact='DAJ' via the forum|updated=3 December 2012|version=1.4a}} | ||
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-4a.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 65: | Line 65: | ||
= Version Control = | = Version Control = | ||
*1. | *1.4a - 3 December 2012, Mark Crossley. Fixes syntax errors in 1.4, adds parameter presence checking. [[http://wiki.sandaysoft.com/filesImportCumulusFile_v1-4a.txt Download]] | ||
*1.4 - 3 December 2012, Mark Crossley. Added ability to create and log data to a 'realtime' table. | |||
*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]] | ||