Fruits table: Difference between revisions

From Discourse DB
Jump to navigation Jump to search
(Added more explanation)
(http => https)
 
(10 intermediate revisions by 3 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 http://discoursedb.org/wiki/Special:GetData/Fruits_data):
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_external_data:http://discoursedb.org/wiki/Special:GetData/Fruits_data|csv|name=1|color=2|shape=3}}
{{#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 http://discoursedb.org/wiki/Special:GetData/Fruits_data?Color=Yellow):
Yellow fruits only (retrieved from the URL https://discoursedb.org/wiki/Special:GetData/Fruits_data?Color=Yellow):
{{#get_external_data:http://discoursedb.org/wiki/Special:GetData/Fruits_data?Color=Yellow|csv|name=1|color=2|shape=3}}
{{#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 24: Line 24:
{{!}} {{{color}}}
{{!}} {{{color}}}
{{!}} {{{shape}}} }}
{{!}} {{{shape}}} }}
|}
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=https://discoursedb.org/wiki/Special:GetData/Fruits_data|format=CSV with header|filters=color=Red|data=name=Name,color=Color,shape=Shape}}
{| class="wikitable"
! Name
! Color
! Shape {{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{name}}}
{{!}} {{{color}}}
{{!}} {{{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
Retrieved from "https://discoursedb.org/w/index.php?title=Fruits_table&oldid=31379"