Opentaps iContact Integration - Revision history

Sichen at 22:43, 24 August 2011

2011-08-24T22:43:33Z

Sichen at 16:45, 9 November 2010

2010-11-09T16:45:15Z

Sichen at 20:19, 8 November 2010

2010-11-08T20:19:15Z

Sichen: Protected "Opentaps iContact Integration": Sysop page [edit=sysop:move=sysop]

2010-06-09T21:10:52Z

Protected "Opentaps iContact Integration": Sysop page [edit=sysop:move=sysop]

Sichen: New page: [http://opentaps.icontact.com 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...

2010-06-09T21:10:52Z

New page: [http://opentaps.icontact.com 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...

New page

[http://opentaps.icontact.com 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

← Older revision		Revision as of 16:45, 9 November 2010
Line 15:		Line 15:
	=== Coupon Offer ===		=== Coupon Offer ===

−	~~This is a coupon offer good until~~ end of January 2011:	+	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.
−
−	~~Use coupon code '''OPENTAPS10''' and~~ get $10 off and 15 days for free for the [http://opentaps.icontact.com iContact email marketing service].

← Older revision		Revision as of 20:19, 8 November 2010
Line 12:		Line 12:
	# put in the script here		# put in the script here
	$ psql -W opentaps_db -U opentaps_user -h 127.0.01 < getEmails.sql > ~/emails.txt		$ psql -W opentaps_db -U opentaps_user -h 127.0.01 < getEmails.sql > ~/emails.txt
		+
		+	=== Coupon Offer ===
		+
		+	This is a coupon offer good until end of January 2011:
		+
		+	Use coupon code '''OPENTAPS10''' and get $10 off and 15 days for free for the [http://opentaps.icontact.com iContact email marketing service].

@@ Line 1: / Line 1: @@
-[http://opentaps.icontact.com 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.
+''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].''
 In the meantime, you can extract e-mail addresses from your contact lists and upload them to iContact using the following SQL command:
@@ Line 12: / Line 14: @@
   # put in the script here
   $ psql -W opentaps_db -U opentaps_user -h 127.0.01 < getEmails.sql > ~/emails.txt

← Older revision	Revision as of 21:10, 9 June 2010
(No difference)