YouTube feeds and e107

A while ago I posted about working on integrating feeds into e107, beginning with the Amazon API. I have yet to progress my work with Amazon web services, however I have been experimenting with adding new feeds into my e107 affiliate plugin. Youtube has always provided an API to allow development against their content but in the post Google phase this has really taken off.

The ultimate goal will be to add YouTube driven uploads and content directly into wistop.com. But for now I have created a small shortcode to simply display and play the video!




The shortcode accepts a single parameter - the video code that we all know and love. It then passes this code over to the affiliate plugin which goes away, gets the details, and then maps this to the template.

e107 YouTube BBCode:



Scriptaculous

The other exciting part of this excerise is the opportunity to experiment with scriptaculous. This is a handy set of functions that very very easily enables web developers to add flashy ajax style effects to their website. The chaps over at the e107 free source site have already integrated the scripts into their plugins. Initially with their lightbox plugin and a more robust solution was introduced with their widgets plugin. In due course I will be upgrading this site to make use of this.

Now you see it, now you don't!

Replacing the thumbnail with the full video became very easy thanks to the appear function.




The advantage of this over the e107 expandit() function is that it allows full control over which elements you wish to show and which you wish to hide. So one click hides the thumbnail and shows the video.

Web 2.0 Ajax and e107

Having seen how easy it is to use the functions of scriptaculous I am now starting to think about all the different uses for it around the wistop.com site or e107 plugins. It is also exciting to know that close integration with these scripts is on the e107 roadmap thus ensuring full support in the long awaited e107 0.8 release.

Rest assured, any cool new ideas, hints and tips will be documented in our blog.

A few updates have been pushed out to the live site to improve stability. A couple of layout bugs have been vanquished with some quick CSS hacking, although the blog posts now need a little spacing out! I have also rolled out the new version of e107 tagcloud. The latest batch of improvements mean that I no longer need any custom code to have tags working on this site the way I want them which is good news! I just need to fix my Google Chrome rendering issues and then I can move on to some functional updates and more importantly, some content creation!

With some excitement I have had the opportunity to add a new item to the
top browser list! Welcome to Chrome! News of the biggest shake up of the browser wars for some time started mounting over the last couple of days with rumours of Google's activity stirring. Things then moved quickly with an official announcement followed by the Beta release of Chrome yesterday evening here in UK!

I have now installed it and am typing in a Chrome window as we speak! Initial reaction to the look and feel is positive and I'm looking forward to exploring all the new features. The wistop Chrome entry will be updated in due course with the features that might persuade you to switch browser!

Welcome to ProBlogger readers!

This post coincided with a challenge on the problogger.net website. For those that don't know, this is blog dedicated to making the most (ie cold hard cash!) from blogging. ProBlogger has asked readers to participate in the Killer Titles - Group Writing Project which invites us to come up with a title for our posts that are perhaps more engaging than average!

For those of you looking to learn more about Amazon Associate Web Services - enjoy part one of a series on how to make use of this and other APIs from leading merchants.

The rest of you might like to:

• learn more about wistop
  
• Read our website related top lists.
  

If you like what you see, please

• subscribe to our feed,
  
• sign up to the site!
  

I've already enjoyed reading through some of the other entries, and look forward to posting my favourites here once the competition closes!

Amazon Associates

The Amazon Associates scheme is the affiliate program set up by everyone's favourite e-tailer - Amazon.com. The premise is simple. You refer your readers over to Amazon, if they buy the product you link to you get 4% or more of the purchase price. You also get a percentage of everything else they buy with a few reasonable caveats and rules. The purchase can take place within 24hrs of you referring them, it also counts if they save the item for future purchase.

And as any customers of the store (all of us I'm sure!) know, Amazon is great at cross selling. You come in for a CD and leave with a new DVD collection, Christmas presents, and possibly a new kitchen sink. And the affiliate gets a percentage of all of that! Sounds good!



Amazon Associates Web Services

The above product cloud is an example of one of the many widgets (carousels, banners, links, recommendations, etc) that Amazon offer to its associates. And in time I will look closer at these and see how they might fit into your site. But my current topic of interest is the Associate Web Services. This is mature system for querying Amazon's comprehensive database and bringing their data to your site. Almost every aspect of their core product data has been exposed and can be readily queried and utilised in your own projects.

This can include:

• Running Product Searches
  
• Navigating the Amazon product tree
  
• Finding Amazon user's lists
  
• Querying user reviews
  
• Detailed product information
  

It's all there waiting for anyone to exploit and with over 4% in commission waiting it seems like a reasonable proposition to me.

Integrating Web Services and Wistop

As a database professional it was always important for me to come up with a generic way to add and exploit any product feed. I was keen to ensure that I didn't limit my solution to Amazon's services only. This requires controlling all of the feed requests and interpretation of the results through feed meta data in such a way that loading a new feed simply becomes a case of dropping in a new URL.

This actually proved quite straight forward with the e107 CMS thanks to its templating system that allows the inclusion of "shortcodes" or placeholders within text that are replaced with dynamic content. With this concept I was able to create a call to the Amazon API with a placeholder for each of the standard parameters used in requests. At some point I will make this code publicly available for other e107 users. My plugin allows for the creation of feeds, mapping any parameters and mapping the results to output templates all through the admin back-end user interface.

Turning feed output into web pages

The hard part was interpreting the results. Of course no two services provide output in the same way and this is rather tricky to manage! However, after much Googling the answer finally presented itself in the form of a handy little script: Magic Parser! The nightmare of trying to navigate xml affiliate feeds instantly disappeared! Worth every penny in my opinion!

When you call Magic Parser into action it allows you to pass in a format string that helps you pick out exactly the feed information you are looking for. This format string can then be stored as an attribute of your feed object. And there you have it, any feed, any format, into any content in the CMS.

Other projects

To demonstrate the ease in which a well designed CMS and good dynamic code can handle feeds quickly with no fuss I have set up a site that shows how easy it can be. Product feeds are dynamically generated, affiliate links are managed and redirected, no maintenance required at all. All of the data that drives the site is collected via web services.

*Note: My host has failed to set up the DNS settings correctly - so the site is offline. Watch this space*

Whats next in this series?

There is so much to cover in this area and it can become quickly overwhelming. However any interested readers will be keen to learn more detail on the above so stay tuned for more in depth discussions!

Future topics:

• Running queries against the Amazon API
  
• Integrating product feeds with e107
  
• Interpreting results
  
• Tips and tricks buried in the technical documentation
  
• much more!
  

The Premier League

There is no doubt that the Premiership is the richest and most popular football league of all time. The success has enabled the top football teams to attract World Class football stars such as Christiano Ronaldo, Cesc Fabregas and Fernando Torres which in turn have helped build an international following of . Thanks to some insane television deals in the early 90's the UK's top sporting league has really taken off over the last two decades. Recent domination of the Champions League has really put the current crop of English football teams into a class of their own!


Some Google Insight into the most searched football team

My new favourite Internet toy is Google Insight! If you haven't had a play already I suggest pulling it up and entering some search terms. The tool will give you a wide range of analytical data giving you feedback on search volumes, geographical insight and some basic keyword analysis.

Here is the output for the big four premiership teams:

Have a play yourself at the Google Insight page!

I notice that:

• Similar search volumes for each team
  
• A wide range of worldwide searching
  
• Liverpool and Chelsea aren't just football clubs, they're places too!
  

So this data really gives us no conclusive answer as to which premiership football team is top!

You can help answer the question once and for all!

Well it seems there is only one way to determine the people's choice. Why not jump over to the wistop greatest football team list and place your vote now! It's worth noting that the wistop site will shortly be displaying graphical data charting the popularity of everything and anything that is tracked in all the lists on the site.

You will also notice that the list needs a little work. If you are passionate about your team then some help would be appreciated:

• Sign up and vote for your favourite footy team!
  
• Help improve the list! If you think you can write a few hundred words explaining why your team should get the wistop readers vote, the please get in touch!
  
• You can include links back to your own relevant football site if that helps motivate you!
  

Thanks for your support!