SSIS Skip Rows in Excel Source filehttp://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 Sheet1$B11:AL Selects all data from column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first column of the data range and NOT the...

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

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

23 April 2013 column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to...

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

Improve Default Joomla Search http://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 your Joomla search results by giving priority to articles where the search term is in the article title. In the stages thereafter, I'm going to simply enhance the relevance factor: Soundex: Built-in function to list matches that sound like the search...

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

T-SQL concatenate an incremental row numberhttp://www.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 001 00101 001 00102 002 00203 -- Wrong! This should start from 1 for another employee. 002 00204 003 00305 Almost There! So we're using the ROW_NUMBER() functionality with an ORDER BY which seems to work somewhat. But using the code above still produces...

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

Problem creating SSRS report subscriptionshttp://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 is straightforward but in our case, we have a report which points to different servers based on a report parameter. How? There are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we...

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

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

15 November 2013 the investigative work to get the service up and running again. Having a small chain-of-command and quick development cycle, there are advantages to working on my own: I can keep costs low, I have scripts which have sped up development on similar...

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

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

24 November 2013 comes with Joomla 2.5 install. How? Source: Joomla! • View topic - Cannot get recaptcha to display on registration form... There are two solutions I have found that fix the problem: Method #1 I prefer this method as it changes less code and is more...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://www.joellipman.com/articles/apple/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: *

Registered Users Cannot Login - Super Users Canhttp://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 a parent_id equal to zero: SELECT COUNT(*) FROM #__assets WHERE parent_id=0 -- where #_ is the Database Tables Prefix value There can be only one: If the number returned is 1 then this article is not addressing your issue. This is a red herring. If the...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5http://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed it but the below details how to...

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

SSRS Stop Scrolling Behindhttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 header on top of the scrolling content 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...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2http://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed it but the below details how to...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttp://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 but I found this on the MySQL Forums. Someone solved their issue by resetting (or re-issuing) their password which implies there was an issue with pre 4.1.1 passwords and the hashing algorithm: SET session old_passwords = 0; SET PASSWORD for 'youruser'...

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

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

20 October 2014 cancel got clicked } }) .show(); Additional: Pre-populating default value and returning input Lots of confusing answers out there on the web but here's an all-in-one where I Open an AlertDialog designed with a custom XML layout Set the hint text of a...

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

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

28 March 2015 content in /public_html/.../.../my_script.php 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...

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

Joes Google Map for Joomla (JGM)http://www.joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there's loads out there but thought making my own to do exactly what I want was quicker. Script Function This displays a google...

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

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

12 September 2015 the Joomla admin interface and then -- updating the database with the correct IDs is easier than the script. -- Use this if there aren't many to do. In this example, I am applying -- this to the "uncategorized" category. --...

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

Sort an associative array by values in Javascripthttp://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

Accessing Apimo WebService APIhttp://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 get the configuration right. After several days... I tried the example as per the Apimo documentation and it worked! There were a few adjustments to make which I'm documenting here. Basic Example Here's a complete PHP script of a basic example of...

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

Display Feeds to major Social Networkshttp://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so...

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