RokDownloads Manager does not list fileshttps://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: *

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

08 October 2009 Camtasia Studio SWF files in it's articles. Why Camtasia when there are other free options? We tried lots of FLV players that were usually branded or not free. These were awkward to configure a full screen button on the controls and do basic...

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

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

25 November 2014 "Basic Android App using Google Maps and Current Location", this article suggests how to add Map as a sub activity. Note that this article is based on a new blank project which does not include code from the previous example but you can still build this...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 to: Apple iOS 7 Apple iTunes 11.1.3.8 Microsoft Windows 7 Professional What? Just so many articles out there that did not help me. This article is how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a...

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

SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

04 April 2013 data source, then the options in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but you can still control the data range. How? My example is that I have an excel sheet where the first 10 rows...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

29 March 2011 but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the below will also let you do this...

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

SSRS Redirect after a report is runhttps://www.joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

12 August 2011 reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are various solutions out there, here's an overview of some: Method #1 Create one report...

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

17 November 2011 solution as well so who copied off who is not my concern as this is not the solution to our problem. This is the solution that I initially used but my end-users were asking why is it always 0 seconds. This was because we were using the following MDX...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

02 December 2011 SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name If you want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

08 April 2014 and would only ever display, the top rows of the dataset. Why? A lot of articles out there on the net are offering solutions that do the exact opposite. Basically, I want the opposite result of "Fixed headers while scrolling". How? Once I figured out...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

28 January 2010 The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

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

Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

27 April 2010 Thought I'd put something here as a lot of my clients and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This...

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

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

30 July 2020 To: Microsoft Windows 10 Pro v10.0.18362 What? This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page....

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

03 June 2021 using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have "Num Lock" on/enabled. Typing a special character is 3 easy steps: Hold down the ALT key (preferably the one on...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

11 October 2012 Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....

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

Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import happens under the Server...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 This is to describe how to change the value of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears, allowing...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form is setup to do this:...... The form above will post to itself but more importantly is the...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 on line ### Why? So I've googled, binged and yahoo'd for this and although there are some solutions that deal with loading UTF16 content into SimpleXMLElement or simplexml_load_string, it doesn't solve my problem. I'm receiving XML data within a cURL...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

12 April 2013 This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...

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