Win a copy of Mastering Corda: Blockchain for Java Developers this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Jj Roberts
  • Carey Brown
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

Ticket Management System

 
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Sheriff
Posts: 22055
113
Eclipse IDE Spring VI Editor Chrome Java Ubuntu Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Author
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 22055
113
Eclipse IDE Spring VI Editor Chrome Java Ubuntu Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic