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

07 April 2022 a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again,...

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

Zoho CRM: Manage a subform using Client Scripthttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 "Which_rate_card_is_this_based_off". The expected outcome is the appending of a row to the subform based on the start date (first field in the subform) match in which case it should re-add the row with an "End Date" specified (blank or not)....

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

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

16 January 2023 either. How? In the example below, we are going to document how to import files associated to CRM Contact records. There's first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip"...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttp://mail.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 with the code to download image attachments from a Zoho Ticket and then to upload the attachment to Zoho Analytics. Why? First of all, we couldn't find how to sync attachments from ZohoDesk to ZohoAnalytics using the integration. Other tables will sync...

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

Zoho Creator: Render to PDF with margins and page numbershttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 back to the 90s. The code snippet below is just for a standard template with a modern design. How? Ok, admittedly, when first designing the template, there could have been a fair few improvements right out of the gate. Then the client comes back and...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 record [DEPRECATED: Please use Generic Webhook at the bottom of this page] For this, we'll create the webhook function first (this one I've called Fn - ZohoSign - Document Completed) and then make it into a REST API function for ZohoSign to send the...

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

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

13 March 2025 the platform must subscribe to or opt out of eBay marketplace account deletion/closure notifications before they make their first API call. Once the new developer's application is subscribed to eBay marketplace account deletion/closure notifications or...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 refer to the output without this column before modifying the query to include the page names of your survey. GENERAL was the first page asking for lead/contact name when I have this prepopulated from a ZohoCRM integration. Also note that the question...

• 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 case covers where the Cx had a working automatic bank feed for a while but at some point simply stopped working. How? First let's go through a resolution and get the official response on what impact this has on refreshing the token. Then I'll put all my...

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

Border settings not saving in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 the project but when I come back to the setting, it's still black. I found that you have to select a color or expression first, then define which border (top, right, bottom, left) the settings apply to... Mad. 1. Type your expressions/specify color...

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

Set default parameter dates to start and end of monthhttp://mail.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes googling...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Convert Decimal (Person Days) to Time in Excelhttp://mail.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join. Why? Currently the smallest bookable time by low-level...

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

Zoho Deluge - Get Full Day Namehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a few methods....

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttp://mail.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 not work] Using the administrator panel, go into each category and hit save and close starting with the parent categories first Copying article heading images from SP Page Builder to normal Joomla Articles SELECT new.`id`, old.`id`,...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 ID of this record var v_ThisRecordID = $Page.record_id; // get the full name of this contact (not sure why this returns both first and last) var v_ContactName = ZDK.Page.getField('Last_Name').getValue(); // get the email of this contact var...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttp://mail.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 number of decimals. I didn't need to use this method for my client; just rounding the decimals would suffice but here is my first version of the script: /* ******************************************************************************* Function: -...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow on save of the record, but the client wants the...

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

How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 guide will work for people who have certain extensions installed or who have SEO turned on as i have not tried it. Step One: First if you don't already have a page that you want to redirect to, you will create one within the Joomla 1.5 admin interface...

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

Setting up your store to use SSLhttp://mail.joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 To setup your store to use SSL (Secure Socket Layer) you will first need an SSL certificate. Many hosting companies will either provide (or can offer) "Shared SSL" or the option to buy a "Dedicated SSL" certificate. Shared SSL means that your store...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Counting the occurence of a word within a string: Benchmarkhttp://mail.joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took : 0.44112181663513 Seconds Count by Preg_Match+Count took : 0.46423101425171 Seconds Count by...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *