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 »
Monthly Archives:: March 2009
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 »
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.
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 »
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 »