11/25/12

Best free channels for your new roku and live tv streaming

After getting my new roku I've started to dig into the best free channels and the best channels to add in general. What I really wanted to do was to stream live tv to my roku - and while I figured out how to do this - it might not be worth it. See more on this below.

1. Netflix. Roku may talk about free movies and channels but the truth is that without Netflix you might as well not buy a roku. Other sources are limited and commercial laden - Netflix should be your first stop.

2. Crackle. Ok - these are free movies - but seriously? "Zombie strippers"? There is a reason these movies are free. It is an ok addition to Netflix but only for spare entertainment.

3. Amazon stream. Even though you have to pay extra I've found that occasionally I can find a must watch movie on amazon even when it isn't on Netflix.

4. Ustream. This is interesting and has a lot of potential. In theory this service is intended for expats outside USA- but there is no verification so anyone can use it. I was indeed able to watch live tv for free - fox, NBC, Abc. The problem was resolution. Then true quality was terrible - I viewed it as radio with a side helping of grainy images. If you are looking for a hi quality live tv experience on the roku good luck - I wasn't able to find it.

Lastly - I didn't but one of the fancy hdmi cables - and have found that the basic rgb cables work just fine.


11/21/12

Why is Facebook stock on the rise?

As someone who has played in tech stocks for a while (all the way back to the APCC days) I've been watching facebook stock (FB) for some time with interest.

After all the hoopla that surrounded the IPO it was fascinating to watch reality take hold. Will fb be able to monetize mobile traffic? Will they be able to retain the RIP employees? As the questions mounted, the stock started to tank.

In the meantime I've been watching as our client base has continued to invest in facebook advertising. Google has a well established reputation (and measured ROI) in our client's portfolio of promotion - and we have for some time been recommending facebook as well.

Because of our agency relationship with Facebook we are able to see the ebb and flow of advertising dollars  from a unique vantage point and for me I'm seeing several reason to be optimistic about the future of fb advertising.

1. paying to promote posts is showing a healthy return on investment
2. paying to promote company pages is a great way to build fans - which in turn has value as a communication platform.
3. the concept of a facebook powered ad network (currently in the works) is a powerful one.
4. it appears as though facebook has begun to sort out the monetization of mobile traffic.

All these support an optimistic forecast for facebook revenue and stock appreciation. As I type this it has already surged by almost 4% today alone.








Classic ASP Plotting new visitor location on a google static map

I've been intrigued by the possibility of plotting my web registrants physical location on a map for a while so I thought I'd give it a try and see what was required to make this happen. There are two tools that I ended up using:

1. Google static maps API. Really easy to use - basically just construct the URL to the google map image and you are off and running.

2. Get the visitor location (lat longitude) from their IP address. This was a bit trickier.

Getting started:

1. Visit https://developers.google.com/maps/documentation/staticmaps/ and read up on the creation of a google static map. In my case I stuck with the most basic implementation to keep things easy.


2. After searching for a while I found the best way to get from IP address to location was to use this web service: http://ipinfodb.com/ This service allows you to call an HTTP address and get back physical location information. The basic idea it to call the infodb URL like so:

URL = "http://api.ipinfodb.com/v3/ip-city/?key=" & locationKEY & "&ip=" & UserIPAddress

The result if you simply browse to this address is a semi-colon delimited string containing details like city/state and Lat;Long.

What I did was to create a classic asp function that returned the Lat,Long position like so:

Function getPosition(UserIPAddress)

URL = "http://api.ipinfodb.com/v3/ip-city/?key=" & locationKEY & "&ip=" & UserIPAddress


Set xmlHttp = Server.Createobject("MSXML2.ServerXMLHTTP")
    xmlHttp.Open "GET", URL, False
    xmlHttp.setRequestHeader "User-Agent", "asp httprequest"
    xmlHttp.setRequestHeader "content-type", "application/x-www-form-urlencoded"
    xmlHttp.Send
    getHTML = xmlHttp.responseText
    xmlHttp.abort()
    set xmlHttp = Nothing   


 arrLocation = SPLIT(getHTML,";")


 strLatitude = arrLocation(8)
 strLongitude = arrLocation(9)

 strCoordinatesTemp = strLatitude & "," & strLongitude

 getPosition = strCoordinatesTemp

END FUNCTION

Once this function was created, all I had to do was iterate through my latest visitors IP address to generate the actual map

'--get most recent 5 locations
sqlGet = "select top(5) pr_ip_address,pr_index from tProfile order by pr_index desc"
set objRsLocations = objConn.Execute(sqlGet)

DO WHILE NOT objRsLocations.EOF


strCoordinates = strCoordinates & "%7C" & getPosition(objRsLocations("pr_ip_address"))
objRsLocations.MoveNext

LOOP

Once that was done - just append the coordinates to the google static maps api url and you are good to go:

<img src=http://maps.googleapis.com/maps/api/staticmap?size=300x300&markers=color:blue%7Clabel:%7C<%=strCoordinates%>&sensor=true>

The result?