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

07 April 2022 An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The...

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

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

05 May 2022 Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template snippet for a Zoho Creator page. We set the parameters of the...

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

ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 is the same as on the Shopify website. Included in this is the feature to export all the data as a CSV and to email it to myself: void API.fn_ShopifyQuery_UpdateAllProducts() { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10; b_HasNextPage...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 -------------- -------------- -------------- Joel Google Ads Accepted Invited Sent Me Web Invited Accepted Sent Myself Walk-In Accepted Sent Invited The catch is that our campaign names are in data rows not individual columns. How? There may be ways of...

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

Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 items as well as setting the value of lookup fields so I thought it was worth an article and may help someone else (or even myself) in the future. At time of print (9th October 2025), for some reason, if you click on the plus icon next to Sales Order...

• 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 Credentials" then selecting this should also run you through setting up the connection again (never seen this option myself). If it shows “Connected via Yodlee” or “Connected via Plaid,” note it for later. These indicate which aggregator the feed was...

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

AutoHotkey Ternary Operatorhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 http://www.autohotkey.com/forum/topic29752.html) which I'll put in soon. I just needed something on my site now as I find myself looking for this bit of info every now and again.

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

Welcome to my website!http://mail.joellipman.com/articles/web-development/welcome-to-my-website.html

19 March 2011 Hi Everybody! My name is Joe. I like to think of myself as a web-developer but then I like to get involved with anything related to computers. I've been writing websites and scripts commercially since 1997 and I'm using this website to store notes as I...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

SQL: Use CASE for Relevance columnhttp://mail.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...

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

A for loop within a for loop in MS-DOShttp://mail.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation...

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

PHP: First name and Initial of Surnamehttp://mail.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...

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

CSV Chart Generatorhttp://mail.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation with these and I myself don't put any copyright information on the end product. I needed a program to: + Group all the data by a specified column +...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

MS Excel - Open CSV with Long Numbershttp://mail.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID...

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