Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttp://mail.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would simply load the received XML with SimpleXML and use the...

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

Joes Revolver Map (JRM) Downloadshttp://mail.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 - Added div and parameter "module class" so that class name actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height" values. - Date Uploaded: Fri, 30th Jul 2010 1.1- Separated all...

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

Joes Youtube Plugin (JYP) Downloadshttp://mail.joellipman.com/component/content/article/joes-youtube-plugin-jyp-downloads.html?catid=92

07 September 2015 Width - Added Joomla Admin Panel option: Show Powered By - Date Uploaded: Wed, 16th Feb 2011 1.0.1- Removed all unnecessary code - Date Uploaded: Wed, 16th Feb 2011 1.0.0- Shock as its working - Date Uploaded: Wed, 16th Feb 2011

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

Migrating from Joomla 2.5.x to 3.4.xhttp://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 editor (ie. "Text-editor=None") If you are going to delete an object (eg. contacts), make a note on its contents or embedded code specific to the template. Copy over Users: Rename the Admin ID in the new v34 system to match your v25 system. Check your...

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

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

13 June 2016 * FROM `myTable` WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My Joomla website needed the following code to display the above foreign characters as entered into the Joomla administrators console with accents and all:...

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

Zoho Deluge: Loop through 30 Minute Slotshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing...

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

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

28 January 2019 for download from the download section of this website but I don't expect anyone to trust an executable EXE so here's the code of what it's doing which you can copy and paste to an AutoHotkey script: #NoEnv ; Recommended for performance and...

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

Zoho Deluge - Get distance between two coordinateshttp://mail.joellipman.com/articles/crm/zoho/get-distance-between-two-points-in-zoho.html

11 June 2019 if (unit=="K") { dist = dist * 1.609344 } // kilometers if (unit=="N") { dist = dist * 0.8684 } // nautical Production code // v_Latitude1, v_Longitude1 are coords for origin // v_Latitude2, v_Longitude2 are coords for destination v_Latitude1 =...

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

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 if you want this to be zero, you need to pass the option of tax as zero and remove all other options. Take the following code for example, this will add 20% tax to the overall Tax on this record (where p_QuoteID is the ID of the quote): // init Map...

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

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

22 August 2019 Additional Note(s): Just a list of fields to build up a Product Line Item: "Product_Details": [ { "product": { "Product_Code": null, "Currency": "USD", "name": "Test Product", "id": "1642130000000104087" }, "quantity": 1, "Discount": 0,...

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

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

23 September 2019 the parent... How? We're going to use a touch of CSS and instead of determining heights and alignment with JS. The following code will work with DIV layers but in this case, also works on iframes: HTML: Horizontally and Vertically Centered Iframe CSS:...

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

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 of the month and that Tuesday happens before today, then we want the last Tuesday of the next month. In the following code, consider that the date field we want to set is called "Switch_Over_Day". For the first Monday, we are going to select the first...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 with that profile. How? So you will need to be able to run AutoHotkey or create executables from an AHK file. Here is the code that creates a GUI with a ListView with rows that can be double-clicked to open the profile. As an overview: Setup a standard...

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

Zoho Deluge: Duplicate/Clone a Recordhttp://mail.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: Push Multi-Select Picklist containing Commas from CRM to Creatorhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 (Options 2 is split from 3) Solution: In the Creator picklist/dropdown options, change any comma to , then in your CRM code to create the record in Creator: l_MyMultiPicklist = List(); for each r_PicklistOption in...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 field. Create an entry with one image. Then... Go to Settings Publish Publish Component > Select your report Copy the embed code it pops up with to your clipboard Paste this into a browser Right-click on the image you want and inspect the element, this...

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

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

07 August 2020 // note this returns in 100ns units (= 100 nanoseconds) as per Microsoft Docs. 100ns Units So the following snippet of code will convert your 100ns units to a displayable Hours : Minutes : Seconds format which is more user-friendly: ; Function:...

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

Zoho Deluge: Search Records with Special Characters (COQL)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 https://zoho.com.cn/ then use the endpoint https://www.zohoapis.com.cn/crm/v2/coql 3. The Deluge Code - Uses the EU datacenter Note that using this method, you don't have to escape parentheses characters (): // initialize v_MatchedCount = 0;...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttp://mail.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 one app to another. The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250 expression found COLLECTION expression Another error you may get when...

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

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

03 February 2021 } } // yields: Successful Auth Caveat Unfortunately, I've titled this article as multi-dimensional but I found that this code doesn't support an array nested more than 2 levels deep. In other words, the above solution will not work if I wanted to post...

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