Free books for Facebook fans!

July 8th, 2010

The sun has arrived here in Seattle, and I spent some time out in it this evening. Why do you care? Well, the heady combination of that and the beer I just drank has driven me to introduce a scheme that cannot possibly do me any good at all.

Every month, I am going to give away a book to a Facebook fan chosen at random. The first random drawing will be this Saturday evening (July 10th). You have until then to become a fan, and you may get a free book! In fact this particular month it’s even better than that, because I’ll give away two books if the fan count is more than 1,000 when I do the drawing (it’s 988 right now).

Of course, if you become a fan after that, you might get a free book the following month. If you do not become a fan at all, you will probably not get a free book. The rules are quite simple. All you have to do is go to the Septic’s Companion Fan Page on Facebook and click “like” or “become a fan” or whatever Facebook have decided the button is this week. Good luck!

Bookmark and Share

No more nonsense from my .com here

June 6th, 2010

Spurred on by the news that Apple is now bigger than Microsoft, I’m going to invest some time in doing more blogging for my fledgeling nest-egg, Beta Minus. I’ve started a blog on http://betaminus.com/, and migrated a couple of posts I had here about mobile app sales. Just to tempt you over there, I’ve written a brand new post about using my Proximity app whilst skiing.

I’ll try and keep this blog for things marginally more funny. Once I think of them…

Bookmark and Share

Review of the Cotton Carrier camera harness

May 24th, 2010

I did say a while back that this blog would become somewhat random. Well, now I’m posting a review of a harness with which one can carry a camera. Variety, they say, is the spice of life.

I recently bought my first digital SLR camera, a Nikon D40. At the weekends I often climb up mountains, so it seems sensible that I use my nice new camera to take pictures of those mountains. As far as carrying a large camera up mountains goes, you have two options:

  1. Leave it in your pack all the way up there and back again
  2. Swear at it continually until you revert to option (1).

Enter the Cotton Carrier.

Simply put, The Cotton Carrier is a harness that straps over your chest and allows you to carry a large camera as though it was bolted to your chest. The unit has a sturdy plate which sits on your chest, and the camera attaches to that plate via a small mount that goes in the threaded tripod attachment on the camera. The camera is attached to the mount by turning it to face left and then sliding it into a groove – it cannot then be removed from the mount without turning it ninety degrees and sliding it upward, therefore making it unlikely (but not impossible) that you’ll disengage your camera from the mount by mistake. The device was created by Andy Cotton, a landscape photographer, and it’s described a lot better in Andy’s own introductory video on his web site.

I heard about this system from my boss, Doug – after explaining the whole concept to me he was then inspired to go out and buy one himself. It arrived on Thursday, and rather generously he lent it to me immediately so I could take it on my backpacking trip down the side of Lake Chelan that weekend. This I duly did, and here are my thoughts about the device. I ought to point out that Doug, being a man of great means, purchased the $170 complete system, but the parts that I am reviewing really just represent the $99 camera vest for regular cameras. The complete system has attachments for a secondary camera, bottle opener, lightning conductor, divining rod et cetera. Neither of these systems are cheap, so let’s hope it’s good!

Okay, it’s good. I was never an expert at suspense.

Putting on the harness was pretty simple and after a few experiments I found a height that works well for me on my chest. After you’ve done it a few times, taking the camera out of the carrier becomes almost instinctive. Once it’s out, it seems to magically end up exactly in the right place to take a picture – you can have the camera out of the carrier, take a photo and put it back in within a few seconds. It fits solidly into the mount so there’s never any doubt whether you’ve got it successfully in or not.

Historically I’ve always taken a point-and-shoot camera in my trouser pocket where it’s nice and accessible – carrying the SLR on the Cotton Carrier actually made it much simpler to take photos on the spur of the moment, especially given the extra power-on time that my compact camera seems to need. At one point, one of my backpacking companions leaned over and grabbed my SLR from my chest mount because he didn’t have the time to take his own compact camera from his pocket. It’s amazing the times when a handy pocket is actually not handy at all.

Alright, I think I’ve gushed about this enough now, so I’ll analyse a couple of details. First off, the way in which the camera is mounted to the stand. This is done via a small machined button – I’m please that it’s not heavy, but it does mean that the camera doesn’t sit level any more when you put it down on a table. The only real annoyance here is that it’s hard to take long exposure shots without actually using a tripod – I’m used to just sitting the camera on a rock, and it’s tricky to do that with the button on the bottom. The button comes off easily with the tool provided – it would be great if either the button was a little wider (so the camera could sit flat on it) or the tool could easily be attached to the harness itself (because, umm, I left it in the car). The slot to unscrew the button is pretty generic and the button could easily be removed with a coin or some other similar object, but I stopped short of this one given that the harness belonged to my boss and it might be a bit difficult to explain on Monday exactly what I had been trying to do with his brand new piece of camera equipment and a bent spork.

I was concerned that wearing the harness all day would make both it and me somewhat sweaty – somehow, this didn’t happen but I’m not exactly sure why. The carrier is made of some sort of mesh – Mr Cotton, I don’t know what this is or how it works, but please keep making it that way. Somehow, my rucksack straps ended up soaked, but the carrier did not.

On the subject of rucksacks, the carrier can easily be worn at the same time as a large pack. As you can see from the photos, I was carrying somewhere around 20kgs of stuff in a 70 litre pack and the carrier fitted fine underneath. The shoulder straps are wide enough that they cause almost no discomfort, although if I had to choose I’d have them wider rather than narrower, as that would mean the backpack sat entirely on them which I think would be even better. The carrier was sitting high enough on my chest that the chest strap sat just above the waist straps on my rucksack, so this worked ideally. I could easily have worn a climbing harness as well, and the carrier wouldn’t have got in the way.

Any minus points? Well, I jotted down a couple. However, I’m very much convinced that the positioning the Cotton Carrier uses is precisely the correct place to carry a camera, and some of my gripes are around this. Firstly, I was using a water-bladder inside my rucksack to drink from – the problem with this is that you’re drinking water from a spout directly above the back of your camera so you have to be a little careful not to cheerfully pour a torrent on top of the thing. The solution to this one is, I think, just to drink more carefully. Secondly, it would be inadvisable to keep the neck strap on the camera when using the carrier unless you were going to also put it around your neck as an emergency measure – there’s a reasonable chance it would slip down and you’d end up putting a knee through it when climbing steep terrain. Again, not sure of the solution – the carrier itself comes with a “jesus strap” that you can attach to the harness, so the right answer here is probably just to embrace that, and ditch the old neck strap.

Overall, this is a superb piece of gear – as you know, I don’t make a habit of writing equipment reviews on this blog but I was so impressed with this harness that I felt I ought to write something. I was approached by two people during the backpacking trip asking me what it was and where I’d got it, and my backpacking chum told me he was sorely tempted to buy one because right now his $1000 DSLR camera was largely worthless, gathering dust in his basement. I’m amazed that this device isn’t an open secret in the climbing community, but it isn’t – I’ll certainly be doing my best to remedy that, and I hope Mr Cotton continues innovating because he’s onto the right thing.

Now to persuade the wife…

Bookmark and Share

Making usable reports of Windows Mobile Marketplace sales

May 7th, 2010

[Note: On 2010-05-07 I moved this to its new home on my business blog. Comments are enabled on the migrated post.]

As I mentioned in my last post, I am currently selling two apps on the Windows Mobile Marketplace. These are Carlos (an app intended to remind you where you put the car) and Proximity (a location-triggered alarm and notification system). My previous post detailed the sales I’m currently getting for those apps – I’ll post an update on those numbers at some point, but this post is about how I got those figures into a nice chart.

You can say many things about the Windows Mobile Marketplace, but if you’re an app vendor then one of them will probably not be a long treatise on how wonderful their sales reporting system is. Their primary reporting output is a mysterious “Fulfillment report” XML file that turns out to be SpreadsheetML, the ISO 29500 file format used by Excel. Oddly enough this crosses over into my day job, but enough of that. Here’s how to turn that file into something useful, using Excel.

Using the Template

Download my template reporting spreadsheet, mobileappsalestemplate.xlsm.

Open it in Excel. Enable macros.

Request and download a “fulfillment report” from the Windows Mobile Marketplace developer page:

Leave the report set to All Markets, All OS, All Platforms and choose “90 days” as the time period.

The report downloads as a ZIP file containing two XML files - save FulfillmentReport.xml and use File/Open to open it in the same copy of Excel that your reporting workbook is in and enable editing (if you open it in a new copy you’ll get a VBA error when you try to import the data).

Now you need to add your products. FulfillmentReport.xml has a “SKU detail” tab – copy and paste that data into the same tab of the template sheet. You have to repeat this step whenever your SKUs change (usually when you add a new product, or issue an update).

Now, save the reporting sheet somewhere. It’s going to keep a hold of more history than the Marketplace does.

Without closing the FulfillmentReport.xml workbook, go onto the “Consolidated Purchase History” tab of my template. There’s a button on the right hand side of the table - click this. It will import the fulfillment data from the FulfillmentReport.xml you currently have open, and put it onto the Purchase History tab. It will not import any history that’s already been stored in the template, so it’s fine to just keep requesting 90-day histories from the Marketplace and importing them over the old data. Unless I screwed up the VBA, of course. The VBA is dog-slow - it could take ten minutes for the first import. Yes, I could certainly speed it up. And no, I can’t be bothered. If you do, I’ll be pleased to use yours instead!

Once the import is finished, the yellow columns in this sheet should populate with the right product names – you have all your data now, you’re ready to report on it!

On the sheet imaginatively called “A Chart”, you’ll see that I have the data for the chart I used in my previous blog post. The data on the left is simply to aggregate sales by day. You’ll have to replace my product names in row 1 with yours before you see any data. I was using it to track two products – you can change the chart range if you want to track a different number. You can also create Pivot Tables based upon the data on the Consolidated Purchase History sheet, or add new charts, or what have you.

This is not intended to be a glitzy boxed solution. It’s something I’ve been using myself so there’s not really any error handling and there are all sorts of things hard-coded around the place. If you’re not very familiar with Excel, it’s going to be tricky to use. That said, if you make any improvements to the sheet I’d love to see them (feel free to link them in comments here) and I’ll also post an update if I make a newer version.

Back on my original topic, an interesting switch appears to be happening in my sales figures, so I’ll post updated sales figures for my apps in a month or so. If anyone comes up with a nifty new version of this spreadsheet, I’ll be delighted to do so using that!

Bookmark and Share