[LINK] ACT vote article
Gordon Keith
gordon.keith@marine.csiro.au
Mon, 22 Oct 2001 14:41:16 +1100
On Mon, 22 Oct 2001 13:03, Chirgwin, Richard wrote:
> Bob,
>
> Scuze me if this is a "D'oh!" question, but what's the process for
> e-mailing to a database?
Most straightforward is to write a program that handles the SMTP
protocol and looks like a mail server. When it recieves mail it parses
the address, subject and body of the message and writes the information
to the database. Normally you would have very strict rules as to how
the email should be formatted, so a program which writes and sends the
email is also a good idea.
Slightly more complicated (but probably easier to implement) is to set
up a real SMTP server and write a procmail script that passes the mail
to a program that reads the mail and writes the information to the
database.
Email is a great protocol for transferring information where a bit of
latency isn't a problem. I've written programs that can be controlled
remotely by email, it isn't hard and all you need is some sort of email
connection for it to work. I was able to reboot a data logging system
on a ship whose only network connection was to received email once or
twice a day.
Regards
Gordon