Like CFPOP, but read text file of mail message and parse instead

[Charles R. Thompson]

I have an existing (non CF) support tracking system that read emails from a
server and populates a database. I'm writing a report in CFMX that will take
a case number and assemble a report of the conversations, etc. A Blob file
stores the full email message as it would appear in a mail file. I can get
that info out of the DB fine with CFMX.

Using 6.1, is there a known way or tag out there that will allow me to take
that query result (either after I make it a string or even write it to a
temp file) then extract just the textbody message?

I have experience with CFPOP and utilizing the .TEXTBODY attribute from it's
query object... but it won't suffice for this application. Is there some
hacky way to get CFPOP to read an email file and parse it?

Any ideas?

CT

[Charles R. Thompson]

> I have experience with CFPOP and utilizing the .TEXTBODY attribute from
it's

> query object... but it won't suffice for this application. Is there some
> hacky way to get CFPOP to read an email file and parse it?

For the heck of it I looped over my email list and tried directly writing
the email bodies with headers to an account file on the email server, then
reading in through POP3... almost worked but the headers seemed to munge
everything into one email with additional messages as attachments

Still looking for a solution.

[Tom Jordahl]

> Using 6.1, is there a known way or tag out there that will allow me to
take

> that query result (either after I make it a string or even write it to a
> temp file) then extract just the textbody message?

Charles,

You would have to parse the message. If you are handy with Java, you might
be able to use the JavaMail APIs to parse the message and extract the
content. This would be a pretty tricky thing to do and it may be easier to
write some CFML to parse the text of the message to extract the parts you
want.

In short there is no easy way to do what you want.


--
Tom Jordahl
Macromedia Server Development

[Paul WA]

CFX_POP3 is able to read .eml files using an action attribute of LOADFROMFILE.

[PaulH]

doing some research & stumbled into this. if you haven't already solved this,
tom had the right idea but maybe too pessimistic about it's difficulty (or i've
been doing too much javamail lately). see if this helps

<cfscript>

mailBLOB=createObject("java","java.io.ByteArrayInp utStream").init(yourBlobGoesH
ere);
mailSession=createObject("java","javax.mail.Sessio n");

mimeMessage=createObject("java","javax.mail.intern et.MimeMessage").init(mailSes
sion,mailBLOB);
subject=mimeMessage.getSubject();
from=mimeMessage.getFrom();
sentDate=mimeMessage.getSentDate();