Test-ParserFunctions-in-ExternalData - Revision history

Mharrit1 at 23:30, 24 May 2020

2020-05-24T23:30:18Z

← Older revision		Revision as of 23:30, 24 May 2020
Line 51:		Line 51:
	!class=unsortable\| Wiki User Page		!class=unsortable\| Wiki User Page
	!class=unsortable\| Email		!class=unsortable\| Email
	! WikiUsername		! WikiUsername {{#display_external_table:template=ManagerData\|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername, FirstName=FirstName, LastName=LastName }}
	{{#display_external_table:template=ManagerData\|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername, FirstName=FirstName, LastName=LastName }}
	\|}		\|}

Mharrit1 at 23:23, 24 May 2020

2020-05-24T23:23:44Z

← Older revision		Revision as of 23:23, 24 May 2020
Line 52:		Line 52:
	!class=unsortable\| Email		!class=unsortable\| Email
	! WikiUsername		! WikiUsername

	{{#display_external_table:template=ManagerData\|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername, FirstName=FirstName, LastName=LastName }}		{{#display_external_table:template=ManagerData\|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername, FirstName=FirstName, LastName=LastName }}
	\|}		\|}

Mharrit1 at 23:23, 24 May 2020

2020-05-24T23:23:09Z

← Older revision		Revision as of 23:23, 24 May 2020
Line 49:		Line 49:
	! First Name		! First Name
	! Last Name		! Last Name
	! Wiki User Page		!class=unsortable\| Wiki User Page
	! Email		!class=unsortable\| Email
	! WikiUsername		! WikiUsername

Mharrit1 at 23:22, 24 May 2020

2020-05-24T23:22:23Z

← Older revision		Revision as of 23:22, 24 May 2020
Line 45:		Line 45:


	{\| class="wikitable"		{\| class="wikitable sortable"
	! Role		! Role
	! First Name		! First Name

Mharrit1 at 23:02, 24 May 2020

2020-05-24T23:02:26Z

← Older revision		Revision as of 23:02, 24 May 2020
Line 46:		Line 46:

	{\| class="wikitable"		{\| class="wikitable"
	~~! Name~~
	! Role		! Role
			! First Name
			! Last Name
	! Wiki User Page		! Wiki User Page
	! Email		! Email

Mharrit1 at 16:12, 24 May 2020

2020-05-24T16:12:53Z

← Older revision		Revision as of 16:12, 24 May 2020
Line 52:		Line 52:
	! WikiUsername		! WikiUsername

	{{#display_external_table:template=ManagerData\|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername }}		{{#display_external_table:template=ManagerData\|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername, FirstName=FirstName, LastName=LastName }}
	\|}		\|}

Gfc at 00:19, 24 May 2020

2020-05-24T00:19:08Z

← Older revision		Revision as of 00:19, 24 May 2020
Line 31:		Line 31:
	*Displaying individual values		*Displaying individual values
	*Displaying a table of values		*Displaying a table of values
	## for_external_table		# for_external_table
	## display_external_table		# display_external_table

	{{#get_web_data:		{{#get_web_data:

Gfc at 00:18, 24 May 2020

2020-05-24T00:18:50Z

← Older revision		Revision as of 00:18, 24 May 2020
Line 27:		Line 27:


			GetExternalData provides several ways to display the retrieved data on the wiki page. These are:

			*Displaying individual values
			*Displaying a table of values
			## for_external_table
			## display_external_table

	{{#get_web_data:		{{#get_web_data:
Line 38:		Line 43:
	====Use Display External Table ====		====Use Display External Table ====

	~~GetExternalData provides several ways to display the retrieved data on the wiki page. These are:~~

Gfc: /* Test Case: */

2020-05-24T00:16:00Z

Test Case:

← Older revision		Revision as of 00:16, 24 May 2020
Line 12:		Line 12:
	=== Test Case: ===		=== Test Case: ===

	Display the current Manager / Staff roster from Google Sheet CSV web feed via the CSV import capability of the GetExternalData extension.		Display the current Manager / Staff roster from Google Sheet CSV web feed via the CSV import capability of the GetExternalData extension. Display the Name, email address, Wiki User Name, a link to that person's User page (if it exists), and whether that person is a volunteer or not.

	Use #ifexist and #ifeq conditionals in the ParserFunctions Extension to "clean up" the import, for example, ensuring that we only show links to a wiki user page if that user page actually exists.		Use #ifexist and #ifeq conditionals in the ParserFunctions Extension to "clean up" the import, for example, ensuring that we only show links to a wiki user page if that user page actually exists.
Line 25:		Line 25:

	-->		-->
	~~==== Test ifexist in an ExternalData call: ====~~



	{{#get_web_data:		{{#get_web_data:
Line 35:		Line 37:

	====Use Display External Table ====		====Use Display External Table ====

			GetExternalData provides several ways to display the retrieved data on the wiki page. These are:


	{\| class="wikitable"		{\| class="wikitable"
	! Name		! Name

Gfc: /* Testing combined use of GetExternalData and ParserFunctions extensions */

2020-05-24T00:05:58Z

Testing combined use of GetExternalData and ParserFunctions extensions

← Older revision		Revision as of 00:05, 24 May 2020
Line 1:		Line 1:
	==Testing combined use of GetExternalData and ParserFunctions extensions==		==Testing combined use of GetExternalData and ParserFunctions extensions==

	This page ~~is used~~ to test a variety of methods for combining the functionality of the GetExternalData extension with the ParserFunctions extension. Initial attempts to use the two extensions together failed. Though the documentation isn't entirely clear, it appears that since both extensions use the MediaWiki template functionality (using curly braces "{ }" that there is some incompatibility.		This page was created to test a variety of methods for combining the functionality of the GetExternalData extension with the ParserFunctions extension. Initial attempts to use the two extensions together failed. Though the documentation isn't entirely clear, it appears that since both extensions use the MediaWiki template functionality (using curly braces "{ }" that there is some incompatibility.

			The reason we need to use ParserFunction extension is to allow us to make minor changes of the data imported by GetExternalData. For example, the data contains a column named 'Role' that describes the person's role, whether they are a Manager, Staff, or Advisor. Managers are unpaid volunteers while Staff and Advisers are paid. Using ParserFunction conditionals we can group Staff and Advisers together under the label 'Non Volunteer' while Managers are labelled 'Volunteer'

			Another important reason for conditional testing relates to the need to handle a field differently for different rows. For example, not all Managers have created a user page. We don't keep track of this in the spreadsheet. When we create a link to the user page for each Manager, we can test for the existence of that page and not create a link if the page doesn;t exist.

	Testing will continue but for the immediate future, we have found that using the Display_External_Table format option does work. This option requires the creation of a template for each query and the presence of variable names in both the wiki page and the template makes maintenance somewhat confusing.		Testing will continue but for the immediate future, we have found that using the Display_External_Table format option does work. This option requires the creation of a template for each query and the presence of variable names in both the wiki page and the template makes maintenance somewhat confusing.