kylekeesling’s gists

kylekeesling / Old TableSorter Indicators

Created November 24, 2011 19:50

Incorporate Bootstrap Styling into Sortable Table Helper


	Link to older version of the asset on github:

	https://github.com/twitter/bootstrap/raw/96c3e709963516a06ad6e723a7bba3fbf5fc1ba2/assets/img/tablesorter-indicators.png

kylekeesling / unsub_unengage_subs.js

Created April 11, 2012 18:04

ExactTarget - Self-Cleansing List - Unengaged Subscribers

	<script runat="server" language="javascript">

	Platform.Load("Core","1");

	//Self-Cleansing List
	var selfCleansinglist = List.Init("auto_cleansing_list");
	var status;

	//Newly Refreshed Group that Contains Unengaged Subscribers
	var unengagedGroup = List.Init('unengaged_subscribers_group');

kylekeesling / ssjs.js

Created April 20, 2012 16:05

Using Portuguese in SSJS

	<script runat="server" language="javascript">

	Platform.Load("Core","1");

	var requestsDE = DataExtension.Init("bz-solcon-requests");
	var triggeredSend = TriggeredSend.Init("bsrf");

	requestsDE.Rows.Add({
	repName: Request.GetFormField('repName'),
	companyName: Request.GetFormField('companyName'),

kylekeesling / already-sent-to.sql

Created December 14, 2012 20:49

Query that uses ExactTarget Data Views to find all subcribers who've been sent to today. Also includes an optional qualifier to ignore emails that you may use on a seed list

	SELECT DISTINCT
	SubscriberKey

	FROM _Sent

	WHERE
	DATEDIFF(day, EventDate, GETDATE()) = 0
	AND SubscriberKey NOT IN ('[email protected]','[email protected]''[email protected]')

kylekeesling / form.html

Created December 19, 2012 18:09

Example of an ExactTarget Landing Page that logs form submissions to a Data Extension and then kicks off a Triggered Send to the submitter. This example also leverages ExactTarget's server-side javascript library. More info and documentation can be found here - http://wiki.memberlandingpages.com/010_ExactTarget/020_Content/Server-Side_JavaScript

	<!DOCTYPE html>
	<html>
	<head>
	<meta http-equiv="Content-type" content="text/html; charset=utf-8">
	<title>
	SolCon Request Form
	</title>

	<!-- HTML5 shim, for IE6-8 support of HTML elements -->
	<!--[if lt IE 9]>

kylekeesling / add_data_to_de.php

Last active December 28, 2019 03:31

Example of Adding Data to an ExactTarget Data Extension via the SOAP API - API Starter Kit can be found here - http://docs.code.exacttarget.com/@api/deki/files/199/=PHP_APIstarterKit-V1.zip

	<?
	public function dataExtensionAdd($ExternalKey = '', $client = '') {

	try {
	/* Create the Soap Client */
	$soap = new EBG_ExactTarget_Client($this->wsdl, array('trace'=>1));

	/* Set username and password here */
	$soap->username = $this->username;
	$soap->password = $this->password;

kylekeesling / example.html

Created January 18, 2013 19:50

How to use the jQuery Cookie plugin

	<!doctype html>
	<html>
	<head>
	<title>Example</title>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script>
	<!-- Available here: https://github.com/carhartl/jquery-cookie -->
	<script src="jquery.cookie.js"></script>
	</head>
	<body>
	<script>

kylekeesling / geo-target.sql

Created February 21, 2013 17:03

GeoTargeting SQL for 15km Radius of Zip Code 46254

	SELECT
	myData.*,
	ROUND(6378.137 * ACOS(
	CASE
	WHEN (SIN(RADIANS((SELECT latitude FROM [Zip Codes and Locations] where [Zip Code] = 46254))) * SIN(RADIANS(geo.Latitude))) + (COS(RADIANS((SELECT latitude FROM [Zip Codes and Locations] where [Zip Code] = 46254))) * COS(RADIANS(geo.Latitude)) * COS(RADIANS(geo.Longitude) - RADIANS((SELECT longitude FROM [Zip Codes and Locations] where [Zip Code] = 46254)))) > 1 THEN 1
	WHEN (SIN(RADIANS((SELECT latitude FROM [Zip Codes and Locations] where [Zip Code] = 46254))) * SIN(RADIANS(geo.Latitude))) + (COS(RADIANS((SELECT latitude FROM [Zip Codes and Locations] where [Zip Code] = 46254))) * COS(RADIANS(geo.Latitude)) * COS(RADIANS(geo.Longitude) - RADIANS((SELECT longitude FROM [Zip Codes and Locations] where [Zip Code] = 46254)))) < -1 THEN -1
	ELSE (SIN(RADIANS((SELECT latitude FROM [Zip Codes and Locations] where [Zip Code] = 46254))) * SIN(RADIANS(geo.Latitude))) + (COS(RADIANS((SELECT latitude FROM [Zip Codes and Locations] where [Zip Code] = 4

kylekeesling / paginator.html

Created October 31, 2013 12:35

Simple Jekyll Paginator Logic I didn't like the pagination logic provided in the Jekyll Docs (http://jekyllrb.com/docs/pagination/) since it repeated the HTML for displaying the button, so I came up w/ this. It stores the proper previous page path into a liquid variable then plops it into the HREF so you only have to code your button once

	{% if paginator.previous_page %}
	{% if paginator.previous_page == 1 %}
	{% capture previous_page %}/{% endcapture %}
	{% else %}
	{% capture previous_page %}/page{{ paginator.previous_page }}{% endcapture %}
	{% endif %}
	<a href="{{ previous_page }}" class="previous">← Newer Posts</a>
	{% endif %}

	{% if paginator.next_page %}

kylekeesling / kyles_super_cool_pdf.rb

Created November 15, 2013 03:07

How to Generate a Prawn PDF class with a repeating footer

	class KylesSuperCoolPdf < Prawn::Document

	def initialize
	super()

	repeat :all do
	#Create a bounding box and move it up 18 units from the bottom boundry of the page
	bounding_box [bounds.left, bounds.bottom + 18], width: bounds.width do
	text "Probably the Best Footer Ever", size: 8, align: :center
	end

Kyle Keesling kylekeesling