JOEL LIPMAN

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

638 entries

Protecting your Joomla Administrator Section
Joomla

Protecting your Joomla Administrator Section

This is a quick article to remind me how to move a Joomla administration section and to lock it down to a specific IP address. The below does not involve installing any third-party extensions and will remain in place even if you update your Joomla CMS.

Read note 43,261 hits
Import Excel CSV file as JavaScript array
Excel

Import Excel CSV file as JavaScript array

What I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ , , ]; What I want again: Read a CSV file already uploaded with JavaS...

Read note 32,812 hits
Sort an associative array by values in Javascript
JavaScript

Sort an associative array by values in Javascript

An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web 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 partia...

Read note 32,806 hits
SELECT COUNT(DISTINCT name) FROM table
Joomla

SELECT COUNT(DISTINCT name) FROM table

A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement.

Read note 23,802 hits
VBScript to retrieve Windows Product Key
Windows OS

VBScript to retrieve Windows Product Key

A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows 7 Professional.

Read note 20,656 hits
Migrating from Joomla 2.5.x to 3.4.x
Joomla

Migrating from Joomla 2.5.x to 3.4.x

This is an article to document the migration of a Joomla! CMS running version 2.5.11 to an instance of Joomla! CMS version 3.4.1. I would consider the below instructions an ALPHA version as it is considered unstable for official use... Saying that this is how I upgraded my own personal website: www.joellipman.com. This...

Read note 95,019 hits
CSV Chart Generator
Product Documentation

CSV Chart Generator

Originally dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used...

Read note 22,370 hits
List of Font Awesome
Web-Development

List of Font Awesome

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 all the icons you would want in a modern website design. How? To use...

Read note 21,533 hits
Error 404 Component Not Found when enabling SEF URLs
Joomla

Error 404 Component Not Found when enabling SEF URLs

So I'm getting an error like this: The requested page can't be found. An error has occurred while processing your request. You may not be able to visit this page because of: - an out-of-date bookmark/favourite - a mistyped address - a search engine that has an out-of-date listing for this site - you have no access to t...

Read note 19,767 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
822 Site articles
30.1m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.