A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 Microsoft Windows 7 Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 What? "Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

DJI Phantom FC40 - Fun at the raceshttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 Some more distractions. This is my filming of some Radio Controlled cars at the Torch Racing, UK event last Sunday. The FPV latency isn't good on this camera so it was no use here, so several challenges: No FPV: Keep the quadcopter pointed at the car. I...

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

List of Font Awesomehttp://mail.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 I needed to use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that has...

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

Joes Word Cloud (JWC) Downloadhttp://mail.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 MySQLhttp://mail.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 Networkshttp://mail.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 tinyhttp://mail.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 Desktopshttp://mail.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 Displayhttp://mail.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 Portalhttp://mail.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)http://mail.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 Delugehttp://mail.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)http://mail.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 GPUhttp://mail.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: UploadSiteHostedPictureshttp://mail.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 Scripthttp://mail.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 Attachmentshttp://mail.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 CSVhttp://mail.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 / Toolkithttp://mail.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 Counthttp://mail.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: *