Hi All, As mentioned before on this list, there is a "issue" when exporting data from Outlook to dbmail. I was hoping someone would solve this problem before me and share his solution............
But I needed the solution right now, therefor I went programming myself and come up with a solution that would do the job for me....it isn't portable. some reasons: -Swapping of date within english notation is not supported, it can cause trouble -Just look at it, its made by using the famous: "trail and error" method. -Just dutch and english is supported, several clients with french, german etc etc are not tested I Guess there must be a better way to deal with this date issue, but as mentioned, this was the only solution I could come up with. I'am willing to share this script for "educational" purposes, be free to share, ignore, delete or abuse this script. Keep in mind that I am not a professional programmer (as you certainly will see) Disclaimer: This script shouldn't be destructive, any use is at own risk. The works: It reads the database tables and creates a sql script that must be executed there is a shortcomming, I don't know how to replace ` by ' this must be manual done by loading the sql file in to vi and then execute ":%s/`/'/" (twice) Be warned, in the date field there is a known bug if the date is "english", this means month and day flipped, in my case this didn't turned out to be a problem (I had no occurance) There are some manual actions needed -Replace ` by ' in the generated sql script, as mentioned before. -Create a field within the dbmail message table named "new_int_date", type datetime with a default value of '1989-01-01 00:00:00' ( I suppose, not many people do have mail prior to this date) -Execute the script, this wil update "new_int_date" -and finally execute (after carefull examining and debuging new_date_int): update internal_date set internal_date=new_int_date where (new_int_date > '1990-01-01 00:00:00') in my case it took about 10 minutes to update the database containing 10.000 records of which 400 failed because of a missing date field in the message header. _______________________________________ Fons van der Beek
<<attachment: outlook-date.zip>>
