User Tools

Site Tools


email_campaigns

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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**.
 +
 +
email_campaigns.txt ยท Last modified: 2013/09/19 16:18 by admin