3

We have a form where Exact Target is setting up a triggered send so that once it is submitted, a party involved (an email account submitted) is sent an email. I'd noticed when that trigger was added that the page was doubling the new records in the system and determined through exclusion that the triggered send function is also updating the data extension. I can see a line which must be (for lack of other references) the detail which loads the subscriber email address. I noticed that many of those addresses are sent in all upper case as they are coming from an older database. In order to unify the tables appearance (and to master the function) I'd like to convert the case of the email to all lower case every time.


SET @ts_sub = CreateObject("Subscriber")
SetObjectProperty(@ts_sub, "EmailAddress", RequestParameter("email"))

I'm wondering if the AMPscript function

%%=Lowercase(@name)=%%

can be added in here to force the case change but I don't want to risk breaking the script.

Improve this question
6
  • Are you thinking that the casing of the email is allowing the records to be duplicated - or has that issue been resolved, and you are now just wanting to ensure lowercase insertions?
    – Kelly J Andrews
    Dec 18, 2013 at 19:50
  • Johnny - would you mind splitting this into two questions, so we can answer each individually - thanks!
    – Kelly J Andrews
    Dec 19, 2013 at 18:57
  • 1
    Kelly J. - It's actually just the one question wondering how to ensure the data going into the extension is all lower case. The double post was a concern before but when I removed my upsert entirely, the code inserted for the triggered send apparently performs the data insert also. That code was supplied by someone else here and I'm not sure how it does what it does, but it works so I'm fine with that.
    – Jonny Shaw
    Dec 20, 2013 at 14:23
  • Got it - wasn't sure what the actual question was from the title. Answer posted.
    – Kelly J Andrews
    Dec 20, 2013 at 14:42
  • Is this question answered for you, or no?
    – Kelly J Andrews
    Feb 28, 2014 at 20:36

1 Answer 1

Reset to default
3

In order to ensure lowercase email address going into the data, try the following code - 

SET @ts_sub = CreateObject("Subscriber")
SetObjectProperty(@ts_sub, "EmailAddress", Lowercase(RequestParameter("email")))
Improve this answer
1
  • ^ Exactly what the job required.
    – Jonny Shaw
    Jun 3, 2014 at 13:05

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .