Test-ParserFunctions-in-ExternalData: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
=== Current Roster === | === Current Roster === | ||
Test IfExist: {{#ifexist: User:Mharrit1 | Mharrit1 User Page Exists | No User Page]]}} | Test IfExist Outside ExternalData call: {{#ifexist: User:Mharrit1 | Mharrit1 User Page Exists | No User Page]]}} | ||
{{#get_web_data: | {{#get_web_data: | ||
| Line 12: | Line 12: | ||
{| class="wikitable" | {| class="wikitable" | ||
! Name | |||
! Wiki User Page | ! Wiki User Page | ||
! Role | |||
! Test | ! Test | ||
{{#for_external_table:<nowiki/> | {{#for_external_table:<nowiki/> | ||
{{!}}- | {{!}}- | ||
{{!}} {{{Name}}} | |||
{{!}}[[User:{{{WikiUsername}}}| {{{WikiUsername}}} Userpage ]] | {{!}}[[User:{{{WikiUsername}}}| {{{WikiUsername}}} Userpage ]] | ||
{{!}} {{#ifexist:User:{{{WikiUsername}}} | YES User | {{!}} {{{Role}}} | ||
{{!}} {{#ifexist:User:{{{WikiUsername}}} | YES User:{{{WikiUsername}}} | NO User Page}} | |||
}} | }} | ||
|} | |} | ||
====ExternalData without wiki table markup==== | ====ExternalData without wiki table markup==== | ||
{{#for_external_table: Wiki User "{{{WikiUsername}}}" is | {{#for_external_table: Wiki User "{{{WikiUsername}}}" is {{{Role}}} "{{{Name}}}", who is a {{#ifeq: "{{{Role}}}" | "Manager" | volunteer | non-volunteer ({{{Role}}} != Manager).<p>}} }} | ||
| Line 51: | Line 40: | ||
|} | |} | ||
ManagerData Template: | |||
{{ManagerData}} | {{ManagerData}} | ||
Revision as of 18:03, 22 May 2020
TEST
Current Roster
Test IfExist Outside ExternalData call: Mharrit1 User Page Exists
{{#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: Wiki User "{{{WikiUsername}}}" is {{{Role}}} "{{{Name}}}", who is a non-volunteer ({{{Role}}} != Manager).
}}
Use Display External Table
| Name | Role | 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