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

19 entries / matching Validation

Clear filters
Paypal Checkout API with PHP and JavaScript
PayPal

Paypal Checkout API with PHP and JavaScript

This is an article on how to build a shopping cart and get your website to accept payments via PayPal. The below isn't a final or perfect option, it's an article to help me document and refine a process.

Read note 3,758 hits
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,890 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,979 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,694 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,785 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 50,315 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 66,774 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 35,061 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.