Rowel Atienza wrote:
i preferred this last technique coz you can also use this to retrieve SMS messagesOn 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 likeI 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.
on a customized SMS gateway (+ gnokii), extract the tracking number,
query the database and send the status thru SMS. that is, if you're planing
to make your project SMS ready / capable.
_ 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]
