We have a requirement as below, we send clients few notifications via an email lets info@example.com, if client doesnt respond to any of the notifications we send within 21 days… we send an email again to client saying that the client is unresponsive.
Inorder to know if the client has replied or not , we will need to read the emails send to that mail ie info@example.com, we already configured this info@example.com as a personal email at crm.
I have checked all the tables in suitecrm database , such as emails , emails_text, emails_cache etc, I dont find these details are storing anywhere.
Can anyone here guide me on how to read the inbound emails sent to an personal email configured in crm.
That kind of automatism is normally done with so-called “group” accounts (Admin / Inbound Email settings).
The emails don’t exist in SuiteCRM database until they are imported - even if you see them on screen, they might be only stored on your email server. After import, they are also in SuiteCRM database.
Also @pgr, I have enabled debug mode of log, here’s the udpated log
Tue Apr 7 21:41:39 2020 [32532][134d3b99-816a-8d8a-19da-5b29c47653af][FATAL] Inbound Email Connection is not valid resource for getting New Message Ids.
Tue Apr 7 21:41:39 2020 [32532][134d3b99-816a-8d8a-19da-5b29c47653af][ERROR] ImapHandler trying to use a non valid resource stream.
Tue Apr 7 21:41:39 2020 [32532][134d3b99-816a-8d8a-19da-5b29c47653af][WARN] An Imap error detected: “IMAP expunge error”
Tue Apr 7 21:41:39 2020 [32532][134d3b99-816a-8d8a-19da-5b29c47653af][ERROR] ImapHandler trying to use a non valid resource stream.
Tue Apr 7 21:41:39 2020 [32532][134d3b99-816a-8d8a-19da-5b29c47653af][WARN] An Imap error detected: “IMAP close error”
Tue Apr 7 21:41:39 2020 [32532][134d3b99-816a-8d8a-19da-5b29c47653af][DEBUG] Using system default ImapHandler. Hint: Use any ImapHandlerInterface as dependency of InboundEmail
Tue Apr 7 21:41:39 2020 [32532][134d3b99-816a-8d8a-19da-5b29c47653af][DEBUG] ImapHandlerFactory will using a ImapHandler
Sorry, it’s hard to help without using Office365 myself.
I think al those errors probably boil down to an inability to login to the account in the first place. Then other errors appear, but it’s only because the account is not accessible (this is just a guess).
If you uncomment these lines in the code, you will get additional information in the logs, which I think will be quite helpful for your case:
This will put some more information in your logs to help yo troubleshoot.
I have enabled the log, and I have observed few things .
Does import functionality works only if the email is sent via Emails module ? Where I mean if the email is sent using outlook shouldnt it be part of crm as well (ie when enabled auto import functionality for the group emails)?
Could you please clarify? why because i tried to reply to an email from Emails module and it automatically got imported to CRM, but not other emails which are not replied using Emails module (ie replied from outlook).
I m unable to understand this emails importing functionality after many tests made, Kindly find the screenshot below. It imports few emails and it doesnt import few emails .
Not sure how to track this. sending email from same email id , imports sometimes and doesnt sometimes.
If it is behaving erracticly you need to try and figure out why, maybe from your logs you can get some more info.
Also if you have great amounts of data, or a slow server, check if it is the execution times that are breaking it. Your logs should have evidence of this. You can turn on log slow queries from Admin / system settings and track query times in the logs.
You can also run the first query in this post from phpMyAdmin and see if you have overgrown tables: