SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jun 2012
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Email to Database? How is it done?

    Hi all,

    How do you go about creating a system whereby an email is automatically inserted into DB?

    For example in an online support ticketing system, whereby a support agent can have an email conversation with a customer however all emails are automatically captured and logged by the ticketing system so that either user can log in and see the full conversation?

    Is there some standard software that does this or is it a more customised solution?

    Any pointers would be greatly appreciated!

    Many thanks,

    Ben

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,632
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Exactly how depends on some implementation details, but typically there is a system that reads email -- either from it's own dedicated mailbox or through some hooks in sendmail / exchange / whatever -- and then parses it out and does appropriate things with it. Not horribly difficult to stand up, fun comes in edge cases and parser errors.

  3. #3
    SitePoint Member
    Join Date
    Jun 2012
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Ben A View Post
    Hi all,

    How do you go about creating a system whereby an email is automatically inserted into DB?

    For example in an online support ticketing system, whereby a support agent can have an email conversation with a customer however all emails are automatically captured and logged by the ticketing system so that either user can log in and see the full conversation?

    Is there some standard software that does this or is it a more customised solution?

    Any pointers would be greatly appreciated!

    Many thanks,

    Ben

    What you are describing is called email ticketing. For that you do not need a customized solution, just a system like focalscope (easy to use, affordable, and a proper ticketing system). There are others, but that is the one I am using because it really outperformed the other systems I tested.
    Last edited by Mittineague; Jun 7, 2012 at 11:08. Reason: removing unnecessary link


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •