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

28 March 2015 // close connection curl_close($ch); Things I stumbled upon regarding SSL and cURL Posted data for third-party apps is often required via SSL so this may come in handy curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,...

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

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

13 June 2016 these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'À', 'A'); UPDATE `myTable` t SET...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and want the HTML to be indented...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 perform this operation This is a quick issue to resolve as it may be incorrect scopes specified but in my case is more than often the wrong accounts server: v_DataEndpoint = "https://books.zoho.com/api/v3/contacts?organization_id=123456789"; r_Response...

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

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

17 November 2020 I have had this working with the 2 CNAME records though. Some providers say this will take between 24-48 hours but I have often found that after a few hours, the effects have been propagated. A test I like to do is open the command-line in MS-Windows or...

• 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 special character is 3 easy steps: Hold down the ALT key (preferably the one on the left of the spacebar and not the Alt Gr often found on the right of the spacebar) then press the numbers in the numeric pad (while still holding down the ALT key), then...

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

Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-adding-10-minutes-to-a-crm-date-time-field.html

11 November 2021 + "-" + r_LeadDetails.get("Created_Time").subString(8,10); // // parse date into yyyy-MM-dd (using toString - often works) v_LeadCreatedDate = r_LeadDetails.get("Created_Time").toString("yyyy-MM-dd"); // // parse time into HH:mm:ss v_LeadCreatedTime =...

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

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

21 June 2022 an image to be downloaded, then uploaded to the Zoho Inventory or Zoho Books item record. Well I don't want to research this often so here's the quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list...

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

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

11 February 2023 This will create custom parameters/argument suffixes you can add which represent a whole string of words that you may use often but don't feel like typing every time. (follow these to the letter or it will simply reset your custom option): type /prefer...

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

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but it's easier to use an access token then getting the OAuth access codes from...

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

Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted to update the...

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

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

15 April 2024 design should go in the other direction, as in enter the products in Zoho Inventory and this feeds the website. More than often, however, this request comes in when the customer has already been setting their Zoho environment up and the Wordpress site...

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

SSRS - Lost window with datasetshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-lost-window-with-datasets.html

25 March 2011 Business Intelligence Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM...

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

Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so I may rename this article...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's...

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