[SalesForce] Exact Target upsertDE to more than one Data extension

I currently have a landing page which I'm writing the data to a Data Extension is it possible to write the same data for two different data extension at the same time?

currently i am using upsertDE Ampscript and cant get it to write to the second Data Extension

any help appreciated

Best Answer

Really, the only option is to run multiple upsertDE functions in your AMPscript block.

For example:

%%[

SET @DE1 = "dataextension_1"
SET @DE2 = "dataextension_2"

SET @attr1 = RequestParamater(attr1)
SET @attr2 = RequestParamater(attr2)

IF NOT EMPTY(attr1) AND NOT EMPTY(@attr2) THEN
upsertDE(@DE1, 1, "attr1",@attr1,"attr2",@attr2)
upsertDE(@DE2, 1, "attr1",@attr1,"attr2",@attr2)
ENDIF
]%%

Related Solutions

[SalesForce] Exact Target Data Extension and special characters – HTML markup

Are you adding them via .csv? If the encoding of the file that is storing the information is Unicode (or whatever encoding is needed) the Data Extension should accept it correctly since you said they are set to a field type of 'text.'

[SalesForce] Ampscript to detect if email in another another data extension in exact target

This definitely possible. You would use a conditional statement as described in the documentation

%%[IF expression1 <comparison operator> expression2 THEN]%%
    [wrapped script or email content]
%%[ELSEIF expression1 <comparison operator> expression3 THEN]%%
    [wrapped script or email content]
%%[ELSE]%%
    [wrapped script or email content]
%%[ENDIF]%%

In your particular case you will also need a DataExtension AMPScript function as well.

Lookup("DEAllMembers","email_address","email_address", emailaddr)
Lookup("DESpecialMembers","email_address","email_address", emailaddr)

Your final AMP script would look something like this -

%%[
    SET @all    Lookup("DEAllMembers","email_address","email_address", emailaddr)
    SET @special    Lookup("DESpecialMembers","email_address","email_address", emailaddr)

    IF EMPTY(@all) AND EMPTY(@special) THEN
]%%

<p>Your content here</p>

%%[ENDIF]%%

Best Answer

Related Solutions

[SalesForce] Exact Target Data Extension and special characters – HTML markup

[SalesForce] Ampscript to detect if email in another another data extension in exact target

Related Topic