Mailchimp Integration - EspoCRM getting Emails a few times

[tanya]

It could be the reason

[bruce185]

I wonder if selecting the 'All Mail' folder in gmail includes 'Drafts' and so emails are imported multiple times as the email is edited... Maybe that is a possibility and a reason for the duplicates?

[bruce185]

1. Version of EspoCRM
2. Check the log and attach it, if you find something, related to email fetching
3. Is it possible, that this email is in different folders, are monitored?

1. Version is 4.4.1

2. I've attached a variety of logs, it looks like there are some relevant error messages. Although that said, I have re-created the personal email account in question to see if that helps resolve this...

3. I've just selected the gmail inbox, all mail and sent items folders...

[tanya]

1. Version of EspoCRM
2. Check the log and attach it, if you find something, related to email fetching
3. Is it possible, that this email is in different folders, are monitored?

[bruce185]

No, this is the normal email integration stuff, attaching emails via imap and personal accounts.... here's an example of what I'm talking about for a lead...

[tanya]

Are you talking about Mass Emailing feature in EspoCRM? This topic is about MailChimp Synchronization, that's why asked you about Advanced Pack. Which version of EspoCRM do you use?

[bruce185]

Which version of advanced pack do you have?

I don't have the advanced pack but I'm getting the same problem with duplicate emails from a single user being attached multiple times to the same lead/contact etc.

[tanya]

Which version of advanced pack do you have?

[bruce185]

I have a similar problem but with a normal user... Basically espo imports many duplicates of an email into a lead's record when obviously only 1 email was sent... Do you know why this might be happening? Thanks...

[lucakuehne]

Did you get new duplicates with updated integration?
Old version has bug with duplicates and this script just delete them.
This script deletes data from database. Not sure, that duplicates by MailChimp still exist. Any screenshots?

Yes I know.. Since the update of the Advanced Pack I only sent one small campaign, and I couldn't get any duplicates as far as I noticed..
But the old duplicates are also just in EspoCRM! And the script removed them from contacts, leads and account but not from the capaigns entity

[tanya]

Did you get new duplicates with updated integration?
Old version has bug with duplicates and this script just delete them.
This script deletes data from database. Not sure, that duplicates by MailChimp still exist. Any screenshots?

[lucakuehne]

Hi and thank you for the script :-)
So I reserved some time today and tested the script. It solves the problem halfway...
It removes the duplicates from leads/contacts/account, but if I'm going into "Campaigns" and then into one of my campaigns, there are still all of the duplicates..
It's fine for a temporary solution, but it isn't a clean solution..

[tanya]

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

[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]

After bugs fixing, let's discuss this script.