CSV Chart Generatorhttp://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can...

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

Joomla: Unable to find install packagehttp://www.joellipman.com/articles/cms/joomla/joomla-unable-to-find-install-package.html

05 September 2009 This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and...

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

Add the website name to the page title in Joomla!http://www.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 Go to "Global Configuration" and set the "Include site name in page titles" setting to "No" Open your templates component file (in the case of Yootheme using the Warp Framework this is \templates\\warp\systems\joomla\layouts\head.php, in the case of...

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

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

20 January 2010 2. Unzip to a folder 3. Login to your admin panel 4. Go to Extensions > Install/Uninstall 5. Install com_comprofiler.zip (remember to wait till it confirms it says "Installation finished") 6. Go back to Extensions > Install/Uninstall 7. Install...

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

Change the login link in MediaWikihttp://www.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 Note: This article is displaying how to change the link and not how to setup these authentication methods. Open your skin file /skins/.php. Look for and change the following lines:

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

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

13 October 2010 Download the appropriate file for your system (see compatibility table below) Login to your Joomla admin panel and install as per usual. How to Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your front-end to...

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

RokDownloads Manager does not list fileshttp://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the middle...

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

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

01 March 2011 of their course. It had to allow for synchronizing with the official student record system and timetabling system (done via file upload). It included it's own timesheet / session management / invoicing system. The website was held on a virtual host...

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

CSS Background Without Causing Scrollbarshttp://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I...

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

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

27 April 2011 out there. I'm basing most of this article on the official Joomla 1.6 documentation: http://docs.joomla.org/Creating_a_profile_plugin and I want to use an example that worked for me. Important: This is for Joomla version 1.6.x+. Aim / Objective Add a...

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

T-SQL Record Separatorhttp://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 Thursday Thursday Thursday Thursday Friday Friday */ This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer literate so the SQL query had to do the bulk of the work. The SQL query we...

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

Basic Oracle Stored Procedure Structurehttp://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 STUDENTID STUDENT_USERNAME STUDENT_CREATION_DATE STUDENT_FILE ---------- ----------------- ---------------------- ---------------------------- 1234567 jsmith2012 08-MAY-12 sac180786.txt Permissions CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

How to change local folder for TFShttp://www.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 of my colleagues installed it however, they decided to use a common local directory for all workstations so configuration files would not need to be modified. So? Once installed, my BIDS install would continuously check-out files and store these in the...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

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

07 June 2012 JComments on your upgraded website (at time of print: Jcomments v2.3.0 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...

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

Upgrading a Joomla 1.5 module to Joomla 2.5http://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 you're upgrading and follow the below instructions. I'm also going on the basis tha. Basic Checklist Download all J1.5 files to one folder: /modules/mod_moduletoupgrade/mod_moduletoupgrade.xml /modules/mod_moduletoupgrade/mod_moduletoupgrade.php [if...

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

Joes Syntax Styler (JSS)http://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 Use PHP or JavaScript (avoiding Framework conflicts) You select what words are highlighted what color. Uses separate CSS file for overall look. This is still in development! Currently this plugin is mostly hard-coded and most of the parameters have no...

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

T-SQL: Parse an XML valuehttp://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table...

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

Include a carriage return in a column headinghttp://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 Studio resultset. Remember to format the cells (column headings) in the Excel spreadsheet for it to wrap text and save the file. Hereafter, you will NOT need to do this on each data refresh. Ensure that there is a trailing space after the label and...

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

A quick run through of setting up an export process in SITShttp://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 :) Testing: Manual export of XET Run the relevant screen (in our demo this is Application Clearance Decision (ACD)) Go to File > Export... Type XET as the Data format Double-click in the Template field to see relevant XETs (in our demo, this will only...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

MessageBox or AlertDialog in Android Javahttp://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 hangar_aircraft_name = currentName.getText().toString(); // get the AlertDialog XML layout file final View v = getLayoutInflater().inflate(R.layout.my_custom_dialog, null); // set the hint of the EditText in the AlertDialog EditText inputText =...

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