/hhshhs
WordPress REST API retrieve data and email it as an xls using Google Sheets
Google Script to read a WordPress REST API endpoint into a Google Sheet and then email it ( no titles in this one, see other tutorials for titles )
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 |
function onOpen() { // setup a custom menu SpreadsheetApp.getUi() .createMenu('Barcodes') .addItem('Get Data', 'getPosts') .addToUi(); setupSheet(); } function setupSheet() { // just clear sheet and set & style headings var ss = SpreadsheetApp.getActiveSpreadsheet(); // set the tab name - just for neatness var sheetname = ss.getSheets()[0].setName('Data'); // clear the sheet var range = ss.getDataRange(); range.clear(); } function getPosts(){ setupSheet(); // loop here as we need get back posts in chunks, Rest API max is 100 post offset = 0; per_page = 10; while ( (got=getPage(offset,per_page)) > 0 ) { offset+=got; } SpreadsheetApp.flush(); sendGoogleSpreadsheetAsExcel(); } function getPage(offset,per_page) { // gets posts in chunks of per_page var ui = SpreadsheetApp.getUi(); // used for error messages var ss = SpreadsheetApp.getActiveSpreadsheet(); var options = { 'method': 'get', "contentType" : "application/json", 'muteHttpExceptions': true } var apiHost = 'https://YOURDOMAIN/wp-json'; // set to your own domain url = apiHost + '/wp/v2/ENDPOINT?per_page='+per_page+'&offset='+offset; // set to appropriate END POINT try { var response = UrlFetchApp.fetch(url, options); var data = JSON.parse(response) // loop through the map and output to sheet for (i = 0; i < data.length; i++) { row=offset+i+1; ss.getRange('A'+row).setValue(data[i].title.rendered); // work out the data structure by looking at the JSON ss.getRange('B'+row).setValue(data[i].barcode_id); // work out the data structure by looking at the JSON } return data.length; } catch(error) { var result = ui.alert( error.toString()); } return 0; } function sendGoogleSpreadsheetAsExcel(){ try { var ss = SpreadsheetApp.getActiveSpreadsheet(); var url = "https://docs.google.com/feeds/download/spreadsheets/Export?key=" + ss.getId() + "&exportFormat=xlsx"; var params = { method : "get", headers : {"Authorization": "Bearer " + ScriptApp.getOAuthToken()}, muteHttpExceptions: true }; var blob = UrlFetchApp.fetch(url, params).getBlob(); blob.setName(ss.getName() + ".xlsx"); // change the EMAIL address MailApp.sendEmail("youremail@example.com", "Google Sheet to Excel", "The XLSX file is attached", {attachments: [blob]}); } catch (f) { Logger.log(f.toString()); } } |
Stopping Genesis Full menu loading momentarily before the responsive menu
Many, if not all of StudioPress’s older themes flash up the full menu for a glimpse before the responsive hamburger comes in. This doesn’t look great but is easy to fix in 2 steps. First, tweak the CSS so that the start of the responsive section reads
|
1 2 3 |
body.js .genesis-nav-menu { display: none; } |
the responsive section may for instance start @media only screen and (max-width: 800px) { [Read the full article…]
Sage Business Cloud Accounting – a new name for Sage One
Sage Business Cloud Accounting is the new name for Sage One Accounting. To celebrate this, you can get a 50% discount by following this discount code link. Sage Business Cloud Accounting is an accounting and payroll solution for small businesses. Being a small business that uses an online accounting system ( not Sage ) I am [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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
<?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/ * License: GPL-3.0+ * License URI: http://www.gnu.org/licenses/gpl-3.0.txt */ function admin_email_callback( $wp_new_user_notification_email, $user, $blogname ) { $shopmanager = get_users( array( 'role' => 'shop_manager' ) ); // set the to: the first shop manager email. $wp_new_user_notification_email['to'] = $shopmanager[0]->user_email; return $wp_new_user_notification_email; } add_filter( 'wp_new_user_notification_email_admin', 'admin_email_callback', 10, 3 ); |
Download this as a plugin from fullworks -> https://fullworks.net/wp-content/uploads/2018/02/set-shop-manager-new-user.zip
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…]
DezRez XML import into WordPress
I am about to embark on some custom work on a DezRez XML import into WordPress, and want to gauge if there is any interest in this as a plugin, please use the comments to express issues and thoughts. My plan is, rather like my Rightmove XML converter, is to let WP All Import ( [Read the full article…]
- 1
- 2
- 3
- …
- 14
- Next Page »
