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

12 September 2015 the Admin ID in the new v34 system to match your v25 system. Check your usergroups are the same in both systems. Import new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over user group mappings Update new...

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

MS-DOS: Copy folders without overwriting fileshttp://mail.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 ROBOCOPY c:\Sourcepath c:\Destpath /E /XC /XN /XO -- /E makes Robocopy recursively copy subdirectories, including empty ones. -- /XC excludes existing files with the same timestamp, but different file sizes. -- /XN excludes existing files newer than the...

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

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

11 February 2023 Real Estate Photography Still Life Photography Tech Photography Camera Angle Note that there others, I'm only listing ones that actually followed the prompt (eg. Eye-Level Shot puts a massive eye on the picture???) Cinematic Still Shot Full-Body shot...

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

Joe's Unduplicater (JUD)http://mail.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 simply the converted versions of music or video files, then this tool asks which folder has the files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS: LICENSE: These scripts are offered freely...

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

SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special chars rather than Null). My example here is that the first column is our employee number and the second...

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

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

08 October 2009 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 MediaWiki system to display your Camtasia Studio SWF files in it's articles. Why...

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

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

25 February 2010 can't see face-to-face with colleagues or clients. Startup Meeting For you to discuss: Aims / Objectives Deadlines / Milestones Target Audience (Internally Centered? / Customer Focused?) Outsources? (Is JoelLipman.Com Project Manager? other...

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

Remove write-protect from USB pen in Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 equivalent. I use my USB pen as the "My Documents" folder on every computer I use. It was fine with my 16Gb one but my 32Gb ones have all failed at some point. I went for a cheap one on Play.com (Verbatim 32Gb@£49.99 & Kingston DataTraveler@?) and an...

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

Crystal Reports: Exporting to Excel omits column headershttp://mail.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 worked for me, was to make all the heading boxes the same height and to get rid of all the unnecessary extra gridlines (the ones that appear in the ruler as little arrows). So right-click on a heading text box that works Select "Size and Position..."...

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

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

30 January 2011 (mysql user) with most privileges on BOTH databases. -- -- To change the database names used in the below script to the ones you use!!! -- SKIP MIGRATION: -- -- Each section was written so that it could be migrated separate to the rest. -- -- It is...

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

Room Availability Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 mouse over the block it will display the details). I've used a UNION clause which will hopefully make all rooms (even empty ones) display. Note the second select statement (to list all the rooms) has to have the same number of fields as the first...

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

AutoHotkey Format Date and Format Secondshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) { FormatTime,...

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

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

20 August 2012 this has been quite a challenge. I have tried so many examples, testing different mootools libraries to see why the Joomla ones weren't working. It may not be right, it may not be the best or optimized order but it works for me and that's pretty much...

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

Joomla article modal with clear buttonhttp://mail.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 folder/directory of your component (/my_component/administrator/models/fields/article.php). It's based on two Joomla core ones, namely administrator\components\models\fields\modal\article.php and \libraries\joomla\form\fields\media.php. You then refer...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007http://mail.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 the others. Once it's in your Outlook, you can copy over events. The calendar is separate to your own and to other Exchange ones. Eeek! A bit daunting of a process as you may be lead to believe that your personal calendar will be synchronized with the...

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

Preg_Replace all strings between two tagshttp://mail.joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 = preg_replace( '/[a-z_ -]+\ \(/i','$0', $string_original); Anymore? Please leave a comment if I've missed some useful ones out.

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

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

30 March 2013 so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know which ones best: Method #1 This method replicates the table in a listview format: ; tell the script which content to parse Haystack :=...

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

Improve Default Joomla Search http://mail.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 back up all your website files and its database. Or, if space is limited, you can backup the files I have listed here (the ones we will be modifying): \plugins\search\content\content.php \components\com_search\views\search\tmpl\default.xml...

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

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

04 October 2013 as a Custom Component Script. (ie. if we use this script in many packages, we can change just this script instead of the ones for every package). Here is the near enough final version of my script (or more like an experienced colleague's comprehensive...

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

Problem creating SSRS report subscriptionshttp://mail.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 based on a report parameter. How? There are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them working. Custom DataSource Upload the report to the ReportServer. Hover...

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