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

Language Codes
Joomla

Language Codes

Having started developing multi-language components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international and narrow-minded to think only English speakers will use Joomla! CMS. The below is for reference only:

Read note 23,736 hits
K2 Items disappear
Joomla

K2 Items disappear

Basically you've woken up this morning, visited your website, and all your K2 articles are gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should get the following error: Warning: Invalid argument supplied for foreach() in /home/public_html/administrator/components/co...

Read note 73,708 hits
Thank You for your donation!
Articles

Thank You for your donation!

As an IT professional, I feel that both OpenSource and Commercial applications have their benefits and neither should go. My day job doesn't involve any Joomla! material but has many Content Management Systems (CMS) commercial equivalents. I use any donations to justify working on Joomla! specifically; but like to add...

Read note 41,128 hits
Invalid arguments passed in router.php on line 325
Joomla

Invalid arguments passed in router.php on line 325

Thought I'd put this error in here and how I fixed it. Basically because firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other intelligent solutions on the web. The issue was that I was building my first...

Read note 34,973 hits
Webdeveloper-Speak
Web-Development

Webdeveloper-Speak

I don't usually write an article on another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand providing consultation, website design, development and usability evaluati...

Read note 31,237 hits
Error during processing - Converting Date/Time
Transact-SQL

Error during processing - Converting Date/Time

Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen i...

Read note 34,596 hits
Crystal Reports: Exporting to Excel omits column headers
Excel

Crystal Reports: Exporting to Excel omits column headers

If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One solution was to untick "Simplify page headers" on the Excel Format Opt...

Read note 46,044 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.