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

18 entries / matching Validation

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

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 53,646 hits
Submit form as a server and not the client with cURL
API Miscellaneous

Submit form as a server and not the client with cURL

A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups.

Read note 31,786 hits
Joomla Development: Possible XML Filters
Joomla

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 21,311 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,206 hits
Joomla article modal with clear button
Joomla

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 49,722 hits
Basic Joomla 2.5 Mootools Form
Joomla

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 65,845 hits
SSRS AlphaNumeric Parameter Validation
SQL Server Reporting Services

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 34,859 hits
$_SERVER['http_referer'] returns blank in Internet Explorer
Microsoft

$_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 22,584 hits
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
812 Site articles
29.8m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.