You might want to try to automate this a little by creating a form that stores keywords to look for in an e-mail and push data to create an entry in whatever system you want. Also keep in mind Oracle is case sensitive if that is your DB. In my previous job we did something similar by allowing departments to create their own front end interface that sent an e-mail to remedy to generate tickets. If the user replied it would go into the worklog of the ticket and in some cases re-open it if it was resolved. The only thing to be careful of is if the system you are getting an e-mail from is an automated system that sends auto-replies. You can get into an e-mail loop and you have to build code to handle that.
Thanks, Sean -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Worsdell Sent: Wednesday, October 29, 2008 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: Creating an Automated Email System Not sure what help you require, but FWIW this is how I would approach it. First of all create your data form where the emails are stored. Try and keep the fields to a minimum to help the email submitter quickly create a ticket. Then build a control panel that views the data form and adds the functionality you described. In terms of delete I would be inclined to implement a soft delete using a Status in case of erroneous deletions. Finally create the email template from your data form, use Email Instructions to make the template the submitter uses to be as simple as possible. i.e. The body of the email gets parsed into a single char field without the need for the !12345678! field identifiers. And don't forget indexes and archiving if the volumes warrant it. HTH Matt > > > Hello List, > > > > I need some inputs on creating an Automated E-mail application where a > Customer sends an ordinary e-mail to an inbox which will be submitted to > the ARS Inbox. I am planning to have all the e-mails from this inbox get > submitted to a holding form where I can have choice of creating a new > ticket, add to existing ticket or deleting the e-mail. > > > > I am planning on having a filter fire when a new E-mail arrives so it > gets submitted to the Email Holding form where agents can take further > actions on the email. Any input will be much appreciated. > > > > Thanks! > > > > Manjari R. Shrestha > > Junior Programmer Analyst > > > > SAIC > > 12530 Parklawn Drive, Suite 350 > > Rockville, MD 20852 > > Office: (301) 998-7364 > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"