SugarCRM (Automatic Retrieval of Emails)

Another issue encountered about the efficiency of the standard CRM application. Users has to check for any new emails manually. Any email client should do it automatically, however Sugar CE didn't. I updated the latest patch and currently using 5.2.0K version. I researched for this problem and found a tweak for the cron job for php files. The instructions on several different tech forums were not very clear therefore I am mentioning exactly what I did: -

In Windows: -

Initially set-up a batch file and add that batch file to the windows scheduler.

1. To create a batch file in Windows, open notepad.exe, copy & paste the what Sugar tells you to into a blank file. here is what - just copy and paste this php code: -

cd C:\Program Files\sugarcrm-5.2.0k\htdocs\sugarcrm\

"C:\Program Files\sugarcrm-5.2.0k\php\php-cgi.exe" -c "C:\Program Files\sugarcrm-5.2.0k\php\php.ini" -f "C:\Program Files\sugarcrm-5.2.0k\htdocs\sugarcrm\cron.php"

Now save this notepad as crmcron.bat and When saving, and this is VERY important, change the Save As Type: dropdown to All Files *.*. Give it any name you want, but make sure the extension is .bat. Test it by double-clicking the batch and making sure you pull down some emails from your inbox.

Now go to the Scheduler screen through Admin -> Schedulers. At the bottom of the default screen, you will see the contents of the commands you need to add to a batch file. Just add the created crmcron.bat file to this schedule and schedule it to run every minute daily for 24 hours from midnight (this is very important). And bingo, the CRM application started checking for newly arrived emails automatically.