Welcome to Joel Lipman .com
I hope this helps!

We've been writing websites and scripts commercially since 1997 and using this website to store notes as we go along. What we learn we share for free, why? because someone else taught us for free... Thank you OpenSource!

Automation Aficionados Integration Specialists

This is Joel Lipman .com, a website and mobile application development company.

Our focus is on automation and system to system integrations/migrations (API).

#WhiteHatsRule

As a note specifically to @Google who previously blocked this site, demoted it and criticized it for demonstrating vulnerabilities in websites around the world when our only aim was to show people how to protect against such attacks. We have had to remove these articles to remain public. You have hypocritically censored us for the same reason the great firewall of China censored you: the Freedom of Speech!

To the rest of you: Thank you for visiting! I hope this website is, as always, of some use to you!

What we are

We are Joel Lipman .com, a website and mobile application development company.

What we do

Our focus is on the automation of business processes and system to system integrations/migrations (API).

What this is

This is our website for storing scripts and notes on all things IT since 1997.

SOME POSTS FROM OUR BLOG

02Dec

Zoho CRM: Schedule a Task: Timesheet Reminder

What? A quick article to demonstrate code that creates a task in CRM based on the time logged...

18Nov

Zoho CRM: Schedule a Call using Deluge

What? This is an article to document how to schedule a call with a reminder in Zoho CRM using Zoho...

17Nov

Zoho Creator/Deluge: UnPredictable exception, Invalid statement found

What? Just a quick article if you get the above error and what to look for. Why? I was writing a...

17Nov

Zoho Creator: Copy Subform to other Subforms

What? A quick article on a snippet of code which copies one subform to other subforms in the same...

11Nov

Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field

What? I already have an article documenting Pushing a value to a datetime field in CRM but wanted...

02Nov

Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday

What? A very quick article with a snippet of code to get today's date, tomorrow's, and the day...

22Oct

Zoho Creator: Change Radio into Tabs

What? This is an article to serve as a guide in terms of styling a radio group into a group of...

21Oct

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach

What? An article to save time where a customer wants to click a button to generate a merged...

19Oct

Zoho Deluge: Generate List of TimeZones

What? A quick article to take a list of options from a HTML select element and convert to a Zoho...

17Oct

Zoho Creator: Public URL of an Image field / Upload to Shopify API

What? This is an article to document how I downloaded an image held in a Zoho Creator form, and...

13Oct

Zoho Creator / eBay: Get all Active Products

What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs...

12Oct

Zoho Creator / Shopify: Get all Active Products

What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs...

28Sep

Installing phpBB3 for Joomla with a RocketTheme template

" OK this should take just a few minutes " I've written this because I spent all night on...

07Jun

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...

28Jan

Windows 7: System Clock is constantly going out of sync

The Issue People have reported that although they have manually set the date/time on their...

10Nov

SSRS Zero Padding

Quick Reminder I didn't want to do this at the database level, mainly because it meant modifying...

28Oct

RokDownloads Manager does not list files

Well this isn't a problem for those that don't use RokDownloads. The other day, I logged in to...

27Apr

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2

Applies to: Joomla CMS v3.2.3 ( Joomla.org ) jComments v3.0.0 ( JoomlaTune.com ) PlayThru v1.1.8 (...

28Jul

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connect

Applies to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick...

10Oct

Basic Android App using Google Maps and Current Location

Applies to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a...

30Jan

Migrate Joomla! 1.5.x to 2.5.x+

Update June 2013 - How to use this migration script: Make a backup copy of your old Joomla website...

20Mar

JComments 2.3.0 with ReCaptcha in Joomla 2.5.x

Applies to: Joomla CMS v2.5.11 ( Joomla.org ) jComments v2.3.0 ( JoomlaTune.com ) What? Posting...

09Nov

Create Read-Only Database User in SQL Server

The following describes how to setup a database user with read-only access to the AdventureWorks...

24Mar

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5

Applies to: Joomla CMS v2.5.11 ( Joomla.org ) jComments v2.3.0 ( JoomlaTune.com ) PlayThru v1.1.8...

Welcome to our new website template for 2021! We migrated from Joomla version 2.5.x to 3.5.x with just a few lines of code. Contact us if you want to do the same!

-- Copy articles

INSERT INTO `newdb_content` (`title`, `alias`, `introtext`, `fulltext`, `state`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `images`, `version`, `ordering`, `access`, `hits`, `featured`)

SELECT `title`, `alias`, `introtext`, `fulltext`, `state`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `images`, `version`, `ordering`, `access`, `hits`, `featured` FROM `olddb_content`;

-- Copy categories

INSERT INTO `newdb_categories` (`parent_id`, `lft`, `rgt`, `level`, `path`, `extension`, `title`, `alias`, `description`, `published`, `access`, `params` ,`hits`)

SELECT `parent_id`, `lft`, `rgt`, `level`, `path`, `extension`, `title`, `alias`, `description`, `published`, `access`, `params` ,`hits` FROM `olddb_categories`;

AT YOUR SERVICE

0/5

Contact us for your web-development and mobile application needs!

JOEL LIPMAN .COM is a script repository that started because we didn't want to have to sign up and get permission to post articles that could help us save time in the future. These articles help us develop businesses IT systems faster, especially if we've done the task before.

Creative and DynamicAdaptive and FlexibleEver-ready to serve you.

We build in accordance with industry standards. Always aiming to future-proof the applications we develop and ensure these will work on the latest computers and mobile devices.

Every application we build is designed around the customer's requirements and tweaked to accommodate for the users who will need to use the interface. This is not dictated by fashion trends or the nice-to-haves but by the feedback from users who have to use them day to day.

TESTIMONIALSTHE HEARSAYTHE RUMOURSTHE LEGEND

“Joe did a really superb job for me on this. My website crashed and I had no idea how to fix it. My hosting service were no help at all. Worse, I hadn't backed up my website for 18 months so even if Joe managed to retrieve it I expected most of my data to have gone. Joe not only fixed it immediately but all the data was still there too! Magic!”

Nick C.

“I wanted to let you know that we have been really pleased with the work Joel has been doing for us on several API query projects, and general questions. He’s explained everything really well and we feel like we’re understanding some of those complex elements of Zoho a little bit better, too!”

Amy M.

"Great Stuff! The idea to generate a cloud not from the usual metatags, but from the full text of articles is brilliant. (...) Support is also great : I wanted to connect Word Cloud with Mijosoft Search module and absolutely did not know how to do that (I am beginner in Joomla) : Joe solved that quite immediately."

Jean-Benoit G.

"Very Good Work! Extension is working perfect for me! Easy to set up, easy to maintain, lot of options.
I needed a word cloud NOT working with meta keywords but using my own keywords, here I found it!
Perfect for me, thanks!"

Klaus R.

"Very good Extension, does its Job! Quick and great support! Thank you Joe"

Marge E.

We are continuing to develop extensions for the Joomla! Content Management System (CMS). Please note that our current extensions are still only versions 1.5.x to 2.5.x compatible and although they are working on newer systems, they are not presently supported on the latest editions of Joomla! CMS.

We are currently heavily focusing our efforts on Zoho Customer Relationship Management system (CRM) developments and helping businesses with their sales processes. My team specialise in the financial aspects of Zoho Apps such as Zoho Books and integration to Xero.

There was a time when cloud services were not trusted. All information could be hacked as long as it was online. Nowadays, we cannot manage without cloud services. Even if you are still using MS Excel or pen and paper, it is still a legacy process that doesn't compete with 21st century technologies.

Joel Lipman .com isDynamicInnovativeAdaptive

We aim to develop applications and systems which have not been done yet or have not been documented online at least.

Visitors of the World

Joel Lipman Ltd is a website and mobile application development company. Used as an OpenSource repository and notes for all types of IT development and commercial applications. Our focus is on automation and system to system integrations/migrations (API).

New Website?

Our services include minor front-end tweaks to full stack website redesigns.

We've been writing websites and scripts commercially since 1997 and using this website to store notes as we go along. What we learn we share for free, why? because someone else taught us for free...

MEMBERS

ARTICLE HITS

APPLICATIONS

0W/Y

DEDICATED SUPPORT

Welcome to Joel Lipman .comI hope this helps!