Opentaps iContact Integration

From Opentaps Wiki

Jump to: navigation, search

Integration between opentaps and GetResponse is now available. For details, see GetResponse Email Marketing Integration Module.

iContact is an online service for e-mail marketing.

In the meantime, you can extract e-mail addresses from your contact lists and upload them to iContact using the following SQL command:

SELECT DISTINCT CM.INFO_STRING FROM CONTACT_MECH AS CM 
JOIN CONTACT_LIST_PARTY AS CLP 
ON CLP.PREFERRED_CONTACT_MECH_ID = CM.CONTACT_MECH_ID 
AND CLP.CONTACT_LIST_ID = '${listId}' 
AND CLP.STATUS_ID = 'CLPT_ACCEPTED'

For example, with PostgreSQL, you can save this list to a file by running the script from the command line, such as:

$ cat > getEmails.sql
# put in the script here
$ psql -W opentaps_db -U opentaps_user -h 127.0.01 < getEmails.sql > ~/emails.txt


© Open Source Strategies, Inc. Development of this documentation site is sponsored by Open Source Strategies, Inc.
Help support opentaps with a subscription to this documentation site.



Join our mailing list to learn more about opentaps Open Source ERP + CRM