I’ve been looking for a way to import a csv into pages on WordPress. So far all I’ve found is plugins to import csv’s into posts. In the past I’ve ran mySQL inserts created from spreadsheets, which do work but are time consuming to create.

I’ve found one import scrip which with a simple change will upload csv files into pages. You can download the plugin (well it’t not technically a plug in but an import script which goes in /wp-admin/import) from Zack Preble’s blog.

All you need to do is change line 292 from

= "post";

To

= "page";

That sets the new entry as a page rather than a post. Get your csv ready and upload. This is great for building new sites or transferring sites in to WordPress as you can get the client to prepare all the data in excel first. The other useful tip is for affiliates …… product feeds……

It seems more and more tv commercials are now using the “Search for……” rather than giving out websites address. The latest is the 3D movie from Dreamwork’s Monsters Vs Aliens, I went to see the movie yesterday and have to say it was really good, especially with the 3D glasses.

Anyway, the TV advert this afternoon promoting the movie this afternoon ask the viewer to search for “MVA” which is quite precise. It’s working according to the stats from Google insight with a recent surge in traffic.

picture-42

Amazingly this is the SERP you see searching for MVA.

picture-32

So you get one PPC advert about the Monsters Vs Alien’s movie and the top organic spot is taken by www.mvaconsultancy.com. Nothing in the top ten is related to the movie. This type of campaign must be costing a fair amount of money for Dreamworks and maybe bringing a fair amount of traffic to www.mvaconsultancy.com.

Posted in SEO.

There seems to be a little page rank update going on this weekend. As we know Page Rank doesn’t directly relate to how much traffic a site receives, sales or success but many people are hung up on what the little Green Bar says.

The last update was on News Year Eve, if you’ve gone down in Page Rank this time you’ve either lost links, links have changed to nofollow, or the sites that link to you have lost links thus not passing on the page rank they once did.

Another reason for a drop in score is Google shifting the boundaries, Google will shift the page rank boundaries up to make sure we all don’t end up with page ranks of 10.

I’ve added a plugin today to reward commentators on the blog. After five comments the nofollow link is removed from the link back to their site. Many sites have adopted this policy as it also means you can select which commentators to keep the nofollow on their links in the admin section of wordpress, thus giving your editorial control over the use of nofollow.

The plug in i’ve used called Lucia‚Äôs Linky Love.

Loving Spotify still but no new doves album but the new Yeah Yeah Yeah’s album is on there. A great site has been launched in the past few months by Kieron Donoghue called www.sharemyplaylists.com.

share my playlists spotify

The site works like many other of the Spotify playlists sites, you see a play list you like, click the link and hey preston the playlist is loaded up into Spotify. What makes this site slightly different, apart from the nice layout is the rating, comments and most importantly the quality of the playlists, plenty of decent indie and britpop stuff!

Head over to www.sharemyplaylists.com remember you’ll need to download spotify and have a good taste in music!

Following the release of Google Street View in the UK I’ve been roaming around Manchester the City I live in. At the moment street view hasn’t been released in South Manchester where I live but the city center down to Fallowfield is mapped and here my top drinking venues in the mapped area.

1. Jabez Clegg

jabez-clegg

2. Sinclairs

sinclairs

3. Trof Fallowfield

trof-fallowfield

4. tv21s

tv21s

5. The Old Monkey

the-old-monkey

I’ve pointed out a few sites in the past that have working black hat technique another one cropped up the other day, I mentioned it on twitter.

Showforce.com are a company that provide staff for events, promotions etc, I’m sure they are a great company but it seems that the SEO company they are using are not too great (well they are ranking in Google…). In this case plenty of key phrases have been hidden in a h1 tag at the bottom of Showforce’s homepage.

showforce-hidden-text

So how is this text hidden? Well the text is placed in a H1 inside a div called “SEO”, the style is set to hidden.

Does this work? Well yes, the text is hidden and the Showforce site ranks number one at for “event staff”.

event-staff

Will it work for longer? We’ll have to see. It seems that Google need to fix up and look sharp on their spam detection.

YouTube have recently had to remove many music videos due to a issue regarding payments with Performing Rights Society. The result is that some videos have now been removed for UK viewers.

For example this video from Adele – Chasing Payment is now removed.

youtube-removed

Interestingly this page is still hanging on in a Google Search for a search for “adele – chasing payments

adele-chasing-payments1

That page returns a 303 response, which is is similar to a 302 (more details here) in that the page as moved elsewhere but the difference its not permanent or a temporary change, it just does say.

This means the page will remain in the search engine rankings which is happening, the page was cached on the 16th.

This is a great move by YouTube as they are holding onto the positions in the search engine rankings and keeping levels of traffic until a deal with the Performing Rights Society is sorted out. Once the deal is sorted out the page will return a normal 200 ok like other YouTube video pages.

I’m not sure if the 303 response is the correct status to give to the search engine? Anyone know?

I think the Google street view car may be following me, after the spotting the other day I passed the van today on the A34 coming into Manchester from Cheshire.

I can’t wait now for the pictures to be released, looking forward to looking all the old houses I’ve lived in. Football grounds, city centers and most importantly the prom at Blackpool where I’m from. I wonder if the Google car when through at night when the the illumination were on?

picture-4