| Author |
 Topic Search  Topic Options
|
Misty 
Senior Member
Joined: 06 February 2002
Location: United States
Status: Offline
Points: 711
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Feeding a Web Site via Emails
Posted: 23 June 2003 at 8:37pm |
I have a potential client who is interested in feeding a web site via emails. For example, when the person sends an email to list@anywhere.com, it posts the email to the web site as dated content. The web site itself would just be a series
I have never done this before. Can anyone tell me how this might be accomplished?
|
 |
the boss
Senior Member
Joined: 19 January 2003
Location: Saudi Arabia
Status: Offline
Points: 1727
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 June 2003 at 9:00pm |
u need some component like JMAil to read the POP3 mailbox and detect new mails. and then read the required details from the mail like date, subject, body, etc etc etc and insert them in the SQL database,.. download the jmail manual and developer guide from www.dimac.net and u will undertstand how this can be done..
u can also use ASP POP3
also the asp page coded to read the mail and insert in the database should run on a routine..
there r some pop3 software which can directly insert the mail in the SQL database
|
|
Misty
Senior Member
Joined: 06 February 2002
Location: United States
Status: Offline
Points: 711
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 June 2003 at 11:02am |
|
Has anyone ever done this before? Does anyone know of any example codes that might help?
|
|
the boss
Senior Member
Joined: 19 January 2003
Location: Saudi Arabia
Status: Offline
Points: 1727
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 June 2003 at 7:07pm |
www.dimac.net
They got examples and reference for jmail..
www.jmailbox.org
there is a complete POP3 mail client built in ASP using Jmail and it is available for download free of cost..
http://www.serverobjects.com/products.htm#AspPop3
ASP POP3 from Server objects..
doin this with ASP POP3 is much easier and asp pop3 cost less than jmail..
Edited by the boss
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 June 2003 at 9:42pm |
|
this is still not dynamic as you would have to run the asp page at all times. There are some options that have a mail handler integrated with a database system. There are ways with Exchange Server and SQL but I do not know if this is something you can do with your isp
|
|
|
|
the boss
Senior Member
Joined: 19 January 2003
Location: Saudi Arabia
Status: Offline
Points: 1727
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 June 2003 at 11:53pm |
ms exchange integrated with sql servet is not an always or easy available option.. it as well cost a lot to.. a company might be providing hosting solution and would be running exchange server as well sql server but when it comes to integrating both.. it becomes expensive..
doin this in asp would be much cheaper provided that u run the asp file containg the code on regular time bases like ever 10 min or so.. if u hostin agrees to set the system sheduler to run that asp file after ever certain time interval.. that would be great..
and i guess there r some ways in making a WSH application which would execute a webpage / app after countinusly after a certain time interval but WSH files r required to be registered on a server just like dll files..
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 June 2003 at 3:23am |
|
Assuming that you are using SQL Server it is not necessary for the script to be on the web server. You could create a VBscript file and run it on any machine with Internet access and the POP3 component. You could then schedule the file to run without needing to schedule it on the web server. My suggestion would be to use a reliable machine (or several machines) to insure the update happens.
Additionally, you could have the an ASP page on the server start the process. Assuming you get regular traffic to the home page of the web site you could have it set off the process every 10 minutes. This would mean there would be less updates during the web sites lower periods, but there are also likely to be less email updates during that time as well. Also, if no one is veiwing the site, is there really a need to do the update?
|
|
|
|
the boss
Senior Member
Joined: 19 January 2003
Location: Saudi Arabia
Status: Offline
Points: 1727
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 June 2003 at 6:04am |
updates r REALLY necessay in any condition so search engines may discover it and bring some unique traffic.. and yes ljamal is is right that the ASP page can be sheduled to run from ur local machine or u can upload the page to hosting and still shedule ur local computer to run it..thats like more viable option as it will keep the site safe from hackers threat and reduce ur webserver load as well save bandwidth too..
|
|
