5,838
edits
ImportCumulusFile: Difference between revisions
m
→Version Control: made clearer which relate to legacy Cumulus, which to MX
m (→Installation: remove download of obsolete version that was here) |
m (→Version Control: made clearer which relate to legacy Cumulus, which to MX) |
||
| Line 419: | Line 419: | ||
= Version Control = | = Version Control = | ||
*4.3 - 1 September 2020 | Latest MX download: | ||
*4.3 - 1 September 2020 [https://cumuluswiki.org/files/ImportCumulusFile_v4-3.txt Download] | |||
** Steinar Utne: If monthly and $auto_month=true then construct filename from date (i.e. <dir>MonYYlog.txt) rather than read from parameters | ** Steinar Utne: If monthly and $auto_month=true then construct filename from date (i.e. <dir>MonYYlog.txt) rather than read from parameters | ||
*4.2 - 18 August 2020 | |||
Earlier MX Downloads: | |||
*4.2 - 18 August 2020 [https://cumuluswiki.org/files/ImportCumulusFile_v4-2.txt Download] | |||
** Steinar Utne: Added Humidex in dayfile and monthly | ** Steinar Utne: Added Humidex in dayfile and monthly | ||
*4.1 - 5 May 2020 | *4.1 - 5 May 2020 [https://cumuluswiki.org/files/ImportCumulusFile_v4-1.txt (Download, right click, Save as)] | ||
**Fix for files that do not have the required number of fields | **Fix for files that do not have the required number of fields | ||
*4.0 - 4 May 2020 Download removed | *4.0 - 4 May 2020 Download removed | ||
| Line 436: | Line 439: | ||
**SQL injection protection improved - requires the table names to be defined in this script | **SQL injection protection improved - requires the table names to be defined in this script | ||
*2.8 - 27 April 2015 [[https://cumuluswiki.org/files/ImportCumulusFile_v2-8.txt Download]] | *2.8 - 27 April 2015 [[https://cumuluswiki.org/files/ImportCumulusFile_v2-8.txt Download]] | ||
**Added | **Added additional configuration parameter $rainUnit, default is 'mm' | ||
**Added 'rain since midnight' to the monthly log file table | **Added 'rain since midnight' to the monthly log file table | ||
**This version is REQUIRED to support CumulusMX direct inserts | **This version is REQUIRED to support CumulusMX direct inserts | ||
| Line 442: | Line 445: | ||
**To updated existing monthly tables use the following SQL command [if you use 'mm' for rain change (4,2) to (4,1)]: | **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; | ***ALTER TABLE <<YOUR_MONTHLY_TABLENAME>> ADD COLUMN RainSinceMidnight DECIMAL(4,2) NULL AFTER RG11rain; | ||
Legacy Cumulus 1 downloads: | |||
*2.7 - 23 February 2015 [[https://cumuluswiki.org/files/ImportCumulusFile_v2-7.txt Download]] | *2.7 - 23 February 2015 [[https://cumuluswiki.org/files/ImportCumulusFile_v2-7.txt Download]] | ||
**Fixed | **Fixed real-time/monthly/day tables creates, to make rainfall 2dp to allow for inches | ||
**Fixed monthly table create, to make evapotrans 2 dp | **Fixed monthly table create, to make evapotrans 2 dp as it uses same units as rainfall | ||
**Converted from depreciated mysql to mysqli | **Converted from depreciated mysql to mysqli | ||
*2.6 - 02 April 2014, Mark Crossley [[https://cumuluswiki.org/files/ImportCumulusFile_v2-6.txt Download]] | *2.6 - 02 April 2014, Mark Crossley [[https://cumuluswiki.org/files/ImportCumulusFile_v2-6.txt Download]] | ||
| Line 452: | Line 457: | ||
***To alter an existing table... | ***To alter an existing table... | ||
***ALTER TABLE `dayfile` CHANGE `HighSolarRad` `HighSolarRad` DECIMAL(5,1) NULL DEFAULT NULL | ***ALTER TABLE `dayfile` CHANGE `HighSolarRad` `HighSolarRad` DECIMAL(5,1) NULL DEFAULT NULL | ||
*2.4 - 23 October 2013, Mark | *2.4 - 23 October 2013, Mark Crossley [[https://cumuluswiki.org/files/ImportCumulusFile_v2-4.txt Download]] | ||
**Changed day file humidity fields from varchar(3) to decimal(4,1) | **Changed day file humidity fields from varchar(3) to decimal(4,1) | ||
*2.3 - 05 June 2013, Mark Crossley [[https://cumuluswiki.org/files/ImportCumulusFile_v2-3.txt Download]] | *2.3 - 05 June 2013, Mark Crossley [[https://cumuluswiki.org/files/ImportCumulusFile_v2-3.txt Download]] | ||
| Line 462: | Line 467: | ||
*2.0 - 13 March 2013, Mark Crossley [[https://cumuluswiki.org/files/ImportCumulusFile_v2-0.txt Download]] | *2.0 - 13 March 2013, Mark Crossley [[https://cumuluswiki.org/files/ImportCumulusFile_v2-0.txt Download]] | ||
**Change monthly and realtime tables to use combined date/time columns rather than separate | **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 | **Added optional retention time for realtime table. Records older than the specified age will be deleted. The query-string parameters are '''retainVal=NNN retainUnit=XXXX''' | ||
**Added checking to allow running of the script from a command line as well as via http | **Added checking to allow running of the script from a command line as well as via http | ||
**Added 'extra' columns to record wind directions as compass points where they are only provided as bearings: | **Added 'extra' columns to record wind directions as compass points where they are only provided as bearings: | ||
| Line 473: | Line 478: | ||
*1.3 - 27 Nov 2012, Mark Crossley, updated for Cumulus b1050 [[https://cumuluswiki.org/files/ImportCumulusFile_v1-3.txt Download]] | *1.3 - 27 Nov 2012, Mark Crossley, updated for Cumulus b1050 [[https://cumuluswiki.org/files/ImportCumulusFile_v1-3.txt Download]] | ||
*1.2 - 6 May 2011, Mark Crossley, updated for Cumulus 1.9.1 | *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]] | *1.1c - 11 Mar 2010,David A Jamieson, Small modification to code to handle date delimiter with a dot [[http://wiki.sandsoft.com/files/ImportCumulusFile_v1-1c.txt Download]] | ||
*1.1b Added a variable to consider decimal separator | *1.1b - 04 Feb 2010, David A Jamieson, Added a variable to consider decimal separator | ||
*1.1a Added date delimiter | *1.1a - David A Jamieson, Added date delimiter | ||
*1.1 Added the facility to identify the delimiter used on the import file | *1.1 - David A Jamieson, Added the facility to identify the delimiter used on the import file | ||
*1.0 First Release | *1.0 - David A Jamieson, First Release, see top of page for details | ||
[[Category:WebTools]] [[Category:User Contributions]] | [[Category:WebTools]] [[Category:User Contributions]] | ||