Difference between revisions of "Opentaps iContact Integration"
From Opentaps Wiki
Jump to navigationJump to searchm (Protected "Opentaps iContact Integration": Sysop page [edit=sysop:move=sysop]) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | [http://opentaps.icontact.com iContact] is an online service for e-mail marketing. | + | ''Integration between opentaps and [http://www.getresponse.com/index/sichen GetResponse] is now available. For details, see [http://shop.opentaps.org/index.php/featured/getresponse-email-marketing-integration-module.html GetResponse Email Marketing Integration Module].'' |
| + | |||
| + | [http://opentaps.icontact.com 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: | In the meantime, you can extract e-mail addresses from your contact lists and upload them to iContact using the following SQL command: | ||
Latest revision as of 22:43, 24 August 2011
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
