JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

Advanced search

608 entries

Proposed Budget i3 PC under £200
IT Support

Proposed Budget i3 PC under £200

i3 workstation upgrade running Windows 7 So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is that our workstations need upgrading (it always is). So on a budget (i...

Read note 25,378 hits
Set up Desktop SlideShow in Windows 7
Windows OS

Set up Desktop SlideShow in Windows 7

Applies to Windows 7. Requires a Vogonian environment of red tape and bureaucracy. This is an article to describe an alternative method then "right-clicking on the desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to the Picture Location". The problem happens when browsing to the picture lo...

Read note 35,579 hits
Three boxes, two roll over, one falls out
Cascading Stylesheets

Three boxes, two roll over, one falls out

So this is an article to note an oddity when I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves 1 pixel...

Read note 27,630 hits
Php convert filesizes to bytes kb mb gb
Personal Home Page

Php convert filesizes to bytes kb mb gb

Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as => "8 Gb"

Read note 24,318 hits
Setup a copy of your Joomla website
Joomla

Setup a copy of your Joomla website

More for others than for myself, but 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 and in most cases, they are pay...

Read note 66,809 hits
Error 1065: Query was Empty
MySQL

Error 1065: Query was Empty

In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common.

Read note 25,433 hits

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

27 Years in IT
1021 CRM clients
810 Site articles
29.8m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.