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

02 February 2019 the access token, store it off the web but where this script can access it (read/write). // Location of private key on your server (JSON downloadable from Google) $api['keys']['private']['file'] = '.json'; // Location to store access token (needs be...

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

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

01 September 2021 A quick article to remind me of the regex to change a date from the format dd/MM/yyyy to yyyy-MM-dd. Why? Irrespective of server, organization or user settings, the date handling can vary. If we are getting a date from a CSV or other external source as...

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

SSRS Display question mark when date is blankhttps://joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 Certificates and click on the "Manage" button alongside the domain you want to install the SSL certificate for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and find the CRT file Return to your GoDaddy page and...

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

Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 only available in the most expensive subscription plan. NSFW will likely be blocked. Installing Stable Diffusion on a local server is the recommended stealth mode. Check out Matt Wolfe's video on how to do this: Youtube - Matt Wolfe - Install Stable...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 articles on this website but for clients in the US, where there could be 4 different timezones between customer, agent, HQ, server; we would create a separate table to manage this data. I can't do this for every client, so here's a quick snippet to just...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 why you would need to limit users so I don't blame them. But if you can, why not make your own? How? So you will need a webserver of your own running PHP 8. The following PHP script was only tested using PHP version 8.x so I can't say whether it will...

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

FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/web-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 - Knowledgebase - How to fix failed to retrieve directory listing error in FileZilla FTP Cannot connect to work ftp server from mac

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *