Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search639 entries
Before you ask, I tried Google Prettify and Alex Gorbatchev's Syntax Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery and MooTools) conflicting with other scripts but do I really need a complex solution? So here I am making my own again...
This is a quick article on what I change the error page for Joomla websites to. I like a clean error page, for a demo visit http://www.joellipman.com/my_error_page. Applies to Joomla 1.6.x, 1.7.x, 2.5.x How? Backup the file \templates\system\error.php Create a replacement file called error.php including the below code...
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource.
So it's the end of the month again and I have to prepare a report for some investors. The idea of an infographic report has excited them to no end but because the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web...
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.
Just a pretty picture on how hackers have created an infographic of the internet: Source: BitBucket.Org - Internet Census 2012
So this is an article to serve as documentation for one of the data sources available to download for FREE from this site.
Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European D...
This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well.
Working principle
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.
Recently Added
👍 Zoho CRM's Notes now gets Reactions and a new look Zoho CRM: Sync Deal and related record owners from Zoho Desk Zoho CRM: Link supplier emails to the Purchase Order Emails related list Zoho CRM's WhatsApp integration now supports multiple accounts, multiple numbers, and custom modules Zoho Books: Improper Statement Error might be due to missing ';'Protected notes
Log in for protected notes and any private client projects assigned to your account.