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

07 April 2022 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So I've run into the issue that when downloading the certificate from GoDaddy...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 r_UploadPhoto = invokeurl [ url :v_Url type :POST files:f_base64 connection:"my_books_connection" ]; Caveat(s) The code above only uploads 1 photo... Update 2024: the code above STILL only uploads 1 photo. Error(s) Encountered {"code":37,"message":"The...

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

Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 intend to send the PDF files to your Kindle. Sending PDF files to your Kindle After you have done all that has been stated above, you are now ready to send PDF files to your Kindle device. Also, the above steps are a one-time process and won’t need to...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 Client ID and Client Secret. Do not share the Client ID and Client Secret with anyone. STEP 2: GENERATE A GRANT CODE On the above screen (Zoho API Console - Applications @ https://api-console.zoho.com/) Select your "Self Client" Enter in the applicable...

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

Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 , 'Price Disrepency' ) AND po."Purchase Order Status" NOT IN ( 'Cancelled' ) The second dataset will be a grouping of the above, in addition to including the customer ID and invoice ID, I'm calling this one "Invoice Items vs SoPo Items": SELECT...

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

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

11 February 2023 Volumetric Lighting Famous Artist Styles I've tried to list artists here who have styles that I could not generate using the above keywords/tokens. Usage:...in the style of... Note that some of these may verge on Copyright Infringement so be careful if...

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

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

06 August 2024 for the webhook in ZohoCRM: Login to ZohoCRM > Setup > Functions > and hover the mouse over the function you just created above (eg. Fn - ZohoSign - Document Completed) Hover the mouse over the ellipsis that appears and select "REST API" Then click on...

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

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

13 October 2025 } return v_OutputMessage; } Caveat(s): Tax rates have to have the same name in both CRM and Xero The code above is for EU / UK clients only (change the TLD as applicable) The code above accounts for clients not using the Items module and only the...

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

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

13 February 2013 to time is equal to 24 hours; 0.5 would be 12 hours and so forth. My formula: -- Given Cell B5 = 0.14 person days from above example. -- 1 person day = 26640 seconds and 1440 minutes = 24 hours. -- 0.07 person days = 30 minutes or 0.14 person days = 1...

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

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

13 December 2023 // and if we don't want/need to check, just round em (also means you don't need the above function to count decimals) var v_ProductCost = ZDK.Page.getField('Purchase_Rate').getValue();...

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

Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html

30 May 2009 any information we are holding on you is incorrect or incomplete, please write to or email us as soon as possible, at the above address. We will promptly correct any information found to be incorrect.

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

Pancakeshttps://joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 serve: caster sugar lemon juice lemon wedges Method Sift the flour and salt into a large mixing bowl with a sieve held high above the bowl so the flour gets a airing. Now make a well in the centre of the flour and break the eggs into it. Then begin...

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 'pdf', 'zip', 'flv', 'swf'); Online forums are saying this is it, but my system still didn't allow them and returned the above error... Secondly: Edit your /includes/specials/SpecialUpload.php file and add the following line shortly after the...

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

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

10 November 2009 as they love playing this about and giving all russians a bad name on the net. If you visit your site and receive either the above error or the alert that a malware was detected: congratulations! you've been hacked. So first of all check that this is...

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

Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 http://www.ukreg.com/ International Domain Registration Services (for .com, .net, .org, etc) - Note you can use the above UK ones for .com domains as well. http://www.networksolutions.com/ http://www.register.com/ http://www.godaddy.com/...

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

Webdeveloper-Speakhttps://joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 a Web Definition Glossary (there are others but this one's got that "kiwi" approach) A few terms I wanted to list up: "above the fold" or "before-the-scroll" The part of a webpage that is visible in the web browser window when the page first loads is...

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

UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 articles and not for this module? A. Think this is because that module is loaded before... not sure but for some reason the above command set names 'utf8' is obviously not run prior to the module being displayed.

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

Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 version 5.0.3. In earlier versions, this option has no effect. Using encryption, alternative Some reported problems with the above one. Try replacing the key "Encryption" with "Encrypt" instead....

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

Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 for ages (as I have), I found out you cannot declare the parameters used by the software within the SQL script... So the above should look more like this: -- =============================================================================== -- Description:...

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

Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 1 Welcome This is HP 2 Copyright This site and its design is property of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT...

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