Import data into a data extension using FTP

FTP data file into “import” folder

In ET, go to “Interactions / Import” and click “Create”

Name: Your choice
File Naming Pattern: This is the name of the file you uploaded using FTP. Make sure to include file extension (.csv).
Destination Type: If you are uploading data to a data extension, make sure and choose “Data Extensions”.
In the box below, select the data extension you want to import data to.

Update Type: Select

Thank you for reading!

Adding possessive apostrophe to names – AMPscript

So we have some personalization in an email where we want to greet the recipient using their first name. In the example the first name was a pet name and the email was alerting the recipient that it was time for their pet’s shots, checkup, etc.

It’s time for Sparky’s checkup.

The works fine, but if the pet name ends in “s”, we want to just add the apostrophe and not the apostrophe and the “s”.

Let’s say your dog’s name is “Spots”.

So, we want to check and see if the pet name ends in “s”.

First I’ll make sure the pet name is in the case I want it in (upper, lower, proper).

Set @PET_NAME = ProperCase(@PET_NAME)

Then I’ll get the length of the name.

Set @PET_NAME_LENGTH = Length(@PET_NAME)

Now, let’s check to see if “s” is the last character. If it is, we’ll set a variable to hold just the apostrophe (‘). If the last character is not an “s”, we’ll set the variable to apostrophe + “s” (‘s).

IF Substring(@PATIENT_NAME,@PATIENT_NAME_LENGTH,1) == "s" THEN 
Set @PATIENT_NAME_Apostrophe = "'"
ELSE
Set @PATIENT_NAME_Apostrophe = "'s"
ENDIF

Substring(S1, I1, I2)
Returns the portion of the specified string starting with the specified character position and no longer than the specified length. If the specified character position is greater than the length of the specified string, an empty string is returned.

Arguments

S1 The string from which to return a portion
I1 The character position at which to begin the substring
I2 Maximum length of the substring

Example

%%=Substring(“abcdef”,2,2)=%%

System returns:bc

https://help.exacttarget.com/en/documentation/exacttarget/content/ampscript/ampscript_syntax_guide/utilities_ampscript_functions/

Thank you for reading!

Format date/time via AmpScript

—————————-
Today’s Date Substitution String (Short Date Format):

%%xtshortdate%%

8/14/2011
—————————-
Today’s Date Substitution String (Long Date Format):

%%xtlongdate%%

Sunday, August 14, 2009
—————————-
Today’s Date MM/dd/yyyy:

%%=Format(Now(),"MM/dd/yyyy")=%%

08/14/2011
—————————-
Today’s Date plus 7 days (no formatting):

%%=DateAdd(Now(), "7","D")=%%

8/21/2011 10:05:55 PM
—————————-
Today’s Date plus 7 days (with formatting – no time):

%%=Format(DateAdd(Now(), "7","D"), "MM/dd/yyyy")=%%

08/21/2011
—————————-
FYI – Today’s Date plus 7 days (Format first; Date add second; Time stamp removed; Defaults to midnight)

%%=DateAdd(Format(Now(),"MM/dd/yyyy"), "7","D")=%%

8/21/2011 12:00:00 AM
—————————-

Thank you for reading!

mxtoolbox.com blacklist lookup

This took can be very helpful when trying to figure out why your emails campaigns are having a low deliverability rate.

About the SuperTool!

All of your MX record, DNS, blacklist and SMTP diagnostics in one integrated tool.  Input a domain name or IP Address or Host Name.Links in the results will guide you to other relevant tools and information.  And you’ll have a chronological history of your results.  

http://mxtoolbox.com/SuperTool.aspx

Thank you for reading!