K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 your website, and all your K2 articles are gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should get the following error: Warning: Invalid argument supplied for foreach() in...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 used this script continuously to migrate J1.5.x websites to J2.5.x without issue. I have managed to do whole migrations in under 2 hours (this script runs in about 20 seconds based on 1000 articles and 5000 users) and my clients are satisfied! I am so...

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

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 displayed fine. The left and right columns finally got them side by side. But the footer that has a background image was under the left and right columns... The main content layer was overlapping the footer. I tried various z-index's bearing in mind...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const SHGDN_NORMALConst = 0 ;// Default (display purpose) Const SHGDN_INFOLDERConst = 1 ;// displayed under a folder (relative) Const SHGDN_INCLUDE_NONFILESYS = $2000 ;// If Not set display names For shell name space items that are Not in the file...

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

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 was already configured to read off the sharepoint list, and it had re-ordered to what I set in the view!!! I don't really understand how it works only that it does. I think this could get complicated if you had two dropdowns reading off the same list...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 green if successful, red if failed. License Details: This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License,...

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

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

18 July 2012 with the action name (eg. "Prefix_with_line_numbers") Right-click on this new key and add a key to this one called "command" Under the "command" key, double-click the "(Default)" string in the right-pane and type the following...

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

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 Create a new key with the action name (eg. "Print Directory Contents To File" - replace spaces with underscores if you are unsure this will work) Add a key to this one called "command" Under the "command" key, there should be a new string value called...

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

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

11 October 2012 Average - Run against a database of circa 30'000 students and their details (incl. courses ~ 700'000 records) took just under 2 minutes (found over 7 million occurrences similar to "DNYA").

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal...

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

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 maximized the Google Chrome browser, the row would split and there would be 2 boxes on the top row and the third would pop under these. As for MSIE, that was ok when maximized. How? You could do loads of code hacks which is what I tested but all for...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• 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 Fix Right-click on "My Computer" > select "Properties" Click on "Advanced System Settings" Click on "Environment Variables" Under "System Variables" modify the variable "ORACLE_HOME" (without the quotes). Or create NEW if it doesn't exist. Give it the...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 Check: The problems here relate to when our datasource was a flat file connection. We had to change the Format under General to Ragged Right (I had been setting it to "fixed width" but then got problems with it not understanding the last two characters...

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

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 list of all countries, regions and their respective IP ranges. ip_lookup.php: to use the database License.txt: Released under GNU/GPL ReadMe.txt What is it? I wanted my own IP lookup script to tell me the country that is allocated a given IP address,...

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

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

04 April 2013 "AL"): In the data flow, click on the Excel datasource component so that it's selected. View the Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the datasource (eg....

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 Panel Navigate to Global Configuration > Site > Site Settings > Feed Email = Site Email (check this is “Site Email”) Then go under Global Configuration > Server > Mail Settings > From email (has to be the exact sender email address (check...

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

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

03 November 2013 In iTunes, right-click on the old phone and select "Transfer Purchases". (you will need to know your Apple ID password) Under the "Summary" tab, in the "Backups" section, click on "This computer" and tick the "Encrypt iPhone backup" (note the password...

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

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

07 July 2014 -- 1 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 Last Step: Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you refresh the data, it will retain the carriage...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 this app. {youtube}fQD0xVEYDks{/youtube} Location: For location, type a city name, post code, zip code or any value that is understood by the api.openweathermap.org website. There are plans to shift this to using Google Services as they are more likely...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 Click on Change settings or Advanced system settings Select the Advanced tab Click on the Environment Variables... button Under "System variables" find the PATH variable and add the JDK bin folder you noted earlier: Click on OK and close the respective...

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