Jayant_Singh
Level 2
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Wednesday
|
22
Posts
0
Likes
0
Solutions
a week ago
In a loop condition, for each item business need is to sort it twice.
#foreach( $myList_c in $sorter.sort($myList_cList, "date:desc") )
#set( $mySortedList = $sorter.sort( $myList, ["field1"] ) )
Considering, more than 1 millions data sets, will this behavior result into
1. email delivery to be delay more
2. soft bounces and campaign response result affected
... View more
Labels:
a week ago
In CO list, there are total eight field in which one field is date and second field item type. Business requirement is to sort it based on item type first after that again sort it by date field type.
custom objects(default_c) ,
field
Date(date),
Item Type(itemType)
And, counter is running for up to two times. what will be best way to sort it again and again in Velocity script?
... View more
Labels:
2 weeks ago
Hi Sanford,
I was wondering if you have gone through the debug code and please let me know the details.
... View more
2 weeks ago
date class java.lang.String 2020-03-20 08:20:02
leadID class java.lang.String 1
productCTA class java.lang.String https://www.mdg.co.in/product/item.html
productID class java.lang.String 059130d0-b9a5-4691-9f85-4f94afdadffe
productImage class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item.png
productName class java.lang.String item
date class java.lang.String 2020-04-21 08:20:02
leadID class java.lang.String 2
productCTA class java.lang.String https://www.mdg.co.in/product/item2.html
productID class java.lang.String 059130d0-b9a5-4691-9f85-4f94afdadffe
productImage class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item2.png
productName class java.lang.String item1
date class java.lang.String 2020-05-22 08:20:02
leadID class java.lang.String 3
productCTA class java.lang.String https://www.mdg.co.in/product/item3.html
productID class java.lang.String 059130d0-b9a5-4691-9f85-4f94afdadffe
productImage class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item3.png
productName class java.lang.String item2
[{date=2020-03-20 08:20:02, leadID=1, productCTA=https://www.mdg.co.in/product/item.html, productID=059130d0-b9a5-4691-9f85-4f94afdadffe, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item.png, productName=item}, {date=2020-04-21 08:20:02, leadID=2, productCTA=https://www.mdg.co.in/product/item2.html, productID=059130d0-b9a5-4691-9f85-4f94afdadffe, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item2.png, productName=item1}, {date=2020-05-22 08:20:02, leadID=3, productCTA=https://www.mdg.co.in/product/item3.html, productID=059130d0-b9a5-4691-9f85-4f94afdadffe, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item3.png, productName=item2}]
... View more
2 weeks ago
{kv.getKey()} class java.lang.String 2020-03-23 08:20:02 {kv.getKey()} class java.lang.String 4 {kv.getKey()} class java.lang.String https://www.mdg.co.in/product/item4.html {kv.getKey()} class java.lang.String b1c1c49a-1545-3c38-a421-d3af748ac5c1 {kv.getKey()} class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item4.png {kv.getKey()} class java.lang.String item3 {kv.getKey()} class java.lang.String 2020-04-24 08:20:02 {kv.getKey()} class java.lang.String 5 {kv.getKey()} class java.lang.String https://www.mdg.co.in/product/item6.html {kv.getKey()} class java.lang.String b1c1c49a-1545-3c38-a421-d3af748ac5c1 {kv.getKey()} class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item6.png {kv.getKey()} class java.lang.String item4 {kv.getKey()} class java.lang.String 2020-05-20 08:20:02 {kv.getKey()} class java.lang.String 6 {kv.getKey()} class java.lang.String https://www.mdg.co.in/product/item5.html {kv.getKey()} class java.lang.String b1c1c49a-1545-3c38-a421-d3af748ac5c1 {kv.getKey()} class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item5.png {kv.getKey()} class java.lang.String item5 [{date=2020-03-23 08:20:02, leadID=4, productCTA=https://www.mdg.co.in/product/item4.html, productID=b1c1c49a-1545-3c38-a421-d3af748ac5c1, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item4.png, productName=item3}, {date=2020-04-24 08:20:02, leadID=5, productCTA=https://www.mdg.co.in/product/item6.html, productID=b1c1c49a-1545-3c38-a421-d3af748ac5c1, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item6.png, productName=item4}, {date=2020-05-20 08:20:02, leadID=6, productCTA=https://www.mdg.co.in/product/item5.html, productID=b1c1c49a-1545-3c38-a421-d3af748ac5c1, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item5.png, productName=item5}]
... View more
2 weeks ago
I am using only the debug code and removed everything from VTL.
#set( $coList = $pro_cList )
#foreach( $record in $coList )
#foreach( $kv in $record.entrySet() )
{kv.getKey()} ${display.alt($kv.getValue().class,"")} ${display.alt($kv.getValue(),"null")}
#end
#end
${coList}
In the template, I am using {{my.VTL}} to debug it now. is it ok now or need to add code more?
... View more
2 weeks ago
This is the one script product name where I added the code at the top.
<html>
<body>
<table>
#set( $coList = $pro_cList )
#foreach( $record in $coList )
#foreach( $kv in $record.entrySet() )
{kv.getKey()} ${display.alt($kv.getValue().class,"")} ${display.alt($kv.getValue(),"null")}
#end
#end
## start product name select
<tbody>
#set( $DEFAULT_Product = "No item in list." )
<tr>
#if( $pro_cList.isEmpty() )
#set( $outputName = $DEFAULT_Product )
#else
#foreach( $pro_c in $sorter.sort($pro_cList, "date:desc") )
#if( !$display.alt($pro_cList["productName"],"").isEmpty() )
#set( $outputName = $pro_c["productName"] )
#break
#end
#end
#set( $outputName = $display.alt($outputName, $DEFAULT_Product) )
#end
<td>
${outputName}
</td>
</tr>
</tbody>
</table>
</body>
</html>
is code placement is incorrect?
... View more
2 weeks ago
I have added the code in three ways
1. Full code at top after debug no change in previous email design.
2. Both end statement at last after debug nothing display.
3. Putting both end statement before output the ${outputName} and got below design
... View more
2 weeks ago
In the given code,
1. kv and record will be replaced with any property?
2. This code need to add in velocity script in starting
... View more
2 weeks ago
I have already selected that one but not sure why it is evaluating only default output this is the worry part and I am not starting macro unless I am sure that I can get output individually correct.
... View more
2 weeks ago
Hi San,
Before creating macro, I want to fetch the data for each field correctly. So, I am not able to find checked off condition for the script. Can you please suggest more in this?
... View more
2 weeks ago
I have imported a list of records to custom objects which contains data based on user visits in the website. By using this list trying to create email in Marketo. From CO list, selecting only recent visit of the product. In the given list, have product name, image, URL and recent visit date.
Problem- I have created three velocity script and sorting the list based on recent visit date. But, in email output is display incorrect.
Below three velocity script used for sorting the product name, image and URL.
Script-1
<html>
<body>
<table>
## start product image select
<tbody>
#set( $DEFAULT_Product = "No item in list." )
<tr>
#if( $pro_cList.isEmpty() )
#set( $outputItemimage = $DEFAULT_Product )
#else
#foreach( $pro_c in $sorter.sort($pro_cList, "date:desc") )
#if( !$display.alt($pro_cList["productImage"],"").isEmpty() )
#set( $outputItemimage = $pro_c["productImage"] )
#break
#end
#end
#set( $outputItemimage = $display.alt($outputItemimage, $DEFAULT_Product) )
#end
<td>
<img width="189" align="right" src="${outputItemimage}" border="0"/>
</td>
</tr>
</tbody>
</table>
</body>
</html>
Script-2
<html>
<body>
<table>
## start product name select
<tbody>
#set( $DEFAULT_Product = "No item in list." )
<tr>
#if( $pro_cList.isEmpty() )
#set( $outputName = $DEFAULT_Product )
#else
#foreach( $pro_c in $sorter.sort($pro_cList, "date:desc") )
#if( !$display.alt($pro_cList["productName"],"").isEmpty() )
#set( $outputName = $pro_c["productName"] )
#break
#end
#end
#set( $outputName = $display.alt($outputName, $DEFAULT_Product) )
#end
<td>
${outputName}
</td>
</tr>
</tbody>
</table>
</body>
</html>
Script-3
<html>
<body>
<table>
## start product URL select
<tbody>
#set( $DEFAULT_Product = "No item in list." )
<tr>
#if( $pro_cList.isEmpty() )
#set( $outputItemCTA = $DEFAULT_Product )
#else
#foreach( $pro_c in $sorter.sort($pro_cList, "date:desc") )
#if( !$display.alt($pro_cList["productCTA"],"").isEmpty() )
#set( $outputItemCTA = $pro_c["productCTA"] )
#break
#end
#end
#set( $outputItemCTA = $display.alt($outputItemCTA, $DEFAULT_Product) )
#end
<td>
<a href="${outputItemCTA}">Check out</a>
</td>
</tr>
</tbody>
</table>
</body>
</html>
... View more
Labels:
3 weeks ago
Wish you best of luck, Happy to see you in MOPsCON 2020!!! 😊
is the registration link are open now?
I will love to join and read advanced content management method when you published it I will subscribe the blog.
... View more
3 weeks ago
Thanks San! but, it seems to be someone has to be more expertise in VTL. Kindly, share any reference link to understand in depth with similar scenario.
... View more
3 weeks ago
Suggested method to use two velocity variable one in template level that will help to control the output but my purpose is to allow edit the variable value in email level as it offer when we create local variable in email template.
Although, velocity token can control output but not allow to edit variable at email level. To edit velocity variable value need to change the velocity token value each time which I want to avoid this limitations here.
... View more
3 weeks ago
Hi San,
May be my application is wrong. Could you please suggest possible way to achieve this business goal? or it has no options at all.
... View more
3 weeks ago
I have defined a variable within the email template and want to use that variable in velocity script. So, I am not sure about that email variable can be used in velocity or not?
Email Variable -
Email variable name is email_variable <meta class="mktoString" id="email_variable" mktoname="Button Link" default="mylink" mktomodulescope="true" />
Velocity Script code is
#if( $ObjectList.isEmpty() )
<a href="http://www.mywebsite.com?parameter=${email_variable}">read more</a>
#end
Business Goal- To enable email local variable edit section in Email when variable is used in VTL coding.
... View more
- Tags:
Labels:
3 weeks ago
I have found your article https://blog.teknkl.com/multiple-marketo-tracked-links-in-velocity/ but I can see you are not using https:// in VTL token but do you have written any additional blog to strip out url too?
... View more
3 weeks ago
So, If I start using #macro coding with loop conditions after sorting the url based on date filter there would be no issue. For example, as I have html block for three products A, B, C.
1. first I will sort the url for product A and use html block A. I will use only one utm tag i.e. for product link A only.
2. I will repeat same coding for Product B and C and will use one utm tag in each product. So, I will not get any issue in URL.
... View more
3 weeks ago
Hi Sanford,
I am starting my first code in VTL and have been assigned a scenario only. So, I am pretty much new and still learning.
Scenario:
In custom objects list, field-A has value as https://www.abc.com/product.png as a product image and field-B has value https://www.abc.com/productlink.html as product link and field-C has product name and field-D date and time. and other fields are used to store additional data.
Additionally, I have html block to use for field A,B,C
My approach before starting code:
Sorting custom objects list with field-D #set( $sortedList = $sorter.sort($customObjList,"date:desc") )
but after that, I am missing logic to use html block for field A,B,C because I have to add UTM tags as parameter in field-B so that it is traceable in google analytics. ?utm_tag=productlink so I am not sure whether to strip out the URL or not.
So, I am looking for better approach here only.
... View more
3 weeks ago
In custom objects list, capturing the URL as a string data type with https:// but when adding UTM parameters the in the link UTM details are not captured. And I came to know that need to strip out the https:// part from before importing either in custom objects or in email velocity script. Can anyone have the email velocity script implemented to strip out the URL https:// ?
kindly, share the any reference link to use $params
... View more
Labels:
Public Statistics
| Name | |
| Date Registered | 09-24-2019 02:52 AM |
| Date Last Visited | Wednesday |
| Total Messages Posted | 22 |
| Total Tags | 3 |
.png?67D10DF4A500B5C9CAD6D9D40B974747)