
-
Display Namemedia
-
Member SinceMarch 23rd, 2015
-
Last SeenDecember 12th, 2019
media does not have any add-ons for sale.
-
Support September 9th, 2015 @ 8:51 pm
Thanks for the reply. We will try installing the most recent version and re-syncing.
1.) The script uses the sugar bean to just update a custom field, business type, where it was blank before on some users. It's basically just this:
$bean = BeanFactory::getBean('Leads',$row['id']);
$bean->business_type_c = trim($excel_row[1]);
$bean->save();2.) Right. I believe these leads were already in Mail Chimp. Should the lead still be in MailChimp if they were added to MailChimp and opted out (I believe using the CRM) at a later date? I didn't notice anything in MailChimp stating that they had opted out, but maybe I missed it.
3.) Only for this lead, from what I have seen. What do you mean "confirmed their email address via MailChimp"? I don't think the email address is being changed when it's being sync either. It looks like the same email.
View Comment
-
Support July 14th, 2015 @ 10:49 pm
Hello,
Looks like we are still having some issues with some leads missing from MailChimp and I can't figure out why. They are in the Target List, but not in MailChimp. I have also tried adding them manually to the target list using the SugarBean as we discussed above using this code:
$bean = BeanFactory::getBean('Leads', $lead_id); //I looped through the leads that were missing to added them, and also tried hard coding a lead ID.
$bean->load_relationship('prospect_lists');
$bean->prospect_lists->add('7a67ba0d-0937-5c5f-1f7d-553e9c3b080a'); //add lead to “Main” target list
$bean->save();Thank you.
View Comment
-
-
Support June 9th, 2015 @ 10:45 pm
Ok, cool. That seems to have worked. I checked a few of the latest leads and can see them importing correctly.
One more question. I tried to select all the leads in the CRM using the standard interface and add them to the target list so we could pull in any leads we may have missed, and I saw the list of a few thousand in the pending area of the health status page and they were resent, but the ones we had issues with are still not in MailChimp. The number in the pending batch was less that the number of leads in the target list, btw. Any idea how I can get those transferred or what the hiccup might be?
For those who could potentially find this through a search, this is the logic hook SugarBean relationship code I used instead of a raw query:
$bean->load_relationship('prospect_lists');
View Comment
$bean->prospect_lists->add('7a67ba0d-0937-5c5f-1f7d-553e9c3b080a'); //Change this to the ID of the target list you wish to add the lead to
-
Support June 9th, 2015 @ 7:03 pm
Ok, that may be it. My custom logic hook is inserting the lead manually to the target list in a query, not using the Sugarbean relationship methods to add it. I'll make that switch and report back on the result.
View Comment
-
Support June 9th, 2015 @ 5:06 pm
Thanks. I have a custom logic hook PHP script in Sugar CRM that automatically adds every new lead to the target list as they come into the CRM. So they are being added as soon as they come into the system. When I export the target list to CSV in the CRM, the leads that are missing from MailChimp are displayed in the exported target list, so they are in there according to the CRM.
I initially stated that the leads are coming in late, but after further review, it appears some leads are making it into mailchimp, while others are not, regardless of the date (some still appear to come in a few days later). We added a new lead to the CRM today, June 9th, and that lead is in Mailchimp, while some other leads added today are still missing.
View Comment
-
Support June 8th, 2015 @ 7:28 pm
1.) It says "done" for the scheduler, which is running every 30 minutes, it looks like it's running successfully. Doesn't look to be getting stuck or failing from errors.
2.) No really big numbers. Both the pending to and pending from MailChimp show 0 at the moment.
View Comment
-
Support April 9th, 2015 @ 4:02 pm
Ok, sounds good, thanks. Yes, please cancel the other two trials so we only have our pro account. The pro instance uses the same credentials, right?
View Comment
-
Support April 7th, 2015 @ 7:21 pm
Thanks. We took care of those other schedulers, but the SugarChimp scheduler is still not running:
Tue Apr 7 15:09:01 2015 [10639][1][FATAL] Job 93b1e517-450e-c70d-abc1-55242b84de39 (SugarChimp) failed in CRON run
Tue Apr 7 15:10:02 2015 [10685][1][FATAL] Job 60a7029e-4993-b355-d180-55242b06c43a (SugarChimp) failed in CRON run
Tue Apr 7 15:11:01 2015 [11202][1][FATAL] Job 985dbe48-1d68-d7a6-00f5-55242ba6bbc5 (SugarChimp) failed in CRON run
Tue Apr 7 15:12:02 2015 [11270][1][FATAL] Job 16aad458-99a5-1191-8ab2-55242cfce66c (SugarChimp) failed in CRON run
Tue Apr 7 15:13:01 2015 [11315][1][FATAL] Job 7ccaa5cf-e13c-00a5-d337-55242cb8948b (SugarChimp) failed in CRON run
Tue Apr 7 15:14:01 2015 [11374][1][FATAL] Job e0c05d7d-fed3-d249-f6ca-55242cdab47b (SugarChimp) failed in CRON run
Tue Apr 7 15:15:01 2015 [11459][1][FATAL] Job 4cf06c02-3211-0e4c-1381-55242c12c647 (SugarChimp) failed in CRON runThe Job Queue table in the database says "Cannot call function: SugarChimp" for the message.
View Comment
-
Support April 6th, 2015 @ 5:10 pm
Here are the latest entries in the Sugar Log:
Thu Mar 26 11:30:03 2015 [29641][-none-][FATAL] SugarPHPMailer encountered an error: Invalid address:
View Comment
Thu Mar 26 11:31:02 2015 [12262][1][FATAL] Job 5ece8404-66f0-feaf-a85f-551426843f14 (Run Nightly Process Bounced Campaign Emails) failed in CRON run
Thu Mar 26 11:32:01 2015 [12395][1][FATAL] Job 5f9c9caa-a751-8084-d749-551426cbb7ab (Run Nightly Mass Email Campaigns) failed in CRON run
Thu Mar 26 11:33:02 2015 [12516][1][FATAL] Job 6a1096d7-7333-a9a5-6ad8-5514269add2b (SugarChimp) failed in CRON run
Thu Mar 26 11:36:02 2015 [12910][1][FATAL] Job 52757138-6810-2151-daec-5514275add6e (Run Nightly Process Bounced Campaign Emails) failed in CRON run
Thu Mar 26 11:37:01 2015 [13059][1][FATAL] Job 8a619a90-a83a-dfe7-daa5-551427e5391f (SugarChimp) failed in CRON run
Thu Mar 26 21:45:08 2015 [27986][-none-][FATAL] SugarPHPMailer encountered an error: Invalid address:
Fri Mar 27 05:00:01 2015 [3465][1][FATAL] Job 9c453e99-c1cf-7f65-80ab-55151c5aefdc (Run Nightly Mass Email Campaigns) failed in CRON run
Fri Mar 27 13:15:03 2015 [28558][-none-][FATAL] SugarPHPMailer encountered an error: Invalid address:
Sun Mar 29 13:15:03 2015 [27291][-none-][FATAL] SugarPHPMailer encountered an error: Invalid address:
Sun Mar 29 14:00:02 2015 [27592][-none-][FATAL] SugarPHPMailer encountered an error: Invalid address:
Mon Mar 30 00:27:07 2015 [27592][1][FATAL] Email Address provided is not Primary Address for email with id ' Emailman id=21091
Mon Mar 30 00:27:07 2015 [27592][1][FATAL] Email Address provided is not Primary Address for email with id ' Emailman id=21090
Mon Mar 30 07:00:03 2015 [13431][-none-][FATAL] SugarPHPMailer encountered an error: Invalid address:
Mon Mar 30 13:30:26 2015 [3673][1][FATAL] SUGAREMAILADDRESS: address did not validate [ mark@demeoconstruction ]
Tue Mar 31 10:00:02 2015 [8109][-none-][FATAL] SugarPHPMailer encountered an error: Invalid address:
media has not rated any add-ons.
media has not verified any add-ons.
media has not created any Wanted Add-ons.
Keep up to date on the latest additions