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

Checklist for the local computer repairs
IT Support

Checklist for the local computer repairs

Equipment List: Car Notebook Mini-USB mouse (wired) Norton Ghost USB Drive for storage (backing up clients pc) USB Drive with drivers/software/portable apps USB Dongle connecting to an Internet Provider OS disks Document Templates: Service Agreement Template Computer Repair Invoice Template Documents: Service Agreement...

Read note 49,394 hits
Creating a Profile Plugin for Joomla 1.6
Joomla

Creating a Profile Plugin for Joomla 1.6

So there is other documentation out there. I'm basing most of this article on the official Joomla 1.6 documentation: http://docs.joomla.org/Creating_a_profile_plugin and I want to use an example that worked for me. Important: This is for Joomla version 1.6.x+. Aim / Objective Add a field with a dropdown list. Add a but...

Read note 62,796 hits
CSS keeping the footer at the bottom
Cascading Stylesheets

CSS keeping the footer at the bottom

Spent enough time trying different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header LeftRight Footer <div id="container"> <div id="header"></div> <div id="content"> <div id="left"></div> <div id="righ...

Read note 33,081 hits
CSS Fieldset
Cascading Stylesheets

CSS Fieldset

Add horizontal space between label and fieldset fieldset label.inline Change color of fieldset grouping line fieldset

Read note 10,322 hits
CSS Background Without Causing Scrollbars
Cascading Stylesheets

CSS Background Without Causing Scrollbars

Quick note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I separated off the clouds as another div layer, specified the...

Read note 31,377 hits
Inserting incremental weeks in MySQL
MySQL

Inserting incremental weeks in MySQL

Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are academic week numbers. So I can't use the built-in functions. The curr...

Read note 31,341 hits
F_ck You. Pay Me.
Web-Development

F_ck You. Pay Me.

To be honest I saw this on some Joomlaworks Blog who appropriately title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some of this. March 2011 San Francisco, CreativeMornings (creativemornings.com) was Mike Monteiro, Design Director, and co...

Read note 15,500 hits
Difference between two dates - the midnight hour
Web-Development

Difference between two dates - the midnight hour

I might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in Euro...

Read note 31,803 hits
Set default parameter dates to start and end of month
SQL Server Reporting Services

Set default parameter dates to start and end of month

Situation The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that p...

Read note 37,155 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.