Convert foreign characters to English alphabethttps://www.joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 'ź', 'z'); UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'ż', 'z'); Retrieve records with foreign characters: SELECT * FROM `myTable` WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My Joomla website needed the following...

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

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 do a bunch of screenshots: The error is that I can't receive/send messages on this account. The problem has something to do with DeltaSync no longer being supported. Deactivate the account by deselecting "include this account when receiving mail or...

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

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 an AutoHotkey program to simply return the folders in the drive and display the size of all the files/folders contained within. How? So I'll be putting this program for download from the download section of this website but I don't expect anyone to...

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

Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-apiv2-using-php-curl.html

30 January 2019 This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data from...

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

Zoho Deluge - Modify the product line items in an invoice modulehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

22 August 2019 This is a reminder on how to swap out a product in an invoice. Why? A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a product that they didn't stock. How? So editing the...

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

CSS Center an iFrame Horizontally and Verticallyhttps://www.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When the app within the iframe has an alert message, it popups a div at the centre of its app. The alert message is always at the center of...

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

Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded by: l_Users = zoho.crm.getRecords("users") or r_User =...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 How? Through sweat and perseverance. The trick is to update both the sales order id and to update the invoice line items with their respective sales order item id value. For our client's purpose, we are running a custom function off the invoice module...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) as `total`, `value`...

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

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 This is an article with the snippet of code required to duplicate or clone a record in Zoho CRM using Zoho Deluge. Why? The aim here is to have a scheduled task that on the 1st of every month, takes the invoices for the month before, and duplicates each...

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

Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

11 January 2021 A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name,...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 is a lot simpler than you might think... Doing the above, I would get a really messy response (I'm targeting an API made with ExpressionEngine) such as: Fatal error: Uncaught Error: Class '\Webservice\Service\Exception' not found in...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 This is a very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module to another, sometimes you need to manage existing...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 UK/US keyboard layout. Why? Being able to type international characters from other alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho CRM & Zoho Creator: Query returns some fields missing other data on the recordhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-creator-query-returns-some-fields-missing-other-data-on-the-record.html

26 July 2021 from using zoho.creator.getRecordById(). Why? My use case scenario is that I was trying to build a related list in Zoho CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being returned, all pretty much...

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

ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zohocrm-search-records-only-returns-certain-records.html

29 July 2021 converted" records: =zoho.crm.searchRecords(,,,,,); The solution: The long answer/investigation is getting a JSON response with a zoho.crm.getRecordByID() with a quote that works and a quote that doesn't Comparing both records JSON and finding the...

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

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

30 July 2021 != 0) { v_QuoteTotalGBP = (v_QuoteTotal.toDecimal() / v_ExchangeRate).toDecimal().round(2); // // format currency with commas (thousand separator) and 2 decimals v_QuoteTotalStr = v_QuoteTotal.toDecimal().round(2).toString().replaceAll("(?" + v_QuoteRef...

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

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

01 September 2021 1975-01-07 07-Jan-1975 Tue, 7 Jan 1975 Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge .toList() fails the function if the .get is...

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

Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 transactional modules (quotes, sales orders, invoices, purchase orders), you need to modify each product record (can be done with "Mass Update") to give them the applicable tax rates: Browse to a CRM product record (you can do mass edit on a listview of...

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

Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

24 September 2021 a currency or tax rate and want to push a sales order immediately over. Get Currencies Remember to replace the v_BooksOrgID with your client's Organization ID for Zoho Books and check the URL for whether it will be https://books.zoho.eu or...

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