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,