On Tue, 12 Nov 2002, Federico Sevilla III wrote:
> On Tue, Nov 12, 2002 at 07:21:09AM +0800, Adorable Dauz wrote:
> > I need you suggestion, I'm doing a project to our company. This is
> > about track and trace thru email reply. The client will send the email
> > with the body or subject content of the tracking number and it will
> > reply back to the sender what is the status of the package. The
> > program will pull the info in our sql server. Any idea please to start
> > my project.
>
> Among other approaches you can consider using your scripting language of
> choice (Python, Perl, et al). You can create an alias so that your
> MTA/MDA pipes all messages to a certain user (maybe
> [EMAIL PROTECTED]) through your script. At least in Postfix this is
> done by making the alias entry something like
>
I think this is not that difficult to do. Assuming you have an
email account (eg [EMAIL PROTECTED]) where all inquiries can be made, all you
need to do is run a cron job (say every min) that reads the
/var/mail/sales file. You can use "From" to delimit each email. If an
email is new, it has no "Status:" string after the header. If it is new
use perl to extract the subject line (tracking number) and use that
tracking number to query the database of its status. Email back the status
using the primitive /bin/mail. Your client will get a reply in a couple of
minutes.
Alternatively, why not use a web-based script to query the status
of a certain tracking number?
rowel
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
