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

28 March 2014 in MS Windows, you may need to find someone who is. How? As a proof of concept, let's see how to hide a specific drive. Note that this section applies to the currently logged-in user. To restrict other users, see the example after this one: Open the...

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

301 Redirect using htaccess filehttps://joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted...

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

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

13 June 2014 could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source and to populate a...

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

T-SQL functions to convert Strings to Tableshttps://joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput...

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

DJI Phantom FC40 - Fun at the raceshttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 stood so I could see the height of our 1 marshall's head. To be honest, the reason I wasn't using my propeller guards was that I clean forgot which was rather reckless of me, but the winds were really strong, I'd doubled the cost of the quadcopter and...

• Type: Article
• Author: Joel Lipman
• Category: Quadcopters
• 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 The example above should have populated this correctly but if you are still getting problems, I have the following fields that I also use related to Google Maps v2: Last Additional Ensure that when Google asks for your Android API key, you enter the...

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

Android: Replace return key with done, go, send...https://joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 // standard postal address textPassword // password type field textVisiblePassword // um... textPhonetic // text that will sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime //...

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

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

20 February 2015 IP address 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...

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

TravelPort Universal API - Ping Request with PHP-cURLhttps://joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 Universal API. This is to be achieved using PHP as the server-side programming language and cURL, a sub-component of PHP that allows you to send and receive requests as the server (as opposed to the client device). Why? Yes there's documentation online...

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

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

04 September 2015 I needed to use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that has...

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

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

07 September 2015 Joomla Core db->nameQuote function for old MySQL. - Enhancement: Check for W3C Validation and force fix "&". - Double-check that unicode characters work in exclusion list. (they do) - Date Uploaded: Mon, 8th Aug 2011 1.6.6- Bug Fix: "Case-sensitive=No"...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• 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 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 not an excuse. I also found that examples across the web were only partial and thought I'd write a full example here. No...

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

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

13 June 2016 to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but...

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

Pure JS - Display Time Elapsed & Remaininghttps://joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 and display the elapsed/remaining hours minutes and seconds in real-time. Why? I know there are a lot of articles out there that write about the same, but this is an example that I was coding and found to be one of the most reduced cut down formats I've...

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

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 has to split a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx). How? In summary, we are going to move the Excel file to a folder of its own. We're going...

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

Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 Checking by Regular Expression: So I could do it the long way in Zoho Deluge. We match a pattern and replace everything out that conforms to the criteria so a true response will be an empty string: v_MyRegEx =...

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

Zoho Deluge - Modify the product line items in an invoice modulehttps://joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

22 August 2019 in an invoice. Why? A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a product that they didn't stock. How? So editing the product_details field of an invoice record seems...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02...

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

Zoho Deluge - InvokeConnector and useful snippetshttps://joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded by: l_Users = zoho.crm.getRecords("users") or r_User =...

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

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

06 February 2020 A quick article on how to debug some errors in Zoho. Why? I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list...

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