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 and "MACHURA". " and ", "la", "le", " van ", " de ", " of " and similar should remain lowercase. How? The SSIS Script component task has to be generic, it should only apply this to columns we specifically tick in a package and we should be able to use...

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

Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 I'm making a custom component for Joomla CMS 2.5.x which is restricted to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin...

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

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 I'm revisiting this component for the third time (previously known as "downloadtracker" and "joesdownloadtracker"); for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year...

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

Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 hidden fields: limit, search phrase (all, any, exact), ordering, and areas (set to doc_indexer by default as per the component). The parameters are changed in the back-end of the site (Joomla admin panel). The functionality and component are simply an...

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

Error 404 Component Not Found when enabling SEF URLshttps://joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 to this page If difficulties persist, please contact the System Administrator of this site and report the error below. 404 Component not found. Just because I'm doing something like this: How? I found that this was only affecting my subdomains where...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 section and click the "Load Settings" link. In the right panel, there is an option saying "Recompile stale style components" with a radiobox, set this to "YES" and click on "Submit" at the bottom of the page. Under the same section is the "Security...

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

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

27 August 2012 article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important clear button. What I found was that no one posted this solution which I found is compatible...

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

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 not an upgrade; it is likely that your client may reconsider the template they are using or may want to add new 3rd-party components. If asked: "how long will it take", do not say 5 minutes. This script runs on average in 15 seconds. The remaining...

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

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

14 March 2013 not be converted because of a potential loss of data.". Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Extract dates from string dates" (3614)" failed because error code 0xC0049064 occurred, and the error row disposition on...

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

Mootools - How to contain a menu sidebar between header and footerhttps://joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 = $('jdo_marker_table').getCoordinates().top; var menu_height = $('jdo_actions').getCoordinates().height; var component_top = $('jdo_overall').getCoordinates().top; var component_height = $('jdo_overall').getCoordinates().height; var match_lowest_y =...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 work include anything, other than the work as a whole, that (a) is included in the normal form of packaging a Major Component, but which is not part of that Major Component, and (b) serves only to enable use of the work with that Major Component, or to...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Creating a custom form field type for Joomla XML fieldsethttps://joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some...

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

Invalid arguments passed in router.php on line 325https://joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 "cowboy fix" rather than the other intelligent solutions on the web. The issue was that I was building my first Joomla 1.5 component and getting the below error if I put in a menu: Warning: implode() [function.implode]: Invalid arguments passed in...

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

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

07 June 2012 /* INSERT INTO mydb_upgrade_j25.myprefix_jcomments_settings ( component, lang, name, value ) SELECT component, lang, name, value FROM mydb_livecopy_j15.myprefix_jcomments_settings; */ --...

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

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

17 August 2012 TO Joomla 2.5.x Why? I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 clear as mud: Error: The conditional operation failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error row disposition on "output column...

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

Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 the core framework files. Yes the bad news is you have lost your site. The good news is that it's only the core files and component files. Here are some tips when restoring the site to return it to as it was. The error refers to a function used by the...

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

Joomla field types clear my htmlhttps://joellipman.com/articles/cms/joomla/joomla-field-types-clear-my-html.html

09 August 2012 Trying to make a component and can't remember how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no...

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

SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft staff...

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

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

04 February 2025 > com_akeebabackup > Uninstall: Joomla\CMS\Filesystem\Folder::delete: Path is not a folder. Path: [ROOT]/administrator/components/com_akeebabackup Joomla\CMS\Filesystem\Folder::delete: Path is not a folder. Path: [ROOT]/components/com_akeebabackup...

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