When I try to upload the old files from WD to MYSQL, the application gets an error saying that there is a duplicate key when it tries to go to the next day of data.
Make sure you’ve got the very latest version of 10.17r. It’s gone through a number of iterations in the last 24 hours and one version had a date problem which could be causing your problem. The code was prefixing the date with a 20 (for this millenium) so dates like 2003-09-01 became 2020-03-09 (the 01 was truncated). So you would get the same date repeated for a complete month.
Check the data you’ve uploaded to see if the dates are sensible. If they’re not, then this is almost certainly the problem.
Thanks, I was using version n. This new version seems to be working fine and also trasmits to SQL a lot faster.
Its also putting less of a load on my SQL box.
Shadow
This new version seems to be working fine and also trasmits to SQL a lot faster. Its also putting less of a load on my SQL box.
It does 
Getting it to this stage has been the reason for the multiple updates to 10.17r in the laast 24 hours!
and it does not complain about duplicate key errors either
I noticed that when I was running some test queries that the day column is actually being filled in with the month.
ok, i see that bug
try vers 2.6:
http://www.weather-display.com/downloadfiles/wdmysql.zip
unzip to where you have wd installed (exit wdmysql.exe first)
Just installed the updated version and it’s working just fine now.
Thanks