Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 What? This is an article which lists the functions necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired....

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Deluge - Get English Ordinalhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 What? This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018". Why? Well there's a long a way to do it (but...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 What? So I needed to clear space on a workstation's C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-apiv2-using-php-curl.html

30 January 2019 What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is very different to my code for OAuth when attended:...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next xTitleId = "JoelsTooCoolForExcel" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Specify Data Range", xTitleId,...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

How to run a .RUN filehttps://www.joellipman.com/articles/linux/how-to-run-a-run-file.html

19 September 2009 I've been told of two ways of running a downloaded .RUN file. Note: Bear in mind that the following is all case-sensitive. Through the terminal server Download the .RUN file to your desktop Open a terminal by going to Application > Accessories >...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 What? This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 What? This is an article resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

CSS Printing - Page Break Inside with Headers and Footershttps://www.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 What? I saw a lot of articles that would cover this but I wanted an example which includes headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but this is obviously for when it comes to printing. Why? I...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 What A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible...

• Type: Article
• Author: Joel Lipman
• Category: cPanel
• Language: *

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 What? So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

How to use download managers with Google Chromehttps://www.joellipman.com/articles/google/how-to-use-download-managers-with-google-chrome.html

19 September 2009 Apparently everyone knows how to download FLV videos from web addresses which use the Youtube syntax: http://www.youtube.com/watch?v= Using the bookmark feature: Right click on the bookmarks bar of Google Chrome. Type the name to what ever you want...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Cranberry flapjackhttps://www.joellipman.com/articles/_other-misc/cranberry-flapjack.html

07 July 2009 Ingredients 100g/3½oz oats 3 tbsp honey 50g/1¾oz self-raising flour 1 free-range egg 4 tbsp dried cranberries 5 tbsp butter For the caramel sauce 50g/1¾oz butter 50g/1¾oz caster sugar 50ml/1¾fl oz double cream 1 orange, peeled and segmented Method 1....

• Type: Article
• Author: Joel Lipman
• Category: Hobbies
• Language: *

Peanut Butter Milkshake Recipehttps://www.joellipman.com/articles/_other-misc/peanut-butter-milkshake-recipe.html

05 September 2009 Recipe Ingredients 1 milk 1 tbsp creamy peanut butter 1 tsp vanilla 1 vanilla ice cream Recipe Preparation Fill a tall glass or mug with as much milk as you wish (I use 1 cup); pour into blender, and add the vanilla and peanut butter. Whirl for 1...

• Type: Article
• Author: Joel Lipman
• Category: Hobbies
• Language: *

Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 What? Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 What? This is an article I hope to refine one day where given a set of breadcrumb hyperlinks, when I hover the mouse over the links, the text changes and the transition between the two is controlled smoothly. Why? At time of print, I couldn't find any...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *