To have a dynamic section from Google Docs as below simply create ( and share to editors as required) your Google Doc and go to File>Publish to Web in the Doc – select embed – Create your post of page and where you want the Google Doc add an html block and put the generated [Read the full article…]
Sage Business Cloud Accounting Review
I don’t normally write reviews cloud software, I’m more of a geek than an author and prefer writing code to English. In fact I could only manage a C grade at O-Level English but A’s for Maths and Physics, so nothing is surprising. What is in a name? Sage renamed their Sage One Accounting to [Read the full article…]
Archiving old files after 18 months
In a WordPress installation I have an uploads folder that contains html files, that need to be archived away after 18 months. As the links are dynamically built I don’t need to worry about anything except moving them. If they were normal WordPress uploads that would be different. So in this case a simple monthly [Read the full article…]
Linking WooCommerce to a Spreadsheet using Google Sheets and the REST API
IMPORTANT NOTE As of 22 Oct 2019 – this script seems to be in an infinite loop – so use this as a coding concept ONLY. I will debug it in due course, and update – BUT if you spot the issue first please do leave me a comment below with your solution. Following on [Read the full article…]
Code snippet to change notification of new users
Example plugin to set admin notification of new users. In this case it uses the first user defined as shop_manager role <?php /* * * Plugin Name: Notify New Users to Shop Manager * Plugin URI: https://fullworks.net/products/custom-plugin-development/ * Description: Needs Woo Commerce of Course * Version: 1.0 * Author: Fullworks * Author URI: http://fullworks.net/ * [Read the full article…]
Putting it all together – authenticate, read and update WordPress from a spreadsheet
This is my fourth post in my series of how to build a script to manage WordPress data via the API and a spreadsheet. If you have arrived here without looking at the others you probably should start at the beginning here. In this tutorial I’m going to handle updating and then pull it all [Read the full article…]
How to authenticate WordPress Rest API from Google Sheets / Scripts
This is the third tutorial in my series relating to integrating Google Sheets and WordPress using the REST API. The first post covered reading basic post information into a spreadsheet. The second post was about getting meta data from the REST API, which can be a little tricky. This one covers authentication. Basically as an [Read the full article…]
Getting post meta via WordPress REST API
This the second post post in my series about getting and updating WordPress data via a spreadsheet. The first post focused on the basics of Google Apps Scripting and the API call to the WP REST API – if you haven’t seen it you can read it here. This post is about meta data. In [Read the full article…]
Linking WordPress to a Spreadsheet using WP REST API and Google Sheets scripts
This post shows you how you can link a Google Spreadsheet to a WordPress website to extract data. I will write some further posts covering authentication and updating too. However a little warning, this is a programming task and a basic understanding of javascript is really required to follow what is going on. WordPress is [Read the full article…]
Recipe for a Raspberry Pi Kiosk
I recently set up a Raspberry Pi as Chromium Kiosk so I could display a webpage on a wall mounted TV screen. I have written what I did in an easy to follow recipe format. If you follow configuration steps carefully you should be successful in setting up your Raspberry pi to work as a [Read the full article…]
