Developer's Checklist: Taking over a projecthttp://mail.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 system. The website was held on a virtual host running PHP and MySQL. There was no documentation, logs, notes, and any code comments were in Hungarian (later found out it was slang or a dialect not understood by most Hungarians). Fellow students and...

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

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 temporary table structure to match given table SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and data types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ',' +...

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

Inline Labels in Form Fields using Javascripthttp://mail.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 name indicates, trigger events when the cursor is either in the field or not. The above field was created with the following code: Explanation type="text" - standard attribute that tells the field this is an input field for single line of text....

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

Three boxes, two roll over, one falls outhttp://mail.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 on the top row and the third would pop under these. As for MSIE, that was ok when maximized. How? You could do loads of code hacks which is what I tested but all for nothing because you always end up needing to specify a third of the width. Our template...

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

Parse a HTML Table into a ListViewhttp://mail.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 A quick article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so...

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

SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because error code 0xC0049063...

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

htaccess Rewrites SEF URL and submits to PHPhttp://mail.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 rules (they basically redirect to a branded error page). So I sanitize on the receiving index.php file: Check for possible Code Injection Do NOT allow the use of apostrophe or double-quotes, convert these to a numerical representation only if you need...

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

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

04 October 2013 script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "IT Department" and "Director of IT". "O'REILLY" should become "O'Reilly" and...

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

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

28 February 2014 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 code to get all the users out of a Joomla CMS. How? I could just type a query on the database and get the same result, but this...

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

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

31 October 2014 and close the respective dialogs (note that setting the variable via the command prompt will NOT work!) To get the Test SHA1 code: Creating a Google Maps project in Android Studio (v0.8.6 beta) "creates" a SHA1 along with the project name: something...

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

Protecting your Joomla Administrator Sectionhttp://mail.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 to memorise. Create a file called index.php in the folder you just made with the following contents: Append the following code to the .htaccess file in the root of your joomla website: # Admin Redirect RewriteEngine On RewriteCond %{REQUEST_URI}...

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

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

30 October 2018 This is an example of Javascript code to update 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...

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

Zoho Deluge - Get English Ordinalhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018". Why? Well there's a long a way to do it (but...

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

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

30 January 2019 and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've rewritten this code a...

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

Zoho Deluge - Update Creator from CRMhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the responses returned as successful, but the target fields did not update. This was as...

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

Zoho Deluge - Counting in a Map dataTypehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products...

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

AutoHotkey: App GUI Listview to Rename Fileshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename...

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

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

12 August 2020 Authentication Type: set this to "oauth2" Param Type: set this to "Header" Grant Type: set this to "Authorization Code" Client ID: Copy & paste from the previous step this value into this field. Client Secret: Copy & paste from the previous step this...

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

Zoho Creator: info/alert/modal/popup notification for any userhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 (click of a button in a report row) but I've also used this on the submission of a stateless form, in deluge: v_nTitle = encodeUrl("Test"); v_nText = encodeUrl("Test Content"); openUrl(...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)http://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 This is an article to demo some Deluge code on how to download a file that was uploaded in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went wrong, I have a client with ZohoCRM who upload a PDF (can be...

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