236
edits
ImportCumulusFile: Difference between revisions
m
Text replacement - "cumuluswiki.wxforum.net" to "cumuluswiki.org"
SaratogaWX (talk | contribs) m (Text replacement - "http://wiki.sandaysoft.com/" to "https://cumuluswiki.wxforum.net/") |
SaratogaWX (talk | contribs) m (Text replacement - "cumuluswiki.wxforum.net" to "cumuluswiki.org") |
||
|
=Installation=
*Download the PHP script ... [https://cumuluswiki.
*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.2 - 11 September 2018 [[https://cumuluswiki.
**Fixed inserting of WindbearingSym and CurrWindBearingSym
*3.1 - 1 March 2018 [[https://cumuluswiki.
**Fix variable typos in realtime table creation status messages
**Remove some HTTP headers that were causing problems on some servers
*3.0 - 6 November 2016 [[https://cumuluswiki.
**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 [[https://cumuluswiki.
**Added addtional configuration parameter $rainUnit, default is 'mm'
**Added 'rain since midnight' to the monthly log file table
**To updated existing monthly tables use the following SQL command [if you use 'mm' for rain change (4,2) to (4,1)]:
***ALTER TABLE <<YOUR_MONTHLY_TABLENAME>> ADD COLUMN RainSinceMidnight DECIMAL(4,2) NULL AFTER RG11rain;
*2.7 - 23 February 2015 [[https://cumuluswiki.
**Fixed realtime/monthly/day tables creates, to make rainfall 2dp to allow for inches
**Fixed monthly table create, to make evapotrans 2 dp
**Converted from depreciated mysql to mysqli
*2.6 - 02 April 2014, Mark Crossley [[https://cumuluswiki.
**Fixed a PHP vulnerability that could reveal your passcode
*2.5 - 03 December 2013 (uploaded 02 Feb 2014), Mark Crossley [[https://cumuluswiki.
**Changed day file HighSolarRad from varchar(5) to decimal(5,1)
***To alter an existing table...
***ALTER TABLE `dayfile` CHANGE `HighSolarRad` `HighSolarRad` DECIMAL(5,1) NULL DEFAULT NULL
*2.4 - 23 October 2013, Mark crossley [[https://cumuluswiki.
**Changed day file humidity fields from varchar(3) to decimal(4,1)
*2.3 - 05 June 2013, Mark Crossley [[https://cumuluswiki.
**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 [[https://cumuluswiki.
**Fixed typo in day file table field name LowDewPint -> LowDewPoint
*2.0 - 13 March 2013, Mark Crossley [[https://cumuluswiki.
**Change monthly and realtime tables to use combined date/time columns rather than separate
**Added optional retention time for realtime table. Records older than the specified age will be deleted. retainVal=NNN retainUnit=XXXX
Dayfile: Added the following columns:- HWindGBearSym, DomWindDirSym
Monthly: Added the following columns:- WindbearingSym, CurrWindBearingSym
*1.4a - 3 December 2012, Mark Crossley. Fixes syntax errors in 1.4, adds parameter presence checking. [[https://cumuluswiki.
*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. [[https://cumuluswiki.
*1.3a - 30 Nov 2012, Mark Crossley, added line breaks to output text [[https://cumuluswiki.
*1.3 - 27 Nov 2012, Mark Crossley, updated for Cumulus b1050 [[https://cumuluswiki.
*1.2 - 6 May 2011, Mark Crossley, updated for Cumulus 1.9.1
*1.1c Small modification to code to handle date delimiter with a dot [[http://wiki.sandsoft.com/files/ImportCumulusFile_v1-1c.txt Download]]
| |||