Re: DbMail Outlook Received Date

Hello Roel,

thanks for your answer. I'll write a little tool for that in the 
evening. I am not a Perl Expert, so it will be a small java-program. :-) 
I've tested some things with the Java-Mail API and DBMail IMAP(getting 
Received_date and Date of Email-Header). So the Update won't be a hard 
thing.

Greetings,
Ronny

Roel Rozendaal - IC&S wrote:

> that's probably a design flaw :$ i don't know what the rfc's say about 
> the internal date of a message when copying it, we'll check this out 
> if none on this list knows the answer :) For the time being, you might 
> create a simple perl script fixing this issue; you could use something 
> like:
>
> * connect to the imap server
> * connect to the database
> * send "fetch 1:* (uid body[header.fields (date)])" for each folder to 
> the server
> * parse each response item to give the message-uid and the date
> * for each response item send "update messages set internal_date = 
> $date_from_imap_server where message_idnr = $uid_from _imap_server)
>
> it's probably a lot faster to query&parse the date header field 
> directly from the database but if time is not much of an issue this is 
> the easiest way to fix it.
>
> regards roel
>
> Op 26-feb-04 om 16:16 heeft Ronny Walter het volgende geschreven:
>
> > Hello DBMail users,
> >
> > I installed DBMail (1.2.3) on my server and copied a lot of emails to 
> > an folder in dbmail. Problem is the "received date", that is shown by 
> > email-clients. When using clients like thunderbird or kmail 
> > everything works fine. But some users still use Outlook as 
> > email-client. In Outlook the received date is wrong. Outlook shows 
> > the date, when the email is copied into the dbmail server (the value 
> > of "internal_date" in table messages). I tried the same thing with an 
> > another IMAP-Server (Cyrus) and there it works with the "original" 
> > receive date of the email.
> >
> > Is this a problem of Outlook, or why does dbmail sends this date to 
> > the client? Perhaps you have an idea how to solve this. It is not 
> > very nice to have 5000 mails with the same date in one folder. :-)
> >
> > Greetings,
> > Ronny
> > _______________________________________________
> > Dbmail mailing list
> > Dbmail@xxxxxxxxxx
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> _________________________
> R.A. Rozendaal
> IC&S
> T: +31 30 63 55 736
> F: +31 30 63 55 731
> www.ic-s.nl
>
> _______________________________________________
> Dbmail mailing list
> Dbmail@xxxxxxxxxx
> https://mailman.fastxs.nl/mailman/listinfo/dbmail