Shipping URL in delivery email

[joe.pr...@dynamiccolour.co.uk]

Hi All, I wonder if this will be obvious to some of you! I'm having trouble getting the tracking URL for shipments to show up in the delivery confirmation email. Here's what I've done so far:

1. Added a new entry into Message Template SQL named ShipData (I saw how to do that in another post here) - value of SQL is as follows:

exec('SELECT DPS.Name as ServiceName, CreationDate, ShipDate,
RTRIM(LTRIM(TrackingNumber)),
REPLACE(REPLACE(RTRIM(LTRIM(DPS.TrackingLinkFormat)), ''{0}'',
RTRIM(LTRIM(TrackingNumber))), '' '', '''') as TrackingURL   from
Delivery join DeliveryProviderService DPS on
DPS.DeliveryProviderServiceId=Delivery.DeliveryServiceId
where Delivery.DeliveryId =' + @DeliveryId)

2. Modified the message template to include the following:

<xsl:if test="//Sqls/ShipData/Row/TrackingNumber!=''">
  <td>
    <a>
      <xsl:attribute name="href">
        <xsl:value-of select="//Sqls/ShipData/Row/TrackingURL" />
      </xsl:attribute>
      <xsl:value-of select="//Sqls/ShipData/Row/TrackingNumber" />
    </a>
  </td>
</xsl:if>

And yet there is till no tracking link in the email sent by uStore when I create a new delivery... I'mn sure it's going to be something small I've missed but I can't for the life of me see it...

Cheers

Joe

[Braam Ekermans]

Hi

 

I did it a little simpler.

 

Message TemplateSQL entry:

exec('SELECT TrackingNumber FROM Delivery WHERE DeliveryID = ' + @DeliveryID)

 

Named it TrackingNumber

 

 

Message template code added:

Your tracking number is: <strong>

      <xsl:value-of select="//Sqls/TrackingNumber/Row/TrackingNumber" />

    </strong>.

 

 

Hope this helps.

 

Kind Regards

Confidential: This email and its attachments may contain confidential and privileged information. If you are not the intended recipient, you are not authorized to retain, copy, or distribute the email message or its attachments. If you received this email in error, please notify the sender immediately.

--
You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users...@googlegroups.com.
To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

[Jon Chan]

Hi Braam,

I have a need for this as well,

I've added the Message SQL as the attached screen shot and changed an order to delivering,

but there is no tracking number in the email,

any ideas?

would love to get this working!

Thanks!

[Braam Ekermans]

Hi

 

I see you do not have the message template ID in your Ustore SQL entry. Looks like that is the problem.

 

[Jon Chan]

Hey Braam,

When i enter a message template ID,

i get this error

look familiar at all?

Thanks,

Jon Chan

Beyond Digital Imaging Inc.

36 Apple Creek Blvd.,

Markham, Ontario L3R 4Y4

Tel: 905-415-1888 ext.218

Cell: 647-988-8846

To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users+unsubscribe@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "XMPie Interest Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/xmpie-users/MiJW86KCZNs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to xmpie-users+unsubscribe@googlegroups.com.

[Braam Ekermans]

Hi

 

No Im not sure what the issue is here. Maybe someone else does. You definitely don’t have another “TrackingNumber” entry for that same same message template id?

 

Confidential: This email and its attachments may contain confidential and privileged information. If you are not the intended recipient, you are not authorized to retain, copy, or distribute the email message or its attachments. If you received this email in error, please notify the sender immediately.

 

 

From: jon.m...@gmail.com [mailto:jon.m...@gmail.com] On Behalf Of Jon Chan
Sent: Monday, 08 August 2016 3:19 PM
To: xmpie...@googlegroups.com
Subject: Re: [xmpie-users] Shipping URL in delivery email

 

Hey Braam,

--

You received this message because you are subscribed to a topic in the Google Groups "XMPie Interest Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/xmpie-users/MiJW86KCZNs/unsubscribe.

To unsubscribe from this group and all its topics, send an email to xmpie-users...@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

[Jon Chan]

Hey Braam,

ya that's the only one,

i'll open a case with XMPie support,

so if i fill in message template ID, 

i just add your XLST code and then it should work?

Thanks,

Jon Chan

Beyond Digital Imaging Inc.

36 Apple Creek Blvd.,

Markham, Ontario L3R 4Y4

Tel: 905-415-1888 ext.218

Cell: 647-988-8846

To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users+unsubscribe@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "XMPie Interest Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/xmpie-users/MiJW86KCZNs/unsubscribe.

To unsubscribe from this group and all its topics, send an email to xmpie-users+unsubscribe@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users+unsubscribe@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "XMPie Interest Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/xmpie-users/MiJW86KCZNs/unsubscribe.

To unsubscribe from this group and all its topics, send an email to xmpie-users+unsubscribe@googlegroups.com.

[Braam Ekermans]

Hi

 

Yes definitely, works perfectly on my side.

 

Good luck, I hope they can help you quickly.

--

You received this message because you are subscribed to a topic in the Google Groups "XMPie Interest Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/xmpie-users/MiJW86KCZNs/unsubscribe.

To unsubscribe from this group and all its topics, send an email to xmpie-users...@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users...@googlegroups.com.
To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to a topic in the Google Groups "XMPie Interest Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/xmpie-users/MiJW86KCZNs/unsubscribe.

To unsubscribe from this group and all its topics, send an email to xmpie-users...@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

[Jon Chan]

thanks Braam!

Thanks,

Jon Chan

Beyond Digital Imaging Inc.

36 Apple Creek Blvd.,

Markham, Ontario L3R 4Y4

Tel: 905-415-1888 ext.218

Cell: 647-988-8846

To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users+unsubscribe@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "XMPie Interest Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/xmpie-users/MiJW86KCZNs/unsubscribe.

To unsubscribe from this group and all its topics, send an email to xmpie-users+unsubscribe@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users+unsubscribe@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "XMPie Interest Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/xmpie-users/MiJW86KCZNs/unsubscribe.

To unsubscribe from this group and all its topics, send an email to xmpie-users+unsubscribe@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users+unsubscribe@googlegroups.com.

To post to this group, send email to xmpie...@googlegroups.com.
Visit this group at https://groups.google.com/group/xmpie-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "XMPie Interest Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/xmpie-users/MiJW86KCZNs/unsubscribe.

To unsubscribe from this group and all its topics, send an email to xmpie-users+unsubscribe@googlegroups.com.

[Doug Reigelsperger]

I had to throw it into a variable to get it to work correctly

 

Your tracking number is: <xsl:variable name="track_id">

            <xsl:value-of select="//Sqls/ShipData/Row/TrackingNumber" />

          </xsl:variable>

            - <a href="http://wwwapps.ups.com/WebTracking/track?track=yes&amp;trackNums=?{$track_id}">

          <xsl:value-of select="//Sqls/ShipData/Row/TrackingNumber" />

[Jon Chan]

i'll try this out

thanks doug!

[Jon Chan]

Hey Doug,

When i use {$track_id}

it shows up in the triggered email in plain text, instead of displaying the variable contents ( i don't know how to use XSL)

any ideas?

[Jon Chan]

nevermind

it's inexplicably working now

thanks!