Skip to content

Instantly share code, notes, and snippets.

View rwinikates's full-sized avatar

Rob Winikates rwinikates

  • NGP VAN, Inc.
  • Boston, MA
View GitHub Profile
-- Outlook can export folders of emails to Access. This select will show you counts per provider, based solely on the html contents, obviously exporting headers will be a lot more exact.
SELECT TOP 1 (SELECT Count(*)
FROM [campaign blasts]
WHERE contents LIKE "*images.myngp*") AS NGPClassic,
(SELECT Count(*)
FROM [campaign blasts]
WHERE contents LIKE "*myngp.com/el/*"
OR contents LIKE '*act.dscc.org/el/*') AS NGPNew,
(SELECT Count(*)
FROM [campaign blasts]
@rwinikates
rwinikates / contrib-amt-callback.js
Created July 8, 2014 16:59
Contrib amount callback
var contribAmount;
var submitSegue = function (args) {
contribAmount = args.postVals.Amount;
console.log(contribAmount);
return args;
}
var nvtag_callbacks = nvtag_callbacks || {};
nvtag_callbacks.preSegue = nvtag_callbacks.preSegue || [];
nvtag_callbacks.preSegue.push(submitSegue);
@rwinikates
rwinikates / exiftool-snippets
Created October 20, 2013 14:22
Exiftool manipulations for timestamps
// Read camera model and create date for photos shot by canon powershot for all files in current directory
exiftool -model -createdate -if '$model eq "Canon PowerShot A3100 IS"' *
// Add 46 minutes to the capture time for that camera model for all files in current directory
exiftool -DateTimeOriginal+='0:46' -if '$model eq "Canon PowerShot A3100 IS"' *
// Add 46 minutes to the capture time for that camera model for all files in many directories
exiftool -DateTimeOriginal+='0:46' -if '$model eq "Canon PowerShot A3100 IS"' 10-07 10-08 10-09 10-10 10-11 10-12 10-13 10-14
// documentation for exiftool CLI: http://owl.phy.queensu.ca/~phil/exiftool/exiftool_pod.html#processing_control
@rwinikates
rwinikates / block.tpl.php
Created July 27, 2012 19:25 — forked from pixelwhip/block.tpl.php
Modular Stylesheets - Design 4 Drupal
<?php
/**
* @file
* Default theme implementation to display a block.
*
* Available variables:
* - $block->subject: Block title.
* - $content: Block content.
* - $block->module: Module that generated the block.