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

16Jan

ZohoCRM: Import Attachments

What? An article for myself really as I couldn't find much online to address the errors I...

09Dec

Zoho CRM: Manage a subform using Client Script

What? This is an article with a snippet of code demonstrating how to manage a subform using a Zoho...

24Oct

Zoho Analytics: Set Up Widget Displaying Sales Person

What? A quick article to display a value in a column in a widget in Zoho Analytics. Why? Because I...

21Oct

Zoho Deluge: Generate a loop or list of any size

What? This is an article on a trick I picked up from one of our interviewees as well as apparently...

19Oct

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account

What? This is a quick article to note down some code used in Zoho Recruit. This particular bit of...

17Oct

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record

What? This is an article describing a custom function built into Zoho Flow that will accept as...

18Aug

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template

What? A noteworthy article in my opinion on how to send a CRM quote record using a template the...

18Aug

Zoho Creator: Populate a Multi-Lookup

What? This is a very quick article with a code snippet on how I added to a multi-lookup field....

17Aug

Zoho Books/Inventory: Trigger a workflow when an invoice has been paid

What? An article on something that has taken me several days to get working: Get Zoho Books or...

20Jul

ZohoCRM: ZDK Client Script to retrieve Contact Email

What? An article on one of my first client scripts for ZohoCRM. This retrieves and populates an...

20Jul

Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now"

What? This is a quick article to re-enable desktop notifications after having been prompted...

14Jul

Zoho Inventory: Mark a package slip as delivered and shipped

What? A quick article on a code snippet to mark a package as shipped and delivered in Zoho...

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

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

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

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!