Test-ParserFunctions-in-ExternalData: Difference between revisions
Jump to navigation
Jump to search
| Line 41: | Line 41: | ||
! Role | ! Role | ||
! Test | ! Test | ||
! Wiki User Page | |||
! BestEmail | ! BestEmail | ||
! WikiUsername | ! WikiUsername | ||
Revision as of 23:56, 22 May 2020
TEST
Current Roster
Test Ifeq & Ifexist Outside ExternalData call, with no variables:
Test Ifeq: Result is.... Mharrit1 = Mharrit1
Test IfExist: Result is.... Mharrit1 User Page 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
}}
| 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: Role is undefined or empty. Role is undefined. Wiki User "{{{WikiUsername}}}" is {{{Role}}} "{{{Name}}}", who is a non-volunteer ({{{Role}}} != Manager).
}}
Use Display External Table
| Name | Role | Test | Wiki User Page | BestEmail | 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