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

30Jul

Zoho CRM & Zoho Books: Custom Related Lists Deluge

What? This is an article to quickly demo a couple of snippets of code to display values in a...

29Jul

ZohoCRM: zoho.crm.searchRecords only returns certain records

What? This is an article to hopefully resolve for you quicker than it took me, why a...

27Jul

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects

What? This is an article to document how to have two submit buttons on a non-stateless form which...

27Jul

Zoho Creator: Assign an integration field value with an integration value

What? This is a quick article to help anyone encountering this gotcha: I have an integration...

26Jul

Zoho CRM & Zoho Creator: Query returns some fields missing other data on the record

What? A super quick article to demonstrate how an idiot like myself can misread the documentation....

14Jul

Zoho Creator: Add a subform while creating a record

What? This is an article to document how to include a subform and rows while you are creating a...

23Jun

Zoho Deluge: Zoho Bookings Get Available Slots

What? This is an article of code snippets to query a Zoho Bookings instance from within Creator....

17Jun

Zoho Projects: Deluge to Submit Custom Fields

What? A super quick article to demonstrate an example where we create a project with custom...

16Jun

Zoho Deluge: Generate and Send a CSV via Email

What? A super quick article to remind me how to generate and send a CSV as an attachment to an...

16Jun

Zoho CRM REST API: Stop Workflow from Triggering

What? This is an article to show you how to use triggers but also how to stop them. We only found...

03Jun

Windows OS: Alt Codes / Symbols / Special Characters

.joellipman-alt-code-table{ width:100%; max-width:400px; margin:0 auto; border:1px; }...

17May

Zoho CRM: Update a custom field in line items / product details using REST API v2.1

What? This is a quick article documenting how to update custom fields in a line items or product...

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

25Jan

Add Image Mouseover effect in AutoHotkey GUI

Couldn't find this anywhere on the net and kinda needed it so am making a note of how to do it...

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

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!