Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 1.6+ What? This is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important clear button. What I found was that no one posted this solution which I...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 access to a SharePoint 2007 site (team portal). Steps: Open your Outlook 2007 Using MS Internet Explorer (demo below is version 8), bring up your SharePoint Calendar Click on Actions Select Connect to Outlook Allow the website to open a program on your...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 "C:\ORACLE\product\11.2.0\client_1\network\admin". Furthermore I've been asked why aren't all our Oracle databases the same version? It's due to the fact that these aren't our databases, we simply help support them. You say less than ideal, I say...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Things to Check if Joomla Password Reminder email not being senthttps://joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well...

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

Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 people selling third party products... they don't get it. If you are reading this, it's likely you've paid for a commercial version of a Microsoft product which cannot possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it......

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 in many packages, we can change just this script instead of the ones for every package). Here is the near enough final version of my script (or more like an experienced colleague's comprehensive script to which I have merely added my transform part)...

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

Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 3rd-party extensions If you didn't have a backup, then I would simply take a Joomla install (preferably NOT the most recent version - so that you can force it to update later on) and copy over the core files. Get that working and then begin installing...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 What? This article is a follow on from my article JComments 2.3 with PlayThru (Joomla 2.5.x) but this is for a later version of the components using the alternative called PlayThru by AreYouAHuman.Com. Why? The kCaptcha used by the jComments extension...

• 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://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 solution has been advised that you have to tell MySQL WorkBench 6.0 to "use the old authentication protocol": • For versions before 6.0.7 • For versions after 6.0.7 Method #3 (Recommended): Do not use MySQL WorkBench!!! Seriously, your pride...

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

Add attribute xsl:nil=true on empty elements using XSLThttps://joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 not This doesn't tell us if the element is just an empty string or null. This doesn't have much affect on point-to-point conversions and strings but what if the value is blank and I try to convert that date of birth from SQL format (yyyy-mm-dd) to...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 Go to File and create a New Project... I'm developing on a Tablet so I select Phone and Tablet then a relatively old version of the Android OS: Add an activity to Mobile: select Google Maps Activity: Change the Title to what you want (don't change the...

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

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

08 March 2015 to: Wordpress CMS v4.1.1 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...

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

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

13 March 2015 A quick article for Joomla CMS version 3.x on resolving a menu item alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla...

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

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

04 September 2015 on the following site at https://fortawesome.github.io/Font-Awesome/examples/. The List This is a copy of the cheat sheet version 4.4. If some icons don't appear on this page, it is because I have only copied over some of the entire directory (the icons...

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

Sort an associative array by values in Javascripthttps://joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 I didn't find one that worked otherwise I'd have included it in this article. How? The fix is a PHP one and has to do with versions of PHP and MySQL. As quoted by the PHP htmlspecialchars: "As of PHP 5.4 they changed default encoding from "ISO-8859-1"...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 with imposed limit requests. I can halve this so let's upgrade! Method #2: Mulitipart single request This is my recommended version. In this function, we are sending the metadata before the media: $GAPIS = 'https://www.googleapis.com/'; function...

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

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

30 January 2019 Zoho CRM and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized version (following updates) making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 I'm aware of width transitions for div layers). DEMO: See my JsFiddle jsfiddle.net/Jlipman/4kj96rL0/1 Submitted by Ike This version submitted as an update is a little smoother as it adds a font-size transition: ul li{ display: inline-block;...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *