Hi Javier,
The issue with yours seems to be that your latest.csv only contains around 43 fields where as mine has 76 (I thought all csv files were same - obviously not).
I cannot rewrite for you nor assist until this weekend.
But what you can do is manually delete the “wxsim_raw_csv” table.
Then in “2wxsim_create_tables_views_run_once_only.php” you will need to remove lines from below section of create table to match/ leaving only the ones in your csv.
Then check all other files do not have a field that is not present in your csv.
// sql to create "wxsim_raw_csv" table
$sql = "CREATE TABLE IF NOT EXISTS $wxsimrawcsvtable (
`Year` int(4) DEFAULT NULL,
`Month` int(2) DEFAULT NULL,
`Day` int(2) DEFAULT NULL,
`Time` decimal(10,1) DEFAULT NULL,
`WXType1` varchar(20) DEFAULT NULL,
`WXType2` varchar(20) DEFAULT NULL,
`Temperature` decimal(4,1) DEFAULT NULL,
`HiTemp` decimal(4,1) DEFAULT NULL,
`LowTemp` decimal(4,1) DEFAULT NULL,
`RelHum` decimal(4,1) DEFAULT NULL,
`DewPt` decimal(4,1) DEFAULT NULL,
`WetBulb` decimal(4,1) DEFAULT NULL,
`WindSpd` decimal(4,1) DEFAULT NULL,
`WindDir` decimal(4,1) DEFAULT NULL,
`TotPrcp` decimal(4,2) DEFAULT NULL,
`SnowDpth` decimal(4,1) DEFAULT NULL,
`SLP` decimal(6,1) DEFAULT NULL,
`StnPres` decimal(6,1) DEFAULT NULL,
`WindChl` decimal(4,1) DEFAULT NULL,
`HeatInd` decimal(4,1) DEFAULT NULL,
`VlyTmp` decimal(4,1) DEFAULT NULL,
`HillTmp` decimal(4,1) DEFAULT NULL,
`TLvl1` decimal(4,1) DEFAULT NULL,
`T850mb` decimal(4,1) DEFAULT NULL,
`10p5Thk` decimal(6,1) DEFAULT NULL,
`LI` decimal(4,1) DEFAULT NULL,
`SkyCov` decimal(4,1) DEFAULT NULL,
`SCL1` decimal(4,1) DEFAULT NULL,
`SCL2` decimal(4,1) DEFAULT NULL,
`SCL3` decimal(4,1) DEFAULT NULL,
`SCL4` decimal(4,1) DEFAULT NULL,
`SCL5` decimal(4,1) DEFAULT NULL,
`VisTrans` decimal(4,1) DEFAULT NULL,
`VIS` decimal(4,1) DEFAULT NULL,
`SunAlt` decimal(4,1) DEFAULT NULL,
`SolarRad` decimal(4,1) DEFAULT NULL,
`UVIndex` decimal(3,1) DEFAULT NULL,
`FreezingLevelhighest` decimal(6,1) DEFAULT NULL,
`SnowLevel` decimal(6,1) DEFAULT NULL,
`Convectionindex` decimal(4,2) DEFAULT NULL,
`Severeindex` decimal(4,2) DEFAULT NULL,
`1minGust` decimal(4,1) DEFAULT NULL,
`10minGust` decimal(4,1) DEFAULT NULL,
`1hrGust` decimal(4,1) DEFAULT NULL,
`6hrGust` decimal(4,1) DEFAULT NULL,
`15m50ftTemperature` decimal(4,1) DEFAULT NULL,
`GrassTemperature` decimal(4,1) DEFAULT NULL,
`SoilSurfaceTemperature` decimal(4,1) DEFAULT NULL,
`SoilTemperatureDepth1` decimal(4,1) DEFAULT NULL,
`SoilTemperatureDepth2` decimal(4,1) DEFAULT NULL,
`SoilTemperatureDepth3` decimal(4,1) DEFAULT NULL,
`SoilTemperatureDepth4` decimal(4,1) DEFAULT NULL,
`SoilTemperatureDepth5` decimal(4,1) DEFAULT NULL,
`SoilMoistureDepth1` decimal(4,1) DEFAULT NULL,
`SoilMoistureDepth2` decimal(4,1) DEFAULT NULL,
`SoilMoistureDepth3` decimal(4,1) DEFAULT NULL,
`SoilMoistureDepth4` decimal(4,1) DEFAULT NULL,
`SoilMoistureDepth5` decimal(4,1) DEFAULT NULL,
`ET0ShortReferenceCrop` decimal(6,4) DEFAULT NULL,
`ET0LongReferenceCrop` decimal(6,4) DEFAULT NULL,
`ActualEvapotransipration` decimal(6,4) DEFAULT NULL,
`TotalET0ShortReference` decimal(5,4) DEFAULT NULL,
`TotalET0LongReference` decimal(5,4) DEFAULT NULL,
`TotalActualEvapotranspiration` decimal(5,4) DEFAULT NULL,
`IRDown` decimal(4,1) DEFAULT NULL,
`IRUp` decimal(4,1) DEFAULT NULL,
`SensibleHeat` decimal(4,1) DEFAULT NULL,
`LatentHeat` decimal(4,1) DEFAULT NULL,
`NetRadiation` decimal(6,1) DEFAULT NULL,
`HeatConductedUptoSurface` decimal(4,1) DEFAULT NULL,
`SoilTensionDepth1` int(4) DEFAULT NULL,
`SoilTensionDepth2` int(4) DEFAULT NULL,
`SoilTensionDepth3` int(4) DEFAULT NULL,
`SoilTensionDepth4` int(4) DEFAULT NULL,
`SoilTensionDepth5` int(4) DEFAULT NULL,
`TotalIrrigation` int(4) DEFAULT NULL
)";
I also see many others have downloaded the files, though not given any feedback.
l also attached copy of my latest.csv for you to compare.
regards,
latest (5).zip (44.4 KB)