jbutters’s gists

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 -->

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 / 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 / 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> <br><a href="/admin/students/misc.html?frn=~(studentfrn)"> Other information</a></p>
	</div>

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 / 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 / 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 / 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