batch update: add newsletter contacts using SQL?

[wivaku]

Hi all,

Environment: SugarPro 5.2.0c with MySQL 4.

Trying to batch update a list of contacts so they are subscribed to a certain newsletter (campaign).
Either using the user interface or using direct database access.

Couple of questions:
- can I use the user interface for this?
(for individual contacts: contact detail view -> Manage Subscriptions, but how for batch update?)
- when using direct database access: there's the contacts and campaigns table,
but where is the link between the two stored?
Was expecting something similar to accounts_opportunities, but could not find this.

-Winfred

[crmsiva]

There is a project for community edition in sugarforge, which do exactly what you are expecting. You can find it here. But i don't know whether it works good for professional edition of sugar. Better you can contact Markku. He is one of the project Admins for this project.

[wivaku]

This is why I love the community: fast and friendly help!

Actually, it helped to switch on the light in my head... I can use Target lists for this.

I created a (temporary) report, selected the target list and used Select from Reports. Done. :-)

Thanks for the tip and sending me in the right direction!

(Not needed right now, but still curious: where is it stored in the database?)

[crmsiva]

Check the table prospect_lists_prospects.
For contacts, the field related_id is the id from contacts table, prospect_list_id is the id from prospect_lists table and related_type=Contacts

This is how contacts is related to prospect lists or target lists