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

41 entries / matching JavaScript

Clear filters
Import Excel CSV file as JavaScript array
Excel

Import Excel CSV file as JavaScript array

What I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ , , ]; What I want again: Read a CSV file already uploaded with JavaS...

Read note 32,708 hits
Sort an associative array by values in Javascript
JavaScript

Sort an associative array by values in Javascript

An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an excuse. I also found that examples across the web were only partia...

Read note 32,621 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,881 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
JComments 2.3.0 with ReCaptcha in Joomla 2.5.x
Joomla

JComments 2.3.0 with ReCaptcha in Joomla 2.5.x

Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha with Google's ReCaptcha. Note that I have an article on how to do this with a ReCaptcha alternative called PlayThru by AreYouAHuman.com

Read note 215,446 hits
Joes Password Analyzer (JPA)
Product Documentation

Joes Password Analyzer (JPA)

What is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's Password Analyzer is a Joomla 2.5.x component which simply dis...

Read note 25,624 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.