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 NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL END UP WITH NEITHER SITE WORKING!!!) Open the SQL file in your favorite text-editor Rename any instance of "my_old_database.jos_" to the name of your old Joomla 1.5 database or a copy of (note the...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 this app by opening a finder/file explorer window and browsing to the app folder: Then open the file “widget.html” in your favorite code editor, here I am using MS Visual Studio Code for Mac and I get the following: If I change the HTML and save the...

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

View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 button in the top right Click on the link 'Show in New Window' Bookmark the web address of the new window The bookmark/favorite that you have just made can be refreshed when you change things on your site and should reflect exactly how your website is...

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

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

23 September 2009 Opens Developer Tools. Ctrl+Shift+Delete Opens the Clear Browsing Data dialog. F1 Opens the Help Center in a new tab (our favorite). Address bar shortcuts Use the following shortcuts in the address bar: Type a search term, then press Enter. Performs a...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 techniques should help get you started. Next, I would recommend the following: Try these Controls out on some of your favorite webpages. Find some more JavaScript examples, and then try "translating" them to COM. (JavaScript is well documented online)...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 is where you "map" the variables to the oracle returned variables. Debug Testing "Process of elimination" is possibly my favorite and most reliable way of figuring out what's wrong. Here are some suggestions: Check your Oracle stored procedure compiles...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 c:\original_file.txt c:\temp.txt > c:\results_file.txt" The resulting file will be "c:\results_file.txt", open it in your favorite text editor... ta-daa... Explanation: FC is a file comparison tool in MS-DOS /N tells the comparison tool to prefix each...

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

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 it is submitted (either on "Successful form submission", or on properties "On Successful Submission" > "Direct To", or my favorite, Deluge "openUrl()"). Standard as for any usual form without a redirect. Drag a decision box field on to the form; we are...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 can be 'placeheld', other than what the interface offers, into the template. the CRM webhook API function So let's do my favorite method of creating a REST API function in CRM Login to ZohoCRM > Setup > Functions > New Function Give it a function name,...

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

Mirror's Edge Prologue Speedrun Under 2:00https://www.joellipman.com/articles/_other-misc/mirrors-edge-prologue-speedrun-under-200.html

22 September 2009 Blinding run in Mirror's Edge which is one of my favorite games. Yes it's quick to complete but if you've ever youtube'd the levels, there isn't another game so quick-paced and varied giving you that freedom of completing the game your way. The...

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

Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 surname does NOT contain a letter or number -- eg. O'Brien will NOT be returned as it contains letters MySQL And my favorite. Note the circumflex as we are still excluding non-alphanumeric rows. SELECT * FROM Students WHERE studentSurname REGEXP...

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