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… Continue reading Importing Excel CSV files into PhpMyAdmin
Month: March 2009
How to install yum on Plesk 8 / Centos 5
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… Continue reading How to install yum on Plesk 8 / Centos 5
Recursively deleting files matching wildcards
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
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.… Continue reading Integrating CakePHP and Joomla
Gotchas when first installing IIS on Vista
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,… Continue reading Gotchas when first installing IIS on Vista