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

08 October 2009 > 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 and JS file in the...

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

Community Builder in Joomla Vulnerabilityhttps://joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 those who need to keep Community Builder as their user manager. There are several things I have picked up which I will go into more detail as I test each one (11.11.09): administrator/components/com_comprofiler/plugin.class.php variable...

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

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

12 July 2010 of media files (all legitimately :) and stored them in my music folder. I then run my MP3 software to convert all the files into MP3 format and store these in another folder. I needed a program to: Check the final folder for all the MP3 filenames Check...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 priority Press "Enter" on the first boot device Select "CDROM" Press "F10" to save and exit the BIOS. Load your ISO or CD into your CDROM Go to "Action" in the menubar and select "Reset..." Additional Information Taming your multiple IE standalones...

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

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

26 May 2010 MS Windows eventlog 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...

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

Error during processing - Converting Date/Timehttps://joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once you've added your parameters (date/time type): Right-click on the DataSet. Select 'DataSet Properties. Find...

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

Webdeveloper-Speakhttps://joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 marketing. Section 508 Section 508 is an amendment to the United States Workforce Rehabilitation Act of 1973. Signed into law in 1998, this legislation requires that electronic and information technology developed or purchased by the US Federal...

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

Passwords: Did-you-knowhttps://joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 client’s network simply drops loads of free nice USB flash drives in the parking lot. Employees pick them up and plug them into their machines at work which then sends the details over the internet. Apparently this has a 9 in 10 chance of working....

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 Server. Ensure you name them the same thing as you did in the report. I am looking at ways of doing this without logging into the reporting server or making any changes to it. If anyone knows of a way, please feel free to comment!

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

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

29 March 2011 the warning "Overlapping report items are not supported in all renderers" then I'd suggest you use method #1. Issues I ran into: I replaced the empty dataset with the message "None" using Method #2 above. I noticed when a textbox is hidden, the next...

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

Difference between two dates - the midnight hourhttps://joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 2011-03-08 23:30:00 = -23.00 This is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 it a networked printer, I mean is there a cable that directly connects the printer to your computer or does the printer plug into the wall? Ok could you please follow the cable from the computer to the printer and tell me.". "Hang on its on the other...

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

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

05 July 2011 Windows Applications. This tutorial is going to be high level, but will provide links to those who want to dig deeper into these concepts. You don't need to have much programming experience, but I will assume you feel comfortable writing and executing...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 need to use the ID parameter all returned zero rows. So one workaround exists where if I combined all 10 dataset queries into 1 mega dataset query, problem solved… Another workaround exists where if I added the OR part to all my datasets (so where each...

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

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 from the PivotTable altogether, hit the Data Refresh button Add the column back to the "Row Labels" Move the field back into "Report Filter" Done! The filter dropdown should retain the order. Alternatively Similar to the above, open a Microsoft product...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 share (file). Before you ask, we have several MS Sharepoint sites but we didn't go down the route of uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external images to...

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

Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 joomla database. Note that your database user should have access to both databases in order for this to run smoothly: INSERT INTO my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email, user_url, user_registered, user_activation_key,...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We use a...

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

Basic Oracle Function Structurehttps://joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN...

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

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

18 July 2012 the documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code. What? Change contents of "original_file.txt"...

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