Management - Revision history

Mharrit1 at 22:43, 9 August 2020

2020-08-09T22:43:02Z

← Older revision		Revision as of 22:43, 9 August 2020
Line 20:		Line 20:

	{{#get_web_data:		{{#get_web_data:
	url=https://docs.google.com/spreadsheets/d/e/~~2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5~~/~~pub~~?~~gid~~=~~1533673129~~&~~single=true&output~~=~~csv~~		url=https://docs.google.com/spreadsheets/u/2/d/1fmNN8mN1b3Qqtkt_KZJCUEX_UoOi0n7Vl0UWQVjYqdg/gviz/tq?tqx=out:csv&gid=0
	\|format=CSV		\|format=CSV
	\|data=Name=2, Email=6, Role=1, FirstName=3, LastName=4, NickName=5, WikiUsername=10		\|data=Name=2, Email=6, Role=1, FirstName=3, LastName=4, NickName=5, WikiUsername=10

Mharrit1: /* Current Roster */

2020-08-09T21:21:59Z

Current Roster

← Older revision		Revision as of 21:21, 9 August 2020
Line 20:		Line 20:

	{{#get_web_data:		{{#get_web_data:
	url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/~~pubhtml~~?gid=1533673129&single=true&output=csv		url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pub?gid=1533673129&single=true&output=csv
	\|format=CSV		\|format=CSV
	\|data=Name=2, Email=6, Role=1, FirstName=3, LastName=4, NickName=5, WikiUsername=10		\|data=Name=2, Email=6, Role=1, FirstName=3, LastName=4, NickName=5, WikiUsername=10

Mharrit1 at 21:20, 9 August 2020

2020-08-09T21:20:47Z

← Older revision		Revision as of 21:20, 9 August 2020
Line 20:		Line 20:

	{{#get_web_data:		{{#get_web_data:
	url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/~~pub~~?gid=1533673129&single=true&output=csv		url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pubhtml?gid=1533673129&single=true&output=csv
	\|format=CSV		\|format=CSV
	\|data=Name=2, Email=6, Role=1, FirstName=3, LastName=4, NickName=5, WikiUsername=10		\|data=Name=2, Email=6, Role=1, FirstName=3, LastName=4, NickName=5, WikiUsername=10

Mharrit1: /* Current Roster */

2020-08-09T21:15:27Z

Current Roster

← Older revision		Revision as of 21:15, 9 August 2020
Line 21:		Line 21:
	{{#get_web_data:		{{#get_web_data:
	url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pub?gid=1533673129&single=true&output=csv		url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pub?gid=1533673129&single=true&output=csv
	\|format=CSV ~~with header~~		\|format=CSV
	\|data=Name=~~Name~~, Email=~~BestEmail~~, Role=~~Primary Role~~, FirstName=~~FirstName~~, LastName=~~LastName~~, NickName=~~NickName~~, WikiUsername=~~WikiUsername~~		\|data=Name=2, Email=6, Role=1, FirstName=3, LastName=4, NickName=5, WikiUsername=10
	}}		}}
	<!--		<!--

Mharrit1: /* Current Roster */

2020-08-09T20:51:43Z

Current Roster

← Older revision		Revision as of 20:51, 9 August 2020
Line 24:		Line 24:
	\|data=Name=Name, Email=BestEmail, Role=Primary Role, FirstName=FirstName, LastName=LastName, NickName=NickName, WikiUsername=WikiUsername		\|data=Name=Name, Email=BestEmail, Role=Primary Role, FirstName=FirstName, LastName=LastName, NickName=NickName, WikiUsername=WikiUsername
	}}		}}
			<!--
	{\| class="wikitable sortable"		{\| class="wikitable sortable"
	! Role		! Role
Line 32:		Line 32:
	!class=unsortable\| Email {{#display_external_table:template=ManagerData\|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername, FirstName=FirstName, LastName=LastName }}		!class=unsortable\| Email {{#display_external_table:template=ManagerData\|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername, FirstName=FirstName, LastName=LastName }}
	\|}		\|}
			-->

	~~<!--~~
	{\| class="wikitable sortable"		{\| class="wikitable sortable"
	! Role		! Role
Line 49:		Line 49:
	}}		}}
	\|}		\|}
	~~-->~~

	<!-- Alternate approach using three queries to separate staff, managers, & advisors: -->		<!-- Alternate approach using three queries to separate staff, managers, & advisors: -->

Mharrit1: /* Staff: */

2020-07-18T19:30:56Z

Staff:

← Older revision		Revision as of 19:30, 18 July 2020
Line 54:		Line 54:

	===Staff:===		===Staff:===
	~~[[File: \| center \|150px \| thumb \|Annie Lu ]]~~

	{{#get_web_data:		{{#get_web_data:

Mharrit1 at 19:30, 18 July 2020

2020-07-18T19:30:39Z

@@ Line 55: / Line 55: @@
 ===Staff:===
 [[File: | center |150px | thumb |Annie Lu ]]
-<!-- Old way of doing this... doesn't seem to work anymore?
 {{#get_web_data:
   url=https://docs.google.com/spreadsheets/u/2/d/1fmNN8mN1b3Qqtkt_KZJCUEX_UoOi0n7Vl0UWQVjYqdg/gviz/tq?tqx=out:csv&gid=0&tq=select%20B%2CF%2CA%2CC%2CD%2CE%2CJ%2CM%2CN%2CO%20where%20A%3D%22Staff%22
@@ Line 97: / Line 89: @@
 ===Advisers:===
 {{#get_web_data:
   url=https://docs.google.com/spreadsheets/u/2/d/1fmNN8mN1b3Qqtkt_KZJCUEX_UoOi0n7Vl0UWQVjYqdg/gviz/tq?tqx=out:csv&gid=0&tq=select%20C%2CD%2CF%20where%20A%20%3D%20%22Adviser%22
@@ Line 125: / Line 109: @@
 ===Managers:===
 {{#get_web_data:

Mharrit1 at 19:22, 18 July 2020

2020-07-18T19:22:23Z

← Older revision		Revision as of 19:22, 18 July 2020
Line 57:		Line 57:
	<!-- Old way of doing this... doesn't seem to work anymore?		<!-- Old way of doing this... doesn't seem to work anymore?
	Should probably change this... looks ugly currently		Should probably change this... looks ugly currently
	~~{{#get_web_data:~~
	url=https://docs.google.com/spreadsheets/u/2/d/1fmNN8mN1b3Qqtkt_KZJCUEX_UoOi0n7Vl0UWQVjYqdg/gviz/tq?tqx=out:csv&gid=0&tq=select%20B%2CF%2CA%2CC%2CD%2CE%2CJ%2CM%2CN%2CO%20where%20A%3D%22Manager%22%20or%20A%3D%22Staff%22%20or%20A%3D%22Adviser%22
	~~\|format=CSV~~
	~~\|data= Name=1, Email=2, Role=3, FirstName=4, LastName=5, NickName=6, WikiUsername=7, HeadShot=8, SkillsLearned=9, SkillsLearning=10~~
	}}
	~~-->~~
	{{#get_web_data:		{{#get_web_data:
	url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pub?gid=1533673129&single=true&output=csv		url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pub?gid=1533673129&single=true&output=csv
Line 68:		Line 62:
	\|data=Name=Name, Email=BestEmail, Role=Primary Role, FirstName=FirstName, LastName=LastName, NickName=NickName, WikiUsername=WikiUsername, HeadShot=HeadShot, SkillsLearned=SkillsLearned, SkillsLearning=SkillsLearning		\|data=Name=Name, Email=BestEmail, Role=Primary Role, FirstName=FirstName, LastName=LastName, NickName=NickName, WikiUsername=WikiUsername, HeadShot=HeadShot, SkillsLearned=SkillsLearned, SkillsLearning=SkillsLearning
	\|filters=Primary Role=Staff		\|filters=Primary Role=Staff
			}}
			-->
			{{#get_web_data:
			url=https://docs.google.com/spreadsheets/u/2/d/1fmNN8mN1b3Qqtkt_KZJCUEX_UoOi0n7Vl0UWQVjYqdg/gviz/tq?tqx=out:csv&gid=0&tq=select%20B%2CF%2CA%2CC%2CD%2CE%2CJ%2CM%2CN%2CO%20where%20A%3D%22Staff%22
			\|format=CSV
			\|data= Name=1, Email=2, Role=3, FirstName=4, LastName=5, NickName=6, WikiUsername=7, HeadShot=8, SkillsLearned=9, SkillsLearning=10
	}}		}}

Mharrit1 at 19:16, 18 July 2020

2020-07-18T19:16:01Z

← Older revision		Revision as of 19:16, 18 July 2020
Line 54:		Line 54:

	===Staff:===		===Staff:===
			[[File: \| center \|150px \| thumb \|Annie Lu ]]
	<!-- Old way of doing this... doesn't seem to work anymore?		<!-- Old way of doing this... doesn't seem to work anymore?
			Should probably change this... looks ugly currently
			{{#get_web_data:
			url=https://docs.google.com/spreadsheets/u/2/d/1fmNN8mN1b3Qqtkt_KZJCUEX_UoOi0n7Vl0UWQVjYqdg/gviz/tq?tqx=out:csv&gid=0&tq=select%20B%2CF%2CA%2CC%2CD%2CE%2CJ%2CM%2CN%2CO%20where%20A%3D%22Manager%22%20or%20A%3D%22Staff%22%20or%20A%3D%22Adviser%22
			\|format=CSV
			\|data= Name=1, Email=2, Role=3, FirstName=4, LastName=5, NickName=6, WikiUsername=7, HeadShot=8, SkillsLearned=9, SkillsLearning=10
			}}
			-->
	{{#get_web_data:		{{#get_web_data:
	url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pub?gid=1533673129&single=true&output=csv		url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pub?gid=1533673129&single=true&output=csv
Line 61:		Line 68:
	\|data=Name=Name, Email=BestEmail, Role=Primary Role, FirstName=FirstName, LastName=LastName, NickName=NickName, WikiUsername=WikiUsername, HeadShot=HeadShot, SkillsLearned=SkillsLearned, SkillsLearning=SkillsLearning		\|data=Name=Name, Email=BestEmail, Role=Primary Role, FirstName=FirstName, LastName=LastName, NickName=NickName, WikiUsername=WikiUsername, HeadShot=HeadShot, SkillsLearned=SkillsLearned, SkillsLearning=SkillsLearning
	\|filters=Primary Role=Staff		\|filters=Primary Role=Staff
	}}
	~~Should probably change this... looks ugly currently~~
	~~-->~~
	~~{{#get_web_data:~~
	url=https://docs.google.com/spreadsheets/u/2/d/1fmNN8mN1b3Qqtkt_KZJCUEX_UoOi0n7Vl0UWQVjYqdg/gviz/tq?tqx=out:csv&gid=0&tq=select%20B%2CF%2CA%2CC%2CD%2CE%2CJ%2CM%2CN%2CO%20where%20A%3D%22Manager%22%20or%20A%3D%22Staff%22%20or%20A%3D%22Adviser%22
	~~\|format=CSV~~
	~~\|data= Name=1, Email=2, Role=3, FirstName=4, LastName=5, NickName=6, WikiUsername=7, HeadShot=8, SkillsLearned=9, SkillsLearning=10~~
	}}		}}

Mharrit1 at 01:33, 30 June 2020

2020-06-30T01:33:08Z

← Older revision		Revision as of 01:33, 30 June 2020
Line 88:		Line 88:
	{{!}} {{{LastName}}}		{{!}} {{{LastName}}}
	{{!}} {{{FirstName}}}		{{!}} {{{FirstName}}}
	{{!}} ~~'''~~{{{SkillsLearned}}}~~'''~~<br>''{{{SkillsLearning}}}''		{{!}} {{{SkillsLearned}}}<br><br>{{{SkillsLearning}}}
	{{!}} [[User:{{{WikiUsername}}} \| User Page for {{{WikiUsername}}}]]<br> ([[special:Contributions/{{{WikiUsername}}} \| {{{FirstName}}}'s Wiki Contributions ]])		{{!}} [[User:{{{WikiUsername}}} \| User Page for {{{WikiUsername}}}]]<br> ([[special:Contributions/{{{WikiUsername}}} \| {{{FirstName}}}'s Wiki Contributions ]])
	{{!}} [mailto:{{{Email}}} send email ]		{{!}} [mailto:{{{Email}}} send email ]