Jon_Wright
Level 3
Contact Me
| Online Status |
Online
|
| Date Last Visited |
5 hours ago
|
Top Badges Earned
Customize up to 8 badges at the top of your trophy case for all other Community members to see!-
Affirm 3
Earned on 10.20.21
Earned by 164 people
Select to learn more
-
Boost 3
Earned on 6.25.21
Earned by 1343 people
Select to learn more
-
Affirm 1
Earned on 3.23.21
Earned by 458 people
Select to learn more
-
Give Back 25
Earned on 3.02.21
Earned by 256 people
Select to learn more
-
Validate 1
Earned on 2.08.21
Earned by 377 people
Select to learn more
-
Give Back 5
Earned on 2.08.21
Earned by 809 people
Select to learn more
-
Ignite 5
Earned on 2.08.21
Earned by 451 people
Select to learn more
-
Give Back 3
Earned on 2.08.21
Earned by 1204 people
Select to learn more
a week ago
1 Like
Hi Sophie - you may want to look into the use of a 3rd Party tool for this, we use RingLead but sure there are many others out there. This will give you much more control over how you convert your leads.
... View more
a week ago
Hi
I've seen a few discussions on this but couldn't find an answer. For our last email send we saw a large number of 'Malformed links' in the email link performance report
We're using Velocity to output the links based on @SanfordWhiteman code to get around the tracking bug
This has always worked well, the only difference this time is we are also using (another Sanford trick) to get around tracking bulletproof buttons in Outlook
This is code for renaming link variables
#foreach( $session in $all_listings )
#set( $downloadLink = $session.sessionURL )
#evaluate( "${esc.h}set( ${esc.d}downloadLink_${foreach.index} = ${esc.d}downloadLink )" )
#end
Then output like so (first the VML for Outlook, then the HTML for everything else)
<tr>
<td align="center">
<!--[if mso]>
#if( $foreach.index.equals(0) )
<a:roundrect xmlns:a="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" href="https://${downloadLink_0}" style="height:44px;v-text-anchor:middle;width:230px;" arcsize="100%" strokecolor="#e0121d" fillcolor="#e0121d">
#elseif( $foreach.index.equals(1) )
<a:roundrect xmlns:a="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" href="https://${downloadLink_1}" style="height:44px;v-text-anchor:middle;width:230px;" arcsize="100%" strokecolor="#e0121d" fillcolor="#e0121d">
#elseif( $foreach.index.equals(2) )
<a:roundrect xmlns:a="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" href="https://${downloadLink_2}" style="height:44px;v-text-anchor:middle;width:230px;" arcsize="100%" strokecolor="#e0121d" fillcolor="#e0121d">
#elseif( $foreach.index.equals(3) )
<a:roundrect xmlns:a="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" href="https://${downloadLink_3}" style="height:44px;v-text-anchor:middle;width:230px;" arcsize="100%" strokecolor="#e0121d" fillcolor="#e0121d">
#elseif( $foreach.index.equals(4) )
<a:roundrect xmlns:a="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" href="https://${downloadLink_4}" style="height:44px;v-text-anchor:middle;width:230px;" arcsize="100%" strokecolor="#e0121d" fillcolor="#e0121d">
#elseif( $foreach.index.equals(5) )
<a:roundrect xmlns:a="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" href="https://${downloadLink_5}" style="height:44px;v-text-anchor:middle;width:230px;" arcsize="100%" strokecolor="#e0121d" fillcolor="#e0121d">
#end
<w:anchorlock/>
<center style="color:#ffffff;font-family:arial;font-size:14px;font-weight:normal;">REGISTER</center>
</a:roundrect>
<![endif]-->
#if( $foreach.index.equals(0) )
<a href="https://${downloadLink_0}" style="background-color:#e0121d;border:1px solid #e0121d;border-radius:50px;color:#ffffff;display:inline-block;font-family:arial;font-size:14px;font-weight:500;line-height:44px;text-align:center;text-decoration:none;width:230px;-webkit-text-size-adjust:none;mso-hide:all;">
#elseif( $foreach.index.equals(1) )
<a href="https://${downloadLink_1}" style="background-color:#e0121d;border:1px solid #e0121d;border-radius:50px;color:#ffffff;display:inline-block;font-family:arial;font-size:14px;font-weight:500;line-height:44px;text-align:center;text-decoration:none;width:230px;-webkit-text-size-adjust:none;mso-hide:all;">
#elseif( $foreach.index.equals(2) )
<a href="https://${downloadLink_2}" style="background-color:#e0121d;border:1px solid #e0121d;border-radius:50px;color:#ffffff;display:inline-block;font-family:arial;font-size:14px;font-weight:500;line-height:44px;text-align:center;text-decoration:none;width:230px;-webkit-text-size-adjust:none;mso-hide:all;">
#elseif( $foreach.index.equals(3) )
<a href="https://${downloadLink_3}" style="background-color:#e0121d;border:1px solid #e0121d;border-radius:50px;color:#ffffff;display:inline-block;font-family:arial;font-size:14px;font-weight:500;line-height:44px;text-align:center;text-decoration:none;width:230px;-webkit-text-size-adjust:none;mso-hide:all;">
#elseif( $foreach.index.equals(4) )
<a href="https://${downloadLink_4}" style="background-color:#e0121d;border:1px solid #e0121d;border-radius:50px;color:#ffffff;display:inline-block;font-family:arial;font-size:14px;font-weight:500;line-height:44px;text-align:center;text-decoration:none;width:230px;-webkit-text-size-adjust:none;mso-hide:all;">
#elseif( $foreach.index.equals(5) )
<a href="https://${downloadLink_5}" style="background-color:#e0121d;border:1px solid #e0121d;border-radius:50px;color:#ffffff;display:inline-block;font-family:arial;font-size:14px;font-weight:500;line-height:44px;text-align:center;text-decoration:none;width:230px;-webkit-text-size-adjust:none;mso-hide:all;">
#end
REGISTER</a>
</td>
</tr>
Links all appear to work as expected when I send a live version to various email clients (Outlook 2016 included) so not sure how to troubleshoot further? Support have given the usual ' browser mangling the unique identifier' response, but given the volume (over 200 in report compared to usually maybe 1 or 2) think there must be something else happening here.
Thanks
Jon
... View more
07-22-2021
12:52 PM
Hi, can anybody ( @SanfordWhiteman ) help me with escaping double quotes in a Velocity. I have a value that contains some HTML that I'd like to output e.g. I want to output the body_copy value so it contains hyperlinked text (aware I'll probably need to add mktNoTrack to this so it works)
Have tried single backslash, double backslash but neither seem to work.
#set( $sessions = {
"Tech":{
"session_name":"Test",
"session_url":"dtw.tmforum.org/agenda/the-public-cloud-in-telecoms-an-unstoppable-force/",
"banner_url":"https://info.tmforum.org/rs/021-WLD-815/images/HEADER_digital_twins1.png",
"subject_line":"Meet the digital twins",
"body_copy":"What is the next stage of your digital evolution? <p> This session as part of the <a href="https://dtw.tmforum.org/agenda/the-public-cloud-in-telecoms-an-unstoppable-force/" style="color:#0D2548;font-weight:600">The public cloud in telecoms: an unstoppable force?</a> episode will dive into how integration of multiple deployments will drive the next wave of IoT. And this is way more than theory – you will hear from both Telstra and Microsoft and how they partnered to overcome challenges around security, privacy, interoperability and developer productivity. </p>",
"session_speakers":[
{
"speaker_name":"",
"speaker_title":"",
"speaker_image":"",
"speaker_logo":""
},
{
"speaker_name":"",
"speaker_title":"",
"speaker_image":"",
"speaker_logo":""
}
]
}
}
)
Thanks
... View more
Labels:
06-25-2021
08:13 AM
1 Like
Firstly, make sure you have checked off your lead.storeNumber field from the tree on the right-hand side. But as Sanford says, and he's always right on these things, easier to use a list and see if it contains the value e.g.
#set($store = $lead.storeNumber )
#set($storeList = [ "100","102","103","104","106","107","108","110","112","114","115","116","117","120","121","12","123","124","125","128","129","132","133","134","135","136","139","140","141","142","147","48","150","151","152","153","154","156","158","159","160","161","162","163","164","165","166","301","305","307","308","310","311","312","313","316","317","319","320","321","322","325","329","330","8000","8006","8007","8015","8016","8023","8026","8029","8036","8045","8055"] )
#if($storeList.contains($store))
here's version one!
#else
here's the default!
#end
Note this is not converting the storeNumber to a Number, but if you need to do that you can use
#set($store = $convert.toInteger($lead.storeNumber) )
and then your list of stores wouldn't contain the quotes. But $convert.toInteger will throw an error if the field doesn't contain a 'number'
FYI - Sanford's blog is a great resource for Velocity tips: https://blog.teknkl.com/tag/velocity/
... View more
06-24-2021
08:01 AM
1 Like
Going to try and beat @SanfordWhiteman to this one, but this should do it rather than the for loop.
$display.list($productsValues, ", ", " and ")
Sure Sanford has feedback on how do do all of this more succinctly though.
... View more
06-11-2021
09:51 AM
Hi, does anybody know what might be causing an intermittent 'Submission Failed' message on this LP
https://info.tmforum.org/GAF-BT-Product-Modelling-Scheme.html
Seems to have only started today, as far as I'm aware. No changes have been made to LP template, or actual LP
I see some related posts e.g. https://nation.marketo.com/t5/product-discussions/help-forms-embedded-on-wordpress-receiving-submission-failed/m-p/311524#M175896
But don't see that the form is loading from 2 different places.
Thanks
Jon
... View more
03-23-2021
02:48 AM
Thanks for confirming. Saves me tearing any more hair out.
... View more
03-10-2021
07:30 AM
thanks @SanfordWhiteman only just picked this up. I was kind of hoping to avoid an if statement as potentially could have up to 20 different links
... View more
03-03-2021
03:08 AM
@SanfordWhiteman thanks, missed the markdown option.
I'll admit I'm a bit stumped how I can create a new object from the current object without referencing the current object. Just always seems I'm shifting the reference around. I tried mixing up lots of code snippets to get a 'map-y string' and converting back to a map, but that didn't work either i.e.:
#set( $member_cta = {
1 : {"text": "Members get more: ",
"link_text": "Text 1",
"url": "www.tmforum.org/toolkits-overview/?l=1",
"campaign": "member-footer"
},
2 : {"text": "Text 2",
"link_text": "Link text 2",
"url": "www.tmforum.org/toolkits-overview/?l=2",
"campaign": "member-footer"
},
3 : {"text": "Text 3",
"link_text": "Link text 3",
"url": "www.tmforum.org/toolkits-overview/?l=3",
"campaign": "member-footer"
}
})
#foreach( $key in $member_cta )
#set( $downloadLink = $member_cta[$foreach.count] )
#evaluate( "${esc.h}set( ${esc.d}downloadLink_${foreach.count} = ${esc.d}downloadLink )" )
#end
#set( $random = $math.random(1,3) )
#set($dynamicsource = "$downloadLink_$random")
#set( $new_map = '#set( $new_map = ' + $dynamicsource + ' )' )
#evaluate( $new_map )
#set($url = $new_map.url)
<div><b>${new_map.text}</b>
<a href="https://${url}" style="color: #ffffff;">
${new_map.link_text}</a>
</div>
... View more
03-02-2021
12:41 PM
Thanks @SanfordWhiteman . I did post there but couldn't get the script to display in the comments so thought better to post over here instead.
So I've tried this (thinking I was creating a new object) but still no joy.
#set( $random = $math.random(0,3) )
#set( $member_cta = {
0 : {"text": "Text 0",
"link_text": "Link text 0",
"url": "www.tmforum.org/toolkits-overview/?l=0",
"campaign": "member-footer"
},
1 : {"text": "Text 1",
"link_text": "Link text 1",
"url": "www.tmforum.org/toolkits-overview/?l=1",
"campaign": "member-footer"
},
2 : {"text": "Text 2",
"link_text": "Link text 2",
"url": "www.tmforum.org/toolkits-overview/?l=2",
"campaign": "member-footer"
}
})
#set($cta = $member_cta[$random])
#set($new = {})
#set($void = $new.put("u", $cta) )
#set($new_url = $new["u"].url)
<div><b>${new["u"].text}</b>
<a href="https://${new_url}" style="color: #ffffff;">
${new["u"].link_text}</a>
$new
</div>
... View more
03-02-2021
08:58 AM
Hi @SanfordWhiteman I've been looking to use this
https://blog.teknkl.com/lightweight-a-b-testing-in-velocity/
but also with different (tracked) links. I'm aware of the multiple tracked links issue but I though renaming the variable would work e.g.
#set( $random = $math.random(0,3) )
#set( $member_cta = {
0 : {"text": "Text 0",
"link_text": "Link text 0",
"url": "www.example.com?l=0"
},
1 : {"text": "Text 1",
"link_text": "Link text 1",
"url": "www.example.com?l=1"
},
2 : {"text": "Text 2",
"link_text": "Link text 2",
"url": "www.example.com?l=2"
}
})
#set($url_new = $member_cta[$random].url)
${member_cta[$random].text}
<a href="https://${url_new}" style="color: #ffffff;">
${member_cta[$random].link_text}</a>
${url_new}
</div>
And indeed it was, but turns out it was only working 'randomly'. I only want to output 1 link, what am I doing wrong here?
Thanks Jon
... View more
10-15-2020
02:49 AM
Hi Sanford
Unfortunately that doesn't seem to work either, although I'm sure you may spot something I'm doing wrong in my code. Here it is in case you wanted to take a look ( I removed a lot of the HTML for simplicity).
This works in preview, but when I send a test the first link in the first outer loop gets overwritten with the first link in the 2nd outer loop. I ended up removing tracking so the links did at least work but think I may have to go back to an if then else statement on each day for this to work with tracking. Any pointers appreciated!
#set( $allSessions =
[
{
"sessionId": "249",
"sessionName": "Beyond Connectivity kick off",
"sessionDay": "Tuesday",
"sessionRunningTime": "15:00-16:30 CET",
"sessionStartISO": "2020-10-13T13:00:00Z",
"sessionStartDateText": "Tuesday 13 October",
"sessionColor": "#dc131b",
"sessionTheme": "Beyond Connectivity",
"sessionCalendar": "ics.agical.io/?subject=Beyond%20Connectivity%20kick%20off&dtstart=2020-10-13T13:00:00Z&dtend=2020-10-13T14:30:00Z&description=https://dtws.tmforum.org/session/249&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/249"
},
{
"sessionId": "247",
"sessionName": "Intro to Collaboration: Autonomous Networks kick off",
"sessionDay": "Tuesday",
"sessionRunningTime": "17:00-18:00 CET",
"sessionStartISO": "2020-10-13T15:00:00Z",
"sessionStartDateText": "Tuesday 13 October",
"sessionColor": "#07c2c7",
"sessionTheme": "Autonomous Networks & the Edge",
"sessionCalendar": "ics.agical.io/?subject=Intro%20to%20Collaboration%3A%20Autonomous%20Networks%20kick%20off&dtstart=2020-10-13T15:00:00Z&dtend=2020-10-13T16:00:00Z&description=https://dtws.tmforum.org/session/247&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/247"
},
{
"sessionId": "166",
"sessionName": "Making autonomous networks a reality",
"sessionDay": "Wednesday",
"sessionRunningTime": "10:00-11:30 CET",
"sessionStartISO": "2020-10-14T08:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#07c2c7",
"sessionTheme": "Autonomous Networks & the Edge",
"sessionCalendar": "ics.agical.io/?subject=Making%20autonomous%20networks%20a%20reality&dtstart=2020-10-14T08:00:00Z&dtend=2020-10-14T09:30:00Z&description=https://dtws.tmforum.org/session/166&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/166"
},
{
"sessionId": "181",
"sessionName": "Catalyst panel - TEST",
"sessionDay": "Wednesday",
"sessionRunningTime": "11:00-11:30 CET",
"sessionStartISO": "2020-10-14T09:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#7b1acb",
"sessionTheme": "AI, Data & Analytics",
"sessionCalendar": "ics.agical.io/?subject=Catalyst%20panel%20-%20TEST&dtstart=2020-10-14T09:00:00Z&dtend=2020-10-14T09:30:00Z&description=https://dtws.tmforum.org/session/181&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/181"
},
{
"sessionId": "226",
"sessionName": "Catalyst showcase panel: AI Ops: Delivering advanced services through intelligent operations",
"sessionDay": "Wednesday",
"sessionRunningTime": "11:10-11:50 CET",
"sessionStartISO": "2020-10-14T09:10:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#7b1acb",
"sessionTheme": "AI, Data & Analytics",
"sessionCalendar": "ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20AI%20Ops%3A%20Delivering%20advanced%20services%20through%20intelligent%20operations&dtstart=2020-10-14T09:10:00Z&dtend=2020-10-14T09:50:00Z&description=https://dtws.tmforum.org/session/226&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/226"
},
{
"sessionId": "145",
"sessionName": "The building blocks for getting organizational transformation right",
"sessionDay": "Wednesday",
"sessionRunningTime": "12:00-13:20 CET",
"sessionStartISO": "2020-10-14T10:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#757679",
"sessionTheme": "The Human Factor",
"sessionCalendar": "ics.agical.io/?subject=The%20building%20blocks%20for%20getting%20organizational%20transformation%20right&dtstart=2020-10-14T10:00:00Z&dtend=2020-10-14T11:20:00Z&description=https://dtws.tmforum.org/session/145&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/145"
},
{
"sessionId": "160",
"sessionName": "CX strategies to win the brand battle",
"sessionDay": "Wednesday",
"sessionRunningTime": "13:00-14:30 CET",
"sessionStartISO": "2020-10-14T11:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#e05500",
"sessionTheme": "Customer Experience & Trust",
"sessionCalendar": "ics.agical.io/?subject=CX%20strategies%20to%20win%20the%20brand%20battle&dtstart=2020-10-14T11:00:00Z&dtend=2020-10-14T12:30:00Z&description=https://dtws.tmforum.org/session/160&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/160"
},
{
"sessionId": "261",
"sessionName": "An Introduction to the Open APIs collaboration project",
"sessionDay": "Wednesday",
"sessionRunningTime": "15:00-16:00 CET",
"sessionStartISO": "2020-10-14T13:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#1a3ca3",
"sessionTheme": "Cloud Native IT & Agility",
"sessionCalendar": "ics.agical.io/?subject=An%20Introduction%20to%20the%20Open%20APIs%20collaboration%20project&dtstart=2020-10-14T13:00:00Z&dtend=2020-10-14T14:00:00Z&description=https://dtws.tmforum.org/session/261&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/261"
},
{
"sessionId": "209",
"sessionName": "Digital Leadership Roundtable: The path to becoming cloud native",
"sessionDay": "Wednesday",
"sessionRunningTime": "16:00-17:45 CET",
"sessionStartISO": "2020-10-14T14:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#1a3ca3",
"sessionTheme": "Cloud Native IT & Agility",
"sessionCalendar": "ics.agical.io/?subject=Digital%20Leadership%20Roundtable%3A%20The%20path%20to%20becoming%20cloud%20native&dtstart=2020-10-14T14:00:00Z&dtend=2020-10-14T15:45:00Z&description=https://dtws.tmforum.org/session/209&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/209"
},
{
"sessionId": "136",
"sessionName": "Wake up to the shared B2B value opportunity",
"sessionDay": "Wednesday",
"sessionRunningTime": "16:30-18:00 CET",
"sessionStartISO": "2020-10-14T14:30:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#dc131b",
"sessionTheme": "Beyond Connectivity",
"sessionCalendar": "ics.agical.io/?subject=Wake%20up%20to%20the%20shared%20B2B%20value%20opportunity&dtstart=2020-10-14T14:30:00Z&dtend=2020-10-14T16:00:00Z&description=https://dtws.tmforum.org/session/136&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/136"
},
{
"sessionId": "263",
"sessionName": "Headliner: New ecosystem dynamics",
"sessionDay": "Wednesday",
"sessionRunningTime": "18:00-18:30 CET",
"sessionStartISO": "2020-10-14T16:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#dc131b",
"sessionTheme": "Beyond Connectivity",
"sessionCalendar": "ics.agical.io/?subject=Headliner%3A%20New%20ecosystem%20dynamics&dtstart=2020-10-14T16:00:00Z&dtend=2020-10-14T16:30:00Z&description=https://dtws.tmforum.org/session/263&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/263"
},
{
"sessionId": "227",
"sessionName": "Catalyst showcase panel: AI Ops: Delivering advanced services through intelligent operations",
"sessionDay": "Wednesday",
"sessionRunningTime": "18:10-18:50 CET",
"sessionStartISO": "2020-10-14T16:10:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#7b1acb",
"sessionTheme": "AI, Data & Analytics",
"sessionCalendar": "ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20AI%20Ops%3A%20Delivering%20advanced%20services%20through%20intelligent%20operations&dtstart=2020-10-14T16:10:00Z&dtend=2020-10-14T16:50:00Z&description=https://dtws.tmforum.org/session/227&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/227"
},
{
"sessionId": "212",
"sessionName": "Catalyst showcase panel: Automating enterprise services delivery through open digital standards",
"sessionDay": "Thursday",
"sessionRunningTime": "09:10-09:50 CET",
"sessionStartISO": "2020-10-15T07:10:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#1a3ca3",
"sessionTheme": "Cloud Native IT & Agility",
"sessionCalendar": "ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20Automating%20enterprise%20services%20delivery%20through%20open%20digital%20standards&dtstart=2020-10-15T07:10:00Z&dtend=2020-10-15T07:50:00Z&description=https://dtws.tmforum.org/session/212&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/212"
},
{
"sessionId": "232",
"sessionName": "Catalyst showcase panel: Innovations for sustainable digital future",
"sessionDay": "Thursday",
"sessionRunningTime": "10:10-10:50 CET",
"sessionStartISO": "2020-10-15T08:10:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#757679",
"sessionTheme": "The Human Factor",
"sessionCalendar": "ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20Innovations%20for%20sustainable%20digital%20future&dtstart=2020-10-15T08:10:00Z&dtend=2020-10-15T08:50:00Z&description=https://dtws.tmforum.org/session/232&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/232"
},
{
"sessionId": "149",
"sessionName": "Getting platform business models right",
"sessionDay": "Thursday",
"sessionRunningTime": "10:30-13:00 CET",
"sessionStartISO": "2020-10-15T08:30:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#dc131b",
"sessionTheme": "Beyond Connectivity",
"sessionCalendar": "ics.agical.io/?subject=Getting%20platform%20business%20models%20right&dtstart=2020-10-15T08:30:00Z&dtend=2020-10-15T11:00:00Z&description=https://dtws.tmforum.org/session/149&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/149"
},
{
"sessionId": "139",
"sessionName": "Laying down winning foundations with AI, analytics and automation",
"sessionDay": "Thursday",
"sessionRunningTime": "11:00-12:20 CET",
"sessionStartISO": "2020-10-15T09:00:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#7b1acb",
"sessionTheme": "AI, Data & Analytics",
"sessionCalendar": "ics.agical.io/?subject=Laying%20down%20winning%20foundations%20with%20AI%2C%20analytics%20and%20automation&dtstart=2020-10-15T09:00:00Z&dtend=2020-10-15T10:20:00Z&description=https://dtws.tmforum.org/session/139&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/139"
},
{
"sessionId": "167",
"sessionName": "Network automation and softwarization capability expansion",
"sessionDay": "Thursday",
"sessionRunningTime": "12:30-14:00 CET",
"sessionStartISO": "2020-10-15T10:30:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#07c2c7",
"sessionTheme": "Autonomous Networks & the Edge",
"sessionCalendar": "ics.agical.io/?subject=Network%20automation%20and%20softwarization%20capability%20expansion&dtstart=2020-10-15T10:30:00Z&dtend=2020-10-15T12:00:00Z&description=https://dtws.tmforum.org/session/167&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/167"
},
{
"sessionId": "245",
"sessionName": "Digital Leadership Roundtable: Intelligent automation is the key to unlocking digital transformation",
"sessionDay": "Thursday",
"sessionRunningTime": "13:00-14:00 CET",
"sessionStartISO": "2020-10-15T11:00:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#e05500",
"sessionTheme": "Customer Experience & Trust",
"sessionCalendar": "ics.agical.io/?subject=Digital%20Leadership%20Roundtable%3A%20Intelligent%20automation%20is%20the%20key%20to%20unlocking%20digital%20transformation&dtstart=2020-10-15T11:00:00Z&dtend=2020-10-15T12:00:00Z&description=https://dtws.tmforum.org/session/245&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/245"
},
{
"sessionId": "161",
"sessionName": "Let''s talk customer centricity",
"sessionDay": "Thursday",
"sessionRunningTime": "14:30-16:00 CET",
"sessionStartISO": "2020-10-15T12:30:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#e05500",
"sessionTheme": "Customer Experience & Trust",
"sessionCalendar": "ics.agical.io/?subject=Let%27%27s%20talk%20customer%20centricity&dtstart=2020-10-15T12:30:00Z&dtend=2020-10-15T14:00:00Z&description=https://dtws.tmforum.org/session/161&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/161"
},
{
"sessionId": "213",
"sessionName": "Catalyst showcase panel: Automating enterprise services delivery through open digital standards",
"sessionDay": "Thursday",
"sessionRunningTime": "15:10-15:50 CET",
"sessionStartISO": "2020-10-15T13:10:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#1a3ca3",
"sessionTheme": "Cloud Native IT & Agility",
"sessionCalendar": "ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20Automating%20enterprise%20services%20delivery%20through%20open%20digital%20standards&dtstart=2020-10-15T13:10:00Z&dtend=2020-10-15T13:50:00Z&description=https://dtws.tmforum.org/session/213&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/213"
},
{
"sessionId": "211",
"sessionName": "CXO Summit: Failing fast, learning faster",
"sessionDay": "Thursday",
"sessionRunningTime": "16:30-18:00 CET",
"sessionStartISO": "2020-10-15T14:30:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#757679",
"sessionTheme": "The Human Factor",
"sessionCalendar": "ics.agical.io/?subject=CXO%20Summit%3A%20Failing%20fast%2C%20learning%20faster&dtstart=2020-10-15T14:30:00Z&dtend=2020-10-15T16:00:00Z&description=https://dtws.tmforum.org/session/211&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/211"
},
{
"sessionId": "233",
"sessionName": "Catalyst showcase panel: Innovations for sustainable digital future",
"sessionDay": "Thursday",
"sessionRunningTime": "18:10-18:50 CET",
"sessionStartISO": "2020-10-15T16:10:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#757679",
"sessionTheme": "The Human Factor",
"sessionCalendar": "ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20Innovations%20for%20sustainable%20digital%20future&dtstart=2020-10-15T16:10:00Z&dtend=2020-10-15T16:50:00Z&description=https://dtws.tmforum.org/session/233&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/233"
}
]
)
##split semicolon data into list
#if($lead.DTWSJSONBookmarkedSessions.isEmpty() )
#set($personBookmarks = [])
#else
#set($personBookmarks = $lead.DTWSJSONBookmarkedSessions.split(";"))
#end
##get list of person boomarks details
#set( $personBookmarkDetails = [] )
#foreach( $session in $allSessions )
#if($personBookmarks.contains($session.sessionId))
#set( $void = $personBookmarkDetails.add($session) )
#end
#end
##get unique list of days person has boomarks for
#set( $personBookmarkDays = [] )
#foreach( $session in $personBookmarkDetails )
#if(!$personBookmarkDays.contains($session.sessionDay))
#set( $void = $personBookmarkDays.add($session.sessionDay) )
#end
#end
##Check not empty
#if( $personBookmarkDetails.isEmpty() )
#else
##Loop over the days person has bookmarks for
#foreach($day in $personBookmarkDays)
${day}
##get list of person boomarks details by day
#set( $personBookmarkDetailsByDay = [] )
#foreach( $bookmark in $personBookmarkDetails )
#if($bookmark.sessionDay == $day)
#set( $void = $personBookmarkDetailsByDay.add($bookmark) )
#end
#end
##output calendar links for each day
#foreach( $bmark in $personBookmarkDetailsByDay )
#set( $downloadLink = $bmark )
#evaluate( "${esc.h}set( ${esc.d}downloadLink_${foreach.count} = ${esc.d}downloadLink )" )
#end
#if( $downloadLink_1 )
<a href="http://${downloadLink_1.sessionCalendar}" target="_blank">${downloadLink_1.sessionName}</a>
#end
#if( $downloadLink_2 )
<a href="http://${downloadLink_2.sessionCalendar}" target="_blank">${downloadLink_2.sessionName}</a>
#end
#end
#end
... View more
10-12-2020
12:27 PM
Hi
I'm running into some issues outputting multiple tracked links using Velocity, I know Marketo doesn't allow for this so you have to use a workaround (cue shout out to Sanford's blog piece)
But I still seem to have links overwritten when using the script below. I'm pretty sure it must be something to do with the nested foreach loops as the workaround works fine in other emails. Note, I'm actually using a different workaround supplied by Sanford here https://nation.marketo.com/t5/Product-Discussions/Conditional-forEach-statement-in-Velocity-Script/td-p/60387
This works fine in preview, but when I send a test the tracked links go to the wrong urls
Quick summary of script.
It's selecting a lead's sessions from the allSession JSON, using a semi colon separated list of session ids contained in a lead field
Setting a unique list of days the lead has sessions for
Looping over the the list of days and then looping over a separate list of sessions for that day and outputting those
e.g.
MON: session 1, session 4, session 6
WED: session 7, session 9, session 9
Maybe I've overcomplicated this, I did start building a separate token for each day but nested loops seemed more fun...
@SanfordWhiteman I know you love this stuff...
#set( $allSessions =
[
{
"sessionId": "249",
"sessionName": "Beyond Connectivity kick off",
"sessionDay": "Tuesday",
"sessionRunningTime": "15:00-16:30 CET",
"sessionStartISO": "2020-10-13T13:00:00Z",
"sessionStartDateText": "Tuesday 13 October",
"sessionColor": "#dc131b",
"sessionTheme": "Beyond Connectivity",
"sessionCalendar": "https://ics.agical.io/?subject=Beyond%20Connectivity%20kick%20off&dtstart=2020-10-13T13:00:00Z&dtend=2020-10-13T14:30:00Z&description=https://dtws.tmforum.org/session/249&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/249"
},
{
"sessionId": "247",
"sessionName": "Intro to Collaboration: Autonomous Networks kick off",
"sessionDay": "Tuesday",
"sessionRunningTime": "17:00-18:00 CET",
"sessionStartISO": "2020-10-13T15:00:00Z",
"sessionStartDateText": "Tuesday 13 October",
"sessionColor": "#07c2c7",
"sessionTheme": "Autonomous Networks & the Edge",
"sessionCalendar": "https://ics.agical.io/?subject=Intro%20to%20Collaboration%3A%20Autonomous%20Networks%20kick%20off&dtstart=2020-10-13T15:00:00Z&dtend=2020-10-13T16:00:00Z&description=https://dtws.tmforum.org/session/247&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/247"
},
{
"sessionId": "166",
"sessionName": "Making autonomous networks a reality",
"sessionDay": "Wednesday",
"sessionRunningTime": "10:00-11:30 CET",
"sessionStartISO": "2020-10-14T08:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#07c2c7",
"sessionTheme": "Autonomous Networks & the Edge",
"sessionCalendar": "https://ics.agical.io/?subject=Making%20autonomous%20networks%20a%20reality&dtstart=2020-10-14T08:00:00Z&dtend=2020-10-14T09:30:00Z&description=https://dtws.tmforum.org/session/166&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/166"
},
{
"sessionId": "181",
"sessionName": "Catalyst panel - TEST",
"sessionDay": "Wednesday",
"sessionRunningTime": "11:00-11:30 CET",
"sessionStartISO": "2020-10-14T09:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#7b1acb",
"sessionTheme": "AI, Data & Analytics",
"sessionCalendar": "https://ics.agical.io/?subject=Catalyst%20panel%20-%20TEST&dtstart=2020-10-14T09:00:00Z&dtend=2020-10-14T09:30:00Z&description=https://dtws.tmforum.org/session/181&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/181"
},
{
"sessionId": "226",
"sessionName": "Catalyst showcase panel: AI Ops: Delivering advanced services through intelligent operations",
"sessionDay": "Wednesday",
"sessionRunningTime": "11:10-11:50 CET",
"sessionStartISO": "2020-10-14T09:10:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#7b1acb",
"sessionTheme": "AI, Data & Analytics",
"sessionCalendar": "https://ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20AI%20Ops%3A%20Delivering%20advanced%20services%20through%20intelligent%20operations&dtstart=2020-10-14T09:10:00Z&dtend=2020-10-14T09:50:00Z&description=https://dtws.tmforum.org/session/226&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/226"
},
{
"sessionId": "145",
"sessionName": "The building blocks for getting organizational transformation right",
"sessionDay": "Wednesday",
"sessionRunningTime": "12:00-13:20 CET",
"sessionStartISO": "2020-10-14T10:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#757679",
"sessionTheme": "The Human Factor",
"sessionCalendar": "https://ics.agical.io/?subject=The%20building%20blocks%20for%20getting%20organizational%20transformation%20right&dtstart=2020-10-14T10:00:00Z&dtend=2020-10-14T11:20:00Z&description=https://dtws.tmforum.org/session/145&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/145"
},
{
"sessionId": "160",
"sessionName": "CX strategies to win the brand battle",
"sessionDay": "Wednesday",
"sessionRunningTime": "13:00-14:30 CET",
"sessionStartISO": "2020-10-14T11:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#e05500",
"sessionTheme": "Customer Experience & Trust",
"sessionCalendar": "https://ics.agical.io/?subject=CX%20strategies%20to%20win%20the%20brand%20battle&dtstart=2020-10-14T11:00:00Z&dtend=2020-10-14T12:30:00Z&description=https://dtws.tmforum.org/session/160&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/160"
},
{
"sessionId": "261",
"sessionName": "An Introduction to the Open APIs collaboration project",
"sessionDay": "Wednesday",
"sessionRunningTime": "15:00-16:00 CET",
"sessionStartISO": "2020-10-14T13:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#1a3ca3",
"sessionTheme": "Cloud Native IT & Agility",
"sessionCalendar": "https://ics.agical.io/?subject=An%20Introduction%20to%20the%20Open%20APIs%20collaboration%20project&dtstart=2020-10-14T13:00:00Z&dtend=2020-10-14T14:00:00Z&description=https://dtws.tmforum.org/session/261&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/261"
},
{
"sessionId": "209",
"sessionName": "Digital Leadership Roundtable: The path to becoming cloud native",
"sessionDay": "Wednesday",
"sessionRunningTime": "16:00-17:45 CET",
"sessionStartISO": "2020-10-14T14:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#1a3ca3",
"sessionTheme": "Cloud Native IT & Agility",
"sessionCalendar": "https://ics.agical.io/?subject=Digital%20Leadership%20Roundtable%3A%20The%20path%20to%20becoming%20cloud%20native&dtstart=2020-10-14T14:00:00Z&dtend=2020-10-14T15:45:00Z&description=https://dtws.tmforum.org/session/209&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/209"
},
{
"sessionId": "136",
"sessionName": "Wake up to the shared B2B value opportunity",
"sessionDay": "Wednesday",
"sessionRunningTime": "16:30-18:00 CET",
"sessionStartISO": "2020-10-14T14:30:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#dc131b",
"sessionTheme": "Beyond Connectivity",
"sessionCalendar": "https://ics.agical.io/?subject=Wake%20up%20to%20the%20shared%20B2B%20value%20opportunity&dtstart=2020-10-14T14:30:00Z&dtend=2020-10-14T16:00:00Z&description=https://dtws.tmforum.org/session/136&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/136"
},
{
"sessionId": "263",
"sessionName": "Headliner: New ecosystem dynamics",
"sessionDay": "Wednesday",
"sessionRunningTime": "18:00-18:30 CET",
"sessionStartISO": "2020-10-14T16:00:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#dc131b",
"sessionTheme": "Beyond Connectivity",
"sessionCalendar": "https://ics.agical.io/?subject=Headliner%3A%20New%20ecosystem%20dynamics&dtstart=2020-10-14T16:00:00Z&dtend=2020-10-14T16:30:00Z&description=https://dtws.tmforum.org/session/263&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/263"
},
{
"sessionId": "227",
"sessionName": "Catalyst showcase panel: AI Ops: Delivering advanced services through intelligent operations",
"sessionDay": "Wednesday",
"sessionRunningTime": "18:10-18:50 CET",
"sessionStartISO": "2020-10-14T16:10:00Z",
"sessionStartDateText": "Wednesday 14 October",
"sessionColor": "#7b1acb",
"sessionTheme": "AI, Data & Analytics",
"sessionCalendar": "https://ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20AI%20Ops%3A%20Delivering%20advanced%20services%20through%20intelligent%20operations&dtstart=2020-10-14T16:10:00Z&dtend=2020-10-14T16:50:00Z&description=https://dtws.tmforum.org/session/227&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/227"
},
{
"sessionId": "212",
"sessionName": "Catalyst showcase panel: Automating enterprise services delivery through open digital standards",
"sessionDay": "Thursday",
"sessionRunningTime": "09:10-09:50 CET",
"sessionStartISO": "2020-10-15T07:10:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#1a3ca3",
"sessionTheme": "Cloud Native IT & Agility",
"sessionCalendar": "https://ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20Automating%20enterprise%20services%20delivery%20through%20open%20digital%20standards&dtstart=2020-10-15T07:10:00Z&dtend=2020-10-15T07:50:00Z&description=https://dtws.tmforum.org/session/212&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/212"
},
{
"sessionId": "232",
"sessionName": "Catalyst showcase panel: Innovations for sustainable digital future",
"sessionDay": "Thursday",
"sessionRunningTime": "10:10-10:50 CET",
"sessionStartISO": "2020-10-15T08:10:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#757679",
"sessionTheme": "The Human Factor",
"sessionCalendar": "https://ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20Innovations%20for%20sustainable%20digital%20future&dtstart=2020-10-15T08:10:00Z&dtend=2020-10-15T08:50:00Z&description=https://dtws.tmforum.org/session/232&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/232"
},
{
"sessionId": "149",
"sessionName": "Getting platform business models right",
"sessionDay": "Thursday",
"sessionRunningTime": "10:30-13:00 CET",
"sessionStartISO": "2020-10-15T08:30:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#dc131b",
"sessionTheme": "Beyond Connectivity",
"sessionCalendar": "https://ics.agical.io/?subject=Getting%20platform%20business%20models%20right&dtstart=2020-10-15T08:30:00Z&dtend=2020-10-15T11:00:00Z&description=https://dtws.tmforum.org/session/149&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/149"
},
{
"sessionId": "139",
"sessionName": "Laying down winning foundations with AI, analytics and automation",
"sessionDay": "Thursday",
"sessionRunningTime": "11:00-12:20 CET",
"sessionStartISO": "2020-10-15T09:00:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#7b1acb",
"sessionTheme": "AI, Data & Analytics",
"sessionCalendar": "https://ics.agical.io/?subject=Laying%20down%20winning%20foundations%20with%20AI%2C%20analytics%20and%20automation&dtstart=2020-10-15T09:00:00Z&dtend=2020-10-15T10:20:00Z&description=https://dtws.tmforum.org/session/139&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/139"
},
{
"sessionId": "167",
"sessionName": "Network automation and softwarization capability expansion",
"sessionDay": "Thursday",
"sessionRunningTime": "12:30-14:00 CET",
"sessionStartISO": "2020-10-15T10:30:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#07c2c7",
"sessionTheme": "Autonomous Networks & the Edge",
"sessionCalendar": "https://ics.agical.io/?subject=Network%20automation%20and%20softwarization%20capability%20expansion&dtstart=2020-10-15T10:30:00Z&dtend=2020-10-15T12:00:00Z&description=https://dtws.tmforum.org/session/167&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/167"
},
{
"sessionId": "245",
"sessionName": "Digital Leadership Roundtable: Intelligent automation is the key to unlocking digital transformation",
"sessionDay": "Thursday",
"sessionRunningTime": "13:00-14:00 CET",
"sessionStartISO": "2020-10-15T11:00:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#e05500",
"sessionTheme": "Customer Experience & Trust",
"sessionCalendar": "https://ics.agical.io/?subject=Digital%20Leadership%20Roundtable%3A%20Intelligent%20automation%20is%20the%20key%20to%20unlocking%20digital%20transformation&dtstart=2020-10-15T11:00:00Z&dtend=2020-10-15T12:00:00Z&description=https://dtws.tmforum.org/session/245&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/245"
},
{
"sessionId": "161",
"sessionName": "Let''s talk customer centricity",
"sessionDay": "Thursday",
"sessionRunningTime": "14:30-16:00 CET",
"sessionStartISO": "2020-10-15T12:30:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#e05500",
"sessionTheme": "Customer Experience & Trust",
"sessionCalendar": "https://ics.agical.io/?subject=Let%27%27s%20talk%20customer%20centricity&dtstart=2020-10-15T12:30:00Z&dtend=2020-10-15T14:00:00Z&description=https://dtws.tmforum.org/session/161&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/161"
},
{
"sessionId": "213",
"sessionName": "Catalyst showcase panel: Automating enterprise services delivery through open digital standards",
"sessionDay": "Thursday",
"sessionRunningTime": "15:10-15:50 CET",
"sessionStartISO": "2020-10-15T13:10:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#1a3ca3",
"sessionTheme": "Cloud Native IT & Agility",
"sessionCalendar": "https://ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20Automating%20enterprise%20services%20delivery%20through%20open%20digital%20standards&dtstart=2020-10-15T13:10:00Z&dtend=2020-10-15T13:50:00Z&description=https://dtws.tmforum.org/session/213&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/213"
},
{
"sessionId": "211",
"sessionName": "CXO Summit: Failing fast, learning faster",
"sessionDay": "Thursday",
"sessionRunningTime": "16:30-18:00 CET",
"sessionStartISO": "2020-10-15T14:30:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#757679",
"sessionTheme": "The Human Factor",
"sessionCalendar": "https://ics.agical.io/?subject=CXO%20Summit%3A%20Failing%20fast%2C%20learning%20faster&dtstart=2020-10-15T14:30:00Z&dtend=2020-10-15T16:00:00Z&description=https://dtws.tmforum.org/session/211&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/211"
},
{
"sessionId": "233",
"sessionName": "Catalyst showcase panel: Innovations for sustainable digital future",
"sessionDay": "Thursday",
"sessionRunningTime": "18:10-18:50 CET",
"sessionStartISO": "2020-10-15T16:10:00Z",
"sessionStartDateText": "Thursday 15 October",
"sessionColor": "#757679",
"sessionTheme": "The Human Factor",
"sessionCalendar": "https://ics.agical.io/?subject=Catalyst%20showcase%20panel%3A%20Innovations%20for%20sustainable%20digital%20future&dtstart=2020-10-15T16:10:00Z&dtend=2020-10-15T16:50:00Z&description=https://dtws.tmforum.org/session/233&reminder=30&location=DTW%20Series%20-%20link%20in%20description",
"sessionURL": "https://dtws.tmforum.org/session/233"
}
]
)
##split semicolon data into list
#if($lead.DTWSJSONBookmarkedSessions.isEmpty() )
#set($personBookmarks = [])
#else
#set($personBookmarks = $lead.DTWSJSONBookmarkedSessions.split(";"))
#end
##get list of person bookmarks details
#set( $personBookmarkDetails = [] )
#foreach( $session in $allSessions )
#if($personBookmarks.contains($session.sessionId))
#set( $void = $personBookmarkDetails.add($session) )
#end
#end
##get unique list of days person has boomarks for
#set( $personBookmarkDays = [] )
#foreach( $session in $allSessions )
#if($personBookmarks.contains($session.sessionId)
&& !$personBookmarkDays.contains($session.sessionDay))
#set( $void = $personBookmarkDays.add($session.sessionDay) )
#end
#end
##output heading text
#if( $personBookmarkDetails.isEmpty() )
#else
<!-- SECTION - Heading -->
<!--[if mso | IE]>
<table
align="center" border="0" cellpadding="0" cellspacing="0" class="" style="width:600px;" width="600"
>
<tr>
<td style="line-height:0px;font-size:0px;mso-line-height-rule:exactly;">
<![endif]-->
<div style="background:#FFFFFF;background-color:#FFFFFF;margin:0px auto;max-width:600px;">
<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:#FFFFFF;background-color:#FFFFFF;width:100%;">
<tbody>
<tr>
<td style="border-left:1px solid #2099d0;border-right:1px solid #2099d0;direction:ltr;font-size:0px;padding:0px;text-align:center;">
<!--[if mso | IE]>
<table role="presentation" border="0" cellpadding="0" cellspacing="0">
<tr>
<td
class="" style="vertical-align:top;width:598px;"
>
<![endif]-->
<div class="mj-column-per-100 mj-outlook-group-fix" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;">
<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top;" width="100%">
<tr>
<td align="center" style="font-size:0px;padding:20px;word-break:break-word;">
<div style="font-family:Arial;font-size:24px;font-weight:600;line-height:28px;text-align:center;color:#29303a;">Thanks for building your schedule, here is a reminder of <span style="color: #2099d0;">your week ahead</span></div>
</td>
</tr>
</table>
</div>
<!--[if mso | IE]>
</td>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table>
</div>
<!--[if mso | IE]>
</td>
</tr>
</table>
<![endif]-->
</td>
</tr>
#end
##output bookmarks HTML
#if( $personBookmarkDetails.isEmpty() )
#else
#set($numberOfBookmarks = $personBookmarkDetails.size())
#foreach($day in $personBookmarkDays)
<!-- SECTION - Session Listing -->
<tr class="mktoModule" id="html-block" mktoname="HTML block">
<td>
<!--[if mso | IE]>
<table
align="center" border="0" cellpadding="0" cellspacing="0" class="" style="width:600px;" width="600"
>
<tr>
<td style="line-height:0px;font-size:0px;mso-line-height-rule:exactly;">
<![endif]-->
<div style="margin:0px auto;max-width:600px;">
<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%;">
<tbody>
<tr>
<td style="border-left:1px solid #2099d0;border-right:1px solid #2099d0;direction:ltr;font-size:0px;padding:10px 0px;text-align:center;">
<!--[if mso | IE]>
<table role="presentation" border="0" cellpadding="0" cellspacing="0">
<tr>
<td
class="" style="vertical-align:middle;width:119.6px;"
>
<![endif]-->
<div class="mj-column-per-20 mj-outlook-group-fix" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:middle;width:100%;">
<table border="0" cellpadding="0" cellspacing="0" role="presentation" width="100%">
<tbody>
<tr>
<td style="background-color:#ffffff;vertical-align:middle;padding:20px 0px 10px 0px;">
<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="" width="100%">
<tr>
<td align="center" style="font-size:0px;padding:10px;padding-top:0px;word-break:break-word;">
<div style="font-family:Arial;font-size:40px;line-height:1;text-align:center;color:#2099d0;"><b>${day.substring(0,3).toUpperCase()}</b></div>
</td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<!--[if mso | IE]>
</td>
<td
class="" style="vertical-align:top;width:478.4px;"
>
<![endif]-->
<div class="mj-column-per-80 mj-outlook-group-fix" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;">
<table border="0" cellpadding="0" cellspacing="0" role="presentation" width="100%">
<tbody>
<tr>
<td style="background-color:#ffffff;border-left:8px solid #2099d0;vertical-align:top;padding:10px 0px 10px 0px;">
<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="" width="100%">
<tr>
<td align="left" style="font-size:0px;padding:10px;word-break:break-word;">
<div style="font-family:Arial;font-size:14px;line-height:20px;text-align:left;color:#29303a;">
##get list of person bookmarks details by day
#set( $personBookmarkDetailsByDay = [] )
#foreach( $bookmark in $personBookmarkDetails )
#if($bookmark.sessionDay == $day)
#set( $void = $personBookmarkDetailsByDay.add($bookmark) )
#end
#end
##output calendar links
#foreach($boomark in $personBookmarkDetailsByDay)
<b>• ${boomark.sessionRunningTime}</b> ${boomark.sessionName}
#if( $foreach.index.equals(0) )
#set( $URL_0 = $personBookmarkDetailsByDay[0].sessionCalendar.substring(8))
<a href="https://${URL_0}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(1) )
#set( $URL_1 = $personBookmarkDetailsByDay[1].sessionCalendar.substring(8) )
<a href="https://${URL_1}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(2) )
#set( $URL_2 = $personBookmarkDetailsByDay[2].sessionCalendar.substring(8) )
<a href="https://${URL_2}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(3) )
#set( $URL_3 = $personBookmarkDetailsByDay[3].sessionCalendar.substring(8) )
<a href="https://${URL_3}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(4) )
#set( $URL_4 = $personBookmarkDetailsByDay[4].sessionCalendar.substring(8) )
<a href="https://${URL_4}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(5) )
#set( $URL_5 = $personBookmarkDetailsByDay[5].sessionCalendar.substring(8) )
<a href="https://${URL_5}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(6) )
#set( $URL_6 = $personBookmarkDetailsByDay[6].sessionCalendar.substring(8) )
<a href="https://${URL_6}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(7) )
#set( $URL_7 = $personBookmarkDetailsByDay[7].sessionCalendar.substring(8) )
<a href="https://${URL_7}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(8) )
#set( $URL_8 = $personBookmarkDetailsByDay[8].sessionCalendar.substring(8) )
<a href="https://${URL_8}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(9) )
#set( $URL_9 = $personBookmarkDetailsByDay[9].sessionCalendar.substring(8) )
<a href="https://${URL_9}" style="color: #2099d0" target="_blank" id="">
#elseif( $foreach.index.equals(10) )
#set( $URL_10 = $personBookmarkDetailsByDay[10].sessionCalendar.substring(8) )
<a href="https://${URL_10}" style="color: #2099d0" target="_blank" id="">
#end
Add to my calendar</a>
<br>
#end
</div>
</td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<!--[if mso | IE]>
</td>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table>
</div>
<!--[if mso | IE]>
</td>
</tr>
</table>
<![endif]-->
#end
#end
... View more
09-09-2020
11:20 PM
we're also having this issue, just seems to be emails with A/B tests which are not being returned - have raised a case. Has anyone received a response yet?
... View more
08-27-2020
11:34 AM
thanks @SanfordWhiteman - yep, I'm going to use split() - your Velocity advice is always appreciated.
... View more
08-27-2020
11:29 AM
THANK YOU!!! I knew I was missing something simple
... View more
08-27-2020
07:41 AM
Hi - I'm going a bit mad doing something which I thought would be pretty simple. I have a ; separated field on the lead record and I just want to get the first matching record from an array using the 'sessionKey' so I can use the values in an email block.
I've tried multiple things but here's my last attempt which hits a
' Invocation of method 'contains' in class java.lang.String threw exception java.lang.NullPointerException near'
error.
#set( $allSessions =
[{
"sessionKey": "Session1",
"sessionName":"Session 1 Name",
"imageURL":"example.com/image1"
},
{
"sessionKey": "Session2",
"sessionName":"Session 2 Name",
"imageURL":"example.com/image2"
}
])
#foreach( $session in $allSessions)
#if( $lead.recommendedSession.contains($allSessions.sessionKey))
#set( $recommendedSession = $session )
#break
#end
#end
$recommendedSession.sessionKey
$recommendedSession.sessionName
$recommendedSession.imageURL
I think I need to split my list and do an exact match but when I tried that I didn't get the error but I didn't get any values either (doubled checked lead record I was testing with etc)
@SanfordWhiteman - are you able to help?
... View more
08-13-2020
06:34 AM
Hi @SanfordWhiteman doesn't this solution hit the same problem you provided a workaround before i.e.
https://blog.teknkl.com/multiple-marketo-tracked-links-in-velocity/
at least it seems to when I use it
... View more
05-07-2020
04:31 AM
Hi @SanfordWhiteman
I'm having a similar issue with Datetime flow step logic that I was hoping you could help with. I want to send records to a different campaign based on a datetime field, here is my logic:
Here is the value in that field for the lead I am testing with, outputted into an email
And just to confirm the field is a Datetime field:
So I would expect this record to skip Choice 1, and be picked up in Choice 2. But it gets picked up in choice 1, any idea what I'm doing wrong here? Your TZ knowledge is always appreciated!
... View more
12-04-2019
10:43 AM
No problem! Just wondering did you set it up to use OAuth 2.0 or or API Keys, seems can only use API keys if sheet is Public. OAuth 2.0 sounds like would need some additional smart campaigns to manage access tokens.
... View more
12-03-2019
07:52 AM
Hi Sanford Whiteman just wondering if you wrote the blog post for doing real-time lookups using Sheets, couldn't find anything on TEKNKL?
... View more
11-28-2019
10:32 AM
Marketo Sales Insight may help with this, your sales team would be able to see all emails that have been sent to a contact within the Salesforce contact record.
... View more
10-22-2019
04:07 AM
Hi Has anyone else experienced an issue with local variables being stripped out when declaring a champion email? This has happened for all of our modules, and you're unable to update the variables in the new champion email which means having to essentially rebuild the email. Global Variables seem to be unaffected.
... View more
05-03-2019
01:05 AM
1 Like
I owe you so many beers for your help on this! The only thing was I was getting an error if the domain for the lead didn't appear in the JSON which I wasn't getting when just doing a standard foreach , so I referenced another one of you answers and wrapped it in an if statement to output some default content if the list is empty, is this the best way to handle this? #if( $domainProjects.isEmpty() ) Default content #else #foreach( $idx in [0..$math.min(7,$math.sub($domainProjects.size(),1))] ) #set( $project = $domainProjects[$foreach.index] ) You're a ${project.category.participantType} for Project ${foreach.count}: #if( $foreach.index.equals(0) ) #set( $project_category_URL_0 = $domainProjects[0].category.URL.substring(8) )<a href="https://${project_category_URL_0}">## #elseif( $foreach.index.equals(1) ) #set( $project_category_URL_1 = $domainProjects[1].category.URL.substring(8) )<a href="https://${project_category_URL_1}">## #elseif( $foreach.index.equals(2) ) #set( $project_category_URL_2 = $domainProjects[2].category.URL.substring(8) )<a href="https://${project_category_URL_2}">## #elseif( $foreach.index.equals(3) ) #set( $project_category_URL_3 = $domainProjects[3].category.URL.substring(8) )<a href="https://${project_category_URL_3}">## #elseif( $foreach.index.equals(4) ) #set( $project_category_URL_4 = $domainProjects[4].category.URL.substring(8) )<a href="https://${project_category_URL_4}">## #elseif( $foreach.index.equals(5) ) #set( $project_category_URL_5 = $domainProjects[5].category.URL.substring(8) )<a href="https://${project_category_URL_5}">## #elseif( $foreach.index.equals(6) ) #set( $project_category_URL_6 = $domainProjects[6].category.URL.substring(8) )<a href="https://${project_category_URL_6}">## #elseif( $foreach.index.equals(7) ) #set( $project_category_URL_7 = $domainProjects[7].category.URL.substring(8) )<a href="https://${project_category_URL_7}">## #end ${project.category.name}## </a> <br> <br> #end #end Thanks again for all of your help.
... View more
05-02-2019
04:04 PM
' Then at the end create N standalone String $references to hold the URLs.' Slightly confused how to join this all up in my example. But will try and tackle this tomorrow, so 'basically' I need to: Filter the list i.e. #set( $domainProjects = [] ) #foreach( $project in $allProjects ) #if( $project.domain.equalsIgnoreCase($lead.Email_Domain__c) ) #set( $void = $domainProjects.add($project) ) #end #end Then create the url reference from the filtered list (with something similar to your code): #foreach( $key in $lead.downloadcenter.split(";") ) #set( $downloadLink = $allDownloadLinks[$key] ) #evaluate( "${esc.h}set( ${esc.d}downloadLink_${foreach.count} = ${esc.d}downloadLink )" ) #end Then have an if statement for N url placeholders, where if the link exists in the filtered list it displays, otherwise it doesn't. (And I thought tomorrow would just be a day of colouring in this email!) # #
... View more
05-02-2019
02:54 PM
Thanks, Sanford - I really do appreciate all of your resources on this. But, as a novice with VTL, when you have to use a giant If statement to use a forEach, I'm thinking I may as well just use a giant If statement without the forEach. It feels like Marketo have dropped the ball on this one. Surely multiple (tracked) links from COs would be a common use case for VTL?
... View more
05-02-2019
09:55 AM
Ouch. That's kind of a big bug, at least for what I had planned. Is this something Marketo plan to fix?
... View more
05-02-2019
02:19 AM
Thanks for the tip, Mark! I am planning to output links so this is very helpful.
... View more
05-02-2019
02:18 AM
Thank you, Sanford! What threw me for a bit in your script was the $project variable in the forEach statement: #foreach( $project in $allProjects ) As I don't have any elements called $project in the JSON. So I can try and understand VTL a little bit more $project is declaring a variable for each record in the array?!
... View more
Public Statistics
| Date Registered | 01-23-2018 01:43 AM |
| Date Last Visited | 5 hours ago |
| Total Messages Posted | 42 |
| Likes Received | 4 |
.png)