Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search608 entries
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before...
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User 1964-02-18 After: ID Name DateOfBirth...
Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website addresses enabled. How? Basically you have to include &view=article as opposed...
Event 1 A friend reported her phone was constantly being drained, wasn't lasting the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I wouldn't usually take notice but I think this is a brilliant e...
We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers.
If you get something like the following error: Warning: call_user_func() [function.call-user-func]: First argument is expected to be a valid callback in /home/.../templates/rt_affinity/rt_sectionrows.php on line 311 How? Copy & backup the file /public_html/.../templates/rt_affinity/rt_sectionrows.php Find the following...
Really not work related but if you know your sharepoint site: Custom Error http:///_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks. Installer?
This is a quick article on how to resolve the following issue: Overall body background color is blue. Background color of my contents is white. When I visit a small page on the site, the contents background (white) shows. When I visit a very long page on the site, the contents background disappears and reveals the over...
Why? So let's say my FTP client is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't have a clue. Here's what I've got so far:
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.
Protected notes
Log in for protected notes and any private client projects assigned to your account.