Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 on the Lead record; use Zoho's GeoCode function to convert this into a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we are going to loop through picklist...

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

CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 or submit material, and unless we indicate otherwise, you grant JoelLipman.com and its associates a nonexclusive, royalty-free, perpetual, irrevocable, and fully sublicensable right to use, reproduce, modify, adapt, publish, translate, create derivative...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 to other pages and it will identify itself as IE7 to sites that check your browser details (see below - Additional Info) The Free Virtual PC solution (Requires ISO or WinXP disk) Go to Microsoft.com and search for Microsoft Virtual PC 2007 SP1...

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

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties=""""; This is a free simple .NET compliant MySQL driver. Project space at SourceForge. MySQL OLEDB Type: OLE DB Provider Usage: Provider=MySQLProv Manufacturer: MySQL...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 of doing this without logging into the reporting server or making any changes to it. If anyone knows of a way, please feel free to comment!

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

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 Findfast findfast.cpl Firefox (if installed) firefox Folders Properties folders Fonts control fonts Fonts Folder fonts Free Cell Card Game freecell Game Controllers joy.cpl Group Policy Editor (XP Prof) gpedit.msc Hearts Card Game mshearts Help and...

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

Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 to change their passwords but that is what the commercial applications are doing. The script to transfer users This is a free solution to at least get your user accounts all migrated. How you deal with the passwords can then be up to you. To use the...

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

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

27 August 2012 copy & paste the below into a PHP file and include it in your component, the solution is really that straightforward. Feel free to check for any dodgy code but I've simply added the clear button to the existing article modal file (Joomla 1.6.x to...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 slide and use only two slides in total (that's the aim at least). Other objects (mostly text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also proven to be responsive and compatible...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they do not: Surround string (apostrophes) with red styling Convert: this='a string' » this='a string'...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 restore/backup) Done Unplug your new phone and test. Ta daa! If this article helped you, please leave a comment below, it's FREE and can be anonymous.

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

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

03 January 2014 the comment section below to suggest changes, corrections, improvements or just to give an opinion. Use it! It's absolutely FREE! The password analyzer URL is: www.joellipman.com/services/password-analyzer.html. Enjoy!

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 new copies may be started. /PF :: check run hours on a Per File (not per pass) basis. /IPG:n :: Inter-Packet Gap (ms), to free bandwidth on slow lines. /SL :: copy symbolic links versus the target. /MT[:n] :: Do multi-threaded copies with n threads...

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

Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 solution using the installed plugin later. STEP #1: Signup at AYAH You need to have a publisher and scoring key, sign up for FREE at AreYouAHuman.Com: Basic Signup: Signup and you will be redirected to a dashboard. On the dashboard, note the Publisher's...

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

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

27 April 2014 solution using the installed plugin later. STEP #1: Signup at AYAH You need to have a publisher and scoring key, sign up for FREE at AreYouAHuman.Com: Basic Signup: Signup and you will be redirected to a dashboard. On the dashboard, note the Publisher's...

• 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 MySQL WorkBench!!! Seriously, your pride will slow you down or get you sacked! Instructions: Go to Google Search Search for "Free MySQL database manager" (preferably add the keyword "portable") Avoid links to MySQL Workbench and download an alternative....

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

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 Instagram Not sure on this one as I could only embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3 dots (ellipsis) at the bottom right...

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

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

18 May 2019 as the width transition is not a smooth one. If anyone has a tried and working solution to the width transition then feel free to comment/message me (please test before sending it to me as I'm aware of width transitions for div layers). DEMO: See my...

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