Harry_Rashid

Harry_Rashid · ‎07-14-2021

Hi, I'm trying to show correct country time and date for an on24 Webinar. I have a custom object which I am pulling data from eventdatetime field which the date shows UK time Apr 23, 2021 2:00 PM, I am trying to show different Time/Date for other locales/Countries depending where the customer is from, so if customer is from Germany the output should show Apr 23, 2021 3:00 PM as Germany is an hour ahead, this needs to be replicated for all countries as we have customers across the globe. So far I only have the following code, any help would be amazing. Thanks #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("Europe/London") ) #set( $defaultLocale = $date.getLocale() ) #set( $calNow = $date.getCalendar() ) #set( $ret = $calNow.setTimeZone($defaultTimeZone) ) #set( $calConst = $field.in($calNow) ) #set( $ISO8601DateOnly = "yyyy-MM-dd" ) #set( $ISO8601DateTime = "yyyy-MM-dd'T'HH:mm:ss" ) #set( $ISO8601DateTimeWithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $ISO8601DateTimeWithMillisUTC = "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'" ) #set( $ISO8601DateTimeWithMillisTZ = "yyyy-MM-dd'T'HH:mm:ss.SSSZ" ) ## Check if the Custom object ID and pull date in #foreach( $attendee in $oN24Attendee_cList ) #if($attendee.eventid == 3091278) #set( $eventdatetimelike = $attendee.eventdatetime ) #set( $eventdatetime = $convert.parseDate( $eventdatetimelike, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) #set( $eventdatetime_formatted = $date.format( $dateOptions.formats.userout, $eventdatetime, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) #if(${lead.Marketo_eShot_Dynamic__c} == "Belgium") $eventdatetime_formatted ##$date.format('dd-MM-yyyy', ${convert.parseDate(${attendee.eventdatetime}, 'yyyy-MM-dd HH:mm:ss')}) ## Check if the Country is Netherlands #elseif(${lead.Marketo_eShot_Dynamic__c} == "Netherlands") $eventdatetime_formatted ## Display the date as dd.mm.yyyy ##$date.format('dd.MM.yyyy', ${convert.parseDate(${attendee.eventdatetime}, 'yyyy-MM-dd HH:mm:ss')}) #elseif(${lead.Marketo_eShot_Dynamic__c} == "UK") ## Display the date as dd.mm.yyyy $eventdatetime_formatted $date.format('dd.MM.yyyy', ${convert.parseDate(${attendee.eventdatetime}, 'yyyy-MM-dd')}) #elseif(${lead.Marketo_eShot_Dynamic__c} == "Germany") ## Display the date as dd.mm.yyyy <br> $eventdatetime_formatted ##$date.format('dd.MM.yyyy', ${convert.parseDate(${attendee.eventdatetime}, 'yyyy-MM-dd')}) ## If Country equals anything else or if the Country is empty display the date in the regular default format #else ${attendee.eventdatetime} #end #end #end

Harry_Rashid · ‎03-18-2021

Thanks Sanford, I was thinking that might be the case - any chance you can help update the code to achieve this?

Harry_Rashid · ‎03-17-2021

As you can see the from the eventid: 2862094 so the date should be 17 February 2021 3:00 PM

Harry_Rashid · ‎03-17-2021

That did work but the wrong date came up: 19 April 2021 03:00 PM for that eventid number it should be 17 February 2021 3:00 PM See screen grab which shows what I am trying to do. Latest code: ## get the size of the list of Custom object ## remove one from the size of the list to reference the right object in the array (arrays start at zero, not 1) #set( $lastIndex = $math.sub($listlength,1) ) ## convert the Service Start Date string to a date #set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd hh:mm", "userout" : "dd MMMM yyyy hh:mm a" }, "timezones" : { "userin" : "America/Chicago", "userout" : "Europe/London" }, "locale" : $date.getLocale() } ) #set( $eventdatetimelike = $oN24Attendee_cList.get($lastIndex).eventdatetime ) #set( $eventdatetime = $convert.parseDate( $eventdatetimelike, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) ## convert the date to a different format #set( $eventdatetime_formatted = $date.format( $dateOptions.formats.userout, $eventdatetime, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) #foreach( $event in $oN24Attendee_cList ) #if( $event.eventid.equals(2862094) ) $eventdatetime_formatted #end #end

Harry_Rashid · ‎03-17-2021

Output for ${oN24Attendee_cList} [{email=cstanton@xxxx.com, eventid=2923321, eventuserid=396136339, personid=85610818, createdAt=2020-12-14 12:14:30, updatedAt=2020-12-16 10:24:27, marketoGUID=6e1d4db5-f994-402f-8f8c-226e5df5fb1d, answeredsurveys=1, archiveminutes=0, askedquestions=1, attendedarchive=N, attendedlive=Y, engagementscore=1.28, eventtitle=Dev Testing - Marketo Integration Webinar: Live Video and Audio with Screen Share, liveminutes=0, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/2923321/8E5C6E8A24121312C6E9ECEEDC0797A0, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=null}, {email=cstanton@xxxx.com, eventid=2971146, eventuserid=403064471, personid=85610818, createdAt=2021-01-15 10:59:18, updatedAt=2021-01-15 13:02:15, marketoGUID=eca41fd8-ce1b-40ad-878f-4bc7125bb57a, answeredsurveys=0, archiveminutes=0, askedquestions=0, attendedarchive=N, attendedlive=Y, engagementscore=0.9, eventtitle=Dev Testing - Marketo Integration Webinar: Live Video and Audio with Screen Share - 5, liveminutes=12, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/2971146/D8337458BB173CD29D78A2207CEA83ED, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=null, eventdatetime=null}, {email=cstanton@xxxx.com, eventid=2862094, eventuserid=412031846, personid=85610818, createdAt=2021-02-11 10:17:22, updatedAt=2021-02-11 10:17:22, marketoGUID=5defefde-ba8a-44e1-a441-56870c46eb9a, answeredsurveys=null, archiveminutes=null, askedquestions=null, attendedarchive=null, attendedlive=null, engagementscore=null, eventtitle=How Will Industry 4.0 and IIoT Change Manufacturing?, liveminutes=null, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/2862094/E6DF1C914D7E0531E26C4F20D1CFCBAB, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=2021-02-17 09:00:00}, {email=cstanton@xxxx.com, eventid=3009982, eventuserid=412753872, personid=85610818, createdAt=2021-02-15 09:00:38, updatedAt=2021-02-15 09:00:38, marketoGUID=f006766f-6df6-48f6-941d-99d38b431cdc, answeredsurveys=null, archiveminutes=null, askedquestions=null, attendedarchive=null, attendedlive=null, engagementscore=null, eventtitle=Thunderboard Workshop: Industrial-Grade TinyML Applications with Silicon Labs and Edge Impulse!, liveminutes=null, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/3009982/25A49F43B8E20571B91468811F6A85F9, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=2021-02-25 11:00:00}, {email=cstanton@xxxx.com, eventid=2989768, eventuserid=412753739, personid=85610818, createdAt=2021-02-15 09:00:38, updatedAt=2021-02-15 09:00:38, marketoGUID=5bffb342-c397-4cfd-ab75-ef155009b489, answeredsurveys=null, archiveminutes=null, askedquestions=null, attendedarchive=null, attendedlive=null, engagementscore=null, eventtitle=LPDDR4 Trends and Tech (Register to Win a Raspberry Pi 4!), liveminutes=null, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/2989768/D3EE09A3DDCF112CBAC4E98F98302286, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=2021-02-24 11:00:00}, {email=cstanton@xxxx.com, eventid=3053359, eventuserid=421641290, personid=85610818, createdAt=2021-03-15 12:21:51, updatedAt=2021-03-15 12:21:51, marketoGUID=f41528de-8591-4087-b02c-78e6f3f2d20c, answeredsurveys=null, archiveminutes=null, askedquestions=null, attendedarchive=null, attendedlive=null, engagementscore=null, eventtitle=IoT MythBusters: Tomorrow's Future Today, liveminutes=null, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/3053359/17BCF76DEE585B7D8BEADC685766177E, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=2021-04-19 09:00:00}] $eventdatetime_formatted

Harry_Rashid · ‎03-17-2021

I think its to do with the IF loop, seems to go blank when adding that within the FOR loop.

Harry_Rashid · ‎03-17-2021

This is the field I am trying use to filter correct data into the email, what needs to show after data format complete: this is what is showing at moment, but is from another record in custom object for that customer 19 April 2021 03:00 PM fields that are used: ${oN24Attendee_cList.get(0).eventdatetime} ${oN24Attendee_cList.get(0).eventid} ${oN24Attendee_cList.get(0).eventtitle}

Harry_Rashid · ‎03-17-2021

Hi Sanford, Thanks for the help but when I add in the formatted field $eventdatetime_formatted within that loop nothing shows up(only blank space). The field I am targeting is eventid ${oN24Attendee_cList.get(0).eventid}. I used your code but it still shows blank.

Harry_Rashid · ‎03-16-2021

I have the following code, which formats date exactly the way I need it. The issue is I only want to show the date in email which matches correct $eventid for customers. I tried this loop but nothing populates: #foreach( $eventid in $oN24Attendee_cList ) #if( $eventid.equals("2862094") ) $eventdatetime_formatted #end #end ---------------- Full code ## get the size of the list of Custom object ## remove one from the size of the list to reference the right object in the array (arrays start at zero, not 1) #set( $lastIndex = $math.sub($listlength,1) ) ## convert the Service Start Date string to a date #set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd hh:mm", "userout" : "dd MMMM yyyy hh:mm a" }, "timezones" : { "userin" : "America/Chicago", "userout" : "Europe/London" }, "locale" : $date.getLocale() } ) #set( $eventdatetimelike = $oN24Attendee_cList.get($lastIndex).eventdatetime ) #set( $eventdatetime = $convert.parseDate( $eventdatetimelike, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) ## convert the date to a different format #set( $eventdatetime_formatted = $date.format( $dateOptions.formats.userout, $eventdatetime, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) #foreach( $eventid in $oN24Attendee_cList ) #if( $eventid.equals("2862094") ) $eventdatetime_formatted #end #end

Harry_Rashid · ‎10-29-2020

Is there an example I can follow or maybe help update the above code?

Harry_Rashid · ‎10-28-2020

Sorry Sanford, maybe I not explained correctly - the code already splits them to individual lines. I want to amend the code so I can separate each line where they maybe a comma: Say this is one line: Part - 7984219, P2220 Oscilloscope Probe, Passive, 300 V Qty. - 11 Is it possible to use comma delimiter to spilt the above line? ie field 1 will only show "Part - 7984219" field 2 "P2220 Oscilloscope Probe, Passive, 300 V" and field 3 "Qty. - 11" Thanks,

Harry_Rashid · ‎10-23-2020

Hi Sanford, Thanks that did work but is there a way to split field $lead.First_5_Lines_in_Basket__c into 3 separate fields i.e. field 1, field 2 and field 3 which will allow me to place anywhere in an HTML table? Something like below for each field Field 1 = Part - 7984219, Field 2 = P2220 Oscilloscope Probe, Passive, 300 V Field 3 = Qty. - 11 At moment it pulls in as below: Part - 7984219, P2220 Oscilloscope Probe, Passive, 300 V Qty. - 11 Thanks

Harry_Rashid · ‎10-16-2020

Thanks Sanford, that has helped.

Harry_Rashid · ‎10-15-2020

Hi, I have the following code which looks up a field in Marketo and pulls through the content, but I have an issue I am trying to start a new row when a certain delimiter "Part" pops up within the content: #if(!$lead.First_5_Lines_in_Basket__c.isEmpty()) #set($First_5_Lines_in_Basket__c = $lead.First_5_Lines_in_Basket__c) #foreach($fivelines in $First_5_Lines_in_Basket__c.split("\n")) $fivelines #end #end The content pulling through is for example - Part - 7984219, P2220 Oscilloscope Probe, Passive, 300 V Qty. - 11 Part - 2497216, ATREB215-XPRO - Expansion Board, AT86RF215 2.4GHz/Sub 1GHz Multi-Band Transceiver, IEEE 802.15.4/4g Compliant Qty. - 3 But would like it to split to next row when "Part" comes up within the content, so should look like as follows: Part - 7984219, P2220 Oscilloscope Probe, Passive, 300 V Qty. - 11 Part - 2497216, ATREB215-XPRO - Expansion Board, AT86RF215 2.4GHz/Sub 1GHz Multi-Band Transceiver, IEEE 802.15.4/4g Compliant Qty. - 3 Any help would be appreciated. Thanks

Harry_Rashid · ‎11-25-2019

Hi Sanford, This is what conversant has come back to me with - The main purpose of email tagging is to help conversant identify Farnell customers and be able to reach (Display ads) them online within different devices. The reason for SHA256 is because the customer file we receive from your company is hashed out with SHA256. Having SHA256 on the email tagging, we can then map the hashed email address to a User in conversant since those are in the customer file as well. Also, just to clarify, we don’t reverse the hashes to its normal email address as those become PII information. Not sure what to make of this.

Harry_Rashid · ‎11-25-2019

I'm lost in all this process, not sure which way to go. Do you have example how to use Unique codes or will best option be coding some velocity using Base64. Thanks

Harry_Rashid · ‎11-25-2019

Hi Sanford, Not sure answer to on any of those, I was told that the email address needs to encrypted as it is personal data, below is what they mentioned - Yes, encryption is required as that is personal data and we would want to make sure CNVR does not ingest those due to legal reasons. Hope you still can help. Thanks again.

Harry_Rashid · ‎11-23-2019

Thanks Tony! but not sure I have the knowledge to this.

Harry_Rashid · ‎11-23-2019

Hi Sanford, it will not be one time load - all customers in our database will be affected at some point. Basically we are working with Conversant(part of Commission Junction), they have provided those parameters which will allow them to track our customer behaviour but we need the email address encrypted. We add the following to our email head: Email Tag Code: <img src="http://login.dotomi.com/ucm/UCMController?dtm_com=2&dtm_cid=61538&dtm_cmagic=a0ad3c&dtm_fid=<Form ID>&dtm_format=6&cli_promo_id=99& dtm_email_hash={{lead.Email Address}} & dtm_user_id={{lead.ID}} & dtmc_drop_id={{program.id}} " width="1" height="1" border="0">  and links will have the following parameter: dtm_email_hash parameter ( dtm_email_hash={{lead.Email Address}} ) should be encrypted using SHA256 hashing as that is personal information...which will look something as follows: https://www.domain.com?dtm_email_hash={{hashed_lead.Email}} If you can help with the coding, would be gratefully appreciated - as you said using base64 now. Thanks for all your help!

Harry_Rashid · ‎11-22-2019

Sorry, we are targeting existing LEADS within Marketo and was told these email addresses will not change for now.

Harry_Rashid · ‎11-21-2019

The leads are existing Leads we send these emails to, so email address will never change and no new is being created. Sanford that would be great help if you could create the SHA-256 code I am sure it will come in handy for a lot of of others using Marketo. Trying to have this up and running within 5 to 7 days, is that duable? Thanks for all your help.

Harry_Rashid · ‎11-21-2019

Sorry, will the link still be: https://mydomain.com/dtm_email_hash={{lead.Email Address}}, Plus why do we need the Data Value Changes in smart flow? Not sure how I would test it as this makes it triggered and cannot Run Once

Harry_Rashid · ‎11-21-2019

Thanks Jay! Will try this, hopefully it will do the job for me. Quick one, the endpoint.php in your screen grab is that the file with the php code you provided me? Thanks again!

Harry_Rashid · ‎11-21-2019

Hi Jay, Thanks for that, not sure how to go about with PHP with Marketo, new to this. Will it be possible to give some more guidance? Thanks!

Harry_Rashid · ‎11-20-2019

Cool, is this the code? https://nation.marketo.com/community/product_and_support/blog/2019/10/13/base64-ing-a-string-in-velocity-without-using-reflection I'll see if I can manage to do something.

Harry_Rashid · ‎11-20-2019

Thanks again Any chance you can provide an example or velocity code I can look at to build this?

Harry_Rashid · ‎11-19-2019

Thanks Sanford! Is there any webhook-compatible service you know of? Would help me look into it a little more.

Harry_Rashid · ‎11-18-2019

Hi, I am working with Conversant to add in parameters, they have asked if hasing is possible with Marketo, as below - The dtm_email_hash parameter (dtm_email_hash={{lead.Email Address}}) should be encrypted using SHA256 hashing as that is personal information. Is this possible with market? Is it possible to SHA256 Hashing an email address in an link? Thanks, Haroon

Harry_Rashid · ‎10-04-2019

# set ( $currentURLNoProto = $co_record . URL_1 ) # foreach ( $link in [ 1 . . 3 ] ) # evaluate ( "${esc.h}set( ${esc.d}URL_${foreach.parent.count}_${foreach.count} = ${esc.d}currentURLNoProto )" ) #end #set($daysRemaining = $math.abs($daysRemaining)) ##set($co_record.URL_1 = $DynamicCustomObjectList.URL_1) ##set($co_record.URL_2 = $DynamicCustomObjectList.URL_2) ##set($co_record.URL_3 = $DynamicCustomObjectList.URL_3) ##set($co_record.URL_4 = $DynamicCustomObjectList.URL_4) ##set($co_record.URL_5 = $DynamicCustomObjectList.URL_5) ##set($co_record.URL_6 = $DynamicCustomObjectList.URL_6) #if($convert.toInteger($daysRemaining) < 5 && $co_record.SendID == "Pattern Breakers Engineer") <table id="bodyContent" class="innertable2" align="center" width="600" cellpadding="0" cellspacing="0" style="background-color:#ffffff;"> <tr> <td valign="top"><table width="100%" style="font-size: 3px;"> <tbody> <tr> <td> </td> </tr> </tbody> </table></td> <td rowspan="6"><img src="http://planet.farnell.com/email/newtemplate/email_assets/spacer.gif" width="2" height="10" class="spacer"/></td> <td rowspan="6" style="background-color:#e4e4e4;"><img src="http://planet.farnell.com/email/newtemplate/email_assets/spacer.gif" width="4" height="1"/></td> <td rowspan="6"><img src="http://planet.farnell.com/email/newtemplate/email_assets/spacer.gif" width="2" height="10" class="spacer"/></td> <td valign="top"><table width="100%" style="font-size: 3px;"> <tbody> <tr> <td> </td> </tr> </tbody> </table></td> </tr> <tr> <td valign="top"><table width="289" border="0" cellspacing="5" cellpadding="5" class="innertable3"> <tr> <td > <table width="100%" border="0" cellspacing="0" cellpadding="0" align="left"> <tr > <td> <table width="15%" border="0" cellspacing="0" cellpadding="0" align="right" class="w100"> <tr> <td> <a href="https://${URL_1_1}" target="_blank"> <img src="$co_record.Image_1" width="100" style="border-collapse:collapse; padding:0px; margin:0px; border-spacing:0; display:block;"/></a> </td> </tr> </table> <table width="15%" border="0" cellspacing="0" cellpadding="0" align="right" class="w100"> <tr> <td> <a href="https://$co_record.URL_2" target="_blank"> <img src="$co_record.Image_2" width="100" style="border-collapse:collapse; padding:0px; margin:0px; border-spacing:0; display:block;"/></a> </td> </tr> </table> Some sample code above utilizing code you provided, but link only pulling from $URL_1 CO field, I need to pull from $URL_2, $URL_3 etc..

Harry_Rashid · ‎10-04-2019

Sorry, new to using the discussion. I have 6 links within the CO which need pulling in, the example you gave seems to pull only URL_1 - is there a way to use the code you had provided and pull all 6 links? Below is how I had set it up but links broke. #set($co_record.URL_1 = $DynamicCustomObjectList.URL_1) #set($co_record.URL_2 = $DynamicCustomObjectList.URL_2) #set($co_record.URL_3 = $DynamicCustomObjectList.URL_3) #set($co_record.URL_4 = $DynamicCustomObjectList.URL_4) #set($co_record.URL_5 = $DynamicCustomObjectList.URL_5) #set($co_record.URL_6 = $DynamicCustomObjectList.URL_6) For example each link was added as - <a href="https://$co_record.URL_1&CMP=e-email-tracking" target="_blank"><img src="$co_record.Image_1" width="100" style="border-collapse:collapse; padding:0px; margin:0px; border-spacing:0; display:block;"/></a> <a href="https://$co_record.URL_2&CMP=e-email-tracking" target="_blank"><img src="$co_record.Image_2" width="100" style="border-collapse:collapse; padding:0px; margin:0px; border-spacing:0; display:block;"/></a> <a href="https://$co_record.URL_3&CMP=e-email-tracking" target="_blank"><img src="$co_record.Image_3" width="100" style="border-collapse:collapse; padding:0px; margin:0px; border-spacing:0; display:block;"/></a> Hope you can help. Thanks, Haroon

Online Status	Offline
Date Last Visited	‎07-14-2021 12:35 PM

Date Registered	‎03-27-2019 08:47 AM
Date Last Visited	‎07-14-2021 12:35 PM
Total Messages Posted	36

Top Badges Earned

on24 Webinar - show correct time zone/ date for cu...

Re: date field with custom object to add if loop

Re: date field with custom object to add if loop

Re: date field with custom object to add if loop

Re: date field with custom object to add if loop

Re: date field with custom object to add if loop

Re: date field with custom object to add if loop

Re: date field with custom object to add if loop

date field with custom object to add if loop

Re: Velocity email script split string

Re: Velocity email script split string

Re: Velocity email script split string

Re: Velocity email script split string

Velocity email script split string

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

Re: SHA-256 an email address Link in Velocity

SHA-256 an email address Link in Velocity

Re: Dynamic links custom objects breaking

Re: Dynamic links custom objects breaking