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 Rename any instance of "my_old_database.jos_" to the name of your old Joomla 1.5 database or a copy of (note the "jos_" prefix to all J15 tables, if you have changed this then reflect this in the SQL file). Rename any instance of "my_new_database" to...

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

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

18 July 2012 Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have...

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

Joes Quicklist Weblinks (JQW) Downloadshttp://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Thumbnail Service: FreeWebsiteThumbnails.Com - Parameter: Date created or date modified - Parameter: Parameter "More Links" prefix text (moved from language file) - Critical: Fixed Custom Order by Weblink ID - Date Uploaded: Thu, 2nd May 2013 2.1.2-...

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

CSS Add Text to Breadcrumb Link with a Transitionhttp://mail.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 Given the following HTML: Home Products lanterns Using CSS only, I have so far achieved the following: /* Specify a blank prefix which is fully transparent */ ul.breadcrumb a span:before { opacity:0; content: ''; transition: all 1s ease;...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 on Joomla v2.5.4) Copy the below script to a text file Change the database names to match your setup Change the table name prefixes to match your setup Run the modified SQL script against your database. Note: It is not advisable to run this on a...

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

Connect to Joomla database in standalone scripthttp://mail.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 $db_pass = $Config->password; // Password for database authentication $db_name = $Config->db; // Database name $db_prefix = $Config->dbprefix; // Database prefix (may be empty) // Database prefix (if empty then remove prefixing double underscore)...

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

Zoho Deluge: Proper Case for Nameshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 v_FirstName = v_FirstName.replaceAll(" :|joel|: ", "-", true); // // Names starting with Mc, O', D', I' l_ExceptionPrefixes = {"Mc", "O'", "D'", "I'"}; // // deal with double barrelled surnames l_FormattedLastName = List(); l_LastNameParts =...

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

Registered Users Cannot Login - Super Users Canhttp://mail.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open the #__assets table where #_ is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration > Server > Database Settings :...

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

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

05 July 2011 loading Sleep, 10 MsgBox, DONE! ComObjConnect( pwb ) ; Disconnect IE object Return IE_DocumentComplete() { ; the "IE_" prefix corresponds to the ComObjConnect() function above Global loading = 0 ; Break the While-Loop } Code: ; AHK Basic: COM_Init() pwb...

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

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 website running Joomla v2.5 as "v25" and the new Joomla instance as "v34". Their respective database tables are prefixed with "v25_" and "v34_". So an example MySQL statement will be: `v25_db`.`v25_tablename` -- with the database name and table prefix...

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

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

12 July 2010 already been converted and can now be deleted. Or run this program. CHANGELOG: v1.1 (12/07/2010) - Added option to ignore prefixes and suffixes to the filename. - Colored the folder to keep in Green and the one to delete in Red. - Lists failed...

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

K2 Items disappearhttp://mail.joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 REPAIR TABLE jos_k2_items Note that I say "jos_k2_items" because by default that's what it is... If you changed the table prefix when you installed Joomla! on your site (default is "jos_") then you'll need to change this repair table command to match...

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

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

28 June 2011 on a floppy disk) Setup/Install: None, it's portable (can run off USB or media) Program Name: WebsiteThumbnailer_v0_6.exe Prefix: JWT So I need a FREE program that simply takes pictures of some websites my website links to (about 153) for an extension...

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

Batch Process to rename multiple files using Windows DOShttp://mail.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 rename.bat This will display all the files to be renamed Return to the notepad (rename.bat) and take out the remark "REM" prefix so your code becomes: @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION FOR /f "tokens=*" %%a IN ('dir /b *" (Copy).jpg"') DO ( SET...

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

Warning: Save failed. Another menu item has the same aliashttp://mail.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is the table prefix) Instead of deleting, I change the existing menu item alias from "about-us" to "about-us2" as well as any similar `path` value....

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 click on the red "Verify Now" link. The sidebar for "Domain Verification" will poup on the right. Note the small code and prefix it to your parent domain (eg. abcd12.joellipman.com) and note the CNAME which will either be creator.cs.zohohost.eu or...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 example, I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our example I am going to prefix it with "l_" (for list) and the plural of what kind of records I am sending as parameters (in this case "Quotes"). As the...

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

UNC Paths in Sharepoint 2007 linkshttp://mail.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 be situations when this is better but I'm just trying to add a link to our Sharepoint 2007 portal. How? Add a link with the prefix File:// and complete the rest of the path as per usual. Sharepoint will correct the link when you OK it if you are trying...

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

Disable User Registration in Joomla 1.5 - Configuration Filehttp://mail.joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 the database to the Joomla 1.5.x website Browse the table "jos_components" (or "#__components" where "#_" is the site table prefix. default is "jos"). Open the row where name="User Manager" Set the value under params for AllowUserRegistration...

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

Forgotten Super User Password in Joomla 2.5.x - 3.xhttp://mail.joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

06 February 2015 a new joomla user if necessary). The gist: Login to your Joomla database Go to the #__users database table (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text there Find the row of...

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