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 the name of the new database -- including the new table prefix (Joomla 1.6.x, 1.7.x, 2.5.x, 3.0.x). -- Tip: I copy & paste this code into a text editor, then do -- "Replace All" with these 3 values, then copy & paste the resulting -- SQL into a query...

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

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 to embed Click the 3 dots (ellipsis) at the bottom right of the description. Click Embed From the box that appears, Copy & Paste the code into your blog or website HTML. YouTube Go to YouTube and browse to your channel Hover the mouse over Uploads and...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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 of its 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...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 Click on "Create" You will be issued a Client ID and Client Secret, make a note of these or leave this window to copy&paste into the next step. Setting up the Oauth Connector So return to your Zoho Books instance (or Subscriptions, Inventory, app you...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 it in a local variable). So the idea here is to run the below example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel:...

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

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

07 December 2012 to your Joomla website admin panel Install this module as per usual (will auto-install) Go to Extensions > Module Manager Paste the ID code you got from revolvermaps.com into the module parameter. Important Note: The ID it installs with is for my demo...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 in the encoding, change every second. You can get it verifying the signature successfully if you go get your public key, paste both keys into jwt.io (these don't change), then paste the encoded assertion. Anyway, this is how you generate the JWT header...

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

Making a CD copy with only one drivehttps://www.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 the desktop, double-click on MY COMPUTER Right-click on the CD drive and select OPEN Go to EDIT > SELECT ALL > EDIT > COPY PASTE to a temporary folder Select all the files, right-click on them and select SEND TO > DIRECTCD Roxio Easy CD Creator...

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

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

23 September 2009 then press Ctrl+C. Copies content to the clipboard. Place your cursor in a text field, then press Ctrl+V or Shift+Insert. Pastes content from the clipboard. Place your cursor in a text field, then press Ctrl+Shift+V. Paste content from the clipboard...

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

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 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 "http://my.video.com/myVideo.flv" with the full url of your own FLV....

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

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

03 June 2010 Position..." Copy to clipboard the exact height value Right-click on a faulty heading textbox Select "Size and Position..." Paste the same height value as the one that worked Repeat for all heading textboxes that weren't appearing This will yield...

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

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 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 you ok this you should be on the following screen: Select the Report Type: For this calendar we want...

• 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 row and copy the value to your clipboard or notepad, etc. Then select all the remaining cells in the row and paste your expression in the "Fill > BackgroundColor" properties row... Done! Borders: I'm putting this here because often enough, if I'm going...

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

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

23 March 2011 [time] in the "column" and [room] in the "row" and [note/status] in the "data" cells. 2. Use the SQL code above: So you can paste this straight into the textarea or use "Query Builder". 3. Select Matrix Tablix: We want all rooms on the left and the time...

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

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

05 July 2011 = $0291 Const WM_MOUSEHOVER = $02A1 Const WM_MOUSELEAVE = $02A3 Const WM_CUT = $0300 Const WM_COPY = $0301 Const WM_PASTE = $0302 Const WM_CLEAR = $0303 Const WM_UNDO = $0304 Const WM_RENDERFORMAT = $0305 Const WM_RENDERALLFORMATS = $0306 Const...

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

SSRS / MDX Date Querieshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html

03 August 2011 I'll add to this if I use others. Apologies for the European formats but this is what I work with so I like to just copy and paste from this article.

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 Query > select Data Source Specify SQL Query: > Add Tables (not really just "close" this) > click on SQL button > Type/Paste your SQL Query > OK > Click on "Return Data" button Report Type: Select PivotTable Report > OK Design Table: Drag StaffName to...

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

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

20 September 2011 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, FormattedTime ,...

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

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

27 August 2012 You then refer to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the below into a PHP file and include it in your component, the solution is really that straightforward. Feel free to check...

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

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to copy and paste into your SQL administration software. You can put a distinct on it (not forgetting the collate). This example is expanded in a...

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