Test-ParserFunctions-in-ExternalData

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.

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.

Test Case:

Display the current Manager / Staff roster from Google Sheet CSV web feed via the CSV import capability of the GetExternalData extension.

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.

Test ifexist in an ExternalData call:

{{#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
|format=CSV with header
|data=Name=Name, Email=BestEmail, Role=Primary Role, FirstName=FirstName, LastName=LastName, NickName=NickName, WikiUsername=WikiUsername

}}

Use Display External Table

Name	Role	Wiki User Page	Email	WikiUsername {{#display_external_table:template=ManagerData|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername }}

ManagerData Template:

|- | {{{Role}}} | {{{FirstName}}} | {{{LastName}}} | User:{{{WikiUsername}}} (Page not created)
([[special:Contributions/{{{WikiUsername}}} | {{{FirstName}}}'s Wiki Contributions]]) | send email

Try using display_external_table without table markup.

{{#display_external_table:template=ManagerDataNoTable|data= Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername }}

Name	Wiki User Page	Role	Test {{#for_external_table:
{{{Name}}}	[[User:{{{WikiUsername}}}| {{{WikiUsername}}} Userpage ]]	{{{Role}}}	NO User Page }}

ExternalData without wiki table markup

{{#for_external_table: {{{wikiusername}}}

{{{wikiusername}}} {{ifexist User:{{{wikiusername}}} | User:{{{wikiusername}}} | No User Page for {{{wikiusername}}} }}

{{{Name}}} ({{{Email}}}) is WikiUser {{{WikiUsername}}} ({{{Role}}}) and is not a volunteer User Page Doesn't Exist.

}} {{{Name}}} ({{{Email}}}) is WikiUser {{{WikiUsername}}} ({{{Role}}}) and is not a volunteer User Page Doesn't Exist.