first time trying to use Campaign email

[robert.]

Hello

I have been mulling this over for a few days and it seems like i am struggling too much. I have prowled the forums and no luck.

So i am doing the campaign email. Got my email setup and it tested out and sent a message. Then I setup the email time thingy to go out at some specified time, and I click on the "launch wizard" which is cool I guess some wizard is going to help me, Which leads me though to the send email and summary list and pages. And I hit the Schedule Email button and well nothing really ever happens.

is there a way to just send out the email to my small list of 30 people or is that just a little too much to ask?

Where do these emails that don't get sent go to when i click on the Schedule Email button?

If I were to try to figure out why my test email to my self will work but this group target list wont work where would i get started?

I have enjoyed the Sugar University and these forums but I guess I am just not quite getting it...

Any one got any tips on how to get this wizzard to blow his horn or to off him and replace him with something else...?

best regards

[crmsiva]

you can find your Emails queued in Admin->Email->Manage Email Queue. Click on the "Send Queued Campaign Emails" button to send the queued emails.

[sugarcane]

Hi Robert,

there are a few components necessary to make a campaign work:

1) In the email marketing subpanel of your campaign, there is a fields called 'Start Date & Time'. This start date and time determines when you want your campaign emails to send out. If you want your emails to go out right away, you can back date this field. If you want it to send out Friday at 1:00 PM, you can set it to that date and time.

2) Status: the status field in the Email Marketing subpanel must be set at active

3) Send Emails: When you have finished setting up your campaign, you must click the 'Send Emails' button. This sends all the emails into the Email Queue area (this can be viewed in the admin area). The emails sit here until the Start date and time from #1 passes AND

4)Scheduler: the date and time the emails are sent out are based on the date and time in #1 and how often the scheduler job runs. You must set up the cron job on your server for the scheduler to be able to run. Once this is done, you can modify the frequency of when the Campaign scheduler runs: Run Nightly Mass Email Campaigns. The system default for this item is On the hour; From 02:00 to 06:00. What this means is that, even if your start date and time from #1 is set for today at 3:00PM, the emails will still sit in the queue until 2:00 AM this morning. Make sense? You can change the default to expand the time period, or set it to 'As often as possible' -- if you do this, then the emails will go out at the time set in #1.

Siva is correct, if you see the emails in the email queue, you can also force them out right away by clicking the 'Send Queued Campaign Emails' button

[Kahler]

Please contact me for further details. bill.kahlert@inbox25.com- 888-898-7135 x.249. We're a boutique ESP (email service provider) and we are the only firm that has done this integration. Our integration allows you to maximize your use of Sugar and especially the email marketing piece. Our website will be live by Wednesday, please excuse our placeholder. Thanks!

[portlandportals]

"Siva is correct, if you see the emails in the email queue, you can also force them out right away by clicking the 'Send Queued Campaign Emails' button "

Si if I tried this and the queued emails (test by the way) are still sitting in my queue what else is wrong with the campaign emails?

Here is a snippet from the log set to debug but I really can not make any sense of it...

Sun Apr 19 11:39:02 2009 [26081][1][DEBUG] ----->Schedulers->deriveDBDateTimes() got an object of type: schedulers
Sun Apr 19 11:39:02 2009 [26081][1][DEBUG] ----->got * day
Sun Apr 19 11:39:02 2009 [26081][1][DEBUG] ----->got * months
Sun Apr 19 11:39:02 2009 [26081][1][DEBUG] ----->got * dates
Sun Apr 19 11:39:02 2009 [26081][1][DEBUG] ----->got * hours
Sun Apr 19 11:39:02 2009 [26081][1][DEBUG] ----->Scheduler did NOT find valid job (Run Nightly Mass Email Campaigns) for time GMT(2009-04-19 18:39)
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query Execution Time:0.00016593933105469
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query:SELECT category, name, value FROM config
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query Execution Time:0.00011920928955078
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query Execution Time:6.6041946411133E-5
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = 'b21325a2-35f7-4307-4885-497d6df3a231'
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query Execution Time:8.5830688476562E-5
Sun Apr 19 11:40:01 2009 [26142][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0
Sun Apr 19 11:40:01 2009 [26142][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1
Sun Apr 19 11:40:01 2009 [26142][-none-][INFO] Query Execution Time:0.00017714500427246
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] Loading Preferences DB admin
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT contents FROM user_preferences WHERE assigned_user_id='1' AND category = 'global' AND deleted = 0
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:6.2942504882812E-5
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:6.6995620727539E-5
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] additional detail query results:
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] SugarBean.load_relationships, Loading relationship (reports_to_id).
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT ea.*, ear.* FROM email_addresses ea
LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:7.8916549682617E-5
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] --------------------------------------------> at cron.php <--------------------------------------------
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] rebuilding cache for Schedulers
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] rebuilding cache for Schedulers
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='Schedulers' AND deleted = 0
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:0.00016999244689941
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:0.00018692016601562
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:5.8889389038086E-5
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] additional detail query results:
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] SugarBean.load_relationships, Loading relationship (reports_to_id).
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT ea.*, ear.* FROM email_addresses ea
LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:7.8916549682617E-5
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] -----> Scheduler flushing dead jobs
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query: SELECT s.id, s.name FROM schedulers s WHERE s.deleted=0 AND s.status = 'In Progress'
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:0.0003809928894043
Sun Apr 19 11:40:01 2009 [26142][1][INFO] QueryELETE FROM schedulers_times WHERE date_entered < DATE_FORMAT('2009-04-18 18:40:01', '%Y-%m-%d %H:%i:%s')
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:0.0030100345611572
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] get_full_list: order_by = '' and where = 'status='Active''
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] process_full_list_query: query is SELECT schedulers.* FROM schedulers WHERE (status='Active') AND DELETED=0
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT schedulers.* FROM schedulers WHERE (status='Active') AND DELETED=0
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:0.00041484832763672
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] process_full_list_query: result is mysqli_result Object
(
)

Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] rebuilding cache for Schedulers
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='Schedulers' AND deleted = 0
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:8.5115432739258E-5
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0
Sun Apr 19 11:40:01 2009 [26142][1][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query Execution Time:0.00012302398681641
Sun Apr 19 11:40:01 2009 [26142][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0

[portlandportals]

fixed, turns out a developer had put in debug statements in an earlier project that were impeding the send.