Author |
|
theowl Groupie
Joined: February 24 2006 Location: United States
Online Status: Offline Posts: 59
|
Posted: February 06 2008 at 00:19 | IP Logged
|
|
|
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 |
|
|
onhiatus Senior Member
Joined: May 12 2004 Location: United States
Online Status: Offline Posts: 279
|
Posted: February 07 2008 at 13:09 | IP Logged
|
|
|
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 |
|
|
Gadgets Senior Member
Joined: January 28 2008 Location: Canada
Online Status: Offline Posts: 178
|
Posted: February 07 2008 at 22:23 | IP Logged
|
|
|
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 |
|
|
BeachBum Super User
Joined: April 11 2007 Location: United States
Online Status: Offline Posts: 1880
|
Posted: March 03 2008 at 13:35 | IP Logged
|
|
|
I’m getting an “Unhandled Exception” using Tony’s POP3 Powerhome Bridge”. Anyone seen this?
__________________ Pete - X10 Oldie
|
Back to Top |
|
|
onhiatus Senior Member
Joined: May 12 2004 Location: United States
Online Status: Offline Posts: 279
|
Posted: March 03 2008 at 18:18 | IP Logged
|
|
|
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 |
|
|
BeachBum Super User
Joined: April 11 2007 Location: United States
Online Status: Offline Posts: 1880
|
Posted: March 03 2008 at 18:30 | IP Logged
|
|
|
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 |
|
|
onhiatus Senior Member
Joined: May 12 2004 Location: United States
Online Status: Offline Posts: 279
|
Posted: March 04 2008 at 14:18 | IP Logged
|
|
|
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 |
|
|
BeachBum Super User
Joined: April 11 2007 Location: United States
Online Status: Offline Posts: 1880
|
Posted: March 04 2008 at 14:33 | IP Logged
|
|
|
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 |
|
|
BeachBum Super User
Joined: April 11 2007 Location: United States
Online Status: Offline Posts: 1880
|
Posted: March 05 2008 at 13:52 | IP Logged
|
|
|
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 |
|
|
onhiatus Senior Member
Joined: May 12 2004 Location: United States
Online Status: Offline Posts: 279
|
Posted: March 05 2008 at 14:29 | IP Logged
|
|
|
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 |
|
|
BeachBum Super User
Joined: April 11 2007 Location: United States
Online Status: Offline Posts: 1880
|
Posted: March 05 2008 at 14:54 | IP Logged
|
|
|
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 |
|
|
Gadgets Senior Member
Joined: January 28 2008 Location: Canada
Online Status: Offline Posts: 178
|
Posted: March 05 2008 at 15:45 | IP Logged
|
|
|
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 |
|
|
BeachBum Super User
Joined: April 11 2007 Location: United States
Online Status: Offline Posts: 1880
|
Posted: March 05 2008 at 16:33 | IP Logged
|
|
|
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 |
|
|
mustangcoupe Super User
Joined: August 08 2003 Location: United States
Online Status: Offline Posts: 308
|
Posted: April 29 2008 at 22:42 | IP Logged
|
|
|
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 |
|
|
onhiatus Senior Member
Joined: May 12 2004 Location: United States
Online Status: Offline Posts: 279
|
Posted: April 30 2008 at 14:26 | IP Logged
|
|
|
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 |
|
|
mustangcoupe Super User
Joined: August 08 2003 Location: United States
Online Status: Offline Posts: 308
|
Posted: May 02 2008 at 17:42 | IP Logged
|
|
|
Thanks, cant wait to see the your parsing method.
__________________ Todd Hannemann
HA newbie
PowerHome - UPB - ELK
|
Back to Top |
|
|
onhiatus Senior Member
Joined: May 12 2004 Location: United States
Online Status: Offline Posts: 279
|
Posted: May 10 2008 at 18:49 | IP Logged
|
|
|
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 |
|
|