Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 to #__banners -- ----------------------------------------------------------------------------- -- For BANNERS, we're going to do the following: -- 1) Create banner-category assets -- 2) Import banner categories -- 3) Migrate banners from J15 to J30 --...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 you want to create the monitoring system. Preferably use the workspace that has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select "Dashboard": Then in the top right of the dashboard, I'm...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 that at the time of this article, API v1 is deprecated (so no authtokens) and API OAuth2.0 is in full swing... we're still going to cheat. How? 1,2,3 steps really. First we're going to set up a Creator form to receive the JSON. Secondly, we'll create...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 tweaking the function and getting it to understand basic mapping and attachments. How? As per our use-case above, we are going to create a button off the contact record which when the user clicks on it will generate a PDF of the merged template and...

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

Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 trying to scan the meta data (snippets at the bottom of this article), the simplest way was right in front of us. We're going to use the interface to find the form where staff have been entering employees goals, then we're going to query it and push it...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 default sort order (as in the first time you view the page) is the order in the admin panel (not even by most recent). I'm going to show you how to do this by title in ascending order without installing any 3rd-party extension as well as by any of the...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 created one plugin which I can install on any number of Joomla 1.6 sites and it does all this for me... Neat huh? Folder I'm going to shove all these files into a folder which I will then compress and install using the Joomla! CMS Extension Manager. I'm...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 I use to list step by step on how to set up a custom domain for a Zoho Creator customer portal. In this example, we are going to use a subdomain of a company which has the domain joellipman.com. Why? This took me a bit of going backwards and forwards to...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 a field called "Customer's Time Zone" on the lead record in ZohoCRM. It should be auto-populated... How? As mentioned, we're going to use the address on the Lead record; use Zoho's GeoCode function to convert this into a latitude and longitude, then...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 Setup a webhook in Xero. [Optional for Method #2] Setup a PHP script on a server that will validate the Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 How? Again, there is a caveat in that the subscription you have or your client has, needs to be Zoho One. Because we're going to use Zoho Creator as a middleware. Just to add to the pain, I'm going to make my function in Zoho CRM: Overview Create a REST...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 we want to get the stock level and then use this data to synchronize with data held in Zoho Inventory... How? So we're going to use a ZohoCRM function to get this file which we can run on demand. Why not in Zoho Inventory or any other Zoho app? Because...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be rendered for PDF...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 The final bit: Embed the radar chart in a Zoho CRM merge template This is the easy bit... not really... not a clue how I'm going to do this nor if writer will just allow us to embed it... but let's give it a go: The page responses query showing only the...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 = Map(); m_CrmContact.put("First_Name",m_XeroContact.get("FirstName")); // last name is mandatory for a CRM contact so we're going to put a placeholder one if this is not given v_CrmContactLastName = ifnull(m_XeroContact.get("LastName"),"-Unknown-");...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 = Map(); m_CrmContact.put("First_Name",m_XeroContact.get("FirstName")); // last name is mandatory for a CRM contact so we're going to put a placeholder one if this is not given v_CrmContactLastName = ifnull(m_XeroContact.get("LastName"),"-Unknown-");...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 do the below in because I went through rocketheme's instructions once and it didn't work. I then carried out all the changes going up and down the document, double-checking I had done everything their instructions said. For demonstration purposes: I am...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 you ok this you should be on the following screen: Select the Report Type: For this calendar we want matrix because we're going to group based on the rows: Design the Matrix: Ok so we want weekday in the columns (to have mon-sun along the top), "Order"...

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 in the "Fill > BackgroundColor" properties row... Done! Borders: I'm putting this here because often enough, if I'm going to make the report pretty with alternating rows, I'm probably going to look at the cell borders as well. I want a bigger border at...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *