4 Mailing 14: First Mailing Events, 2011-05-25
6 contact cid bounce open click reply
10 test03 104 n n y[dc] n
14 test07 111 n y y[dc] n
15 test08 112 n y y[c2] y
17 Mailing 15: Second Test Mailing Events, 2011-05-26
19 contact cid bounce open click reply
22 test03 104 n n y[dc] n
29 <civicrm_contact id=
"102" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Test One" sort_name=
"One, Test" first_name=
"Test" last_name=
"One"/>
30 <civicrm_contact id=
"103" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Test Two" sort_name=
"Two, Test" first_name=
"Test" last_name=
"Two"/>
31 <civicrm_contact id=
"104" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Test Three" sort_name=
"Three, Test" first_name=
"Test" last_name=
"Three"/>
32 <civicrm_contact id=
"105" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Test Bouncy" sort_name=
"Bouncy, Test" first_name=
"Test" last_name=
"Bouncy"/>
33 <civicrm_contact id=
"108" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Test Four" sort_name=
"Four, Test" first_name=
"Test" last_name=
"Four"/>
34 <civicrm_contact id=
"109" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Test Five" sort_name=
"Five, Test" first_name=
"Test" last_name=
"Five"/>
35 <civicrm_contact id=
"110" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Test Six" sort_name=
"Six, Test" first_name=
"Test" last_name=
"Six"/>
36 <civicrm_contact id=
"111" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Test Seven" sort_name=
"Seven, Test" first_name=
"Test" last_name=
"Seven"/>
37 <civicrm_contact id=
"112" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Test Eight" sort_name=
"Eight, Test" first_name=
"Test" last_name=
"Eight"/>
38 <civicrm_contact id=
"113" contact_type=
"Individual" is_opt_out=
"0" display_name=
"Extra Neous" sort_name=
"Neous, Extra" first_name=
"Extra" last_name=
"Neous"/>
39 <civicrm_email id=
"93" contact_id=
"102" location_type_id=
"1" email=
"test01@civicrm.org" is_primary=
"1" is_billing=
"0" on_hold=
"0" is_bulkmail=
"0" signature_text=
"" signature_html=
""/>
40 <civicrm_email id=
"94" contact_id=
"103" location_type_id=
"1" email=
"test02@civicrm.org" is_primary=
"1" is_billing=
"0" on_hold=
"0" is_bulkmail=
"0" signature_text=
"" signature_html=
""/>
41 <civicrm_email id=
"95" contact_id=
"104" location_type_id=
"1" email=
"test03@civicrm.org" is_primary=
"1" is_billing=
"0" on_hold=
"0" is_bulkmail=
"0" signature_text=
"" signature_html=
""/>
42 <civicrm_email id=
"96" contact_id=
"105" location_type_id=
"1" email=
"bouncy@bouncy.civicrm.org" is_primary=
"1" is_billing=
"0" on_hold=
"0" is_bulkmail=
"0" hold_date=
"2011-05-25 13:06:57" reset_date=
"2011-05-26 13:00:43" signature_text=
"" signature_html=
""/>
43 <civicrm_email id=
"99" contact_id=
"108" location_type_id=
"1" email=
"test04@civicrm.org" is_primary=
"1" is_billing=
"0" on_hold=
"0" is_bulkmail=
"0" signature_text=
"" signature_html=
""/>
44 <civicrm_email id=
"100" contact_id=
"109" location_type_id=
"1" email=
"test05@civicrm.org" is_primary=
"1" is_billing=
"0" on_hold=
"0" is_bulkmail=
"0" signature_text=
"" signature_html=
""/>
45 <civicrm_email id=
"101" contact_id=
"110" location_type_id=
"1" email=
"test06@civicrm.org" is_primary=
"1" is_billing=
"0" on_hold=
"0" is_bulkmail=
"0" signature_text=
"" signature_html=
""/>
46 <civicrm_email id=
"102" contact_id=
"111" location_type_id=
"1" email=
"test07@civicrm.org" is_primary=
"1" is_billing=
"0" on_hold=
"0" is_bulkmail=
"0" signature_text=
"" signature_html=
""/>
47 <civicrm_email id=
"103" contact_id=
"112" location_type_id=
"1" email=
"test08@civicrm.org" is_primary=
"1" is_billing=
"0" on_hold=
"0" is_bulkmail=
"0" signature_text=
"" signature_html=
""/>
48 <civicrm_mailing id=
"14" domain_id=
"1" header_id=
"1" footer_id=
"2" reply_id=
"8" unsubscribe_id=
"5" resubscribe_id=
"6" optout_id=
"7" name=
"First Mailing Events" from_name=
"FIXME" from_email=
"info@cividev.yook.civicrm.org" replyto_email=
"info@cividev.yook.civicrm.org" subject=
"Hello {contact.display_name}" body_text=
"" body_html=
"<p> 	Hello {contact.display_name},</p> <p> 	You should check <a href="http://drupal.org">drupal.org</a> and <a href="http://civicrm.org">civicrm.org</a>.</p> " url_tracking=
"1" forward_replies=
"0" auto_responder=
"0" open_tracking=
"1" is_completed=
"1" override_verp=
"0" created_id=
"102" created_date=
"2011-05-26 13:03:50" scheduled_id=
"102" scheduled_date=
"2011-05-25 13:06:08" approver_id=
"102" approval_date=
"2011-05-25 13:06:08" approval_status_id=
"1" approval_note=
"" is_archived=
"0" visibility=
"User and User Admin Only" />
49 <civicrm_mailing id=
"15" domain_id=
"1" header_id=
"1" footer_id=
"2" reply_id=
"8" unsubscribe_id=
"5" resubscribe_id=
"6" optout_id=
"7" name=
"Second Test Mailing Events" from_name=
"FIXME" from_email=
"info@cividev.yook.civicrm.org" replyto_email=
"info@cividev.yook.civicrm.org" subject=
"Hello again, {contact.display_name}" body_text=
"" body_html=
"<p> 	Hello {contact.display_name},</p> <p> 	You should check <a href="http://drupal.org">drupal.org</a> and <a href="http://civicrm.org">civicrm.org</a>.</p> " url_tracking=
"1" forward_replies=
"0" auto_responder=
"0" open_tracking=
"1" is_completed=
"1" override_verp=
"0" created_id=
"102" created_date=
"2011-05-26 13:08:05" scheduled_id=
"102" scheduled_date=
"2011-05-26 13:08:46" approver_id=
"102" approval_date=
"2011-05-26 13:08:46" approval_status_id=
"1" approval_note=
"" is_archived=
"0" visibility=
"User and User Admin Only" />
50 <civicrm_mailing_recipients id=
"1" mailing_id=
"14" email_id=
"96" contact_id=
"105"/>
51 <civicrm_mailing_recipients id=
"2" mailing_id=
"14" email_id=
"93" contact_id=
"102"/>
52 <civicrm_mailing_recipients id=
"3" mailing_id=
"14" email_id=
"94" contact_id=
"103"/>
53 <civicrm_mailing_recipients id=
"4" mailing_id=
"14" email_id=
"95" contact_id=
"104"/>
54 <civicrm_mailing_recipients id=
"5" mailing_id=
"14" email_id=
"99" contact_id=
"108"/>
55 <civicrm_mailing_recipients id=
"6" mailing_id=
"14" email_id=
"100" contact_id=
"109"/>
56 <civicrm_mailing_recipients id=
"7" mailing_id=
"14" email_id=
"101" contact_id=
"110"/>
57 <civicrm_mailing_recipients id=
"8" mailing_id=
"14" email_id=
"102" contact_id=
"111"/>
58 <civicrm_mailing_recipients id=
"9" mailing_id=
"14" email_id=
"103" contact_id=
"112"/>
59 <civicrm_mailing_recipients id=
"10" mailing_id=
"15" email_id=
"93" contact_id=
"102"/>
60 <civicrm_mailing_recipients id=
"11" mailing_id=
"15" email_id=
"94" contact_id=
"103"/>
61 <civicrm_mailing_recipients id=
"12" mailing_id=
"15" email_id=
"95" contact_id=
"104"/>
62 <civicrm_mailing_recipients id=
"13" mailing_id=
"15" email_id=
"99" contact_id=
"108"/>
63 <civicrm_mailing_recipients id=
"14" mailing_id=
"15" email_id=
"100" contact_id=
"109"/>
64 <civicrm_mailing_recipients id=
"15" mailing_id=
"15" email_id=
"101" contact_id=
"110"/>
65 <civicrm_mailing_recipients id=
"16" mailing_id=
"15" email_id=
"102" contact_id=
"111"/>
66 <civicrm_mailing_recipients id=
"17" mailing_id=
"15" email_id=
"103" contact_id=
"112"/>
67 <civicrm_mailing_job id=
"23" mailing_id=
"14" scheduled_date=
"2011-05-25 13:06:08" start_date=
"2011-05-25 13:06:34" end_date=
"2011-05-25 13:06:35" status=
"Complete" is_test=
"0" job_type=
"" job_offset=
"0" job_limit=
"0"/>
68 <civicrm_mailing_job id=
"24" mailing_id=
"14" scheduled_date=
"2011-05-25 13:06:08" start_date=
"2011-05-25 13:06:34" end_date=
"2011-05-25 13:06:35" status=
"Complete" is_test=
"0" job_type=
"child" parent_id=
"23" job_offset=
"0" job_limit=
"9"/>
69 <civicrm_mailing_job id=
"25" mailing_id=
"15" scheduled_date=
"2011-05-26 13:08:46" start_date=
"2011-05-26 13:08:49" end_date=
"2011-05-26 13:08:51" status=
"Complete" is_test=
"0" job_type=
"" job_offset=
"0" job_limit=
"0"/>
70 <civicrm_mailing_job id=
"26" mailing_id=
"15" scheduled_date=
"2011-05-26 13:08:46" start_date=
"2011-05-26 13:08:49" end_date=
"2011-05-26 13:08:51" status=
"Complete" is_test=
"0" job_type=
"child" parent_id=
"25" job_offset=
"0" job_limit=
"8"/>
71 <civicrm_mailing_trackable_url id=
"12" url=
"http://drupal.org" mailing_id=
"14"/>
72 <civicrm_mailing_trackable_url id=
"13" url=
"http://civicrm.org" mailing_id=
"14"/>
73 <civicrm_mailing_trackable_url id=
"14" url=
"http://drupal.org" mailing_id=
"15"/>
74 <civicrm_mailing_trackable_url id=
"15" url=
"http://civicrm.org" mailing_id=
"15"/>
75 <civicrm_mailing_event_queue id=
"44" job_id=
"24" email_id=
"93" contact_id=
"102" hash=
"07705f3169d0fc84"/>
76 <civicrm_mailing_event_queue id=
"45" job_id=
"24" email_id=
"94" contact_id=
"103" hash=
"8f6d859e31948f31"/>
77 <civicrm_mailing_event_queue id=
"46" job_id=
"24" email_id=
"95" contact_id=
"104" hash=
"e9694c902fafa150"/>
78 <civicrm_mailing_event_queue id=
"47" job_id=
"24" email_id=
"96" contact_id=
"105" hash=
"96a8f2de0d12ddf4"/>
79 <civicrm_mailing_event_queue id=
"48" job_id=
"24" email_id=
"99" contact_id=
"108" hash=
"a3e9c35a0f8b8cf9"/>
80 <civicrm_mailing_event_queue id=
"49" job_id=
"24" email_id=
"100" contact_id=
"109" hash=
"a32756fa40596d57"/>
81 <civicrm_mailing_event_queue id=
"50" job_id=
"24" email_id=
"101" contact_id=
"110" hash=
"20d8df8676546473"/>
82 <civicrm_mailing_event_queue id=
"51" job_id=
"24" email_id=
"102" contact_id=
"111" hash=
"2a2ea3816a403ccd"/>
83 <civicrm_mailing_event_queue id=
"52" job_id=
"24" email_id=
"103" contact_id=
"112" hash=
"d429695899514370"/>
84 <civicrm_mailing_event_queue id=
"53" job_id=
"26" email_id=
"93" contact_id=
"102" hash=
"98c5893b97ff170a"/>
85 <civicrm_mailing_event_queue id=
"54" job_id=
"26" email_id=
"94" contact_id=
"103" hash=
"0ad8d95c73f56332"/>
86 <civicrm_mailing_event_queue id=
"55" job_id=
"26" email_id=
"95" contact_id=
"104" hash=
"15035deafe89f4b0"/>
87 <civicrm_mailing_event_queue id=
"56" job_id=
"26" email_id=
"99" contact_id=
"108" hash=
"c7df7cc740a7c105"/>
88 <civicrm_mailing_event_queue id=
"57" job_id=
"26" email_id=
"100" contact_id=
"109" hash=
"c81c306117ca7fbd"/>
89 <civicrm_mailing_event_queue id=
"58" job_id=
"26" email_id=
"101" contact_id=
"110" hash=
"a9ae5b99441f1dda"/>
90 <civicrm_mailing_event_queue id=
"59" job_id=
"26" email_id=
"102" contact_id=
"111" hash=
"32fbff2a4814bb77"/>
91 <civicrm_mailing_event_queue id=
"60" job_id=
"26" email_id=
"103" contact_id=
"112" hash=
"bcd3cfd309c8c117"/>
92 <civicrm_mailing_event_bounce id=
"2" event_queue_id=
"47" bounce_type_id=
"6" bounce_reason=
"Unknown bounce type: Could not parse bounce email" time_stamp=
"2011-05-25 13:06:57"/>
93 <civicrm_mailing_event_delivered id=
"44" event_queue_id=
"44" time_stamp=
"2011-05-25 13:06:34"/>
94 <civicrm_mailing_event_delivered id=
"45" event_queue_id=
"45" time_stamp=
"2011-05-25 13:06:34"/>
95 <civicrm_mailing_event_delivered id=
"46" event_queue_id=
"46" time_stamp=
"2011-05-25 13:06:34"/>
96 <civicrm_mailing_event_delivered id=
"48" event_queue_id=
"48" time_stamp=
"2011-05-25 13:06:34"/>
97 <civicrm_mailing_event_delivered id=
"49" event_queue_id=
"49" time_stamp=
"2011-05-25 13:06:35"/>
98 <civicrm_mailing_event_delivered id=
"50" event_queue_id=
"50" time_stamp=
"2011-05-25 13:06:35"/>
99 <civicrm_mailing_event_delivered id=
"51" event_queue_id=
"51" time_stamp=
"2011-05-25 13:06:35"/>
100 <civicrm_mailing_event_delivered id=
"52" event_queue_id=
"52" time_stamp=
"2011-05-25 13:06:35"/>
101 <civicrm_mailing_event_delivered id=
"53" event_queue_id=
"53" time_stamp=
"2011-05-26 13:08:50"/>
102 <civicrm_mailing_event_delivered id=
"54" event_queue_id=
"54" time_stamp=
"2011-05-26 13:08:50"/>
103 <civicrm_mailing_event_delivered id=
"55" event_queue_id=
"55" time_stamp=
"2011-05-26 13:08:50"/>
104 <civicrm_mailing_event_delivered id=
"56" event_queue_id=
"56" time_stamp=
"2011-05-26 13:08:50"/>
105 <civicrm_mailing_event_delivered id=
"57" event_queue_id=
"57" time_stamp=
"2011-05-26 13:08:50"/>
106 <civicrm_mailing_event_delivered id=
"58" event_queue_id=
"58" time_stamp=
"2011-05-26 13:08:50"/>
107 <civicrm_mailing_event_delivered id=
"59" event_queue_id=
"59" time_stamp=
"2011-05-26 13:08:51"/>
108 <civicrm_mailing_event_delivered id=
"60" event_queue_id=
"60" time_stamp=
"2011-05-26 13:08:51"/>
109 <civicrm_mailing_event_opened id=
"5" event_queue_id=
"50" time_stamp=
"2011-05-26 13:17:54"/>
110 <civicrm_mailing_event_opened id=
"6" event_queue_id=
"50" time_stamp=
"2011-05-26 13:17:54"/>
111 <civicrm_mailing_event_opened id=
"7" event_queue_id=
"50" time_stamp=
"2011-05-26 13:18:13"/>
112 <civicrm_mailing_event_opened id=
"8" event_queue_id=
"50" time_stamp=
"2011-05-26 13:18:13"/>
113 <civicrm_mailing_event_opened id=
"9" event_queue_id=
"49" time_stamp=
"2011-05-26 13:19:03"/>
114 <civicrm_mailing_event_opened id=
"10" event_queue_id=
"49" time_stamp=
"2011-05-26 13:19:04"/>
115 <civicrm_mailing_event_opened id=
"11" event_queue_id=
"52" time_stamp=
"2011-05-26 13:19:44"/>
116 <civicrm_mailing_event_opened id=
"12" event_queue_id=
"52" time_stamp=
"2011-05-26 13:19:44"/>
117 <civicrm_mailing_event_opened id=
"13" event_queue_id=
"52" time_stamp=
"2011-05-26 13:19:47"/>
118 <civicrm_mailing_event_opened id=
"14" event_queue_id=
"52" time_stamp=
"2011-05-26 13:19:47"/>
119 <civicrm_mailing_event_opened id=
"15" event_queue_id=
"51" time_stamp=
"2011-05-26 13:20:59"/>
120 <civicrm_mailing_event_opened id=
"16" event_queue_id=
"51" time_stamp=
"2011-05-26 13:20:59"/>
121 <civicrm_mailing_event_opened id=
"17" event_queue_id=
"53" time_stamp=
"2011-05-26 13:23:22"/>
122 <civicrm_mailing_event_opened id=
"18" event_queue_id=
"53" time_stamp=
"2011-05-26 13:23:22"/>
123 <civicrm_mailing_event_reply id=
"2" event_queue_id=
"45" time_stamp=
"2011-05-26 13:12:15"/>
124 <civicrm_mailing_event_reply id=
"3" event_queue_id=
"48" time_stamp=
"2011-05-26 13:15:09"/>
125 <civicrm_mailing_event_reply id=
"4" event_queue_id=
"50" time_stamp=
"2011-05-26 13:20:02"/>
126 <civicrm_mailing_event_reply id=
"5" event_queue_id=
"52" time_stamp=
"2011-05-26 13:20:33"/>
127 <civicrm_mailing_event_reply id=
"6" event_queue_id=
"54" time_stamp=
"2011-05-26 13:27:44"/>
128 <civicrm_mailing_event_trackable_url_open id=
"5" event_queue_id=
"46" trackable_url_id=
"12" time_stamp=
"2011-05-26 13:16:03"/>
129 <civicrm_mailing_event_trackable_url_open id=
"6" event_queue_id=
"46" trackable_url_id=
"13" time_stamp=
"2011-05-26 13:16:07"/>
130 <civicrm_mailing_event_trackable_url_open id=
"4" event_queue_id=
"48" trackable_url_id=
"12" time_stamp=
"2011-05-26 13:15:36"/>
131 <civicrm_mailing_event_trackable_url_open id=
"8" event_queue_id=
"51" trackable_url_id=
"12" time_stamp=
"2011-05-26 13:21:09"/>
132 <civicrm_mailing_event_trackable_url_open id=
"9" event_queue_id=
"51" trackable_url_id=
"13" time_stamp=
"2011-05-26 13:21:13"/>
133 <civicrm_mailing_event_trackable_url_open id=
"7" event_queue_id=
"52" trackable_url_id=
"13" time_stamp=
"2011-05-26 13:20:03"/>
134 <civicrm_mailing_event_trackable_url_open id=
"12" event_queue_id=
"52" trackable_url_id=
"13" time_stamp=
"2011-05-27 13:20:03"/>
135 <civicrm_mailing_event_trackable_url_open id=
"10" event_queue_id=
"55" trackable_url_id=
"14" time_stamp=
"2011-05-26 13:23:54"/>
136 <civicrm_mailing_event_trackable_url_open id=
"11" event_queue_id=
"55" trackable_url_id=
"15" time_stamp=
"2011-05-26 13:23:58"/>