Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 version”. A contributor's “essential patent claims” are all patent claims owned or controlled by the contributor, whether already acquired or hereafter acquired, that would be infringed by some manner, permitted by this License, of making, using, or...

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

Access MySQL databases using Oracle SQL Developerhttp://mail.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 free at time of print (01-FEB-2013). I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved software for our work computers. We have SQL Server Management Studio (SSMS) as well for our SQL Server...

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

Export/Import Database using MySQL Workbenchhttp://mail.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import happens under the Server Administration...

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

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

04 March 2013 environment thanks partly to group policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in, this is the same user but re-prompted for credentials) Cannot run System Registry (not even DOS REG Query!!!)...

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

Improve Default Joomla Search http://mail.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 your own code to make the "relevance" ordering more relevant.... ok still to come as I'm really happy with what the above already improves! Download the above modified files. The following ZIP file contains the default Joomla v3.4.x core files and then...

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

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

23 February 2014 include empty directories or subdirectories. /T /E includes empty directories and subdirectories. /U Copies only files that already exist in destination. /K Copies attributes. Normal Xcopy will reset read-only attributes. /N Copies using the generated...

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

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

20 March 2014 = "http://www.google.com/recaptcha/api"; STEP #2: Check ReCaptcha Private Key This is assuming you have already signed up for a ReCaptcha key (Google ReCaptcha) Login to your Joomla Administration panel Extensions > Plug-in Manager > Captcha - ReCaptcha...

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

Hide a Drive per User in Windows 7http://mail.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 name for the key. We'll call it Foo. Go to HKEY_USERS\Foo\Software\Microsoft\Windows\CurrentVersion\Policies If it does not already exist, create a key called Explorer Create a new 32-bit DWORD value inside the Explorer key/folder and name it NoDrives...

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

Convert to Proper Case in T-SQLhttp://mail.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 in uppercase SET @Ret=@Text END RETURN @Ret END Examples of what this script does: Reminder: The script only affects data already in UPPERCASE. Change the IF (UPPER(@Text)=@Text COLLATE Latin1_General_CS_AI) line if you want to change this. Original...

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

SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 Flow Items > Tick the "For Each Loop Container") Add the Data-Flow to the container (or drag into the container if it already exists) Edit the ForEach Loop Container (or double-click on it) Under General, give it a reasonable name of your choice Under...

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

Submit form as a server and not the client with cURLhttp://mail.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 to their service. The request has to come from a permitted server with a single IP address. How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the following will only document the process of...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Joes Word Cloud (JWC) Downloadhttp://mail.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 do) - Date Uploaded: Mon, 8th Aug 2011 1.6.6- Bug Fix: "Case-sensitive=No" now checks that word in different case is not already in list. - Date Uploaded: Wed, 20th Jul 2011 1.6.5- Bug Fix: Keyword Exclusion List removes spaces before and after all...

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

Import Excel CSV file as JavaScript arrayhttp://mail.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 'item1b', my_col2_val: 'item2b' }, { my_col1_val: 'item1c', my_col2_val: 'item2c,c' } ]; What I want again: Read a CSV file already uploaded with JavaScript Populate a JS array with each row Account for strings containing double-quotes (and commas to...

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

Windows Live Mail Error ID: 0x8DE00005http://mail.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

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

29 October 2018 or know what they're doing. Why? The objective here is to upload a video file to my Google Drive. This assumes you have already "Enabled the Drive API" via your Google Developers console as well as gotten your OAuth 2.0 access/refresh tokens and...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttp://mail.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 and rewrite token file (in JSON). If token is not required, use access_token stored in file. It is assumed that you have already registered the app with the Google developers console along with the redirect URI being this script. Complete the global...

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

Excel - Check a column for values found in another columnhttp://mail.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 have noticed that the range of words to find from Sheet2 in this screenshot are from the cells B1:B4... This is because I already had values in A1:A4 and wanted to test against a set of different words.

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

URL Alias uniqueness with PHP & MySQLhttp://mail.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 Note(s): The trigger only runs if inserting a record. If your script is trying to modify/update a record with a value that already exists in the table, you will get an error in which case you could probably add another trigger like above but with BEFORE...

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

Zoho CRM REST API: Stop Workflow from Triggeringhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? You might already be familiar with some of the trigger options below but one that worked was initially guessed as "none" but then later found...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 and ZohoCreator.report.CREATE Click on Create and Connect > Note the connection link name (if you've already forgotten) Create a REST API Zoho CRM Function Go to Setup > Developer Space > Functions > New Function Give it a Function Name, I'll call mine...

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