comments

Only one to start with, but I’ll add to this when I can

Solution for Invalid object name 'umbracoDomains' after copying an Umbraco website.

Execute this script to change the schema for each table:

exec sp_MSforeachtable 'ALTER SCHEMA dbo TRANSFER ?'

comments

This is not intended to repeat article already in abundance on the web, just a few bullet points to keep and add to at some point

Technorati Tags: ,
point.
  • Make sure site is submitted to google webmaster tools
  • Check you site is indexed & check you have good title tags and descriptions in search results e.g. https://www.google.com/search?as_sitesearch=yourdomain.com
  • Include many keywords people would use to search, including mis-spellings, in urls, titles, headings, alt text, link text and in body content
  • If it relates to a location, add it to Google Places?
  • Is there sufficient content, and well written to have around 5% keyword density
  • Do you have enough content pages
  • Are you making use of Google Authorship
  • Are there social accounts that link back to the site? Facebook, Twitter etc
  • Are pages well structured with semantic markup, good use of alt text and url names
  • New sites take time (sometimes months) to get ranked, so you need to keep creating content, building links, and monitoring progress
  • Be aware and use as many of the seo success factors as you can - see http://searchengineland.com/guide/seo
  • Include links from your own website, and help the client build others.
  • Backlinks can be checked from a number of sites, for example http://ahrefs.com

comments

Often I see lots of little issues where designers make life difficult for developers without realising it, and in doing so, make life more difficult for themselves, and also compromise the implementation of their designs and cause delays, so I decided I would start to document these with an aim of making things easier for everyone.

1. Mix things up a bit in your designs

Often I see designs where the designer has just repeated a line of dummy text and haven't varied it at all. There are 2 places where this can cause problems later unless the front end developer spots this and allows for it anyway. The 2 places where this can be an issue is in navigation (vertical column navigation) and where numbers or amounts are involved (think prices). Here are examples of these that I came across recently:
 

menu

In this case, the automatic thing for the developer to do is to set the line height of the text to be the distance between the lines as shown by the green arrows. However, as soon as the client puts in the correct text, you’ll find they enter a long menu item that goes on to 2 lines and the space between those lines will be massive, so the dev has to go back to the designer to get them to specify the correct line height. They then need t apply that, and then add padding to the list items to space them out as they originally appeared.

price tableIn the case of prices, the designer here hasn’t allowed for what happens when the client add a price that is greater than £100. If the dev isn’t paying attention, they will just add a space between the total and the amount, but as everyone knows, the numbers should align on the right.

 

To be continued…

comments

Recently I worked on a project where we had to give the client the ability to display a location on a Google Map. In order to store the location, we gave them a field to enter the lat,long comma separated with a piece of code which used the postcode to lookup the location on save and then populate this field. If the client wanted the tweak the position, they would have to go to Google Maps, lookup the location, change the resulting pin, then copy and paste the actual coordinates into the CMS.

Unfortunately, the implementation didn’t check if there was already information there, so if the item was re-saved, even if no change was made to the address, the routine would re lookup the location and overwrite the location manually set by the client. A developer fixed this by having the save event check the location was empty before performing the lookup and saving the result.

Why didn’t they just use an existing data field to perform this?

There’s a perfectly good data type field for this that allows the user to open a popup, enter a search, move the pin and select to use that location. What’s more, it shows a map with the pin in place right in the CMS instead of just a lat,long coordinate.

Before writing something, please spend half an hour researching to see if someone has already implemented something similar (or in this case better!) before you waste hours and hours writing something yourself

</rant>