View qr-api
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=https://sfmarketing.cloud/ |
View generate-qrcode.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<html> | |
<head> | |
<script type="text/javascript" src="https://xxxxx/qrcode.js"></script> | |
</head> | |
<body> | |
%%[ | |
set @data = 'http://sfmarketing.cloud/' |
View qrcode.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* @fileoverview | |
* - Using the 'QRCode for Javascript library' | |
* - Fixed dataset of 'QRCode for Javascript library' for support full-spec. | |
* - this library has no dependencies. | |
* | |
* @author davidshimjs | |
* @see <a href="http://www.d-project.com/" target="_blank">http://www.d-project.com/</a> | |
* @see <a href="http://jeromeetienne.github.com/jquery-qrcode/" target="_blank">http://jeromeetienne.github.com/jquery-qrcode/</a> | |
*/ |
View qrcode-ampscript.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
%%[ | |
set @data = 'https://sfmarketing.cloud/' | |
set @qrcode = concat('https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=', @data) | |
]%% | |
<img src="%%=v(@qrcode)=%%"> |
View barcode-ampscript.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
%%[ | |
set @value = Lookup("Barcode Data","Barcode","SubscriberKey", _subscriberkey) | |
set @codabar = BarcodeURL(@value, "Codabar", 100, 50) | |
]%% | |
<img src="%%=v(@codabar)=%%"> | |
<br> | |
%%=v(@value)=%% |
View celar-de.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
null as SubscriberKey, | |
null as EmailAddress, | |
null as Status | |
where 0 = 1 |
View update-all-subscribers-sql.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
contact.Id as SubscriberKey, | |
contact.Email as EmailAddress, | |
CASE | |
WHEN allsub.Status = 'held' THEN 'active' | |
WHEN allsub.Status = 'bounced' THEN 'active' | |
ELSE allsub.Status | |
END as Status | |
FROM | |
Contact_Salesforce as contact |
View update-all-subscribers-wsproxy.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<script runat="server"> | |
Platform.Load("core", "1.1.1"); | |
try { | |
var deKey = "xxxxx-xxxxxx-xxxx-xxxxx-xx-xxxxxxx", // replace with the external key of the DE holding the query results | |
prox = new Script.Util.WSProxy(), | |
objectType = "DataExtensionObject[" + deKey + "]", | |
cols = ["subscriberkey", "emailaddress", "status"], | |
moreData = true, | |
reqID = null, |
View masking-email-addresses-ampscript.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
%%[ | |
/* pull the field to be masked from a data extension */ | |
set @email = AttributeValue("email") | |
/* find the position of the first occurrence of an @ sign in the string */ | |
set @at = indexOf(@email, "@") | |
/* extract the username portion of the email address */ | |
set @username = Substring(@email,1, Subtract(@at,1)) |
NewerOlder