Opentaps iContact Integration

iContact is an online service for e-mail marketing. We are planning an integration from opentaps to iContact, so you can use it to send e-mails to contact lists maintained in opentaps.

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