Older blog entries for Killerbees (starting at number 224)

19 Aug 2011 (updated 20 Aug 2011 at 13:03 UTC) »

Dipping a toe in FCommerce

FStore Homepage
 Today AllSaints launch our Facebook store (US store follows next week), click the link to browse, view products and buy them directly from within Facebook.

We spent a lot of time looking at other peoples' facebook stores, and rather than try to cram everything in we decided that ours should not be only a replacement for our web store, instead we thought that as we have too much in our catalogue browsing it in facebook would be too cramped an experience. Rather it is intended to promote our web store to our facebook fans, and allow us to do more to monetize our investment in facebook.

FStore category view
We wanted it to blend in well with facebook, and to be a familiar environment for facebook users, not look just like our web store in an iframe. As we see with ASOS and JC Penney. I'm sure that works for those guys, but we wanted to take a more joined up approach to "fcommerce" and to augment and enhance our customers choices and their experience of our brand.

So we have created a place where we can showcase a selection of products, in a specially selected range of categories. Our visual merchandisers have full control of the catalogue, using the same systems that they use to merchandise our other online channels, and I hope that in the coming weeks we will see the facebook store take on a character of its own, seperate from, but complimentary to, our main web site.
FStore product detail

FStore embedded "cart"
And now our fans can buy things that we promote on facebook without having to find them again on our website.

Good Job Team!

Syndicated 2011-08-19 10:55:00 (Updated 2011-08-20 12:05:35) from Danny Angus

7 Jun 2011 (updated 7 Jun 2011 at 13:03 UTC) »

+1 button

As an experiment (and before I let anyone go anywhere that near my employers precious website with it) I added the google +1 button to this blog today.
Unfortunately while I understand the idea of giving a bit of content an Big +1 I can't see where anyone would know that I've +1'ed anything.
If you have more of a grip of reality than I do, do let me know!

UPDATE! I found out, you need to use google.com not google.co.uk[1].. hardly had I done this and +1'ed things than +1's started showing up in my search results.. 

[1] I had to go to my google profile, enter a search term in the search box, then click "reset search tools" and I was on google.com instead of .co.uk

Syndicated 2011-06-07 11:54:00 (Updated 2011-06-07 12:40:52) from Danny Angus

Colleagues go mad for "cheap" TV

OMG, get-a-cheap-tv fever gripped the workplace today as my colleagues (who should've known better!) went on a fevered buying spree after woolworths appeared to be selling Sharp 37" & 42" LCD TV's for £150.
Sadly no-such-luck boys and girls, woolies T's & C's retain the right not only to cancel your order but also to ... ".. continue with the order at the correct price" which might embarrass those who chose to order several of the two grand machines!
There were reports of orders being cancelled, however the on-line price was still £150 as this post "went to press", so if anyone else fancies a go...
Pictured (left) are Colin (Products Development Manager), Kevin (Lead Technical Consultant) and Stuart (Technical Services Manager) at the height of the madness.

Syndicated 2011-05-03 15:49:00 (Updated 2011-05-03 15:49:11) from Danny Angus

27 Jan 2011 (updated 4 Nov 2011 at 11:04 UTC) »

note to self, MySQL query profiler

Update The original article mentioned in this post is no longer available, but if you are still interested in query profiling in MySQL, check out this http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html
I will write up an quick start guide to profiling myself here, one day.
-- original post
this article is a great way to get started using the mysql query profiler.

If you've never used it before take some time to check it out, it will change the way you think about the database forever.

Syndicated 2011-01-27 12:35:00 (Updated 2011-11-04 10:54:00) from Danny Angus

Note to self, how to get the top tens from MySQL slow query log

Use these two commands to get the top ten and top ten repeaters from MySQL's slow query log.

mysqldumpslow -t 10 ./slow-log > /home/danny/top_ten_slow_query.txt

mysqldumpslow -a -s c -t 10 ./slow-log > /home/danny/top_ten_repeat_slow_query.txt

Syndicated 2011-01-19 17:47:00 (Updated 2011-01-19 17:47:38) from Danny Angus

18 Jan 2011 (updated 18 Jan 2011 at 13:10 UTC) »

Quote of the [specify period]

This [period]'s quote is from Nicola Morrison, ScottishPower online manager quoted on computerweekly.com, here, in a piece which quite frankly looks like marketing blurb placed by a PR agent on a day when the editor was hungover.

Anyway, Nicola have an award for improving customer service not by answering customers questions but by analysing them!

Working with [tech co][1] has ... given us an unparalleled insight into our customers' requirements through the ability to analyse the questions they are asking.

[1] I'm not going to repeat the name of the company involved, I don't want to draw attention to them!

Syndicated 2011-01-18 12:19:00 (Updated 2011-01-18 12:20:37) from Danny Angus

Note to self, how to delete files older than

Yes, yet another one that I always have to look up, I think it must be my age!

find /path/to/files* -mtime +5 -exec rm {} \;

Syndicated 2011-01-13 09:32:00 (Updated 2011-01-13 09:32:47) from Danny Angus

misprint of the [specify timeperiod]

How apt:

employment rose causing misery for many.
From this, also worth a read.
Have an award.

Syndicated 2010-11-03 14:03:00 (Updated 2010-11-03 14:03:05) from Danny Angus

Note to self, how to get row numbers in a MySQL SELECT

I've often wondered, idly, how to get MySQL to output a row number column, which would rank sorted and grouped results.
Well thanks to this excellent post I've found out how:

SELECT *, @rownum:=@rownum+1 as rank FROM ( 
-- Your Query Goes in Here
        SELECT t.*
        FROM table t
        WHERE something
        group by 2,3,4
        order by 1 desc limit 20
    ) day_rank, (SELECT @rownum:=0) r;

Syndicated 2010-10-20 08:15:00 (Updated 2010-10-20 08:15:56) from Danny Angus

215 older entries...

New Advogato Features

New HTML Parser: The long-awaited libxml2 based HTML parser code is live. It needs further work but already handles most markup better than the original parser.

Keep up with the latest Advogato features by reading the Advogato status blog.

If you're a C programmer with some spare time, take a look at the mod_virgule project page and help us with one of the tasks on the ToDo list!