Juan Carlos,
You may be in luck- if you're meat the Minimum Standard Requirements...
- have unix
- have procmail installed
- have consistently formatted data
Look up the docs on procmail- it can sent an email through a "filter". A
filter being defined as any program on unix that reads STDIN and writes
STDOUT. The filter program reads the email, parses it appropriately, and
does something with it- in this case inserts the data into the database.
procmail can then discard the email, or forward it along to any other
filters and/or email addresses.
Of course you will have to put some security controls on this- ie: did the
email really come from your boss? Should it generate another email to
notify you of the entry? etc. I'll leave that to you- for now, look for
procmail and write a filter. You may need to do things like utilize the
SETUID bit so the filter runs as you, etc... I can't remember how to set
procmail to do this- maybe it does by default... oh, the filter can be in
any language, so long as it is a command line executable, so Lite may even
work...
regards,
james
At 04:15 PM 10/5/99 +0300, Ing. Juan Carlos Fernandez-B wrote:
>hello list,
>here is my problem, my boss receives stuff via mail that he wants to be in
>a database and on the web. obviusly he forwardss it to me so I can cut an
>paste to the web interfase I made to update the database.
>is there a way to catch this email and automate the proccess??
>like setting an spacial mail box that some how delivers to msql and the a
>lite program thet stips the conten and put it in the data base?
>or am I asking to much? am I doomed to cut and paste every day?
>
>
>Thanx!
>Juan Carlos
>
>
>-------------------------------------------------------------------------
>To unsubscribe, go to http://www.Hughes.com.au/extras/email/
>
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST