cool :-) if you find it working, would you consider it posting to the
list? We might include it as a utility as long as the problem isn't
solved.
regards roel
Op 26-feb-04 om 18:33 heeft Ronny Walter het volgende geschreven:
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
[email protected]
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
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
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
