WordPress Snippets Random musings about life, in addition to tips, code snippets and plugins for th

Time 2021-06-23 19:18:39

Web Name: WordPress Snippets Random musings about life, in addition to tips, code snippets and plugins for th

WebSite: http://www.wpsnippets.com

ID:184945

Keywords:

in,life,to,

Description:

WordPress Snippets Random musings about life, in addition to tips, code snippets and plugins for the average and newbie WordPress userTo keep this post short-and-sweet, which will be the aim for future articles, I am experimenting with the Situation, Task, Action, Result (STAR) method for this write-up. Do let me know if you think it works or not in the comments or the contact form.SituationA TablePress table listing sport fixture results (e.g. football, hockey etc.) requires regular updating.This had been done by one person using an (offline) Excel spreadsheet and manually importing the .csv file. But the job has now been shared amongst a team of three (in different locations), so maintaining an offline spreadsheet no longer seemed practical.Thus it made sense to create and maintain a single version on Google Sheets that could be edited by all.But exporting and importing the file requires extra action. Could this process be automated?Automatically and periodically import a Google Sheet into TablePress to replace a table of fixture resultsActionDownload, install and enable the TablePress Automatic Periodic Table Import extension. Please note this is a premium plugin and so I would strongly encourage you to make a donation to Tobias Bäthge if you find it useful (the current recommended amount is $18).Login to Google Docs and open the sheet you wish to export.Click on File → Share → Anyone with the link can view to ensure the extension can access the sheet; simply enabling File → Publish to the web does not always work for the .csv format as this only makes the HTML output public, but not the .csv version.Copy the URL of the sheet, which should have the following format (where YOUR_DOCUMENT_KEY is the primary ID of your Google Sheet):https://docs.google.com/spreadsheets/d/YOUR_DOCUMENT_KEY/edit?usp=sharingPaste the URL into the Source field for the relevant table and replace:edit?usp=sharing with export?format=csvThe final format is as follows:https://docs.google.com/spreadsheets/d/YOUR_DOCUMENT_KEY/export?format=csvUPDATE with props to Alessandro: The above will import the first sheet ( Sheet1 ) or gid=0 so if you are looking to import a specific tab/sheet in a multi-sheet document, you will need to identify the GID=YOUR_GID_KEY reference and include it in the url.The final format of a specific sheet is as follows:https://docs.google.com/spreadsheets/d/YOUR_DOCUMENT_KEY/export?format=csv&gid=YOUR_GID_KEYClick the check-box to activate the Auto Import, set how frequently this should occur and save changes.ResultA single online spreadsheet hosted on Google Docs/Sheets editable by multiple authors, which is then automatically and periodically imported into TablePress to replace a table of fixture results.Demo: https://www.wpsnippets.com/tablepress-auto-import-using-google-sheets/ReferencesWordPress.org TablePress Support Auto-Import Google Drive SpreadsheetWordPress.org TablePress Support Automatic Periodic Table Import + Google SheetsNew Google Spreadsheets publish limitation comment by s4toriCSV Auto Fetch using Google Drive Spreadsheet Step 2New Google Spreadsheets publish limitation comment by brilletjuAnd if it wasn t for my exams, I would have picked up on this news earlier who would have thought?

TAGS:in life to 

<<< Thank you for your visit >>>

Hot Websites