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

209 entries / matching Images

Clear filters
SSRS Subscriptions cannot be created
SQL Server Reporting Services

SSRS Subscriptions cannot be created

This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How?

Read note 35,760 hits
Call to a member function mark() on a non-object in Joomla CMS
Joomla

Call to a member function mark() on a non-object in Joomla CMS

This is a quick note on one reason you may get the above error in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost your si...

Read note 41,122 hits
SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase
SQL Server Integration Services

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase

So like lots of people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal case, a mixture of mostly lowercase and some UPPERCASE.

Read note 112,791 hits
Improve Default Joomla Search
Joomla

Improve Default Joomla Search

So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line...

Read note 65,483 hits
SSIS Skip Blank Rows in Flat File Source
SQL Server Integration Services

SSIS Skip Blank Rows in Flat File Source

This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because...

Read note 73,577 hits
MS Excel - Sort pivottable column headings by date
Excel

MS Excel - Sort pivottable column headings by date

This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top.

Read note 27,289 hits
Joes WebGL Experiment
Product Documentation

Joes WebGL Experiment

A replacement for Joes Revolver Maps? So I recently came across the Chrome Experiments WebGL Globe which I think is beautiful; here's a screenshot of what I envisaged though: Demo It's still in development and a somewhat stable beta version is demo'd at http://demo.joellipman.com/joomla16/index.php/joes-infographic-for...

Read note 29,835 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.