• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Ticket Management System

 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Any help will be highly appreciated

Thanks in anticipation
 
Rob Spoor
Sheriff
Pie
Posts: 20512
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
David Newton
Author
Rancher
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

Best Regards
 
Rob Spoor
Sheriff
Pie
Posts: 20512
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Look for any JavaMail tutorial. I found the following two quite useful:
http://www.javaworld.com/javaworld/jw-10-2001/jw-1026-javamail.html
http://java.sun.com/developer/onlineTraining/JavaMail/contents.html
 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rob Prime wrote:Look for any JavaMail tutorial. I found the following two quite useful:
http://www.javaworld.com/javaworld/jw-10-2001/jw-1026-javamail.html
http://java.sun.com/developer/onlineTraining/JavaMail/contents.html


Thanks am checking and will let you know about the progress

Best Regards
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic