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

30 January 2011 however... I have used this script continuously to migrate J1.5.x websites to J2.5.x without issue. I have managed to do whole migrations in under 2 hours (this script runs in about 20 seconds based on 1000 articles and 5000 users) and my clients are...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 developers working in that language. The “System Libraries” of an executable work include anything, other than the work as a whole, that (a) is included in the normal form of packaging a Major Component, but which is not part of that Major Component,...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

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

25 January 2010 or dll needed, just a slight modification to the mousemove tooltip in the autohotkey manual. The following code is not the whole code or a working program but should demonstrate how to include it in your own Autohotkey GUI: ; SET TOOLTIP TEXT...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 } } // tranformation exceptions: words to be UPPERCASED // note the first letter case and suffixed space indicating a whole word. exceptionArray_this = new string[] { "Av ", "Gp ", "Hr ", "It ", "Pa ", "Pr ", "Uk ", "Usa " }; foreach (string myValue in...

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

SSRS Stop Scrolling Behindhttps://joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 as long as the end-user doesn't scroll. If the page was scrolled, what should display went behind my report and instead the whole report acted as a header on top of the scrolling content and would only ever display, the top rows of the dataset. Why? A...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 of database you are WRITING to (eg. `myuser_joellipmancom_mysitedb`.`ejf1r_content`) How? Here's a brief outline of the whole process: Backups Install Users Categories -- unstable Content Weblinks 3rd-party: JComments Here's a less brief outline of the...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 This took me a whole afternoon and involved a lot of hope as I browsed the Internet and no one seemed to have done this before. Fortunately, MediaWiki extensions are easier to write than Joomla CMS ones :c) This article shows you how to get your...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 old-school so my table style will be "Generic". > Next FINISH That's all folks! Hopefully this will save you time. I spent a whole morning following someone else's complicated connection using SQL Server Management Studio and would not recommend anyone...

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

Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the parameters...

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

URL passed settings in Reporting Serviceshttps://joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 &rc:Zoom=100% Note: Where 100% can be page width in percent or whole page. To show/hide the document map (default is true) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:DocMap=True Specify a...

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

CSS keeping the footer at the bottomhttps://joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to take over the whole page if there were no modules positioned in the "right" div. I specified width of left using PHP. This is the CSS though:...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 using that computer is in a meeting but I can login and do this for you". IT Policy: Do not share passwords. It defeats the whole purpose! A media student: "My computer has swallowed my CD-Rom, I put in the disk but when I eject the CD there's nothing...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 - Consider using IECapt (problem with modals/lightboxes - IECapt only sees the dark background and not the modal) - Rewrite whole program to use COM/DOM/AHK: Would suppress website error notifications, reduced code, read webpage content, check when page...

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

No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 does not have a username but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result set. Furthermore...

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

Vertically align an asterisk on a linehttps://joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 the line-height of the asterisk and vertically align to the bottom ( line-height: 10px; vertical-align: bottom;). Here's the whole code: ul.listafter{ list-style-type:none; width:130px; height:130px; background:none; } ul.listafter li{ width:59px;...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Parse a HTML Table into a ListViewhttps://joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 markers (character positions) Needle1a := " My Unique Table Heading" ; Needle1a is a marker for a unique value in the whole content Needle1b := " " ; Needle1b is a marker for a value located after Needle1a Needle2a := " " ; Needle2a is the closing...

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

DJI Phantom FC40 - Fun at the raceshttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 to go round corners. Then I learnt there were so many different angles and routes I could have taken (NTS: Take picture of whole track beforehand and plan a route). Strong Winds: Fighting the wind to keep up with the cars. Keep as much space as possible...

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

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

31 March 2022 a Zoho Inventory image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world wide web that had a working solution. My use-case here is that I have built an eBay integration between Zoho Inventory...

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

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

11 February 2023 A4 paper on it's side) /prefer option set This will create custom parameters/argument suffixes you can add which represent a whole string of words that you may use often but don't feel like typing every time. (follow these to the letter or it will...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 bits that I need for the various clients that request an eBay integration. This is a comprehensive snippet which does the whole lot. How? Using the method of "mega-functions", here is the code snippet for one function which will accept as parameter the...

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