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.

192 entries / matching Images

Clear filters
Paypal Checkout API with PHP and JavaScript
PayPal 3615

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
Minimal Privileges for MySQL Database Backup Cron Job
cPanel 25944

Minimal Privileges for MySQL Database Backup Cron Job

What A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods here. One to create a...

Read note
Excel - Check a column for values found in another column
Excel 30665

Excel - Check a column for values found in another column

This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively.

Read note
FTP on Mac: Failed to retrieve directory listing
File Transfer Protocol 22674

FTP on Mac: Failed to retrieve directory listing

Applies to: FileZilla for MacmacOS High Sierra A quick note to remind me how to enable FTP directory listing as it was working on my Windows PC but not on my Mac. The error I was getting was Error: Failed to retrieve directory listing though I could access the folders if I browsed the existing folders by entering it in...

Read note
Change div height to fit content
Cascading Stylesheets 13980

Change div height to fit content

A quick article on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines

Read note

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