Mailchimp Integration - EspoCRM getting Emails a few times

[lucakuehne]

We have a pretty huge problem with the Mailchimp integration.
I activated "fetch sent emails":

But they are getting saved in EspoCRM for 2-6 times, allthought it was sent only once:

That's really anoying. It spams the whole CRM...
Please fix this. We payed for the extension to get a proper solution and not this...

Kind regards
Luca

[tanya]

Hello
In a short time we'll release an updated Mailchimp integration Advanced Pack.
Apologize for this inconvenience.

[lucakuehne]

Thank you for your response!
Then I'm waiting for the update of the Advanced Pack..
Out of curiosity: Are the older campaign Mails going to be fixed?

[tanya]

No, old data won't be touched. I will try to generate a sql query to clear duplicate emails, if you want

[alasdaircr]

Great to see it's not just me who is experiencing this!

[alasdaircr]

@lucakuehne if you look at your campaign log record for the campaign does that also have duplicate 'Sent' messages ?

[lucakuehne]

No, old data won't be touched. I will try to generate a sql query to clear duplicate emails, if you want

Yes please.. We send about en average 5000 mails per campagin.. Some of them are importet into EspoCRM 7 times.. You can calculate yourself how many duplicates are in our system now.. (Round about 25'000 mails per campaign).

@lucakuehne if you look at your campaign log record for the campaign does that also have duplicate 'Sent' messages ?

I guess you're talking about the campaign log of EspoCRM? It's pretty difficult to check that, beacause I'm not able to search in the campaign log. But within 5 minutes I found a few duplicate sent-messages.

[alasdaircr]

Filter the campaign log relationship panel showing underneath the Campaign details.

[alasdaircr]

You can also check the Campaign statistics on the right hand side.

If you see really high open rates (some greater than 100%) you know you are seeing duplicates in the campaign_log_record.

[lucakuehne]

Filter the campaign log relationship panel showing underneath the Campaign details.

That isn't enough.. I have sent round about 4500 mails in the campaign ^^ But as mentioned before, I saw a few duplicate "sent"-entries.

You can also check the Campaign statistics on the right hand side.
If you see really high open rates (some greater than 100%) you know you are seeing duplicates in the campaign_log_record.

No, the "open" rates are in fact to low.. Maybe because the sent "rate" is way to high.. "Sent" is in EspoCRM about 4 times higher, than sent in reallity..

[alasdaircr]

tanya any update on a fix for this?

[lucakuehne]

Yes, what about this topis? The problem itself is fixed in the newest release, but what about the script to remove the duplicates?

[tanya]

After bugs fixing, let's discuss this script.

[lucakuehne]

After bugs fixing, let's discuss this script.

For me this bug is fixed with the newest release of the advanced pack.. what do you mean? So now you just need to clean the hole mess up..

[tanya]

Hello.
Export this file to the Espo directory, run script, and delete this file.
Strongly recommended to create a dump of database