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.

17 entries / matching Validation

Clear filters
TravelPort Universal API - Ping Request with PHP-cURL
API Miscellaneous 53583

TravelPort Universal API - Ping Request with PHP-cURL

An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using PHP as the server-side programming language and cURL, a sub-component of PHP that allows you to send and receive requests as the server (as opposed to the client device).

Read note
Joomla Development: Possible XML Filters
Joomla 21149

Joomla Development: Possible XML Filters

Applies to: Joomla! CMS 2.5.x Joomla Filter: Validation OnSave INT Forces the value to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true or false WORD Strips anything that is not letters (including numbers...

Read note
SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase
SQL Server Integration Services 111941

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
Joomla article modal with clear button
Joomla 49465

Joomla article modal with clear button

This is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important clear button. What I found was that no one posted this solution which I found is compatible with almost any site and with all my components without h...

Read note
Basic Joomla 2.5 Mootools Form
Joomla 65221

Basic Joomla 2.5 Mootools Form

This is an article to demo the crudest form which uses Joomla's version 2.5 core mootools (uncompressed?). This is intended for absolute novices (like me) who just want to see an example of an AJAX form within Joomla 1.6.x - 2.5.x in it's most basic state. At time of print, I am using this with Joomla 2.5.6.

Read note
SSRS AlphaNumeric Parameter Validation
SQL Server Reporting Services 34788

SSRS AlphaNumeric Parameter Validation

Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User enters value in parameters and clicks on "View Report" Report...

Read note
$_SERVER['http_referer'] returns blank in Internet Explorer
Microsoft 22563

$_SERVER['http_referer'] returns blank in Internet Explorer

Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Inte...

Read note
No more notes to load.

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.7m+ Reads / hits