Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? My use-case scenario here is that we have a Zoho Creator app...

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

Zoho Creator: Embed Forms/Reports on a Pagehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-embed-forms-reports-on-a-page.html

05 May 2022 snippet for a Zoho Creator page. We set the parameters of the form/report. Then this shows how to embed using a DIV layer which allows for CSS styling. The last part shows how to embed using an IFRAME tag which isn't great for CSS styling as you can't...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 this data to synchronize with data held in Zoho Inventory... How? So we're going to use a ZohoCRM function to get this file which we can run on demand. Why not in Zoho Inventory or any other Zoho app? Because we like to challenge ourselves... Once...

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

Zoho Creator: Sendmail a list of attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 This is a very quick article on sending an email with Deluge which needs a dynamic number of files attached to it. Why? This came up during a call with another developer and it occurred to me that perhaps this isn't clearly documented. But there are...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 signature (different per user) at the bottom of the email message. How? So there are a few issues with displaying images which would have other solutions, such as hosting the images on a web-server, or converting to a base64 or an SVG. ZohoCRM...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 receive alerts if your Notification Endpoint URL becomes unreachable, then click Save. Enter your Notification Endpoint URL, which must use 'https' and be accessible to you, and ensure it can respond to eBay's validation challenge code. In the...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 OpenAI's ChatGPT doesn't like more than a 500Mb file attachment; and no more than 10 files at a time. I have a 1.5 Gb video which has a duration of 5.5 hours. I struggled with this and ultimately used VOSK but I'm leaving the instructions here in case...

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

Added a Launcher and Unduplicaterhttps://www.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=87

19 May 2010 Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you...

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

Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 working in Zoho CRM. Why? To prove a point to ChatGPT who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my Cx is that they need documents converted from HTML to PDF — as in we send it a bit...

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

View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 for Joomla 2.5.x Note that Joomla versions 1.6 upwards include this as an option in the global configuration settings which you can access using your Joomla admin panel: Template Manager Options Preview Module Positions -> Disabled or Enabled You will...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 to do this:...... The form above will post to itself but more importantly is the enctype="multipart/form-data" without which your file upload processing won't work. The name of the file is important but you can call it what you want, in my case I've...

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

Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 file as well in your webroot as well as some strange index files with strange naming conventions (eg. xzcseifs_kdiek.html) which shouldn't be there either). You'll need to remove these and restore your website. I'd suggest joomlapack if you're using a...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 choose what’s best for my computer “ is by default checked. Below it you should see a list of visual effects, some of which will be unchecked if you are not experiencing the full range of Aero features. Select the custom option and then select all the...

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

Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 or follow a link to provide personal information. These are fake and are known as ‘spoof’ or ‘phishing’ emails. Any emails which combine urgency with a need for personal details should be treated with caution, no matter whom they appear to be from....

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Passwords: Did-you-knowhttps://www.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 Attack (=try every combination starting with words that exist). (source: Lockdown: Choosing a good password) And some more which have become more popular in recent years: There are loads of nightmare stories by security companies but one of my...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University Knowledge Base. The skin itself is the index page loaded for any page in the Wiki...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing" because we used to use MS Outlook to store these kind...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 3rd party avatar). Not riveting stuff but something that all my clients want. Fortunately for me, I just created one plugin which I can install on any number of Joomla 1.6 sites and it does all this for me... Neat huh? Folder I'm going to shove all...

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

SSRS Redirect after a report is runhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then...

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