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

477 entries / matching AI

Clear filters
SSRS Stop Scrolling Behind
SQL Server Reporting Services

SSRS Stop Scrolling Behind

I recently revamped our standard report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half of the page) as long as the end-user doesn't scroll. If the page was scrolled, what should d...

Read note 39,932 hits
301 Redirect using htaccess file
Web-Development

301 Redirect using htaccess file

There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new domain...

Read note 25,837 hits
T-SQL: Parse an XML value
Transact-SQL

T-SQL: Parse an XML value

This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code.

Read note 56,718 hits
JComments 2.3.0 with ReCaptcha in Joomla 2.5.x
Joomla

JComments 2.3.0 with ReCaptcha in Joomla 2.5.x

Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha with Google's ReCaptcha. Note that I have an article on how to do this with a ReCaptcha alternative called PlayThru by AreYouAHuman.com

Read note 215,736 hits
SSRS: Performance Improvements: SELECT TOP
SQL Server Reporting Services

SSRS: Performance Improvements: SELECT TOP

This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to...

Read note 47,616 hits
Registered Users Cannot Login - Super Users Can
Joomla

Registered Users Cannot Login - Super Users Can

This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and "act...

Read note 43,692 hits
MS-DOS: Copy folders without overwriting files
MS-DOS

MS-DOS: Copy folders without overwriting files

A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal hard drive to an external one. I wanted it to copy only the files that were new in the original folder and only copy those...

Read note 84,527 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
816 Site articles
30.0m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.