Inxmail implementation communicates with Tam Tam CMS
Thursday, February 9th, 2006A while ago I told you about Tam Tam’s partnership with Inxmail. After a long search for the best and most flexiible E-Mail Marketing software we decided to go for Inxmail. Tam Tam is the non-exclusive Advanced Partner of Inxmail for the Netherlands.
One of our first implementations is for our longtime customer INREV. INREV acts for investors and other participants in the growing European market for non-listed real estate vehicles. They were already using our selfmade E-Mail mailingsoftware but decided to upgrade to Inxmail because of it’s ease to use and flexibility with the existing CMS. While we have built the Inxmail implementation for the sending and tracking of email messages, the user management interface has been left unaltered.
In a few screenshots I will show you how Inxmail was implemented to use the existing database and CMS.
First we log on to the Tam Tam CMS, the CMS that we built some years ago and was used for content management until we moved over to Microsoft Content Management Server 2002 (MCMS2002). In the Tam Tam CMS we enter some vital information.
After saving, the table is updated:
Now this is the normal procedure of creating new subscribers through the CMS. Nothing has changed here and all possible links to other tables has been left untouched. Underwater though, other things happen. Inxmail needs an TransferTable to INSERT, UPDATE or DELETE recipients. Through some simple triggers the TransferTable is being populated, I will show you the insert trigger:
CREATE TRIGGER [Inxmail_Insert] ON [dbo].[PropertyRecipient]
AFTER INSERT
AS
BEGIN
INSERT INTO Inxmail ([Name], FullName, Email, Company, CMD_TYPE)
SELECT prName, prFullName, prEmail, prCompany, ‘INSERT’ FROM inserted
INSERT INTO Inxmail ([Name], FullName, Email, Company, CMD_TYPE)
SELECT prName, prFullName, prEmail, prCompany, ‘SUBSCRIBE’ FROM inserted
END
The first row is used by to insert the user to the Inxmail database, the second row is to link the user to the appropriate mailinglist. Note; the table includes a auto-populated column that contains the mailinglist name. The result looks like:
This table is being read by the Inxmail DbSync utility every x seconds. As you can see in the next screenshot of the Inxmail client interface, the subscriber has been inserted.
In my next posting I will show you how easy it is to send a new mailing to the subscribers, using an existing template through an HTTP request. This posting will include more screenshots from the Inxmail interface.
If you have questions, please feel free to respond to this posting or email me directly.
www.omtrends.com