The Mermaidhttps://www.joellipman.com/articles/_other-misc/the-mermaid.html

24 July 2012 seas do roar, And the stormy winds do blow, And we jolly sailor boys were skipping up aloft, And the land lubbers lying down below, below, below, And the land lubbers lying down below. Then up spoke the Captain Of our gallant ship, And a fine old man...

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

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 do? After many tweaks and corrections having upgraded multiple sites in the past few years with this script, the version below migrates the following: Articles Banners Categories & Sections Menus * NEW Messages Newsfeeds Users * UPDATED Weblinks So this...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 AND MOUSEOVER EVENT WM_MOUSEMOVE() { static CurrControl, PrevControl, _TT ; _TT is kept blank for use by the ToolTip command below. CurrControl := A_GuiControl SearchButton_Over:=A_ScriptDir "\images\program\icons\search_globe_over.png"...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 a quick article to remind me how to move a Joomla administration section and to lock it down to a specific IP address. The below does not involve installing any third-party extensions and will remain in place even if you update your Joomla CMS. Why?...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 build a prompt combining any of the following in a table (this is not an exhaustive / limited list). Do note that the images below were generated using MidJourney v4: Type of Photography {module title="Joel Lipman's List of MidJourney Photography...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• 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 times the Dates cte can recurse OPTION (MAXRECURSION 100) I'd appreciate if you bear with me as I add captions to the below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the below will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been searching for for the past...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 into the field that says "Columns". Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row with the left parenthesis Click on the dropdown of "Data" and select "TimeStamp". Click in the left of that...

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

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

03 November 2013 apps (and audio). How? Note that the restore can be done when the new phone prompts you to set it up but you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 how to do this and it takes about an hour to go through the documentation and get a working solution. How? So the article below shows how to do this Zoho CRM and how to do it in Zoho Books... The example below is that we are going to search for some...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 accessible link or URL of the image. Why? I've got some other articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of getting a...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 raised an issue that they had previously hard-coded the address of their organization into the body of a template (just below the header... they weren't using the header section) but then they changed address and couldn't change the template. So they...

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

Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 can be an annoying overhead, especially if it can be auto-corrected with a client script. Pre-amble For both of the methods below, you will need to setup a client script which runs when the product page is being modified: Login to ZohoCRM as a system...

• 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 forums for a bit. Their solution only permanently sets the default sort order to WEBLINK TITLE in order from A to Z. The below code with my modifications maintains the functionality for the user to change the sort order by clicking on the column titles....

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 Quick Fix First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional windows update...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 business techno babble and I get asked what does this mean in stage 1? And this in stage 2? (There are over 100 stages)... Below is my template project initiation plan (project mandate?) for my freelance website development process. It may look clean,...

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

Embed an FLV file into a web pagehttps://www.joellipman.com/articles/web-development/html/embed-an-flv-file-into-a-web-page.html

09 March 2010 your webserver. I like to use flowplayer for this example but my own systems can't use a solution as crude as this. Copy the below code (beginning and ending with object tags) Paste it into your HTML page Replace both instances of the text...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• Language: *