Welcome to Vortx Community Forum, where you can ask questions and receive answers from the staff at Vortx and other members of the community.

If you had a user account on our previous forums website, you will need to register a new account here.

Learn more about...

AspDotNetStorefront
DotFeed

How to add FirstName and LastName to welecome email - xmlpackage?

MULTISTORE VERSION: 9.4.0.0


Hi,

I'm trying to customize the welcome email xml package.   I want to start with :


Dear FirstName LastName,

Welcome to .. . .. 


...


..


Thank you,


...



But I can't seem to get the firstname and last name to apear in the email that gets sent out.

Here is my xml package:

Any help?






<query name="Customer" rowElementName="Item">
 <sql>
 <![CDATA[
 select customerid, firstname, lastname from customer where customerid = @customerid
 ]]>
 </sql>
 <queryparam paramname="@customerid" paramtype="runtime" requestparamname="customerid" defvalue="0" sqlDataType="int" validationpattern="^\d{1,9}$"/>
 </query>


<PackageTransform>
xsl:param name="firstname" select="/root/Customer/Item/firstname" />
<xsl:param name="lastname" select="/root/Customer/Item/lastname" />
.
.
.
.
<xsl:template match="/">
<head>
<title></title>
</head>

.
.
<xsl:variable name="customerName">
 <xsl:value-of select="$firstname"/>&#0160;<xsl:value-of select="$lastname"/>
</xsl:variable>


Dear <xsl:value-of select="$customerName" />,

.
.
.
.
.
</xsl:template>
</PackageTransform>
</package>

 

asked Jan 25, 2014 in MultiStore by vultureds (495 points)

1 Answer

0 votes
 
Best answer
This is from an older version but its what we used to get it to work

 

http://forumarchive.vortx.com/threads/19716-how-to-get-Customer-name-in-welcome-email.html
answered Jan 27, 2014 by Skriver (2,345 points)
selected Feb 18, 2014 by vultureds
Thanks so much!!
...