Fruits table: Difference between revisions
Jump to navigation
Jump to search
Yaron Koren (talk | contribs) (#get_external_data => #get_web_data) |
Yaron Koren (talk | contribs) (http => https) |
||
(3 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
Data was retrieved from the [[fruits data]] page, using the [http://www.mediawiki.org/wiki/Extension:External_Data External Data extension]. | Data was retrieved from the [[fruits data]] page, using the [http://www.mediawiki.org/wiki/Extension:External_Data External Data extension]. | ||
All fruits (retrieved from the URL | All fruits (retrieved from the URL https://discoursedb.org/wiki/Special:GetData/Fruits_data, with links added to the fruit names as a demonstration): | ||
{{#get_web_data:url= | {{#get_web_data:url=https://discoursedb.org/wiki/Special:GetData/Fruits_data|format=CSV with header|data=name=Name,color=Color,shape=Shape}} | ||
{| class="wikitable" | {| class="wikitable" | ||
! Name | ! Name | ||
Line 14: | Line 14: | ||
Yellow fruits only (retrieved from the URL | Yellow fruits only (retrieved from the URL https://discoursedb.org/wiki/Special:GetData/Fruits_data?Color=Yellow): | ||
{{#get_web_data:url= | {{#get_web_data:url=https://discoursedb.org/wiki/Special:GetData/Fruits_data?Color=Yellow|format=CSV with header|data=name=Name,color=Color,shape=Shape}} | ||
{| class="wikitable" | {| class="wikitable" | ||
! Name | ! Name | ||
Line 27: | Line 27: | ||
Red fruits only (retrieved from the URL | Red fruits only (retrieved from the URL https://discoursedb.org/wiki/Special:GetData/Fruits_data, with an additional "color=Red" filter placed in the call): | ||
{{#get_web_data:url= | {{#get_web_data:url=https://discoursedb.org/wiki/Special:GetData/Fruits_data|format=CSV with header|filters=color=Red|data=name=Name,color=Color,shape=Shape}} | ||
{| class="wikitable" | {| class="wikitable" | ||
! Name | ! Name | ||
Line 37: | Line 37: | ||
{{!}} {{{color}}} | {{!}} {{{color}}} | ||
{{!}} {{{shape}}} }} | {{!}} {{{shape}}} }} | ||
|} | |||
Here is an example using data from a Google Docs spreadsheet: | |||
{{#get_web_data:url=https://docs.google.com/spreadsheets/d/1VJYDENGxtuqxrRQrzWcWxdsgsYUO2flEZ-JBqIzpjDc/pub?output=csv|format=CSV with header|data=jednotka=Jednotka,sila=Síla,prestiz=Prestiž,vyroba=Výroba,cena=Cena,zold=Zold}} | |||
{| class="wikitable" | |||
! Jednotka | |||
! Síla | |||
! Prestiž | |||
! Výroba | |||
! Cena na dom. trhu | |||
! Žold {{#for_external_table:<nowiki/> | |||
{{!}}- | |||
{{!}} {{{jednotka}}} | |||
{{!}} {{{sila}}} | |||
{{!}} {{{prestiz}}} | |||
{{!}} {{{vyroba}}} | |||
{{!}} {{{cena}}} | |||
{{!}} {{{zold}}} }} | |||
|} | |} |
Latest revision as of 12:48, June 5, 2020
Data was retrieved from the fruits data page, using the External Data extension.
All fruits (retrieved from the URL https://discoursedb.org/wiki/Special:GetData/Fruits_data, with links added to the fruit names as a demonstration):
Name | Color | Shape |
---|---|---|
Apple | Red or green | Round |
Banana | Yellow | Oblong |
Orange | Orange | Round |
Pear | Yellow | Pear-shaped |
Yellow fruits only (retrieved from the URL https://discoursedb.org/wiki/Special:GetData/Fruits_data?Color=Yellow):
Name | Color | Shape |
---|---|---|
Banana | Yellow | Oblong |
Pear | Yellow | Pear-shaped |
Red fruits only (retrieved from the URL https://discoursedb.org/wiki/Special:GetData/Fruits_data, with an additional "color=Red" filter placed in the call):
Name | Color | Shape |
---|
Here is an example using data from a Google Docs spreadsheet:
Jednotka | Síla | Prestiž | Výroba | Cena na dom. trhu | Žold |
---|