Importing Excel CSV files into PhpMyAdmin

Posted by & filed under Uncategorized.

So sadly, Excel doesn’t enclose its CSV fields with double-quotes (“) which phpMyadmin needs. This workaround I found on the Microsoft support site: Open the original CSV file in Excel Run the macro listed above (repeated here) to save out the file: Sub QuoteCommaExport() ‘ Dimension all variables. Dim DestFile As String Dim FileNum As… Read more »

How to install yum on Plesk 8 / Centos 5

Posted by & filed under Uncategorized.

My new VPS is running Plesk 8.x which looks awesome (I think it uses ExtJS for the UI), but oddly has a fairly steep learning curve to do simple things. Inexplicably, it starts you out without yum (perhaps to encourage you to use their package manager)? Their package manager couldn’t seem to resolve the dependencies… Read more »

Recursively deleting files matching wildcards

Posted by & filed under Uncategorized.

I find this useful for “un-versioning” a Subversioned directory structure. Works via Cygwin, not sure if there’s a pure Windows equivalent: $ rm -rvf `find . -name ‘.svn*’` Credit goes to one of the replies on this forum.

Integrating CakePHP and Joomla

Posted by & filed under Uncategorized.

For a website rewrite I am working on I am using Joomla 1.5 with CakePHP 1.2, using the Jake beta bridge (which so far is working great!). I want to have: SEO-friendly URLs for Joomla, hence I am running Apache, which I found far easier to configure than IIS. Hence Joomla runs in the webroot…. Read more »

Gotchas when first installing IIS on Vista

Posted by & filed under Uncategorized.

Today I enabled IIS on my Vista box for the first time in order to run an existing ASP site. Here are my gotchas: ASP handlers are not enabled by default I went to Control Panel->Programs and Features->Turn Windows features on or off, and then checked the box for IIS without thinking about it. However,… Read more »