Fruits table: Difference between revisions

From Discourse DB
Jump to navigation Jump to search
(Fixed Google Docs example)
(http => https)
 
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, with links added to the fruit names as a demonstration):
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=http://discoursedb.org/wiki/Special:GetData/Fruits_data|format=CSV with header|data=name=Name,color=Color,shape=Shape}}
{{#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_web_data:url=http://discoursedb.org/wiki/Special:GetData/Fruits_data?Color=Yellow|format=CSV with header|data=name=Name,color=Color,shape=Shape}}
{{#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 http://discoursedb.org/wiki/Special:GetData/Fruits_data, with an additional "color=Red" filter placed in the call):
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=http://discoursedb.org/wiki/Special:GetData/Fruits_data|format=CSV with header|filters=color=Red|data=name=Name,color=Color,shape=Shape}}
{{#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

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