This shows you the differences between two versions of the page.
email_campaigns [2013/09/10 04:56] admin [Creating an Email Marketing Campaign] |
email_campaigns [2013/09/19 16:18] (current) admin [Managing the Scheduler] |
||
---|---|---|---|
Line 189: | Line 189: | ||
=====Managing the Scheduler===== | =====Managing the Scheduler===== | ||
+ | ====The Normal Way==== | ||
- Log in as Administrator and click on the **Admin** link at the top right of the page. | - Log in as Administrator and click on the **Admin** link at the top right of the page. | ||
- Scroll down to the "System" section and click **Scheduler**. | - Scroll down to the "System" section and click **Scheduler**. | ||
Line 196: | Line 197: | ||
- Use standard crontab notation for basic setup, or click the **Show Basic Options** link next to "Interval" to get a more user-friendly option selection. | - Use standard crontab notation for basic setup, or click the **Show Basic Options** link next to "Interval" to get a more user-friendly option selection. | ||
- Click **Save** when finished. | - Click **Save** when finished. | ||
+ | - SugarCRM does not actually create a cron job, it must be created on the server manually. Log onto the CRM server as root and edit **/etc/crontab**. Add an entry identical to the cron settings in the Scheduler Settings page in Sugar. Enter: <code>0 * * * * www-data php5 /var/www/sugarcrm/cron.php</code> assuming that: you want it to run every hour on the hour, every day of the week, as the user www-data, using the php5 interpreter, and the cron script is located in /var/www/sugarcrm/. These are a lot of assumptions; adjust them as needed. | ||
+ | - SugarCRM is finicky when it comes to the Scheduler. The settings in the Scheduler Settings page must match the crontab entry. Sometimes emails simply don't get sent, and it takes a log time to troubleshoot schedule problems. There is a better way. | ||
+ | |||
+ | ====The Better Way==== | ||
+ | |||
+ | - Download the script **send_from_email_queue.py** from the SVN server at http://10.253.1.48/svn/SUGARCRM_AutoFormFill/ | ||
+ | - Place the script somewhere on the SugarCRM server. I placed it in the root of the CRM directory. | ||
+ | - Put an entry in **/etc/crontab** similar to:<code>0 * * * * root python /path/to/send_from_email_queue.py</code> This is useful because it forces Sugar to send a batch of emails and ignores Sugar's schedule. More notes are located inside the script. | ||
+ | - The size of the email batch is configured in Sugar under **Admin > Campaign Email Settings**. | ||
+ | |||
+ |