Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/else/app-dev/android-os/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 A quick article on how to remove the first two entries from a RSS feed produced by a bunch of java files collectively known as "SimpleRssReader. Why? The original file reads of a feed from PCWorld.com. I adapted this to read a google news rss feed and...

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

SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

14 March 2013 || (LTRIM(ContributionValue) == "") ? "0.0000" : TRIM(REPLACE(ContributionValue,",","")) My Most Frequent Fix: The data files I have to work with are rarely consistent. On some rows the date column will have a string of 8 characters long in the format...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

11 February 2011 it will retain the previously deployed report settings (header&footer). Resolved this by clearing my web-browser's temporary files. Do we instruct all users viewing the reports to do this? When does this report automatically expire? Reminder on Paper...

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

SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

19 September 2011 Some sources are specific saying that the account will need to be able to logon to the external server holding the files. MSDN Quote: When the report is previewed in Report Designer, preview uses the credentials of the user to display the image. When...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

13 April 2010 shockproof 32Gb USB Pretec Pen (as advertised by Gadget Show on Five.tv). Turns out this is an incredibly fragile pen. If files are being written to it and it gets nudged, this will corrupt the pen. BTW I don't use the "remove device safely" rubbish as...

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

Run commands for Windowshttps://www.joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

05 July 2011 control color Dr. Watson System Troubleshooting Utility drwtsn32 Driver Verifier Utility verifier Event Viewer eventvwr.msc Files and Settings Transfer Tool migwiz File Signature Verification Tool sigverif Findfast findfast.cpl Firefox (if installed)...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

25 February 2013 Add arguments in format /c start "Task Name" "Full Path of Program", for example: /c start "VisualStudio2010" "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" for Start In..., I leave this blank but you could specify a working...

• 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 type international characters from other alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 hack into their servers because of the number of queries Joomla does and the number of times I refresh the page and upload files. Why they think that developers should not be able to send a 1000 queries a minute or why a developer has to refresh the...

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

List of Font Awesomehttps://www.joellipman.com/articles/cms/website-development/list-of-font-awesome.html

04 September 2015 set that has all the icons you would want in a modern website design. How? To use this list, you can either: Copy the font files to your template folder (my preference) and add the linked stylesheet in the head section of your webpage. I'm selective of...

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

FTP on Mac: Failed to retrieve directory listinghttps://www.joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 though I could access the folders if I browsed the existing folders by entering it in the remote directory field. Still no files or folders would show. There's a good bit of information from the source link listed below but the settings didn't solve the...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 ENT_COMPAT,'UTF-8', true), ENT_COMPAT, 'UTF-8') Other things to consider: Save all PHP files as UTF-8 and not ANSI Ensure all text fields in the database are set to a UTF-8 charset (eg. utf8_general_ci) Ensure headers are setting the charset to UTF-8...

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

Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

05 October 2015 : new XMLHttpRequest(); // open the file // use GET for faster performance but use POST (no size limits) for large files xhr.open('POST', this_file, false); // set header to CSV mimetype xhr.setRequestHeader('Content-Type', 'text/csv'); // send request...

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

Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 Extract the folder "Template Name" into this directory ^ If in the package the folder "lib" contains, extract the files in the directory \components\com_kunena\lib\

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

Docman - Uploaded a document and can't see ithttps://www.joellipman.com/articles/cms/joomla/docman-uploaded-a-document-and-cant-see-it.html

29 June 2009 As with all Joomla articles and files, you need to check that they have been published and approved. Sometimes you don't have to and it's all automatic, but if they're not showing: Check that they're in the right section and category Check that they...

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

How to make your Joomla site use SEO friendly urlshttps://www.joellipman.com/articles/cms/joomla/how-to-make-your-joomla-site-use-seo-friendly-urls.html

02 April 2010 ("htaccess.txt" to ".htaccess" in your website root folder). You'll need ftp access or a file manager with all your website files in). Do not continue if you ONLY have control of the Joomla CMS. Watch the youtube video below which shows you how to do it...

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

Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki folder and then run php update.php from maintenance folder after updating AdminSettings.php More Information...

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

SSRS Templates in BIDS 2008https://www.joellipman.com/component/content/article/ssrs-templates-in-bids-2008.html?catid=75&Itemid=165

01 April 2011 report and leave elements for all reports. File > Save selected item as... For SSRS 2008: Save in the folder: "C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject" Done!

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

SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/component/content/article/ssrs-no-delay-for-first-report-of-the-day.html?catid=75&Itemid=165

11 April 2014 to each server that requires it. Let your report server administrators do this: On the server, open the XML file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RsReportServer.config Set the recycle time to 0: 0...

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

UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/component/content/article/unc-paths-in-sharepoint-2007-links.html?catid=77&Itemid=165

08 November 2012 to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg....

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