I strongly recommend that you just simply keep these in their Q* and D*
formats and zip up the directories every night and write them to a CD or
something every so often. Retrieval of such E-mail should be rare if
ever necessary, and you can easily write something that would unzip the
files, search for addresses in the Q* files, and copy the needed files
to a directory when needed. You can also of course script the zipping.
Personally, I like the WinZip command line add-on as it seems to
compress better than freeware components, and WinZip only costs $20.
You can zip an entire directory with a short call, and in a script you
can generate a time stamp for the file name and then set it up on the
scheduler.
Matt
Rick Davidson wrote:
Essentially the good folks at Enron and WorldComm brought us the
Sarbanes-Oxley Act or SOX for short. Public companies have to keep a
record of all communications, the details of this are vague but mostly
apply to the money people and decision makers. Since we cant
selectively catch that specific traffic we have to grab it all.
Basicly all mail must be archived including the attachments and all
mail must be retrievable in a reasonable amount of time, thats about it.
We were considering stripping the attachments and storing them in a
directory structure and storing the email text data in the sql
database. Separate fields for the date, to, from, subject, the entire
D file and the attachment names and their location.
We figure we can get decent compression and searchabiltiy with the
text info but the biggest hurdle is the attachments and being a Title
company we have alot of large attachments to deal with.
Rick Davidson
National Systems Manager
North American Title Group
-
----- Original Message ----- From: "Matt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 27, 2004 3:53 PM
Subject: Re: [Declude.JunkMail] Determining a BCC Recipient
That's funny that you should ask. I just coded that one up in
VBScript this last weekend. I even managed to decode base64 text
attachments, remove quoted-printable encoding, and strip out all of
the HTML code. If this is for archiving according to legal
requirement, the attachments would probably be necessary however.
Sandy had some good recommendations on how to archive. Maybe if you
shared your requirements with the list, someone would have some
recommendations as to how to approach this a better way.
Matt
Rick Davidson wrote:
ok thanks Matt, we do have some programmers on staff here but I will
sure conscript your help if we brick wall. Regardless of where it is
stored its going to be a massive amount of data, my initial
samplings show 1.5 to 2GB per day. Yikes!
You wouldnt happen to know how to parse mime types and remove
attachments would you? :-)
Rick Davidson
National Systems Manager
North American Title Group
-
----- Original Message ----- From: "Matt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 27, 2004 2:58 PM
Subject: Re: [Declude.JunkMail] Determining a BCC Recipient
That's going to be one massive database :) I've become quite the
VBScripter as of late (if that's something to brag about), so let
me know if you need any help.
Matt
Rick Davidson wrote:
Thanks Matt,
COPYFILE is working perfectly, now its just a matter of writing
the program to parse and insert it into the SQL database.
Rick Davidson
National Systems Manager
North American Title Group
-
----- Original Message ----- From: "Matt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 26, 2004 5:15 PM
Subject: Re: [Declude.JunkMail] Determining a BCC Recipient
Rick,
This information is in the Q* file. If you use the COPYFILE
action, it will keep both the D* and the Q* file. The only issue
is that the Declude headers are lost and each message is kept
separately and not viewable without a special application like
spamreview. IMO, this is appropriate for archiving due to legal
requirement, but not for doing review.
If you want to handle this in a different way by just sending to
a mailbox, you can use a WARN action with the %ALLRECIPS%
variable which will contain the BCC addresses as well. For
instance, you could do the following:
TESTNAME WARN X-RECIPIENTS: <%ALLRECIPS%>
This of course exposes the BCC info to all that might view the
headers.
Matt
Rick Davidson wrote:
I am looking at creating our own email archiving solution using
sql, the main hurdle is how to handle and email sent to a user
using BCC. Is there a way to use Declude to include that info in
a recipient x-header?
If I send myself using only the BCC field the header contains
only this
From: "Rick Davidson" <[EMAIL PROTECTED]>
To: <Undisclosed-Recipient:;>
Subject: test
I assume the BCC info is lost once the message hits the senders
SMTP server correct?
Rick Davidson
National Systems Manager
North American Title Group
-
---
[This E-mail was scanned for viruses by Declude Virus
(http://www.declude.com)]
---
This E-mail came from the Declude.JunkMail mailing list. To
unsubscribe, just send an E-mail to [EMAIL PROTECTED], and
type "unsubscribe Declude.JunkMail". The archives can be found
at http://www.mail-archive.com.
--
=====================================================
MailPure custom filters for Declude JunkMail Pro.
http://www.mailpure.com/software/
=====================================================
---
[This E-mail was scanned for viruses by Declude Virus
(http://www.declude.com)]
---
This E-mail came from the Declude.JunkMail mailing list. To
unsubscribe, just send an E-mail to [EMAIL PROTECTED], and
type "unsubscribe Declude.JunkMail". The archives can be found
at http://www.mail-archive.com.
---
[This E-mail was scanned for viruses by Declude Virus
(http://www.declude.com)]
---
This E-mail came from the Declude.JunkMail mailing list. To
unsubscribe, just send an E-mail to [EMAIL PROTECTED], and
type "unsubscribe Declude.JunkMail". The archives can be found
at http://www.mail-archive.com.
--
=====================================================
MailPure custom filters for Declude JunkMail Pro.
http://www.mailpure.com/software/
=====================================================
---
[This E-mail was scanned for viruses by Declude Virus
(http://www.declude.com)]
---
This E-mail came from the Declude.JunkMail mailing list. To
unsubscribe, just send an E-mail to [EMAIL PROTECTED], and
type "unsubscribe Declude.JunkMail". The archives can be found
at http://www.mail-archive.com.
---
[This E-mail was scanned for viruses by Declude Virus
(http://www.declude.com)]
---
This E-mail came from the Declude.JunkMail mailing list. To
unsubscribe, just send an E-mail to [EMAIL PROTECTED], and
type "unsubscribe Declude.JunkMail". The archives can be found
at http://www.mail-archive.com.
--
=====================================================
MailPure custom filters for Declude JunkMail Pro.
http://www.mailpure.com/software/
=====================================================
---
[This E-mail was scanned for viruses by Declude Virus
(http://www.declude.com)]
---
This E-mail came from the Declude.JunkMail mailing list. To
unsubscribe, just send an E-mail to [EMAIL PROTECTED], and
type "unsubscribe Declude.JunkMail". The archives can be found
at http://www.mail-archive.com.
---
[This E-mail was scanned for viruses by Declude Virus
(http://www.declude.com)]
---
This E-mail came from the Declude.JunkMail mailing list. To
unsubscribe, just send an E-mail to [EMAIL PROTECTED], and
type "unsubscribe Declude.JunkMail". The archives can be found
at http://www.mail-archive.com.
--
=====================================================
MailPure custom filters for Declude JunkMail Pro.
http://www.mailpure.com/software/
=====================================================
---
[This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)]
---
This E-mail came from the Declude.JunkMail mailing list. To
unsubscribe, just send an E-mail to [EMAIL PROTECTED], and
type "unsubscribe Declude.JunkMail". The archives can be found
at http://www.mail-archive.com.
