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

104 entries / matching Joomla

Clear filters
Connect to Joomla database in standalone script
Joomla

Connect to Joomla database in standalone script

APPLIES TO Joomla 2.5.x Why? I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing con...

Read note 61,399 hits
Joomla field types clear my html
Joomla

Joomla field types clear my html

Trying to make a component and can't remember how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no wonder customers have difficulty following. How? So it's the field o...

Read note 20,827 hits
Migrate JComments from Joomla 1.5.x to Joomla 2.5.x
Joomla

Migrate JComments from Joomla 1.5.x to Joomla 2.5.x

Thought I'd add the migration script I've been using to test my JComments migration from my Joomla CMS site version 1.5.20 to Joomla CMS site version 2.5.6. DISCLAIMER I do not work for either Joomla or JoomlaTune (Jcomments) This script is provided as is without warranty If you do not understand what this script is do...

Read note 295,579 hits
MySQL last year week month day trend periods
MySQL

MySQL last year week month day trend periods

Why? I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example today...

Read note 24,569 hits
Migrate Joomla Users to WordPress
Wordpress

Migrate Joomla Users to WordPress

This is for Joomla 1.5.x sites! Note that this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress. There are lots of commercial migrators out there and they all seem...

Read note 34,787 hits
Importing Joomla articles to WordPress posts
Wordpress

Importing Joomla articles to WordPress posts

Migrating the articles: Change database name my_joomla_db to your joomla database and my_wordpress_db to your Wordpress database Change http://demo.joellipman.com/wordpress/ to the full URL of your WordPress site. If post_type is to be post then append with ?p= otherwise use ?page_id=. Articles: ------ MIGRATING JOOMLA...

Read note 33,074 hits
Joes Bug Tracker (JBT)
Product Documentation

Joes Bug Tracker (JBT)

So I'm revisiting this component for the third time (previously known as "downloadtracker" and "joesdownloadtracker"); for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my reviews/opinions: Phoca Download Good compa...

Read note 117,964 hits
Joes Quicklist Weblinks (JQW)
Product Documentation

Joes Quicklist Weblinks (JQW)

Really Important Note This module has been somewhat popular and the services that offer FREE thumbnail screenshots are getting stricter with their terms of use. You should only enable thumbnail refreshes at the time of install. Also note, this module will NOT generate thumbnails if you select "Public" as the authorized...

Read note 369,970 hits
Joes FREE Website Thumbnailer (JWT)
Product Documentation

Joes FREE Website Thumbnailer (JWT)

Tested on: Windows XP SP3, Windows 7 (both 32-bit) Tested with: MS Internet Explorer 7 libraries System Requirements: Used ~55Mb RAM on 1.6Ghz PC Free Disk space to store your pictures Installed MS Internet Explorer (only uses libraries) Program Size: 1,190Kb (fits on a floppy disk) Setup/Install: None, it's portable (...

Read note 142,049 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.