I encountered this very problem ages ago. At the time, my users were
running Cyrus.
To solve the problem, I wrote a program in C that took the Cyrus files
and pushed them over to DBMail (www.itoperations.com.au), setting
internal_date such that the Outlook and Outlook Express clients saw the
original received date in the message view.
Want to work together on a .dbx->DBMail converter? I'd just need to
adjust my logic slightly to be able to read DBX files.
Regards,
Chris
Roel Rozendaal - IC&S wrote:
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
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
