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

13 October 2010 View the module on your front-end 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...

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

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

28 October 2010 issue with overloading or with the actual code and you can get to this file manager to work without changing your Joomla! setup. Watch this space for when I find a definitive answer!

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

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having...

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

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

05 January 2011 http://dev.mysql.com/downloads/connector/ Click on "Connector ODBC" Download a version suitable to your system Install it Setup the ODBC Connection Start > Programs > Administrative Tools > Data Sources (ODBC) Click on the System DSN tab Select "MySQL...

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

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

19 July 2011 VS2008) with Team Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for the purposes of this article). The...

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

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

19 September 2011 URL (You shouldn't be having any issues with this if the image is available to anonymous users - eg. Google Logo). Our Setup Windows XP Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server 2008 R2 Reporting Server (SSRS) running...

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

List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 do I want? Page ID, Title, Content, Category, AccessLevel (note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've...

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

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values...

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

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

05 February 2013 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 Administration...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 to: - Microsoft Windows 7 Enterprise - User with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS),...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the above setup is located in "C:\app\\product\11.2.0\client_1\Network\Admin". I also checked that the data therein matched the...

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

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

23 April 2013 here is that the first column is our employee number and the second column will be the remaining data on that row. So I setup my connection manager as follows (note the "Ragged Right" and delimiter as "{CR}{LF}" - my rows to skip is because of the state...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 systems which manage my work accurately (eg. my Project Analysis Manager - dubbed PAM - can tell me how long it took to setup a website previously, and will plan the same again). My 15 years of web-development experience allow me to reduce the risk of...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 any changes to the server (no updates), and the recaptcha simply stopped displaying. Public Key and Private Key have been setup in the Joomla Core Plugin. Set to display in both User Registration and Global Configuration. K2 is NOT installed.

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 ; SETUP TRAY ICON ; ********************************************************************************************************************************************************************** Menu, Tray, Tip, %ThisProgram% v%ThisVersion% GoSub, TrayMenu ;...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 in the time that I have written this article, release a newer version that corrects this. I personally downloaded HeidiSQL, setup a connection and exported the database. Job done without making any changes to the LIVE environment!

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

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

21 August 2014 Group as the DOR. In our example, our Type is "SQL db connector" and we use a stored procedure that the supplier helped setup along with the XML that will be sent to our database table. Be sure to use the same XET code and that the "Active" checkbox is...

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

TravelPort Universal API - Ping Request with PHP-cURLhttps://www.joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using PHP as the server-side programming language and cURL, a...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Model handles database and library variables, Views controls the HTML layout - And tweaks so I have as little to setup on each website :c) - Date Uploaded: Mon, 1st Aug 2011 It's Personal- Rounded corners, hover border, styling mostly - For use by my...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 -- ********************************************************************* -- METHOD #1- DOES NOT MAINTAIN V25 CATEGORY IDS: setup these categories -- using the the Joomla admin interface Web-GUI to add them. Ensure the -- aliases are the same in both...

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