Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 run off various instances of Oracle 9i, 10g, and 11g. This article was written for those that need to support these kind of systems and not as an invite for suggestions on how my business should be run. How? So there are a variety of solutions that will...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 (Top 25 this month) Robots/Spiders (Top 25 this month) visits Duration (this month) Pages-URL (Top 25 this month) Operating Systems (Top 10 this month) Browsers (Top 10 this month) Connect to site from (Referers this month) Search Keyphrases (Top 10...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 checker can not guarantee the passwords will be easy to memorize or to type quickly. Companies using certain password systems can even send the login credentials to the remote machine for you, but does this just open another can of worms? The trick in...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 to get it actually working. STEP #1: Check ReCaptcha API Check your recaptcha plugin is up-to-date as some Joomla 2.5.x systems will not have updated this: Open the file \plugins\captcha\recaptcha\recaptcha.php See if you have the line const...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions3.2.4- Fixed Bug: Some systems report "Strict Standards: Non-static method called" - Note: not included in auto-update as it only applies to certain environments. - Note: this version is also backwards compatible with...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 to: Microsoft Windows 10 AutoHotkey 1.1.30 What? Yay for Microsoft Windows 10 in joining the rest of the Operating Systems in implementing multiple desktops. So if you have a Mac or Linux system, you will know of a feature where you can have another...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 you will need to have setup a Zoho Oauth Connection with the appropriate authorized scopes and have access to all related systems such as Zoho Projects and the originating app (in this example, Zoho Creator). 1. Setup up Zoho Oauth Connection: Go to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 lately this hasn't been working for me. To this end, I have thought of an alternative that I now use frequently in client systems. How? The gist is that we add a checkbox called "Processed" which will have a datatype Boolean. Our function will then loop...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 this article to make it simpler for new developers to follow and learn as a quick point of reference. Why? Some clients systems will presume that they don't need their sales or CRM users to think about tax and probably manage it in Zoho Books leaving it...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

21 September 2021 time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 work out how many pages or loops in total it would need to do. How? Here's a couple of working examples I use in production systems: Pre-amble: I'm applying to a Zoho Instance on the US Datacenter (.COM) These examples are using CRM REST API v5 but you...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MyALN.bournemouth.ac.ukhttps://www.joellipman.com/component/content/article/myalnbournemouthacuk.html?catid=33

07 September 2010 ended their support for the site. I was called in to fix several underlying issues and integrate it into the university systems. The Additional Learning Needs team at Bournemouth University use their website to reduce the paperwork and manage all the...

• Type: Article
• Author: Joel Lipman
• Category: Portfolio
• Language: *

Welcome to my website!https://www.joellipman.com/articles/web-development/welcome-to-my-website.html

19 March 2011 since 1997 and I'm using this website to store notes as I go along. I specialise in taking over incomplete and/or bespoke systems which have little or no documentation. I like workarounds and solutions and persist in the knowledge that anything is...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Thank You for your donation!https://www.joellipman.com/thank-you-for-your-donation.html

08 August 2010 have their benefits and neither should go. My day job doesn't involve any Joomla! material but has many Content Management Systems (CMS) commercial equivalents. I use any donations to justify working on Joomla! specifically; but like to add things I...

• Type: Article
• Author: Joel Lipman
• Category: Articles
• Language: *

The greatest invention in IThttps://www.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 preceding command (by issuing some special 'undo' command)." Source: Behavioral Issues in the Use of Interactive Systems. If you've guessed it, my vote goes for whoever invented the "Undo" button: cross-platform, multi-lingual, future-proof and as...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

List last modified files using FTP Command-linehttps://www.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 subdirectories to temp.txt in your local working folder. Additional Notes the switch "-S" does not work on certain systems (at least not accompanied with the command to output to a local file. Type dir . temp.txt to output the current remote directory...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 the exact problem. If you include linked images in the report (as in images not in the report itself but referring to other systems holding the images), then please refer to my article on SSRS External Images don't display. The answer to this error is...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB