Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions3.2.4- Fixed Bug: Some systems report "Strict Standards: Non-static method called" - Note: not included in auto-update as it only applies to certain environments. - Note: this version is also backwards compatible with...

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

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 from "ISO-8859-1" to "UTF-8". So if you get null from htmlspecialchars or htmlentities..." Source: PHP Manual My fix (in some cases): $my_description = html_entity_decode(htmlentities($my_description, ENT_COMPAT, 'ISO-8859-1', true), ENT_COMPAT,...

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

Display Feeds to major Social Networkshttps://joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so actual editing of the...

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

Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 fixed the problem. Step #1 Remove any images that you uploaded to Zoho and you've included in your HTML — this will be something like img src="https://crm.zoho.com/viewInLineImage?fileContent=: You should find your code now previews at a normal...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 then MS Windows will almost remember which apps were open on which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app on their second monitor. So I thought...

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

AutoHotkey: Get Media Information and Displayhttps://joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 also applicable to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 here is dependent on your service provider or domain registrar (website where you registered your domain). I've listed some third-party providers' instructions on how to set up a CNAME record at the bottom of this page. A subdomain is FREE as opposed to...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 This is an article to demo some Deluge code on how to download a file that was uploaded in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went wrong, I have a client with ZohoCRM who upload a PDF (can be...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 below shows how to do this Zoho CRM and how to do it in Zoho Books... The example below is that we are going to search for some records in Zoho Creator and display these in either Zoho Books or Zoho CRM. For demonstration purposes, these have been...

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

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

14 February 2022 (Multi Line) Refresh Token Expiry (Date-Time) AuthToken (Multi Line) AuthToken Expiry (Date-Time) You should end up with something like this screenshot: * Some of these fields are unnecessary for this example but are used to accommodate other API...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 and I was given £1000 towards a new computer... It's more than enough to get a running White Snow Edition PC but I put in some more to get the Graphics Card, more RAM, more fans, more... What I had: Personal Home PC Work-from-Home PC Case Antec Fusion...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 Then go to Setup > Connections > Add Connection Select Zoho OAuth and specify the scope(s) ZohoInventory.items.READ (add some more if you're unsure...) Give it a connection name and note down the connection link name. I'm calling mine joel_zoho...

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

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

09 December 2022 the row with an "End Date" specified (blank or not). console.log("Joel Lipman - 20221018 -------------------------"); // get some values from the current record var v_CurrencyCode = ZDK.Page.getField('Currency').getValue(); var v_ConsultantLocation =...

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

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

16 January 2023 file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets of code or screenshots below are made up. the Attachments.csv A data...

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

ZohoDeluge: Inserting a new line character in a CSVhttps://joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked...

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

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 to check. Why? Not sure how I came across it as most of our customers don't use ZohoMail, but there is a Zoho Toolkit to run some checks on the email deliverability for a customer: https://zohomail.tools/#runChecks. How? So first I'll outline the steps...

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

ZohoCRM: Using Criteria with Module Record Counthttps://joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 An example of code using the new API call "Module Record Count" with some criteria. Why? At time of print, I couldn't find an example of how to use this API call with search filters or criteria. Not sure about the rest of you, but I've been using this...

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

ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 sparse on how to connect a JS widget to the data held in Zoho Creator. Having this example for future use might save me some time. The following is the early version of a JS widget used for a customer and before I added all the layers of complexity, I...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 to display on their estimates in Zoho Books; such as product image, product name, product description. Granted that in some cases, the design should go in the other direction, as in enter the products in Zoho Inventory and this feeds the website. More...

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

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

07 May 2024 = "SPECIAL EDITION "; } // // other properties to add to the description v_ItemDescDisp = v_ItemDescDisp + "Awesome Reason To Buy This #1 "; v_ItemDescDisp = v_ItemDescDisp + "Awesome Reason To Buy This #2 "; // // condition grade v_ConditionChar =...

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