Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 a Password Security System I wrote back in 2008 and I missed the analysis capability so I have restored it on my personal website. Security through Obscurity "Security through Obscurity" is always ultimately fallible. This password checker can not...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 jComments extension is easily automated and no longer blocks spam comments. How? So the main bulk came from the JoomlaTune website but as it was a forum post that may get moved/deleted, I've copied most of it and put it here with my minor...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 a change on a live system to a service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which I found on the web and can be applied if you work somewhere that doesn't...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 the issue, once I had the right SHA1 registered in the Google APIs console other users could download the file from my website and see the maps. I'm not saying it won't fix a problem for you, just that downloading from the Play store was unrelated to...

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

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 Base 40°8′57″N 116°19′17″E Beijing Tongxian Air Base 39°48′40″N 116°42′30″E Note that I tend to copy the coordinates off a website which has strange apostrophes and double-quotes. You can change this but remember to put two double-quotes if you are...

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

Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 What? A note to myself on how to create a development/test version of a production/live Wordpress CMS site. Why? I have a website sitting at a domain (eg. www.myexample.com), and I want to create an exact copy at a subdomain entitled "dev1" (eg....

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 search so other valid values are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search results page. There should be several additional options to your search that will be displayed under...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 the offending menu items somewhere. How? The fix that I use involves a change to #__menu table in the database for that website. The example used here will be to create an about-us page but I already have two items using the alias "about" and...

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

Joes Google Map for Joomla (JGM)https://www.joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 it simple enough for my clients. Why am I giving it away for free? Could be malicious or could be that I made this for a website, got paid, and I've used it again and again since. I learnt how to do this because someone else taught me for free. Enjoy!...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

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

04 September 2015 on image quality or overhead maintenance. It's basically a font set that has all the icons you would want in a modern website design. How? To use this list, you can either: Copy the font files to your template folder (my preference) and add the linked...

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

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

13 June 2016 with foreign characters: SELECT * 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...

• 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 Windows Live Mail Error ID: 0x8DE00005 How? I don't remember the time when the Microsoft website became helpful but as they already have an article on this, I'm going to do a bunch of screenshots: The error is that I can't receive/send messages on this...

• 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 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 trust an executable EXE so here's the code of what it's doing which you can copy and paste...

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

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 to allow users to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click... How? To test any of the following, type the windows key and...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 to identify if the client has 3rd-parties adding clients. eg. "JoelLipman_BooksConnector". Homepage URL: put our corporate website URL, this is for developers who need to query what this app belongs to or does. eg. "https://www.joellipman.com/"...

• 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 ÷ Division sign 0247 ° Degree symbol 0176 ¬ Not symbol 0172 ± Plus/minus 0177 µ Micro 0181 ‰ Per Mille (1/1000th) 0137 Website © Copyright symbol 0169 ® Registered symbol 0174 ™ Trademark 0153 • List Dot 0149 § Section Symbol 0167 † Dagger 0134 ‡ Double...

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

Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 how to set up a connector as there is plenty of documentation on the Zoho Official Documentation and even on this website so we'll skip to the COQL query. This is what I have: // // build up COQL query v_CoqlQuery = "select distinct Currency from Quotes...

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

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

14 February 2022 API access token > Store this in the Access Token field of your Creator form. If your app needs the Storefront API (eg. website checkouts) then set these. Mine don't as the Creator app I'm making is for staff only. REST Admin API: Usage: Here's a quick...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 It's aim is to recover all the modified records of a day and ensure that the data in Zoho is the same as on the Shopify website. Included in this is the feature to export all the data as a CSV and to email it to myself: void...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 An article on how I can query all the orders for yesterday without using the 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...

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