Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 Kunena configuration panel: Download your site from your server to a copy on your local disk (hard disk, flash drive, etc) Make sure that the \components\com_kunena\template folder is on your local disk Make a copy of the default folder inside Rename...

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

Disclaimerhttps://www.joellipman.com/static-items/disclaimer.html

30 May 2009 The information is provided by Joel Lipman .Com and while we endeavour to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability...

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

Sun-Dried Tomato Basil Couscous Recipehttps://www.joellipman.com/articles/_other-misc/sun-dried-tomato-basil-couscous-recipe.html

03 September 2009 tomatoes, green onions, and basil. This dish may be served hot or at room temperature. Use store-bought vinaigrette or make your own. Prep Time: 10 minutes Cook Time: 5 minutes Ingredients: 1/4 teaspoon dried garlic powder 1 package (10 ounces) plain...

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 By making some minor changes to the MediaWiki LocalSettings.php file, we can fix this. For demo purposes, I'm going to make our system recognize SWF files (by default these are disallowed): Firstly: Add the following line to somewhere in the...

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

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

08 October 2009 - Adobe Flash Output' > Next ExpressShow (complete optional settings) > Next Video Info (complete optional settings) > Make sure "Embed Video into HTML" is checked > Next Specify production name and click on 'FINISH' This will produce a HTML, SWF, XML...

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

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 > Community Builder > Configuration 15. Click on the 'Registration' tab 16. Change Allow User Registration to Yes,... 17. Make your custom configuration and Save the configuration file. 18. Go to Site > Global Configuration > System 19. Select No next...

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

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

28 January 2010 caused by any Windows 7 desktop gadgets. Quit/close all desktop gadgets except the CPU monitor and your analogue clock. Make sure your computer is connected to the Internet Left-Click once on the clock on your taskbar Click on Change date and time...

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

Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 We're going to modify a file containing 2 lines of code by default. The file is index2.php in your Joomla root folder. Make a copy of it, back it up or do whatever you usually do when you modify a server-side file... ahem... The code by to look for...

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

Windows Live Messenger: Error 80048820https://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 is accurate or close to real Internet time: Quit/close all desktop gadgets except the CPU monitor and your analogue clock. Make sure your computer is connected to the Internet Left-Click once on the clock on your taskbar Click on Change date and time...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file. CHANGELOG: Version 1.0 + This is version 1.0 unless people have suggestions I...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• 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 design view, only the circled headings would appear on the exported report: The solution I found that worked for me, was to make all the heading boxes the same height and to get rid of all the unnecessary extra gridlines (the ones that appear in the...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 in the worksheet. NOTE: Fields formatted so they are much wider than the actual size of the data can cause blank columns. Make sure the field width is just wide enough to display the longest data value. Cause 3: Fields and objects in the same column do...

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

Joes Word Cloud (JWC)https://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=40

13 October 2010 to see if it does what you want it to do. Modify the module parameters as necessary. Setup First of all, you need to make it visible. These 3 steps will have your module ready: The further steps below are how to configure it to match yours or your...

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

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 on the top of the [Order] column (grey square -like excel- to select the column). Select "delete columns". Still deleting: Make sure you select "delete columns and associated groups": Overview: So the following screenshot is how your report should look...

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

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 Update June 2013 - How to use this migration script: Make a backup copy of your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder....

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 in the "Fill > BackgroundColor" properties row... Done! Borders: I'm putting this here because often enough, if I'm going to make the report pretty with alternating rows, I'm probably going to look at the cell borders as well. I want a bigger border at...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 Sum(Fields!Counter.Value, "Equipment") should come back as zero. MDX Expression: One final and a little confusing tweak to make it all work! Where "Equipment" is the name of the dataset. Bring up the tablix properties (or the textbox you want to hide)...

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

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 Friday. The 1st of January 2011 was a Saturday. The developer felt that as long as you adjust the script each year you could make the system last another year. Shame he also forgot the academic year ends halfway in a normal people's calendar, so you...

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

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 errors EventViewer (if Windows) errors.log (if Linux) Above and beyond Product Handover (branded pack with contact details - make it simple and friendly!!!) Warranty / Grace Period (agreed support period post production - fees and estimates) Behind the...

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

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine. The left and right...

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