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

342 entries / matching Data

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,777 hits
Convert XML UTF-16 to JSON UTF-8 with PHP cURL
Personal Home Page

Convert XML UTF-16 to JSON UTF-8 with PHP cURL

This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would simply load the received XML with SimpleXML and use the built-in PHP JSON_encode function. I ran into the following errors: Warning: SimpleXMLElement::__construct() [si...

Read note 63,883 hits
Warning: Save failed. Another menu item has the same alias
Joomla

Warning: Save failed. Another menu item has the same alias

A quick article for Joomla CMS version 3.x on resolving a menu item alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu items) A good databa...

Read note 34,911 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,869 hits
Excel: convert degrees minutes seconds to decimal
Excel

Excel: convert degrees minutes seconds to decimal

A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B ------------------------------------- ---------------------- Beijing Capital International Airport 40°4′20″N 116°3...

Read note 23,584 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
816 Site articles
30.0m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.