ict.ken.be

Invitation Mail

<DIV MACONSTRAINT="SYSTEM.MAIL=1" id=MASECTION contentEditable=true>
<P align=center style='FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif;font-size=10px'>Indien deze e-mail onleesbaar is, klik <A href="[$=PROBE(0)/]" style="color:de1919;">hier</A>.</P>
</DIV>
<P>Invitation</P>
<P><A href="~PROBE(100)~">Click here if interested</A></P>

Landing Page

<P>Landing</P>
<P><A href="~PROBE(100)~">Registreer hier</A></P>

Registration

<P>Registration : ~SYSTEM.DAY~ ~SYSTEM.MONTH~ ~SYSTEM.YEAR~</P>
<div id="errorMessages">~DATA_ERROR~</div><br />  
<FORM action=[$=PROBE(100)/] method=post>
<P>Name : <INPUT id=NAME value="~(IF(@NAME<>'',@NAME,NAME))~" maxLength=50 name=NAME></P>
<P>Email : <INPUT id=MAIL value="~(IF(@MAIL<>'',@MAIL,MAIL))~" maxLength=50 name=MAIL></P>
<P>Phone : <INPUT id=PHONE value="~(IF(@PHONE<>'',@PHONE,PHONE))~" maxLength=50 name=PHONE></P>
<p><span id="lblZips">City :&nbsp;<input id="txtZips" type="text"  /></span></p>
<p><span id="lblStreets">Street :&nbsp;<input id="txtStreets" type="text"  /></span></p>
<p><span id="lblHouses">Housenumber :&nbsp;<input id="txtHouses" type="text"  /></span></p>
<span id="lblNodes">Selected Node :&nbsp;<input id="NODE" name="NODE" value="" maxLength=50 enabled=false /><br /><input type="submit" class="RedJellyBean" value="Registreer" /></span>
<input type="hidden" id="ZIP" name="ZIP" value="" maxLength=50 /> 
<input type="hidden" id="STREET" name="STREET" value="" maxLength=50 /> 
<input type="hidden" id="HOUSE" name="HOUSE" value="" maxLength=50 /> 
</FORM>

Registration Success

<P>Registration Success</P>
<P><A href="~PROBE(100)~">Back to landing</A></P>
<P><A href="~PROBE(101)~">More registration</A></P> 

designer - select a date

<FORM method=post name=silentboxesform action=[$=PROBE(200)/]>

<DIV id=MASECTION contentEditable=true MACONSTRAINT="DATA_ERROR<>''" MASHOWALLLANGUAGES="FALSE">

<B>Kies een datum...</B>

<P>~DYNAMIC_RADIOLIST~</P>

<INPUT style="BORDER-BOTTOM: 0px; BORDER-LEFT: 0px; WIDTH: 78px; BACKGROUND: url(http://messagent.yourinstallation.be/images/Residential/Adhoc/2008/2008-05/silent%20boxes/btn.gif); HEIGHT: 24px; COLOR: #7a7a7a; FONT-SIZE: 9px; BORDER-TOP: 0px; FONT-WEIGHT: bold; BORDER-RIGHT: 0px" value=Verdergaan alt=Verdergaan type=submit>

</DIV>

</FORM>

timeslots.aspx.cs

protected void Page_Load(object sender, EventArgs e)
 {
 using (var con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
 {
         con.Open();
                var sbQuery = new StringBuilder();
                sbQuery.Append("select year(dag) as jaar, month(dag) as maand, day(dag) as dag, min(id) as slotid");
                sbQuery.Append(" from timeslots");
                sbQuery.Append(" where fk_user_id is null");
                sbQuery.Append(" and DatePart(hour, dag) < 12");
                sbQuery.Append(" group by year(dag), month(dag), day(dag)");
                bool hasVoormiddag = false;
                using (var cmd = new SqlCommand(sbQuery.ToString(), con))
                {
                    using (var dr = cmd.ExecuteReader())
                    {
                        if (dr != null)
                        {
                            hasVoormiddag = true;
                            Response.Write("Voormiddag : <br />");
                            while (dr.Read())
                            {
                                Response.Write(
                                    "<input type='radio' name='slot' value='" + dr["slotid"] + "' onclick=\"new Effect.BlindDown($('internetDiv'),'blind', {duration:0.3});\" /> " + dr["dag"] + " september");
                                Response.Write("<br />");
                            }
                        }
                    }
                 }
                sbQuery = new StringBuilder(); 
                sbQuery.Append(" select year(dag) as jaar, month(dag) as maand, day(dag) as dag, min(id) as slotid");
                sbQuery.Append(" from timeslots");
                sbQuery.Append(" where fk_user_id is null");
                sbQuery.Append(" and DatePart(hour, dag) > 12");
                sbQuery.Append(" group by year(dag), month(dag), day(dag)");
                if (hasVoormiddag) Response.Write("<br />");
                
                using (var cmd = new SqlCommand(sbQuery.ToString(), con))
                {
                    using (var dr = cmd.ExecuteReader())
                    {
                        if (dr != null)
                        {
                            Response.Write("Namiddag : <br />");
                            while (dr.Read())
                            {
                                Response.Write(
                                    "<input type='radio' name='slot' value='" + dr["slotid"] + "' onclick=\"new Effect.BlindDown($('internetDiv'),'blind', {duration:0.3});\" /> " + dr["dag"] + " september");
                                Response.Write("<br />");
                            }
                        }
                    }
                }
            }
}

Aantal malen dat op een webversie is geclicked weergeven voor versies onder 3.1.

Probleem:

Van zodra we de campaign starten word er een probe 0 record toegevoegd zonder dat de mail bekeken of aangeklikt is geweest, ook niet in preview. Nadien word er geen enkele probe 0 (webversion) meer geregistreerd.

Workaround :
Op 'email niet leesbaar click hier' zetten wij een PROBE(2000) en dan geven we PROBE(2000) als property een [PROBE(0)] zo kunnen we exact nagaan hoeveel malen er op de webversie geclicked is. En dit door in de FLAGS naar probeid 2000 te querien.
 

Ter informatie :

FLAGS.PROBEID = 0, dat bedoel dat de email is aangeleverd in de mailbox
FLAGS.PROBEID = -1, de email is gezien
FLAGS.PROBEID >= 100, is de ID van de sensor dat de persoon geklickt heeft

Configuring caching on a data component is not possible. It can be done on a higher level, campaign level or mail/page level.

• CACHE_CAMPAIGNDEF (caching of campaign definition) 
• CACHE_MESSAGEDEF (caching of mails/pages definition) 

The 'Content Expiration'

This option will only give you the possibility to include articles based on their created date or modified date. You cannot use this to exclude articles.  Still if you want to use this option it's very easy. Just select the field were you want to filter on (created date or modified date) and then select the interval you want. For example 1 Hour.

/****** We will add a database trigger that will alter the table on creation ******/

USE [DB_MESSAGENT]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [ddltrg_CREATE_TABLE] ON DATABASE
FOR CREATE_TABLE
AS
SET NOCOUNT ON

DECLARE @data xml
SET @data = EVENTDATA()

DECLARE @objname sysname
SET @objname = @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(256)')
--PRINT @objname

IF LEFT(@objname,6) = 'USERS_'
BEGIN
 DECLARE @sql VARCHAR(MAX)

 SET @sql = 'ALTER TABLE [DBA_MESSAGENT].[' + @objname + '] ALTER COLUMN [MAIL] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL'
 EXECUTE (@sql)

 SET @sql = 'ALTER TABLE [DBA_MESSAGENT].[' + @objname + '] ADD [FIRSTNAME] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL'
 EXECUTE (@sql)

 SET @sql = 'ALTER TABLE [DBA_MESSAGENT].[' + @objname + '] ADD [LANG] [nvarchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL'
 EXECUTE (@sql)

 SET @sql = 'ALTER TABLE [DBA_MESSAGENT].[' + @objname + '] ADD [DATECREATION] [datetime] NOT NULL CONSTRAINT [DF_' + @objname + '_DATECREATION]  DEFAULT (getdate())'
 EXECUTE (@sql)

 SET @sql = 'ALTER TABLE [DBA_MESSAGENT].[' + @objname + '] ADD [DATEMODIFIED] [datetime] NOT NULL CONSTRAINT [DF_' + @objname + '_DATEMODIFIED]  DEFAULT (getdate())'
 EXECUTE (@sql)

 SET @sql = 'INSERT INTO [DBA_Messagent].[' + @objname + '] ([MAIL],[NAME],[TESTUSER],[ONLY_TEXT],[FIRSTNAME],[LANG]) VALUES (''test1@tester.be'', ''Van Gilbergen (Dutch Text Only)'', 1, 0, ''Ken'', ''NL'')'
 EXECUTE (@sql)
 SET @sql = 'INSERT INTO [DBA_Messagent].[' + @objname + '] ([MAIL],[NAME],[TESTUSER],[ONLY_TEXT],[FIRSTNAME],[LANG]) VALUES (''test1@tester.be'', ''Van Gilbergen (Dutch)'', 1, 1, ''Ken'', ''NL'')'
 EXECUTE (@sql)
 SET @sql = 'INSERT INTO [DBA_Messagent].[' + @objname + '] ([MAIL],[NAME],[TESTUSER],[ONLY_TEXT],[FIRSTNAME],[LANG]) VALUES (''test1@tester.be'', ''Van Gilbergen (French)'', 1, 1, ''Ken'', ''FR'')'
 EXECUTE (@sql)
 SET @sql = 'INSERT INTO [DBA_Messagent].[' + @objname + '] ([MAIL],[NAME],[TESTUSER],[ONLY_TEXT],[FIRSTNAME],[LANG]) VALUES (''test1@tester.be'', ''Van Gilbergen (English)'', 1, 1, ''Ken'', ''EN'')'
 EXECUTE (@sql)
 SET @sql = 'INSERT INTO [DBA_Messagent].[' + @objname + '] ([MAIL],[NAME],[TESTUSER],[ONLY_TEXT],[FIRSTNAME],[LANG]) VALUES (''test2@tester.be'', ''Rotthier (Dutch Text Only)'', 1, 0, ''Maarten'', ''NL'')'
 EXECUTE (@sql)
 SET @sql = 'INSERT INTO [DBA_Messagent].[' + @objname + '] ([MAIL],[NAME],[TESTUSER],[ONLY_TEXT],[FIRSTNAME],[LANG]) VALUES (''test2@tester.be'', ''Rotthier (Dutch)'', 1, 1, ''Maarten'', ''NL'')'
 EXECUTE (@sql)
 SET @sql = 'INSERT INTO [DBA_Messagent].[' + @objname + '] ([MAIL],[NAME],[TESTUSER],[ONLY_TEXT],[FIRSTNAME],[LANG]) VALUES (''test2@tester.be'', ''Rotthier (French)'', 1, 1, ''Maarten'', ''FR'')'
 EXECUTE (@sql)
 SET @sql = 'INSERT INTO [DBA_Messagent].[' + @objname + '] ([MAIL],[NAME],[TESTUSER],[ONLY_TEXT],[FIRSTNAME],[LANG]) VALUES (''test2@tester.be'', ''Rotthier (English)'', 1, 1, ''Maarten'', ''EN'')'
 EXECUTE (@sql)

 SET @sql = 'CREATE TRIGGER [DBA_MESSAGENT].[trig_update_' + @objname + '] ON  [DBA_MESSAGENT].[' + @objname + '] AFTER UPDATE AS
BEGIN
 SET NOCOUNT ON;
 IF NOT UPDATE(DATEMODIFIED)
    BEGIN
        UPDATE [DBA_MESSAGENT].[' + @objname + ']
  SET DATEMODIFIED=getdate()
        FROM [DBA_MESSAGENT].[' + @objname + '] INNER JOIN deleted d ON [DBA_MESSAGENT].[' + @objname + '].id = d.id
    END
END'
 EXECUTE (@sql)

 --PRINT @sql
END

GO

SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO

DISABLE TRIGGER [ddltrg_CREATE_TABLE] ON DATABASE
GO

ENABLE TRIGGER [ddltrg_CREATE_TABLE] ON DATABASE
GO