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 and original version of the website (Joomla! 1.5.x) -- -- Upgrade = Fresh install of Joomla! 1.6.x - 3.0.x (sample data optional). -- ----------------------------------------------------------------------------- -- TABLE OF CONTENTS -- I. Help on using...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttp://mail.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 f_CSVFile.setParamName("file"); Get current file name (optional) To check on filename changes, I run this bit of code to get the internal and current file name: // // get original document file (optional) - you need your own record ID here...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 store this line item as an object o_ThisLineItem = a_QuotedItems[i]; console.log(o_ThisLineItem); // if not specified as optional then this will be transferred to the invoice if (o_ThisLineItem.Optional != "Optional Not Included") { // field mapping of...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 { opacity:1; content: 'Return to '; } /* Add the CSS Glyph: angle quotation mark, right to this particular link [Optional] */ ul.breadcrumb a.home:before { content:'\00bb'; margin-right:5px; } The last snippet is completely optional if you want to...

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

Zoho Creator: info/alert/modal/popup notification for any userhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 2 parameters p_NotifyTitle and p_NotifyContent to the page: Then drag a HTML snippet onto the page with the following: /* optional: hide some of the wrapper div boxes: leaves a modal with rounded corners */ .popupboxOuter{background:none;border:0;}...

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

Zoho Analytics: Create a Monitoring System with Imageshttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 a table that holds the URLs of the images I want to use but if the image is hosted elsewhere, then this step is completely optional. Click on "Create" and select "New Table / Import Data": One of the last options on the "Import Your Data" page is "Enter...

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

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

08 October 2009 Video As... > Custom production settings > Next Select 'Flash (SWF/FLV) - Adobe Flash Output' > Next ExpressShow (complete optional settings) > Next Video Info (complete optional settings) > Make sure "Embed Video into HTML" is checked > Next Specify...

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

Merge the content of two similar tables in MySQLhttp://mail.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 tables as I'm quite content with just the two columns I requested. And for those of you that don't know, the alias "AS" is optional in MySQL (think it's optional for most SQL forms). I found that to add further tables, simply start with another "UNION...

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

Creating a Profile Plugin for Joomla 1.6http://mail.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 profile5.php index.html profiles en-GB.plg_user_profile5.ini en-GB.plg_user_profile5.sys.ini JOPTION_REQUIRED JOPTION_OPTIONAL JDISABLED JOPTION_REQUIRED JOPTION_OPTIONAL JDISABLED ./profile5/en-GB.plg_user_profile5.ini ; Joomla! Project ; Copyright...

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

Regular Expression Basic Usage Exampleshttp://mail.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 of the preceding character or subexpression. You can think of this operator as specifying an expression that is optional in the source text. For example, to find--'a', optionally followed by 'b', then followed by 'c'--you use the following regular...

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

ZohoCRM: Process all records of a modulehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 time. When the checkbox gets updated, this modifies the record and puts it at the bottom of the list. In a nutshell: [Optional]: Deactivate any workflows that this process would affect Go to the Module Layout and drag a "Checkbox" field on to the module...

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

Zoho Creator: Input Color Pickerhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 application later - so perhaps rename this to 'Staff Color'] Add another single line field, I'm calling it "RGB Value" [Optional: not required for the functionality of this demo but used in later application when including CSS opacity] Step 1: Code to...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttp://mail.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 sidebar Under "SEO Settings" set to "Yes" to the options: Search Engine Friendly URLs Use URL Rewriting Add Suffix to URL (optional) Unicode Aliases (optional - for international languages) Select the "Integration" tab Change the “URL Routing” option...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 { for each m_LineItem in m_RecordData.get("Quoted_Items") { if(!isNull(m_LineItem.get("id")) && !m_LineItem.get("Optional")) { // add here line items that will be added or updated m_NewLineItem = Map(); m_NewLineItem.put("id",m_LineItem.get("id"));...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttp://mail.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 new admin ID is 111, previous admin ID is 222, and general information desk account is 333), remove other super admins (optional) I also noted the previous admin's ID and returned their super admin status. Sorted by group_id desc and changed 8 to 2....

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

Windows 7: System Clock is constantly going out of synchttp://mail.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional windows update that fixed my issue. check that this issue isn't being caused by any Windows 7 desktop gadgets. Quit/close...

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

SSRS Dropdown parameter cannot be blank!http://mail.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL. When I leave the 3rd and 4th parameter untouched (=""), the report complains saying "Report #3 parameter cannot be...

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

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 line of my code 3: The third line of my code How? Open a MS-DOS Command Prompt (Start > Run... > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path reference). This example assumes the file is in C...

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

Access MySQL databases using Oracle SQL Developerhttp://mail.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 so let's begin: Download the JDBC Driver for MySQL (Connector/J) connector from http://www.mysql.com/products/connector/ [Optional Step] Uncompress the download, then copy or move the JAR file (at time of print: mysql-connector-java-5.1.22-bin.jar) to...

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

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

14 March 2013 the Date was blank and puts a NULL string. The second takes this string and converts it to a date: -- Assuming EndDate is optional (can be null) and in format DDMMYYYY: -- Derived column task 1: Replace 'Date' TRIM(Date) != "" ? TRIM(Date) : "00000000"...

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