Hello,
I developed a user trouble ticket system. Email is fired when ticket is updated or created.
I want to know the possibility that user should be able to reply this ticket from his/her email and data should be inserted in ticket database specific table/columns (Oracle XE).
I mean to say that user should be able to reply either from his/her control panel by logging to the website or reply from his/her regular mail e.g. yahoo, gmail, hotmail etc. but data should be inserted into specific table columns.
You would need to poll the email box, pull out new emails and parse these. The latter part may be tricky - the user can decides to modify the email in such a way it is no longer parseable. What are you going to do then?
At my job where I implemented our own ticketing system we simply disallowed direct replies. Each email sent out to the user has a link that opens the application at a point where all the user has to do is type in his remarks and press a button.
Rob Prime wrote:You would need to poll the email box, pull out new emails and parse these. The latter part may be tricky - the user can decides to modify the email in such a way it is no longer parseable. What are you going to do then?
Bail; I think most systems just look for a ticket number token in the subject. If gone, or not in any mail headers, bye bye.
I agree it's easier to not implement the functionality, but it's *so* convenient to have :/
Farakh khan
Ranch Hand
Joined: Mar 22, 2008
Posts: 672
posted
0
Hello Sir/Madam,
Rob Prime wrote:You would need to poll the email box, pull out new emails and parse these.
I should not say how but request to get me some clues to do it or any documentation/article help