User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
Forum membership is Free!  Click Join to sign-up
Username:
Password:
Save Password
Forgot your Password?

     
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
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hcross

37 Posts

Posted - Nov 04 2009 :  12:31:24  Show Profile  Reply
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

xequte

7504 Posts

Posted - Nov 04 2009 :  15:31:45  Show Profile  Reply
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
Go to Top of Page

hcross

37 Posts

Posted - Nov 04 2009 :  20:40:06  Show Profile  Reply
Thanks Nigel!

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



--
howard cross
Go to Top of Page

xequte

7504 Posts

Posted - Nov 05 2009 :  15:48:13  Show Profile  Reply
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
Go to Top of Page

hcross

37 Posts

Posted - Nov 06 2009 :  19:23:46  Show Profile  Reply
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
Go to Top of Page

xequte

7504 Posts

Posted - Nov 07 2009 :  00:36:50  Show Profile  Reply
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
Go to Top of Page

hcross

37 Posts

Posted - Nov 07 2009 :  08:42:32  Show Profile  Reply
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
Go to Top of Page

xequte

7504 Posts

Posted - Nov 07 2009 :  23:44:17  Show Profile  Reply
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
Go to Top of Page

xequte

7504 Posts

Posted - Nov 08 2009 :  18:51:56  Show Profile  Reply
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
Go to Top of Page

hcross

37 Posts

Posted - Nov 09 2009 :  06:26:23  Show Profile  Reply
Thanks!

--
howard cross
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To: