Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttp://mail.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: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 Zone // convert to IANA TimeZone and hard-code this whenever querying Xero dates/times // if hard-coding timezone from Zoho server (only takes long unix epoch seconds: v_ZohoTime =...

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

SSRS Display question mark when date is blankhttp://mail.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

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)http://mail.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: *

GoDaddy Apache cPanel: Install SSL Certificatehttp://mail.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 Promptshttp://mail.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 effecthttp://mail.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 APIhttp://mail.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: *

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 = standalone.fn_Xero_MapTaxRates(); m_ZohoTaxRates = r_ZohoTaxRates.toMap(); if(b_Debug) { info m_ZohoTaxRates; } // // server timezones v_XeroTimeZone = "Europe/London"; v_ZohoTimeZone = "Europe/London"; // // enter the CRM record ID of your...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 becomes stuck and cannot be refreshed or disabled from within Zoho Books. Pre-amble: I had to check ZohoBooks Downtime Server Incidents: US Zoho Services Availability or Zoho EU Services Availability Permission Issue: Are we logged in to Zoho Books as...

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

FTP on Mac: Failed to retrieve directory listinghttp://mail.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: *