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 c.`published`, CASE WHEN c.`access`=0 THEN 1 WHEN c.`access`=1 THEN 2 WHEN c.`access`=2 THEN 7 END AS access, '{"target":"","image":""}' AS params, '{"page_title":"","author":"","robots":""}' AS metadata, @new_jos_admin_id AS created_user_id, b.date AS...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 { LV_GetText( v_OldFileName, A_Index, 1) LV_GetText( v_NewFileName, A_Index, 2) v_Source := v_FolderPath v_OldFileName v_Target := v_FolderPath v_NewFileName ; MsgBox %v_Source%`rto`r%v_Target% FileMove, %v_Source%, %v_Target% v_RowCount++...

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

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

25 February 2010 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 3rd-parties?)...

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

Joes Revolver Map (JRM)https://joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 Visit the website http://revolvermaps.com/?target=setup Configure the map to the settings you want. Copy the ID reference as per the "Important Note" below. Login to your Joomla website admin panel Install this module as per usual (will auto-install) Go...

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

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

23 February 2014 per pass) basis. /IPG:n :: Inter-Packet Gap (ms), to free bandwidth on slow lines. /SL :: copy symbolic links versus the target. /MT[:n] :: Do multi-threaded copies with n threads (default 8). n must be at least 1 and not greater than 128. This option...

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

XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 group Defines a group of elements to be used in complex type definitions import Adds multiple schemas with different target namespace to a document include Adds multiple schemas with the same target namespace to a document key Specifies an attribute or...

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

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business requirements. Why? If you're developing in SITS, and you use the client,...

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

Android: Replace return key with done, go, send...https://joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 more to input and the IME will be closed. IME_ACTION_GO // the action key performs a "go" operation to take the user to the target of the text they typed. IME_ACTION_NEXT // the action key performs a "next" operation, taking the user to the next field...

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

Import Excel CSV file as JavaScript arrayhttps://joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 mimetype xhr.setRequestHeader('Content-Type', 'text/csv'); // send request to the server xhr.send(); // return contents of target file to JS variable var my_csv_file_contents = xhr.responseText; // split contents into array of rows // store each line of...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 these and more importantly see the command to open them. Note that the MS Windows 10 Mail shortcut will be something like target: microsoft.windowscommunicationsapps_8wekyb3d8bbwe!microsoft.windowslive.mail. The easiest way to do this is to right-click...

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

Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 mouse. Ctrl+F5 or Shift+F5 Reloads your current page, ignoring cached content. Press Alt and click a link. Downloads the target of the link. Ctrl+U Opens the source of your current page. Drag a link to bookmarks bar Bookmarks the link. Ctrl+D Bookmarks...

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

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

28 June 2011 v? (future) - Option to loop text file? note to overwrite images; does this just add more options? - Option to specify target folder. - Option to FTP upload the thumbnail files to a server (more laziness - security concerns) - Consider using IECapt...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 opacity to start with when the page loads; when you hover the mouse cursor over it the thumbnail will regain 100% opacity. Target Window: Rokbox? Demo'd on my personal website because I am using a RocketTheme template but this should work if you have...

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

Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = (WM_USER + 29) Const RB_MINIMIZEBAND = (WM_USER + 30) Const RB_MAXIMIZEBAND = (WM_USER + 31) Const RB_GETDROPTARGET = (CCM_FIRST + 4) Const RB_GETBANDBORDERS = (WM_USER + 34) Const RB_SHOWBAND = (WM_USER + 35) Const RB_SETPALETTE = (WM_USER + 37)...

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

SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 a link dependent on parameters submitted, we had to apply a similar IIF statement block to the Font color and the Action target as well within SSRS.

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

Joes DNS Correction (JDC)https://joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 I get to update it, my connection will drop and my computer will say that it could not connect to either the TFS or my target deploy location. I found a quicker fix than rebooting your computer which is to open a command prompt and to type "ipconfig...

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

SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 -- "Date" is the last column and can be blank in the source. -- "Date" must default to current date if blank for the target database (cannot be NULL). -- PROBLEM: -- assuming date could be blank (has spaces) or in format DDMMYYYY (TRIM(Date) == "") ?...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• 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 to the folder to place binaries from your sample. If you need to place files in the GAC, right-click on the File System on Target Machine -> Add Special Folder -> Global Assembly Cache folder. It will now show up as an additional folder, and you can add...

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

SSIS Multiple Lookups in onehttps://joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around...

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

Android: Function to let user take photo or choose existinghttps://joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 Applies to: Android Studio v0.8.9 Microsoft Windows 7 Pro Android: Min SDK v4.0.3 (IceCreamSandwich) API 15 Android: Target SDK v4.4 (KitKat) API 19

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