Difference between revisions of "Opentaps iContact Integration"
From Opentaps Wiki
Jump to navigationJump to search| Line 15: | Line 15: | ||
=== Coupon Offer === | === Coupon Offer === | ||
| − | + | Until the end of January 2011, opentaps users can get $10 off and 15 days for free for the [http://opentaps.icontact.com iContact email marketing service]. Please [http://www.opentaps.org/contact contact us] for the coupon code. | |
| − | |||
| − | |||
Revision as of 16:45, 9 November 2010
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
Coupon Offer
Until the end of January 2011, opentaps users can get $10 off and 15 days for free for the iContact email marketing service. Please contact us for the coupon code.
