User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 MailList King
 Personalizing Email with Conditional Text

Note: You must be registered in order to post a reply.

Size 
UserName:
Password:
Mode 
Format  BoldItalicizedUnderline Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailBrowse for an image to attach to your post Insert CodeInsert QuoteInsert List
   
Message 

 

Emoji
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Black Eye [B)]
Frown [:(] Shocked [:0] Angry [:(!] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
hcross Posted - Nov 04 2009 : 12:31:24
Nigel and all,

OS - Windows 7 MLK ver 8.62

I would like to do conditional testing (if, then-else or case statements). I'm struggling with the syntax though. I have several additional custom fields in my record. One of which contains a numeric value to indicate a delivery zone. I send out delivery notices all my customers in the whole territory at the start of the week. I would like to remind them of which day I'll be in their part of the state. (delivery zone: 1 = monday, zone 2 = tuesday, etc. We deliver Monday thru Friday.)

This is what I've tried:

%condition:delivery zone=1%Monday or Thursday %condition:delivery zone=2%Tuesday %condition:delivery zone=3%Wednesday %condition:delivery zone=4%Friday %condition:end%

%field:delivery zone% yields the proper result. I can get the

Obviously, it doesn't work. Have I done something improperly or is what I'm trying to do beyond the scope of MLK?

-- howard

--
howard cross
9   L A T E S T    R E P L I E S    (Newest First)
hcross Posted - Nov 09 2009 : 06:26:23
Thanks!

--
howard cross
xequte Posted - Nov 08 2009 : 18:51:56
Hi Howard

Sorry, have checked the code and to clarify; Conditional text commands need to be all uppercase.


Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
xequte Posted - Nov 07 2009 : 23:44:17
Hi Howard

Not on holiday yet, i'm afraid.

The test statement for null checking is:

%CONDITION:Delivery_Zone=NOTHING%

or

%CONDITION:Delivery_Zone=%

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
hcross Posted - Nov 07 2009 : 08:42:32
Hi Nigel,

I hope you're having a great trip. Please don't work on this any more until you get back.

Yes, I could nest the read from file in a conditional test.

%CONDITION:Delivery_Zone=3%%Read_From_File:C:\Users\Zoe\Desktop\test_1.txt%%CONDITION:END%

At first I had trouble because it appears as though it will not read files on my local network file-server. However, it will read files from my local drive.

Question: if the field value is null, what is the test statement? I thought it might be something such as %CONDITION:Delivery_Zone=""% What I got to work was %CONDITION:Delivery_Zone=%

BTW - CONDITION/CONDITION:END have to be all caps. I double checked this morning thinking it might be something I'm doing on my end.

thanks again

--
howard cross
xequte Posted - Nov 07 2009 : 00:36:50
Hi Howard

Thanks I will investigate.

Off the top of my head (I'm out of the office for the weekend) I believe you can have a %Read_From_File:C:\xyz.txt% field inside a conditional text condition. Please try it and confirm :-)

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
hcross Posted - Nov 06 2009 : 19:23:46
Hi there Nigel,

1. %condition:delivery_zone=3%Good + 10% discount coupon %condition:end%

2. %CONDITION:Delivery_Zone=3%Good + 10% discount coupon %CONDITION:END%

Above statement #1 does not work and statement #2 does. The alert box indicates "pos 285: "%CONDITION:END%" outside of any condition"

BTW - Is there any way to insert a text file into the body of an email based on the results of such a conditional test?

--
howard cross
xequte Posted - Nov 05 2009 : 15:48:13
Hi Howard

No, it should be case-insensitive. Can you give me more detail so I can investigate.

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
hcross Posted - Nov 04 2009 : 20:40:06
Thanks Nigel!

It appears as though the personalization is case sensitive and needs to be all caps. Is that correct?



--
howard cross
xequte Posted - Nov 04 2009 : 15:31:45
Hi Howard

Each conditional statement needs to be in the format:

%Condition:Some_Condition%The conditional text%Condition:End%

or

%Condition:Some_Condition%The conditional text%Condition:Else%Alternative text%Condition:End%

So your statements failed because three of your %Condition:Some_Condition% did not have a matching %Condition:End%.

Also custom fields that contain spaces are shown with underlines. Your statement should be:

%condition:delivery_zone=1%Monday or Thursday%condition:end%
%condition:delivery_zone=2%Tuesday%condition:end%
%condition:delivery_zone=3%Wednesday%condition:end%
%condition:delivery_zone=4%Friday%condition:end%

(I just put them on separate lines to make it easier to read. It doesn't need to be).


Also you should use the function Personalize > Insert Conditonal Text on the message sending toolbar to automatically build the conditional text string for you.

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com