Email Campaigns, Target Lists, Duplicates

[heytimc]

Hello everyone;

This is our first post to the Sugar CE Forums and we hope that someone can provide a definitive answer to a question that appears to crop up regularly.

About us: Sugar 4.5.1h (build 11.04) Fedora Core 6 PHP 5.2.3 Apache 2.2.6

Problem: We have set up a Campaign that will run an email to a number of Target Lists. We would like to have separate lsits for differently profiled segments for obvious reasons. There will be overlaps between the two lists. This could mean duplicate emails being sent - a big no-no!

We have scoured the forums, the documentation, Wiki etc and we cannot find anywhere, absolute confirmation that Sugar will NOT send duplicate emails to Targets in the separate Target Lists. Ad does it matter if you send the emails in batches of 500 - does the duplicate checking still happen?

For now we have merged all the names into one giant list of 4,000 because we cannot take the risk of looking like amateurs, but this doesn't really help the marketing folks who want to see which types of targets have higher click throughs etc. We know that others have this concern and there are many unanswered posts asking almost the same question.

We also have just bumped into the following problem:
PHP cannot find the IMAP library even though it is installed. Any clues?

There's some really good work going on with the Sugar project but the lack of clear evidence and documentation on what we think should be basics is frustrating but also a worry. Can anyone point us in the right direction?

[etilley]

Here, here - there should be a clear explanation to how to remove duplicates - I see 4 and 5 copies of my targets - I know I didn't import that many.

I don't care why there are dups - but I also want to be able to clean it up - without buggering up my system.

Can someone please suggest a safe script/process to execute to clean this up? I could, for example,

1. export the prospects table from mysql to a csv file;
2. use excel to create a file with only unique email ids;
3. import all 8000 targets again -

but this is pretty weak ; I can write a php script to delete dups - but I really don't understand the implications of simply removing targets at a database table level - are there xref tables that I also need to update after I delete the dups?

[FrankKelly]

We have just added a business Intelligence product called NetSearch to SugarEXchange.which resolves this requirement very simply.

It automatically holds a copy of your prospects, leads, contact and campaign activity information.

You can quickly build target lists based upon any aspect of the CRM information retrieved from SugarCRM.

You can then deduplicate your selections based upon a number of business rules, before loading them into SugarCRM as a new Target List.

For more nformation pease go to sugar exchange.

http://www.sugarexchange.com/product...hp?product=509