Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttp://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 come with the JComments extension. Check all JComments settings are what you want using the Joomla Admin interface. If the article IDs match then the comments will also match. If however your article IDs don't match in both versions of your site,...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 to: Apple iOS 7 Apple iTunes 11.1.3.8 Microsoft Windows 7 Professional What? Just so many articles out there that did not help me. This article is how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a...

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

Basic Android App using Google Maps and Current Locationhttp://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 location. How? I couldn't find any instructions using the tools I had (Android Studio) which is why I've written this article. Start "Android Studio" Go to File and create a New Project... I'm developing on a Tablet so I select Phone and Tablet then a...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttp://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 This is an article which lists the functions necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 This is an article to document how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading the...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 The aim of this article is to document how you can display a Creator report to the user, that they can select (tickbox) multiple records in that report, and then have a button that loops through all the selected (ticked) records. The example below...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttp://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 This article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team...

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

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

02 September 2021 This is an article for training purposes. I'm pretty sure there is official documentation on how to do this but I thought I'd write this article to make it simpler for new developers to follow and learn as a quick point of reference. Why? Some clients...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttp://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 This is a quick article on how I built my 2022 workstation and got 5 monitors working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article could help others. It's also a chance to show off my build....

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

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttp://www.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but...

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

ZohoDeluge: Inserting a new line character in a CSVhttp://www.joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttp://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 Following on from the article: Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. This is the next step as we get it to look at data within ZohoCRM. Why? Because it is a serious improvement upon ZohoZIA and we get a lot of requests around customizing...

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

Zoho Deluge: Proper Case for Nameshttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template and send it off for signing, then return the Signed...

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

Zoho Survey: Zoho CRM Webhookhttp://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 A separate article as a follow-on from my previous article in this series Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pages which may have grown a little but just wanted to record how to receive a Zoho Survey...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttp://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 What? A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was...

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

SSRS Querying on either of 2 Parametershttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for the purposes of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters:...

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

T-SQL Record Separatorhttp://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday The Official Gist Okay so the below article with the 3 stages can be a little confusing. When I wrote the support documentation which makes use of this little trick for...

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

Basic Joomla 2.5 Mootools Formhttp://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 This is an article to demo the crudest form which uses Joomla's version 2.5 core mootools (uncompressed?). This is intended for absolute novices (like me) who just want to see an example of an AJAX form within Joomla 1.6.x - 2.5.x in it's most basic...

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

Delete related records from multiple tableshttp://www.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database...

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