List last modified files using FTP Command-linehttp://www.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't have a clue. Here's what I've...

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

Deserialization and cannot checkout files in TFShttp://www.joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those obvious ones for those that know how but for those who can't...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

MS Excel - Open CSV with Long Numbershttp://www.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 1.4571E+18 1.4571E+18 Stanley 1709123456 1.4571E+18 1.4571E+18 David 3.31235E+11 1.4571E+18 How? Firstly, save the CSV file as text file (*.TXT). This will stop MS Excel simply opening the CSV as if it knew what to do with it. It doesn't. Saving the...

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

File Transfer Protocolhttp://www.joellipman.com/articles/web-development/ftp.html

• Type: Category
• Language: *

Zoho Deluge: Nested Catch Statementshttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 for my Cx is that they need documents converted from HTML to PDF — as in we send it a bit of code in HTML and we want a PDF file returned. I have severaly instances of an API which accepts HTML and returns a PDF file. Nothing complex but issues with one...

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

GDPR Privacy Policyhttp://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 and managerial procedures to safeguard and secure the information we collect online. How we use cookies A cookie is a small file which asks permission to be placed on your computer's hard drive. Once you agree, the file is added and the cookie helps...

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

Privacy Policyhttp://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 and managerial procedures to safeguard and secure the information we collect online. How we use cookies A cookie is a small file which asks permission to be placed on your computer's hard drive. Once you agree, the file is added and the cookie helps...

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

How to redirect the visitor after the contact pagehttp://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 but make sure you leave the redirect page published. Step Three: To finish and make it all work requires editing of a single file in the Joomla installation. If you update or reinstall Joomla you will possibly lose this modification and have to apply it...

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

Keyboard and mouse shortcuts in Google Chromehttp://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Opens a new window. Ctrl+T Opens a new tab. Ctrl+Shift+N Opens a new window in incognito mode. Press Ctrl+O, then select file. Opens a file from your computer in Google Chrome. Press Ctrl and click a link. Or click a link with your middle mouse button...

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

Running Internet Explorer 6, 7, 8 as standaloneshttp://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 just in case to my own site available for non-registered members at http://www.joellipman.com/features/downloads.html?func=fileinfo&id=12. Install IE7 from Microsoft's website. Reboot if necessary Navigate to http://browsers.evolt.org Scroll down to...

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

Joes Network Transmission Detector (JTD)http://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 Download Available for download for FREE as OpenSource. Portable so no installation/setup (can run off USB). Source files included for you to check. No signups, etc required, have fun! What's it detecting? Currently it just reads the size of packets...

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

Migrate Joomla Users to WordPresshttp://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 IS DEPRECATED IN WORDPRESS 3.X a.name AS 'display_name' FROM my_joomla_db.jos_users a ORDER BY a.id; A bit more to do: PHP file So I needed to do a loop and rather than complicate things with stored procedures and cursors, it's likely if you're using...

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

Connect to Joomla database in standalone scripthttp://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, database, etc.). For obvious reasons, these cannot be...

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

Adding a selectable background to a Yootheme templatehttp://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 using the Joomla Admin Panel. How? For demo purposes, I'm going to add the background "Ambient Turquoise". Yootheme uses CSS files to do this so we'll need to modify the XML file and add some files that this will select. Modify \templates\\config.xml...

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

Access MySQL databases using Oracle SQL Developerhttp://www.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 connector from http://www.mysql.com/products/connector/ [Optional Step] Uncompress the download, then copy or move the JAR file (at time of print: mysql-connector-java-5.1.22-bin.jar) to the folder of your SQL Developer program Open SQL Developer, go...

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

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

05 February 2013 Data Export in the left hand panel: In the screen that appears, select your database, specify to export to a Self-Contained File and click on Start Export: Importing Before importing a SQL file, check that nothing in it instructs it to use a specific...

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

AwStats Data Parser (ADP)http://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 This gives data as to your unique visitors (referred to as visitors), the visits these generated (visits), the number of files/scripts/images requested (hits) and their filesize (bandwidth). Purpose: To extract all data into a Comma Seperated Values...

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

Change the default Joomla Error templatehttp://www.joellipman.com/articles/cms/joomla/change-the-default-joomla-error-template.html

04 April 2013 error page, for a demo visit http://www.joellipman.com/my_error_page. Applies to Joomla 1.6.x, 1.7.x, 2.5.x How? Backup the file \templates\system\error.php Create a replacement file called error.php including the below code Change the message "The Page...

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

Reorder Columns in a Tablehttp://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 VARCHAR(13) NOT NULL DEFAULT 'DefaultString' COMMENT 'A Comment' AFTER other_column; Alternatively Export the file as a SQL file (data & structure), Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE IF NOT...

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

htaccess Rewrites SEF URL and submits to PHPhttp://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 I type: http://www.mywebsite.com/blog/videos.html Sends this to server: http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos How? Options -Indexes +FollowSymlinks RewriteEngine On RewriteBase / RewriteCond %{REQUEST_URI} !index.php...

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