Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome Programming
 PowerHome Messageboard : PowerHome Programming
Subject Topic: Tool to interface with POP3 accounts Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
theowl
Groupie
Groupie
Avatar

Joined: February 24 2006
Location: United States
Online Status: Offline
Posts: 59
Posted: February 06 2008 at 00:19 | IP Logged Quote theowl

I agree Gadget! There are too many issues with OE and virus creators also know how to exploit it way too easy. I've found an alternative and a plausable solution to my e-mail plug-in delema (after several hours of searching the net).

Listing solution as it's own topic: here
Back to Top View theowl's Profile Search for other posts by theowl
 
onhiatus
Senior Member
Senior Member
Avatar

Joined: May 12 2004
Location: United States
Online Status: Offline
Posts: 279
Posted: February 07 2008 at 13:09 | IP Logged Quote onhiatus

OE was why I wrote this tool to start with. I won't go so far as to say I hate it, but I didn't see a reason to have to run it. I also had issues with it hanging.

I didn't think of installing a different email client, but overall I still don't see the point when I can just dump the email to a file and use the file change plugin.

Thanks for sharing, Tony (onhiatus)
Back to Top View onhiatus's Profile Search for other posts by onhiatus Visit onhiatus's Homepage
 
Gadgets
Senior Member
Senior Member
Avatar

Joined: January 28 2008
Location: Canada
Online Status: Offline
Posts: 178
Posted: February 07 2008 at 22:23 | IP Logged Quote Gadgets

onhiatus wrote:
OE was why I wrote this tool to start with. I won't go so far as to say I hate it, but I didn't see a reason to have to run it. I also had issues with it hanging.

I didn't think of installing a different email client, but overall I still don't see the point when I can just dump the email to a file and use the file change plugin.

Thanks for sharing, Tony (onhiatus)


I'm with you Tony, my problem at this point for me is figuring out how to get your's to work, remembering I'm just excited to now have things I'm trying to work.. actually WORK after my rocky start. I looked at yours, I read your posts etc, but I just don't think I'd get it to work at this point... that said, I DO like the plain english commands instead of remembering forumlas to send. Down the road... I will probably take a shot at your method though.

__________________
Friends, don't let friends install Norton Products
Back to Top View Gadgets's Profile Search for other posts by Gadgets Visit Gadgets's Homepage
 
BeachBum
Super User
Super User
Avatar

Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
Posted: March 03 2008 at 13:35 | IP Logged Quote BeachBum

I’m getting an “Unhandled Exception” using Tony’s POP3 Powerhome Bridge”. Anyone seen this?



__________________
Pete - X10 Oldie
Back to Top View BeachBum's Profile Search for other posts by BeachBum
 
onhiatus
Senior Member
Senior Member
Avatar

Joined: May 12 2004
Location: United States
Online Status: Offline
Posts: 279
Posted: March 03 2008 at 18:18 | IP Logged Quote onhiatus

Hmm, I have not seem that. It looks like some com object is not resolving correctly (the app is getting the wrong one). Off the top of my head the only thing I can think of is the .Net installation is there a chance that you have a later version of .Net, like 3.0, and not 2.0? That might give you the above error (wheras if you only had 1.0 or none installed it would tell you you need .Net)

My Pop3 PH Bridge requires .Net 2.0

I'm doubtful that this is the problem, but it's the only thing I can think of.

A few questions:
- Has it ever worked?
- If so, what has changed?

Thanks, Tony
Back to Top View onhiatus's Profile Search for other posts by onhiatus Visit onhiatus's Homepage
 
BeachBum
Super User
Super User
Avatar

Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
Posted: March 03 2008 at 18:30 | IP Logged Quote BeachBum

Tony,

It normally works fine but once in awhile certain E-mails will trigger this. I thought it might be .NET 2.0 problems so I downloaded the 2.0 with SP1 and intermittently still have the same problem. Next time I’ll try and capture the full details for you.


__________________
Pete - X10 Oldie
Back to Top View BeachBum's Profile Search for other posts by BeachBum
 
onhiatus
Senior Member
Senior Member
Avatar

Joined: May 12 2004
Location: United States
Online Status: Offline
Posts: 279
Posted: March 04 2008 at 14:18 | IP Logged Quote onhiatus

Hmm, I'll be curious to see what the common denominator is for the problem emails.

I could probably wrap all the code to catch unhandled exceptions, but my fear is that would just cause it to keep trying to retrieve the bad email...

Thanks, Tony
Back to Top View onhiatus's Profile Search for other posts by onhiatus Visit onhiatus's Homepage
 
BeachBum
Super User
Super User
Avatar

Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
Posted: March 04 2008 at 14:33 | IP Logged Quote BeachBum

Interesting failure. Last night another failure occurred and all the info was the same but it blamed .NET Framework. It shows loading email but doesn’t finish. Just hangs… I’ll update when I have better info.

__________________
Pete - X10 Oldie
Back to Top View BeachBum's Profile Search for other posts by BeachBum
 
BeachBum
Super User
Super User
Avatar

Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
Posted: March 05 2008 at 13:52 | IP Logged Quote BeachBum

Tony, had another failure. When it occurred it happened on both of my systems at the same time. The systems are similar in software only.

Sometimes it just hangs but this time it threw this error

This is the start raw data on the pop3 server. None of this was written to the file but the file was created.




Good Luck.....

Edited by BeachBum - March 05 2008 at 14:53


__________________
Pete - X10 Oldie
Back to Top View BeachBum's Profile Search for other posts by BeachBum
 
onhiatus
Senior Member
Senior Member
Avatar

Joined: May 12 2004
Location: United States
Online Status: Offline
Posts: 279
Posted: March 05 2008 at 14:29 | IP Logged Quote onhiatus

Weird. I've tried to duplicate the above email and had no trouble reading it.

The problem email isn't 10GB long is it?

I have a dedicated email that doesn't get any spam since it's never used to send or post - just recieves email from me or my wife at work, home, or via SMS. So there are only 6 possible email sources (ok, a few more given that we use a few different clients). The point being that I never have to deal with poorly formated spam - so I don't see this at home.
Back to Top View onhiatus's Profile Search for other posts by onhiatus Visit onhiatus's Homepage
 
BeachBum
Super User
Super User
Avatar

Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
Posted: March 05 2008 at 14:54 | IP Logged Quote BeachBum

BTW, Thks Tony

That’s a good point being that most of the hangs are with SPAM type mail. I captured the E-mail and forward to myself but it would not fail. Probably because of the header. The whole thing is 95KB and is totally HTML.

__________________
Pete - X10 Oldie
Back to Top View BeachBum's Profile Search for other posts by BeachBum
 
Gadgets
Senior Member
Senior Member
Avatar

Joined: January 28 2008
Location: Canada
Online Status: Offline
Posts: 178
Posted: March 05 2008 at 15:45 | IP Logged Quote Gadgets

I bet it has something to do with the crap in those x10 emails. I always used Eudora until recently and had it set not to display any html or graphics. I rarely had errors similar to these unlike my friends who didn't disable that stuff.

__________________
Friends, don't let friends install Norton Products
Back to Top View Gadgets's Profile Search for other posts by Gadgets Visit Gadgets's Homepage
 
BeachBum
Super User
Super User
Avatar

Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
Posted: March 05 2008 at 16:33 | IP Logged Quote BeachBum

It has occurred with spam and regular email. I have not found a pattern YET. I don’t give up easily.

__________________
Pete - X10 Oldie
Back to Top View BeachBum's Profile Search for other posts by BeachBum
 
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: April 29 2008 at 22:42 | IP Logged Quote mustangcoupe

Tony,

Can you pass on your macros for processing these files... I am just starting to use the bridge and would like to get a sample of how your process the email and figure out what to do next, baised on your command set, and how you send an email back ect...

__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
onhiatus
Senior Member
Senior Member
Avatar

Joined: May 12 2004
Location: United States
Online Status: Offline
Posts: 279
Posted: April 30 2008 at 14:26 | IP Logged Quote onhiatus

Sure. I'll try to remember to look them up when I get home.

Basically I cheat on the parsing. I look for complete strings in the email ("heat on" , "heat off", "livingroom on", etc) and run a command based on what I find. This means that order is not relevant. For example, the email "heat off heat on" being checked in the above order would result in the "heat on" action being run, then the "heat off" action being run. Regardless of what is run I then send back a status email showing what the current state is - so sending a blank or bogus email will cause a status email to be sent back.

It's all very simple, as I've never had reason to make it more complicated. Like I said I'll try to remember to post the actuall scripts later tonight.

Tony
Back to Top View onhiatus's Profile Search for other posts by onhiatus Visit onhiatus's Homepage
 
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: May 02 2008 at 17:42 | IP Logged Quote mustangcoupe

Thanks, cant wait to see the your parsing method.

__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
onhiatus
Senior Member
Senior Member
Avatar

Joined: May 12 2004
Location: United States
Online Status: Offline
Posts: 279
Posted: May 10 2008 at 18:49 | IP Logged Quote onhiatus

I was hoping to get a chance to clean this up, but it never seems to happen, so here are the macros I use.

The MAIL PROCESS macro processes the incoming mail. The mail is saved to a known file location and this macro is triggered by Dave's file change plugin. The mail index file is expected to be "C:\Program Files\powerhome\Custom\outputIndex.txt" and I don't believe any global variables are used.

The MAIL PROCESS macro:
2008-05-10_183136_Mail_Process.sql.txt

After loading each mail file it calls the "MAIL COMMANDS" macro to parse the email and run the commands. The MAIL COMMANDS uses the local variables passed into the marco call. It also uses one globale variable, {G_EMAILS}, which contains a list of email addresses that the macro will accept commands from (example: ,me@mywork.com,me@gmail.com,wife@work.com,2065551212@tmomail .net,2065551313@tmomail.net,stacy@onhiatus.com,stacy.maenner @gmail.com,Stacy.Maenner@noaa.gov,2062353124@tmomail.net,

Here's the MAIL COMMANDS macro that "parses" the email and sends back a status:
2008-05-10_183947_Mail_Commands.sql.txt

After the MAIL COMMANDS macro is done looking for command strings in the mail it calls the MAIL SEND STATUS macro to send a status mail back to the sender.

Here's the MAIL SEND STATUS macro:
2008-05-10_184117_Mail_Send_Status.sql.txt

Sorry I don't have much time to walk through the code. It's really not that difficult, so good luck! If you have questions ask, and I will try to get back to you quickly.

Thanks, Tony
Back to Top View onhiatus's Profile Search for other posts by onhiatus Visit onhiatus's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

<< Prev Page of 2
  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum