Paper Show

By chris dalby | July 12, 2008

I took delivery of a Paper Show this morning, which I have been sent to try out. Haven’t installed it yet, but I like the idea.

Topics: Tech Watch, Video | No Comments »

City of Men

By chris dalby | July 10, 2008

I went to a screening of City of Men tonight near Googe St in London, organised by Mike Atherton and Dan Light.

I’ve never to been to a screening before, so part of me was going out of curiousity.  I hadn’t heard anything about City of Men before I saw the film tonight, which according to wikipedia:

It is often cited as a ‘spin-off‘ of the film; City of Men is a less violent and more light-hearted affair with dramedy elements (the film adaptation is darker, sharing its roots of City of God). However, the two do share some common aspects: the directors, some of the actors, and the setting of the Brazilian favela (slum) with its background of gangsters and poverty.

City of Men, or Cidade dos Homens in Portuguese, is a subtitled film and focusses on the friendship between 2 characters caught up in the daily life of living in the favela.

I love watching subtitled films.  I always try and match the words to the sounds and try and work out whether the words don’t match the spoken dialogue.  I find it also focusses my attention more on the film too.  It takes more thought to watch a subtitled film.

I enjoyed watching City of Men.  I thought the camerwork and imagery was stunning, the characters convincing and the scenario mind boggling.

It was also great to see the bloggers that went along.  Here’s a few of them in a video I shot just before we went in.

Thanks for inviting me along to the screening Dan and Mike, looking forward to the next one.

Topics: Culture, film | No Comments »

Create XML for Simple Viewer from SQL Server in VB.NET

By chris dalby | July 9, 2008

OK, so this is Part 2 of what has become a series.  In my previous post, I gave you code that will create the XML file from SQL server data using VB.NET needed to use in Tiltviewer, a rather cool image visualisation using flash.

So these same guys also do something called simple viewer.  Today I got around to creating the code needed to generate the XML file for it.  Why this is different to the TiltViewer XML format is beyond me.  Anyways.

Again, this is not a tutorial, I am simply sharing the code. So leave a comment if you want help, but this basically shows you the correct syntax for generating your XML file using vb.NET from SQL Server using a stored procedure.

I simply put this code into the backend file xml.aspx.vb.  Then I run the file and the XML file is generated from the SQL server database.  Oh, you’ll need to add an extra tag at the top of the xml file according to your needs.  I didn’t bother doing this, I just copied and pasted from the sample file as it seemed far easier at the time :)

Imports System.IO
Imports System.Xml
Imports System.Data.SqlClient
Imports System.Data

Partial Class visual2_XML
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim filename As String = “G:\websites\htdocs\test\XML\gallery.xml”
Dim mywriter As System.Xml.XmlTextWriter
‘declare variables
Dim strPhoto As String = “imgs/img.jpg”

‘declare the db connection stuff
‘ Create Instance of Connection and Command Object
Dim connection As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings(”ConnectionString”))
Dim command As SqlCommand = New SqlCommand(”GetProductsInCategory”, connection)
command.CommandType = CommandType.StoredProcedure
command.Parameters.AddWithValue(”@CategoryID”, “74″)

‘ extract details
connection.Open()
Dim customerReader As SqlDataReader = command.ExecuteReader()
‘declare the xml stuff
Dim writer As XmlTextWriter = Nothing

writer = New System.Xml.XmlTextWriter(filename, Nothing)
‘Use indenting for readability.
writer.Formatting = Formatting.Indented

‘Write the XML delcaration.
writer.WriteStartDocument()

‘Write a root element.
writer.WriteStartElement(”simpleviewergallery”)
While customerReader.Read

writer.WriteStartElement(”image”)

‘ Loop
‘Write the title.
writer.WriteElementString(”filename”, customerReader(”ImagePath”))
writer.WriteElementString(”caption”, customerReader(”Name”))
‘Write the close tag for the root element.
writer.WriteEndElement()
End While

‘close db
connection.Close()

writer.WriteEndDocument()

‘Write the XML to file and close the writer.
writer.Flush()
writer.Close()

‘Load the file into an XmlDocument to ensure well formed XML.
Dim doc As New XmlDocument()
‘Preserve white space for readability.
doc.PreserveWhitespace = True

Try
Label1.Text = “This seemed to work.”
Catch ex As Exception
Label1.Text = ex.Message
End Try
End Sub
End Class

Topics: Coding, Tech Watch | No Comments »

The Enterprise Social Messaging Experiment

By chris dalby | July 9, 2008

ESME, the Enterprise Social Messaging Experiment has released a sneak preview video.  Quite honestly, it looks amazing.  A twitter style messaging application for the enterprise with common sense functionality like groups and tag clouds.  I have seen quite a bit of conversation from Abesh and Dennis Howlett regarding ESME and I look forward to trying it out and seeing it in the flesh.

Looking at the blog that Dennis Howlett wrote about ESME, his observations of the development process to date and the community:

Knowing some of the people involved with the project, I can see how all of the above makes complete sense.  Looking forward to seeing this out in the wild.  In the mean time, check out the video here.

Topics: Tech Watch | No Comments »

Carluccio’s PR Policy

By chris dalby | July 9, 2008

I have seen issues of photography police popping up on twitter a lot recently. People talking of experiences where they had been confronted by security staff and prevented from taking photographs in seesmingly public spces. But it had never happened to me until tonight.

I went to Carluccio’s for a meal with my wife and decided to go and video some of the sparkling goodies on display. Within seconds I was literally pounced upon by two members of staff.

I was gobsmacked. And this felt like a well rehearsed and vindictive process.

Honestly, Carluccio, I left your place feeling dirty. I was told the PR guys don’t allow it. Well tell them to get a life and get with the 20th century. No, wait…

[Update - 9th July 2008]

I had a look around Carluccio’s website after writing this blog post and decided to email the MD to pass on my thoughts.  I’m not going to reprint the email, but I got an apology for being treated in such a manner and he assured me that he also discussed this with staff at the restaurant so they understand this.

I’d like to say thanks for a quick response.  It would be great to see a comment on this blog from someone within Carluccio’s as to whether this means photography is banned within Carluccio’s or whether they simply are resolving to deal with refusing photography in a more delicate manner.  I’m still unclear on this.

Going back to the original issue, I find it hard to understand how photographs or footage taken within Carluccio’s can have any negative impact unless there is something to hide.  Is the issue that the products can’t be filmed, or would the same approach be taken if I whipped my phone out and started taking photos at a meal with my family?  Most people generally have a phone with a camera and video nowadays.  Many people take photos of items so they can ask friends or family to help choose at a later time.  It just so happens I regularly get my phone out to take videos or photos wherever I am, most of the time.

What’s not to like about people in the US, or around the world, finding out about a restaurant and deli that they never heard of and seeing the great products on offer?  Which is what happened when i posted this video on phreadz last night.

Topics: Culture, Video | No Comments »

Meet segway

By chris dalby | July 4, 2008

Topics: Culture, Tech Watch, Video | No Comments »

Wordpress Chinposin

By chris dalby | July 4, 2008

A new @chinposin Wordpress Widget was released this afternoon.  Many thanks to Abesh for writing this widget, much appreciated and it works great.  You can see it working here on my blog, it is a random slideshow of your avatar timeline.

Since starting chinposin, I have never ceased to be amazed by the amount of people that have been submitting chinposin photos on flickr or twitter and some of them are group chinposin of 70+ people.

So when Abesh skyped me the other day and said he’d made a Wordpress widget, I was over the moon.  When things like this happen, it makes all the time spent working on this project worthwhile.

Now we have RSS feeds for each user and a couple of widgets to choose from, I hope chinposin starts becoming a useful tool, allowing you to display your main ID in alot of places.  If you have suggestions regarding features you would like, then please let me know by leaving a comment here.

We have further plans for new features in the near future.  The next release will have a permalink url for your most recent avatar, meaning you will be able use a simple url like http://chinposin.com/a/yellowpark/avatar.jpg.

Thanks to everyone in the chinposin community, we hope you like the new features.

Topics: Culture, Tech Watch | No Comments »

I am electric man

By chris dalby | June 30, 2008

Topics: Culture, Tech Watch, Video | 1 Comment »

Widget Widget Widget

By chris dalby | June 29, 2008

A big thanks must go out to abesh, who has submitted some great widgets for @chinposin.  Thanks alot Abesh, now we got RSS, the widget possibilities that open up are endless.

Topics: Tech Watch | No Comments »

My New Dumping Ground

By chris dalby | June 29, 2008

In my last blog post, I spoke about this really cool web app called Indexhibit.  I’ve kinda worked out what I will use this for, so you can now find my new dumping ground over at http://chinposin.com/drop/.  I’m calling this drop, because I intend to use this area to share stuff I find interesting.  Stuff I want to bookmark and share for later.  Stuff that might be created by me or by others.

Expect to see “stuff” that meets the indexhibit agenda:

A web application used to build and maintain an archetypal, invisible website format that combines text, image, movie and sound.

I love this format.  I hear there are new releases and plugins due very soon for this.  So we’ll see how it progresses.

Topics: Tech Watch | No Comments »

Poor Internet Applications

By chris dalby | June 26, 2008

I have been toying with the idea for ages of stripping back my wordpress template to sandbox and creating a minimal theme for my blog.  I think my blog theme is pretty minimal at the moment, but there is something nice about plain black text and white background.

A classic example of this is Dave Winer’s blog.  Minimal. Functional. And looks classically cool IMHO.  But it is so difficult to make black text and white background look cool.

I have played with things like tumblr and soup, and have never really found a use for them.  Not really.  You can pump them full of weird photos and matching tweets and they look cool.  But, I’ve never found a use for them.

Today I came across indexhibit after seeing a tweet from @obstructionist (also known as writer Seth Eagelfeld).

Indexhibit is:

A web application used to build and maintain an archetypal, invisible website format that combines text, image, movie and sound.

So I have setup a classic black text and white background poor internet application.  Love it :)  But I’m still working out what I can use it for, so I won’t link to it just yet.   [update: you can check it out here] OK, so I got my minimal site with a CMS for the backend.  But the king of apps nowadays generally link to a gazillian API’s and posts your content to all of your social networking sites.

So we’ll see how this goes.  Hope I find a use for it.

Topics: Tech Watch | No Comments »

Create XML from SQL Server for Tiltviewer

By chris dalby | June 25, 2008

Last night I cobbled together a script so I could output data from a SQL Server 2005 database into an XML file.  The reason I did this is because Tiltviewer uses an XML file formatted in a particular way to create an amazing visualisation.  Check out an example of a chinposin flickr visualisation using tiltviewer.  Very cool, I think you will agree.  Especially considering it took me 2 minutes!

So, if .NET is your thing and you would like to export data from SQL Server to the correctly formatted XML file for tiltviewer, here is the script. This script simply runs whenever the page is loaded and creates the XML file in the file location specified.  The data is output using a stored procedure.  You can then follow tiltviewer instructions to visualise your new data from the xml file.

By the way, this is not a tutorial, I am simply sharing the code.  Leave a comment if you have a question.  I imagine that I will work this out for php also in the next few days.

You could also add caching to the xml script and automate the way the file is generated.  It’s not a million miles from that.  So if anyone works that out, it would be appreciated if you link to that here.  otherwise, you are free to use as you see fit :)

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim filename As String = “G:\websites\htdocs\xml\gallery.xml”
Dim mywriter As System.Xml.XmlTextWriter

‘declare the db connection stuff
‘ Create Instance of Connection and Command Object
Dim connection As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings(”ConnectionString”))
Dim command As SqlCommand = New SqlCommand(”GetProductsInCategory”, connection)
command.CommandType = CommandType.StoredProcedure
command.Parameters.AddWithValue(”@CategoryID”, “138″)

‘ extract details
connection.Open()
Dim customerReader As SqlDataReader = command.ExecuteReader()
‘declare the xml stuff
Dim writer As XmlTextWriter = Nothing

writer = New System.Xml.XmlTextWriter(filename, Nothing)
‘Use indenting for readability.
writer.Formatting = Formatting.Indented

‘Write the XML delcaration.
writer.WriteStartDocument()

‘Write a root element.
writer.WriteStartElement(”tiltviewergallery”)
writer.WriteStartElement(”photos”)

‘loop thru the database and create the xml nodes

While customerReader.Read
writer.WriteStartElement(”ph
‘ Loop
writer.WriteAttributeString(”imageurl”, “../ProductImages/” + customerReader(”ImagePath”))

‘Write the title.
writer.WriteElementString(”title”, customerReader(”Name”))
writer.WriteElementString(”Description”, customerReader(”Code”))
‘Write the close tag for the root element.
writer.WriteEndElement()
End While

‘close db
connection.Close()

writer.WriteEndDocument()

‘Write the XML to file and close the writer.
writer.Flush()
writer.Close()

‘Load the file into an XmlDocument to ensure well formed XML.
Dim doc As New XmlDocument()
‘Preserve white space for readability.
doc.PreserveWhitespace = True

End Sub

Here is the Stored Procedure that I used.  You can simply or change accordingly:

CREATE PROCEDURE [dbo].[GetProducts]

AS

SELECT Product.ProductID,Product.[Name], Product.Price, Product.Code, Product.ImagePath, Product.CardSize, Product.WebDisplay
FROM Product
WHERE Product.WebDisplay = 1
ORDER BY Product.ProductID Desc
RETURN

GO

Topics: Tech Watch | 1 Comment »

Meeting the Slug

By chris dalby | June 18, 2008

If you read this blog, you will realise from my previous couple of posts that I have been taken with the Current Cost craze that has hit town. That’s right folkes, I’ve put my house online and I’m monitoring energy usage in the name of saving money.

Today I received delivery of my Linksys NSLU2, also known as a SLUG. Advertised as network storage for less than £60, the specs are ok. But then with a relatively easy firmware flash, you have a linux server for only 4watts of electricity and a home automation hub or IP phone system on your hands or whatever you want to use a linux server for.

I have literally only played with this for a couple of hours and I am amazed how easy it has been to flash the firmware and setup Unslung, a linux distro developed specifically for this device.

The flash upgrade to the Unslung firmware is well documented and very easy. I also attached a 40GB external hard drive and changed the system into Unslung mode which was a breeze. Simply follow the readme file and all is explained.

I now have a 40gb mobile hdd attached via USB to the slug. More than enough for my needs. Next up, general config, the nanobroker, MySql and reporting. All I need now is a cable.  Stay tuned.

Topics: Green, Video | 1 Comment »

Setting up my Current Cost Meter

By chris dalby | June 15, 2008

My long awaited current cost meter arrived this week . I have been looking forward to this arriving for the last month, especially after reading the blogs written by Dale Lane, Andy Piper, Roo Reynolds.

Background

I first found out about the Current Cost craze after reading a tweet from Matt Bidulph. His tweet linked to a graph showing his energy consumption. A quick google search, revealed alot of writing about the Current Cost craze that has hit IBM’s Hursley crowd. So I decided to ask on twitter how I could get a Current Cost meter and join the graph.

The magic of twitter gave me a reply by Andy Stanford-Clark, Master Inventor at IBM and specialist in automation and remote monitoring - hence the Current Cost. Andy has been hugely helpful with getting me up and running. He has also given me a huge interest in automation and remote monitoring. Especially after seeing how he has put his whole house online with the andy_house twitter stream and after listening to the podcast where Andy talks about how he automated the mousetraps in his home.

The Current Cost Meter

If you live in the UK, you can order a current cost from from ecogadgetshop.co.uk - beware they have a 28 day delivery time. The meter comes in two parts:

1. Transmitter that hooks over the electricity cable running between your meter and Circuit Box. This requires no wiring to connect and has easy to follow instructions for installing

2. The Current Cost meter is a small display that receives a wireless signal from the transmitter and outputs the energy consumption data, showing current energy usage and cost, historical usage and cost and temperature. This can be located anywhere you wish within the house. My meter is two floors above the transmitter and has a full strength signal.

The meter also has an RJ-45 socket on the bottom, allowing you to attach to a computer via a serial cable and grab xml data that is spat out the meter every 6 seconds.

Graphing the Results

At the moment, my Current Cost is sending data to a Broker at IBM, giving me an online graph in the form of a java applet. This works by using a perl script that monitors the serial connection to the current cost and uses MQTT to send the xml data to a broker at IBM.

This is great, but any geek worth their salt likes to have a play and see what else can be done :

What’s next?

All this has raised my interest in home automation and monitoring. So I have registered chris_house on twitter, in the dream that I will soon be outputting data and eventually be controlling the house via commands entered into twitter. I have also purchased a SLUG, which with a firmware flash becomes a linux server, and will be my home automation hub running a nano version of mqtt - all at the low power of 4 watts.

So in the first instance, I’ll start databasing all the current cost data and outputting the results using the Google Chart API so I can have a web dashboard of all this data available to mobile or desktop devices. Controlling the house using an iPod Touch, cool. I will then look to monitor my SIP phone system as it can’t be too hard to monitor a device on the same network, right?  Who knows how far I will take this :)

It certainly is a great bit of fun at the moment. Seeing people getting their doorbell online also makes me want to go and buy a doorbell for a weekend project. Stay tuned for more blog posts in the future as things progress.

Topics: Tech Watch | No Comments »

New Toy: Saving energy with Current Cost

By chris dalby | June 12, 2008

So I had a new toy arrive today, a Current Cost meter that monitors your electricity use and gives a huge amount of readings out the box. They were on special at www.ecogadgetshop.co.uk. The really cool thing about this gadget is tht it also has an RJ-45 socket on the bottom, allowing you to link the system to the internet

I am looking forward to playing with this. Apart from the obvious cost savings in energy use that I will make, it will also be the start of automating the house and outputting data into twitter. I am also hoping I can build some commands into twitter allowing me to control the house form anywhere.

So here is a quick video that I put together where I show the meter.

Topics: Culture, Green, Video | No Comments »

Phreadz Phriday Meme

By chris dalby | June 6, 2008

Topics: Tech Watch | No Comments »

The Weather And Travel

By chris dalby | May 26, 2008

I recorded this video live and unscripted using CamTwist following the drive home on a bank holiday weekend.  Hence traffic and travel.

Topics: Culture, TWAT, Video | No Comments »

Directions to the Live Meeting Training

By chris dalby | May 15, 2008

I am running a Live Meeting training course on Friday 16th June.  I thought it would be a great thing to film the journey from the tube station to the training venue. So if you are attending the course, watch the journey to the training venue.

 

Â

Topics: Live Meeting, Training, Video | No Comments »

links for 2008-05-12

By chris dalby | May 12, 2008

Topics: Links | No Comments »

Phreadz widgety thing

By chris dalby | May 11, 2008

Topics: Culture, Video | No Comments »

« Previous Entries