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

22Jan

Zoho Creator: eBay: Get Item Transaction

What? This is the function to get the line item order/transaction from eBay if you give it the...

21Jan

Zoho Creator: Receive eBay Notification and Create Shopify Order

What? This is an article documenting how to parse the notification from eBay and using it to...

12Jan

Zoho Analytics: Setup DataSource via FTP Connection

What? So this is going to be an article with a bunch of pictures showing step-by-step of how I...

10Jan

ZohoCRM & Xero Real-Time Invoices: Receive Webhook

What? So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores...

16Dec

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)

What? A very quick article to remind me how to send a text message using Twilio API in Zoho...

15Dec

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)

What? An article with a quick snippet of code which builds up the address from a Lead record to...

07Dec

Zoho Deluge: Calculate start and end of Daylight Savings Time

What? An article to document how I calculated the start and end dates of when Daylight Savings...

07Dec

Zoho Creator/Deluge: Calculating with Timezone Offset

What? This is an article to remind me how to calculate various times for an appointment booking...

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

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!