Simon Fell > Its just code > September 2006

I put up a new version of Soql Xplorer, it cleans up a couple of minor ui issues, but more importantly adds syntax coloring and field/object name validation to the soql editor. As you type field names and the object name, they're validated against the metadata from the describe call, and anything suspect underlined with red dashes. (Kudos to Brent for his simple demo that shows how to put like kind of thing together in cocoa).

Syntax highlighting in action

When I brought Tom last year I picked up some new burrs at the same time. The grind always seemed ok, so I never got around to putting the new burrs in, finally this morning I took the adjustment collar off and took a look at the state of the burrs. I've seen worse, but it seemed like now was going to a good time to put the news one in. Shouldn't have to change these again for at least a couple of years.

	Once you've spun the adjustment collar off (remembering that its back to front, so spin it clockwise to remove it). you can pop the top burr carrier right out. Keep count of how many turns to takes before the collar comes off, will make dialing the grinder setting back in when you're done easier.
	Both the top & bottom burrs are mounted by 3 screws each, so easy to change. You can see in this picture and the one before that old coffee grinds will accumulate and grunge up every nook & cranny they can find.
	Woah!, grinder carnage after taking out the bottom burrs. I brushed this out and down the main exit shoot, but a little vac might work better.
	New burrs ready for mounting, watch your fingers.
	After the new bottom burr's been mounted, all nice and clean.
	Put the top burr carrier back in, and spin the adjustment collar back on (remembering its back to front). Hopefully you remembered to count when you took it off, so you can get it close to the right setting when you put it back. I used some old beans to dial in the grind again, I was surprised to find that its about a 1/4 of a turn more corse than before, that's quite a difference.
	Take the crappy old beans out, put some fresh Black Hand Blend in (Kudos to Tony @ Caffe Fresco, this is one of my favorite espresso blends right now). Fire it up, yummy!

Good news for bay area folks that want to see Black Gold, its showing as part of the Mill Valley film festival, check it out. The Green LA girl has been running a series of posts on what you can d o once you've seen the movie.

The AppExchange Explorer is an invaluable tool when working with the Salesforce.com API, but I've been chaffing this last week or so that there's no OSX version, so I fixed that. It doesn't do everything the AppExEx does yet, but it has the primary bits, explore the describes results, build & run soql queries. Here's the current build of Soql Xplorer, feel free to give it a go.

Update : new build available from SoqlX's new home