automatically import emails

[riprod]

I setup the mail using IMAP and can read and import the individual mails.

Is there a way that the system can automatically pickup emails from a certain email address and apply it to the account or contact or do I have to do it manually with every mail ?

thanks

[roblaus]

Not in the CE version. With Pro/Ent you may create a workflow.
But register a feature request - it's indeed not clear why certain "trusted" senders shouldn't be assigned automatically

[riprod]

I saw this blog about automatically importing email :
http://developers.sugarcrm.com/wordp...mail-in-sugar/

It says to create a group account, which I did. I then assigned it to a group folder, which shows up in the email box.

But when I click on it, there is no mail in it.
Is this because it does not work on the CE edition ?

It also mentions something about adding a line of code to crontab. But I have no idea what that is or where to find it. What is crontab ? How do I edit it.

Can anyone let me know why no mail is showing up in the group box ? thanks

[roblaus]

two questions asked, one I answered above (no auto assignment). The other is more complicated because there are certain requirements:

1. Your group email account must be configured correctly (ssl if necessary, correct ports)
2. You must set up the scheduler in order to check for mail in certain intervals (make sure you have some entries under execution once you set it up)
3. You must set up a crontab (the line at the bottom of the scheduler) to tell the server that it should pick up the mails from wherever (assuming you use an ix system). If you use a Windows server - pls. check somewhere else here.

Even if all three components are set up correctly your mail won't show under the group folder but under "My Emails".

It's friggin complicated and not logical at all but that's what it is.

[riprod]

Thanks for the info but I think I found some solutions that do work.

If I setup a group account and make it POP (does not seam to work with IMAP!). Then assign a group folder.
The mail does show up in the group folder and it does automatically assign it to the correct account based on the email address.
So Auto Assignment does appear to work in the CE version.

So far so good...

However my last problem is that the scheduler is not working to check mail automatically. I need to browse to the cron.php file for it to check mail.

Sugar is running on Mac OS X server and I have added the line to crontab. If I go to terminal and type crontab -l, it does show the new line of code but it obviously not running. Anyone know how to check on the server to see that crontab is running correctly ?

I think that maybe the path in the line of code (* * * * * cd /Library/WebServer/Documents/sugar; php -f cron.php > /dev/null 2>&1) is incorrect on the mac ?? Any ideas ?

[roblaus]

Interesting, auto-assignment is new to me, never worked here. Will test.
[edit] it does work. My mistake. My group accounts are used for auto answer and bounce handling and then it does not as it seems.
Re. cron job: might be that the php command needs a path, happens sometimes. The path to Sugar is easy to check but most probably correct if you didn't move the Sugar folder.

[riprod]

ok, I seam to have got it to work. Basically I changed the crontab to :

* * * * * curl http://localhost:8080/sugarsrm/cron.php

I'm not sure if that is right but it works and is now checking and assigning emails fully automated.

[riprod]

I must have done something wrong. It has now imported 128000 emails which is completely wrong. I don't have more than 1000 mails in there. I think it is importing the entire batch every time. Actually I don't have a clue what it is doing....

Any idea ?