MS Excel: Adding quotes round text for .csv export

Just a quick one this.  When exporting columns of text for .csv files you will probably want to have the text blocks encased in double quotes.  To do this in excel, before saving as .csv, simply

  1. highlight the cells you want to quote-up
  2. right-click on them and choose “format cells”
  3. choose custom from the “Category” list (under the number tab)
  4. in the “Type” box type the following:   \”@\”
  5. hit ok

The backslash is the escape character used to say “use the symbol that comes next” and the @ can be considered to be the wildcard or placeholder for the current contents.

Saves having to use your code/text editor to add in all the quotes.

Facebook Comments

Magento – Making add to cart urls use https when site is secure

So you have got your site all nicely working with your ssl certificate ready for your site to run fully in https:// to appease Google but your padlock never stays green.  For my setup I traced this down to the various form submission URLs such as “add to cart”. Here is how I finally solved it.

Continue reading Magento – Making add to cart urls use https when site is secure

Facebook Comments

Magento admin on localhost gives ERROR_CONNECTION_RESET message (winamp)

This was a curious and frustrating problem to fix.  After updating the local dev copy of a a magento site, and changing a few local folder permissions the admin area stopped working, giving instead an error message of:  ERROR_CONNECTION_RESET.

Continue reading Magento admin on localhost gives ERROR_CONNECTION_RESET message (winamp)

Facebook Comments

Archive An Entire Web Folder Using Tar Via SSH

Before performing any major operations on a site it is great to have the reassurance that you have a complete back up. ALWAYS do this when taking over a new project and, even though you may have your files in a .git or svn system it can be a real livesaver to just turn time back a few minutes if your major update goes pear shaped. One of my colleagues refers to this as the “get out of jail free card”. You can also use this to take a copy of the entire site when you want to move it – to a development server for example.

Continue reading Archive An Entire Web Folder Using Tar Via SSH

Facebook Comments

Match Element Heights Using JQuery

So, you are building a design with dynamic content and the designer or client says, “but those blocks should be the same height”, and you say “but the content changes, we don’t know how tall it can be and anyway, the height needs to be different depending on what device you are using”, etc., etc.

Here is a little jQuery function you can call to set the  height of matching elements

Continue reading Match Element Heights Using JQuery

Facebook Comments