CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Email Piping

Print topic Send  topic

Author Message
duplo1

Posts: 67
Posted: 01/06/2008, 8:32 AM

Does somebody have experience with ASP and "Email Piping" ? We have developed a helpdesk application and a client has raised the question about creating tickets by email. That means a user sends an email and a ticket will automatically created using his Name and Email Address.

Please help.

Christoph
View profile  Send private message
TheunisP

Posts: 342
Posted: 01/06/2008, 11:01 AM

yes I it before, it is pretty simple 1st you set up a dedicated e-mail address that will receive these requests - then using a component like Jmail you get the the pop e-mail queue.

I assume you have master & detail table for tickets?

start cycling through the e-mail as you retrieve it

now you have to do 2 things - (just keep reading here even if you don't get it at 1st) in the body see if the e-mail contains your unique identifier, we create a 32/36 char GUID contained in {} - if it exists you know it is a reply on an existing ticket - use the GUID to id the entry, and add it to your table

if it doesn't have the GUID - create a new GUID, make the entry in table, a nice way is to e-mail the client at this stage with a letter of receipt where you include the GUID

the last stage is to do an after insert event when the support guys answer the ticket - where you send a alert to the client with the response and the GUID - this way they can reply to the e-mail and it will get logged into THAT ticket thread

ok - i just realized I'm not typing fit anymore ;-)

anyway shout if you don't understand - sometime my brain & typing don't really match up


ps just one thing you'll need something to activate the asp that gets the mail - but there is ways and ways to get it done


View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.