Bill Brine 0 Posted September 17, 2013 Report Share Posted September 17, 2013 I'm writing a bot to create a table from emails sent to particular accounts and then process them. Access is through IMAP so I can delete the retrieved emails. For one particular email account, there is no email body in either column 4 or column 5 of the created table, which is where they usually end up. Yet if I manually login to the email account, there are indeed email bodies, everything looks normal. This is a standard Cpanel account, the same as all the others I have used in other bots. Has anyone run into this and have any ideas? Quote Link to post Share on other sites
robchroma 0 Posted September 17, 2013 Report Share Posted September 17, 2013 I'm writing a bot to create a table from emails sent to particular accounts and then process them. Access is through IMAP so I can delete the retrieved emails. For one particular email account, there is no email body in either column 4 or column 5 of the created table, which is where they usually end up. Yet if I manually login to the email account, there are indeed email bodies, everything looks normal. This is a standard Cpanel account, the same as all the others I have used in other bots. Has anyone run into this and have any ideas? Look for special characters in the body of the emails, make sure you are sanitizing your database input before insersion. characters that can cause problems: ' " & Quote Link to post Share on other sites
Bill Brine 0 Posted September 18, 2013 Author Report Share Posted September 18, 2013 Thanks, but I'm not doing any database insertion. I use the Create Table From Emails function within the Connect To Mail Server section. I agree that these characters would cause problems if I were inserting data into a MySQL database. As I said, the bot works correctly for other sources of email, just this one source is doing something to their emails that so far eludes me. I've examined the source code of the emails manually and don't see anything obvious. Next I'm going to try processing the emails one at a time and use the Email Body Text and Email Body HTML functions to see if that acts any differently. Quote Link to post Share on other sites
LoWrIdErTJ - BotGuru 904 Posted September 18, 2013 Report Share Posted September 18, 2013 is this just with gmails?or other services as well?I recently started having this issue with gmail accounts as well. Quote Link to post Share on other sites
Bill Brine 0 Posted September 19, 2013 Author Report Share Posted September 19, 2013 No its with a Cpanel email account. It only occurs for email from one particular source. Haven't seen it with Gmail accounts yet. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.