Skip to content

Instantly share code, notes, and snippets.

View jbutters's full-sized avatar

jbutters

View GitHub Profile
@jbutters
jbutters / gist:bece2fffe85080fe4314
Last active August 21, 2019 20:36 — forked from davidrea/gist:17ba3aebfa65c933daca
function doGet() {
// you only need to modify the next four lines of this code then publish web app
var email = 'email address'; //what you use to login to nest
var password = 'password' ////what you use to login to nest
var zip = 'zip code';
var sheetid = 'sheet id'; //on your spreadsheet url its everything between /d/ <sheet id> /edit
/* to publish web app just:
1) Make sure the four variables are set above before you publish
2) Click Publish --> Deploy as web app
@jbutters
jbutters / PowerShell.Exe.Config
Created February 20, 2015 21:53
allow .NET 4 to be ran in PowerShell
<?xml version="1.0"?>
<configuration>
<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0.30319"/>
<supportedRuntime version="v2.0.50727"/>
</startup>
</configuration>
@jbutters
jbutters / checkdotNET.ps1
Last active August 29, 2015 14:15
check the dot net version
gci 'HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP' | sort pschildname -des | foreach-object {$_.name; $_.GetValue("Version");}
<# credit http://stackoverflow.com/questions/3487265/powershell-script-to-return-versions-of-net-framework-on-a-machine#comment3650817_3491193#>
@jbutters
jbutters / queryFor_NavianceStudents.ps1
Last active August 29, 2015 14:15
PowerShell query students then export as csv for Naviance
<# credit to http://blogs.technet.com/b/heyscriptingguy/archive/2012/12/04/use-oracle-odp-net-and-powershell-to-simplify-data-access.aspx#>
#Just modify the Connection String here
$conString="User Id=<your db query username>;Password=<your password>;Data Source=<your powershool db IP>/<db sid>"
#Just modify the SQL here:
$sqlString=@"
/*
Product: student auto import
Data Type: SIS
@jbutters
jbutters / title_student_end_css.alert_customalert.student.alert.txt ×
Last active August 29, 2015 14:15
page fragment to insert into admin student header
<!-- Start of custom alert -->
&nbsp&nbsp~[if.~([Students.U_Info]Alertcustomalert)="1"]<a class="dialogDivC" title="custom alert Student" href="#hiddenDivDialog"><img src="/images/alert_customalertfield.gif"></a>
<div id="hiddenDivDialog" class="hide">
<<div class="studentAlert" id="alert-customalert~(studentfrn)">
<img class="alertImage" src="/images/alert_customalert.gif" />
<div class="alertContent">
<p class="alertHeader">~(studentname)</p>
<p>~([Students.U_Info]Alertcustomalert;if.fieldvalue.1.then=CustomAlert)<br>&nbsp;<br><a href="/admin/students/misc.html?frn=~(studentfrn)"> Other information</a></p>
</div>
@jbutters
jbutters / cust.insertion_point:custom.studentalerts
Last active August 29, 2015 14:15
custom.studentalerts
<!-- custom insertion point added by someone on mm/dd/yyyy -->
~[cust.insertion_point:custom.studentalerts]
@jbutters
jbutters / misc.alert_customalert.custom.studentalerts.txt
Last active August 29, 2015 14:15
misc.alert_customalert.custom.studentalerts.txt
<tr bgcolor="#f6f6f6">
<td colspan="4" class="bold">custom Alert</td>
</tr>
<tr bgcolor="#edf3fe">
<td class="bold">custom Alert</td>
<td><input type="checkbox" name="[Students.U_Info]customalert" value="0"></td></tr>
@jbutters
jbutters / customalert_teachers_classattendance
Last active August 29, 2015 14:15
add custom alert to /teachers/classattendance.html
<!-- Start of custom alert-->
~[tlist_sql;select CASE customalert WHEN 1 THEN '<a class="dialogDivC" title="customalert Student" href="#hiddenDivDialog"><img src="/images/alert_customalert.gif"></a>' ELSE '' END from ps.students s join ps.U_customalertDBextension i on s.DCID = i.STUDENTSDCID join ps.cc cc on cc.STUDENTID = s.ID where cc.id = '[ccid]';]~(studentid;)[/tlist_sql]
<div id="hiddenDivDialog" class="hide"><div class="studentAlert" id="alert-customalert~(studentfrn)">
<img class="alertImage" src="/images/alert_customalert.gif" />
<div class="alertContent"><p class="alertHeader">customalert Student</p></div></div>
<!-- End of custom alert -->