Skip to content

Instantly share code, notes, and snippets.

View wildbillcat's full-sized avatar

wildbillcat

View GitHub Profile
remote_file "Download: #{data_bag_item("deployment_shares", "vendor_media")["http"]}/Microsoft/TFS/2015/build/agent.msi" do
path "C:/Appstaging/agent.msi"
source "#{data_bag_item("deployment_shares", "vendor_media")["http"]}/Microsoft/TFS/2015/build/agent.msi"
action :create
end
powershell_script 'Install Visual_Studio_2015' do
code <<-EOH
msiexec /i "C:/Appstaging/agent.msi" /qn /norestart
EOH
{
SkuId: 1,
SkuLabel: "xxx-ldke",
SkuPrice: 22.1,
SkuClass: "W",
UpdateTimestamp: "Tue Mar 24 2015 20:00:00 GMT-0400 (EDT)",
SkuSales: {
Months: ["1-May-12", "30-Apr-12", "27-Apr-12"],
Sales: [1,5,3],
SeasonallyNormalizedSales: [.75, 4, 3]
using System;
using System.Collections.Generic;
using System.Net;
using HtmlAgilityPack;
namespace ConsoleApplication
{
class Program
{
static void Main(string[] args)
{
"Name":""
}
$objExcel = New-Object -ComObject Excel.Application
$objworkbook=$objExcel.Workbooks.Open("C:\file.xls")
$objworkbook.SaveAs("C:\Dest.csv",6) # 6 is the code for .CSV
$objworkbook.Close($false)
@wildbillcat
wildbillcat / US Zip Codes from 2013 Government Data
Created June 25, 2017 04:15 — forked from erichurst/US Zip Codes from 2013 Government Data
All US zip codes with their corresponding latitude and longitude coordinates. Comma delimited for your database goodness. Source: http://www.census.gov/geo/maps-data/data/gazetteer.html
This file has been truncated, but you can view the full file.
ZIP,LAT,LNG
00601,18.180555, -66.749961
00602,18.361945, -67.175597
00603,18.455183, -67.119887
00606,18.158345, -66.932911
00610,18.295366, -67.125135
00612,18.402253, -66.711397
00616,18.420412, -66.671979
00617,18.445147, -66.559696
00622,17.991245, -67.153993
@wildbillcat
wildbillcat / US Zip Codes from 2013 Government Data
Created June 25, 2017 04:15 — forked from erichurst/US Zip Codes from 2013 Government Data
All US zip codes with their corresponding latitude and longitude coordinates. Comma delimited for your database goodness. Source: http://www.census.gov/geo/maps-data/data/gazetteer.html
This file has been truncated, but you can view the full file.
ZIP,LAT,LNG
00601,18.180555, -66.749961
00602,18.361945, -67.175597
00603,18.455183, -67.119887
00606,18.158345, -66.932911
00610,18.295366, -67.125135
00612,18.402253, -66.711397
00616,18.420412, -66.671979
00617,18.445147, -66.559696
00622,17.991245, -67.153993
only_if { (File.size(node['FCP-DataWarehouse']['mysql_coresense_src']) / 1024000) >= 2268 && Time.now.hour >= 6 }
not_if { (node['FCP-cookbook']['configured_ip']) == data_bag_item('ips', 'PC') }
data_bag_item('admins', 'justin')
//Function
let DayOfWeekIs (days:DayOfWeek list) =
let today = DateTime.Now
List.exists (fun dow -> dow == today.DayOfWeek) days
//Function Use
DayOfWeekIs([DayOfWeek.Saturday; DayOfWeek.Sunday])