Template:Repository fetch: Difference between revisions

From Indian River Lagoon Project
mNo edit summary
mNo edit summary
 
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
<!-- Cargo database Links -->
[[Repository_Table{{!}}View Repository Data Table]] {{!}} [[Repository{{!}}View Repository Page]]
This template uses Extension:externaldata to fetch data from a local csv file, and then sends it to Template:Repository_store, which creates a database table (if doesn't exist), and stores the fetched data.
Edit this template for instructions.
<!--
Uncomment the two code sections below to fetch new data. Caution: This will dump the current data.  if you need to keep the old table, use PHPAdmin to back it up before uncommenting this page.
Click Preview to start the data fetch and store process. This may take a minute depending on the data size.
***Make sure to RECOMMENT the code sections before saving this file or it will overwrite the data every time it is viewed.***
-->
<!-- Fetch the Data -->
<!-- Fetch the Data -->
{{#get_web_data:
{{#get_web_data:
url=http://book/Indian_River_Lagoon_Repository_Data.csv
url=https://indianriverlagoonnews.org/guide/resources/documents/Indian_River_Lagoon_Repository - Data.csv
|format=CSV with header
|format=CSV with header
|data=Title=Title,Type=Type,Count=Count,Size=Size,Author=Author,Publication=Publication,Publisher=Publisher,Published=Published,Waterbody=Waterbody,Region=Region,URL=URL,Description=Description,Image=Image,Archived=Archived
|data=Title=Title,Type=Type,Count=Count,Size=Size,Author=Author,Publication=Publication,Publisher=Publisher,Published=Published,Waterbody=Waterbody,Region=Region,Description=Description,Image=Image,URL=URL,Archived=Archived,ArchiveURL=ArchiveURL }}
}}
<!-- Cargo database Links -->
[[Repository_Table{{!}}View Repository Data Table]] {{!}} [[Repository{{!}}View Repository Page]]


<!-- Store Fetched Data -->
<!-- Store Fetched Data -->
{{#display_external_table:template=Repository store|data=Title=Title,Type=Type,Count=Count,Size=Size,Author=Author,Publication=Publication,Publisher=Publisher,Published=Published,Waterbody=Waterbody,Region=Region,URL=URL,Description=Description,Image=Image,Archived=Archived}}
{{#display_external_table:template=Repository store|data=Title=Title,Type=Type,Count=Count,Size=Size,Author=Author,Publication=Publication,Publisher=Publisher,Published=Published,Waterbody=Waterbody,Region=Region,Description=Description,Image=Image,URL=URL,Archived=Archived,ArchiveURL=ArchiveURL }}

Latest revision as of 08:58, May 28, 2023

View Repository Data Table | View Repository Page

This template uses Extension:externaldata to fetch data from a local csv file, and then sends it to Template:Repository_store, which creates a database table (if doesn't exist), and stores the fetched data.

Edit this template for instructions.