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

01 March 2011 had created the system to only last during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then there were the error logs... some 20000 errors per use of a feature over 4 seconds. Do...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 JOELLIPMAN_ALLERGYTIMEOPTION1="Less than a year" JOELLIPMAN_ALLERGYTIMEOPTION2="1 year" JOELLIPMAN_ALLERGYTIMEOPTION3="5 years" JOELLIPMAN_ALLERGYTIMEOPTION4="10 years+" PLG_USER_PROFILE5_FIELD_ALLERGYTIMEDISP_DESC="Choose to hide from other users?"...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago from today SET @MaxYear = DATEPART(YEAR,GETDATE())-18; -- 18 years ago from today -- GET RANDOM DATE VALUES SELECT...

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

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago from today SET @MaxYear = DATEPART(YEAR,GETDATE())-18; -- 18 years ago from today -- GET RANDOM DATE VALUES SELECT...

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

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 or ZohoInventory instance. Why? This took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is that the customer wants the...

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

Google Event Ilustrations aka Flairshttps://www.joellipman.com/articles/google/google-event-ilustrations-aka-flairs.html

05 December 2024 bowling breakfast: breakfast, breakfasts, brunch, brunches camping: camping chinesenewyear: chinese new year, chinese new years, chinese new year's cinema: cinema, movies clean: cleaning, clean the house, clean the apartment, clean house, tidy up,...

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

View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 Enabled You will still need to suffix the frontend URL with ?tp=1 Joomla 1.5.x This is another feature which took me a few years to notice in Joomla. If you've ever installed a template for Joomla and spent hours working out where or how you are going...

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

Passwords: Did-you-knowhttps://www.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 with words that exist). (source: Lockdown: Choosing a good password) And some more which have become more popular in recent years: There are loads of nightmare stories by security companies but one of my favourites is when the company hired to hack the...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 saved me so much time! What does this do? After many tweaks and corrections having upgraded multiple sites in the past few years with this script, the version below migrates the following: Articles Banners Categories & Sections Menus * NEW Messages...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 specified that that's all it scans for, it's not interested in your personal details or what you had for breakfast, it's my years as IT support that push me to make software self-analyze in order to reduce support calls in the first place. Question How...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 templates would create a style that was hard to customize. Remository Really liked this and used for the best of 2 years. But 1000 downloads in 10 days caused it to crash my Joomla! website. It was very plain and basic, needed tweaking to get rid of...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 in, a physical product (including a physical distribution medium), accompanied by a written offer, valid for at least three years and valid for as long as you offer spare parts or customer support for that product model, to give anyone who possesses the...

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They experiment on their customer-facing website...

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

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

01 February 2013 for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, all freeware until someone expresses an interest in using it and then the supplier will implement restrictions and trial based...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 Manager - dubbed PAM - can tell me how long it took to setup a website previously, and will plan the same again). My 15 years of web-development experience allow me to reduce the risk of nasty surprises and also allows me not have to Google search every...

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

Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 been googling how to download a file that was uploaded into a Creator form, you may have come across forums that are over 10 years old; URLs that were so custom that they didn't apply to you because of the app owner, name, view link name, etc. The...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 gets removed from any of your code. How? As someone who's been using Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very quick to do...

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

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first time I'm using it so I'm documenting it. For this example, we're going to use my use-case scenario...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 guy. My skillset is really around software (see my other articles) and I've been using Mac alongside my PCs for the past 7 years. My MacBook is from 2015 and still runs everything from MacOSX to Final Cut Pro (latest version 2022) and I don't have to...

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