We have done things like this with iMS. iMS would make this far easier to accomplish
than any other mail server. iMS puts CF in
control of every aspect of sent and received email.
The situation that you mention here sounds fairly simple but is actually somewhat
complicated. For example, most outlook users
leave their default settings which means that the mail would be html formatted. Also,
there is a chance that the mail could be
quoted printable or base64 encoded as well. For NTMail you would need to write a
"robot" (which is a kind of CGI for the mail
server) or another type of processor (NTMail allows you to write an SMTP DLL for basic
functions). This means that you need a
developer to write these programs and then somehow get the information into CF.
The software would need to MIME-docode the mail and then call CF via CFML.EXE.
Here is the way NTMail could do this:
SMTP Receives mail completely
SMTP calls Robot
Robot decodes mail and writes out a CSV file
Robot calls CFML to read in the CSV
Here's how iMS would do this:
SMTP Receives mail completely
ColdFusion template uses CFX_ODSMIME tag (included with iMS) to decode the mail. The
same ColdFusion template does the additional
processing of the CSV data.
Of course I'm biased, but I think iMS is the best solution for processing mail
dynamically.
Regards,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
>>> Find out how iMS Stacks up to the competition:
>http://www.coolfusion.com/imssecomparison.cfm
----- Original Message -----
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 6:34 AM
Subject: OT: Integrating email solutions with CF
> Hi.
>
> Has anyone successfully engineered a solution for database entry by email,
> using CF - and if so, with which mail server? I'm keen to get this solution
> working for a client, using Gordano's NTMail software (for example -
> customers email CSV files to company, which is then validated by CF and
> entered into the DB).
>
> Any advice appreciated.
>
> Will
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
