Simon Fell > Its just code > OSX

Sunday, July 13, 2008

I released a new version of SoqlX a few days ago, this updates it to the v13.0 API, and adds the ability to save the query results as a CSV file. And i just posted a new release of PocketHTTP, this adds a change to not send the full URL when proxying over SSL. PocketSOAP and PocketXML-RPC both now are a few revs behind pocketHTTP. I'll be updating the installers for those 2 to bring them up to date sometime in the next week.

Thursday, July 10, 2008

Hits the streets today, even making the front page of AppStore. Finally, time for some sleep ;)

Thursday, June 26, 2008

Sometimes full blown 2 way sync is just overkill, for some people just having a read only copy of their salesforce.com calendar in iCal is all they want, fortunately this is pretty straightforward, iCal supports subscribing to iCalendar feeds, and conveniently your Mac includes a copy of Apache httpd, so can easily run perl, python etc in response to a request. Throw in a library for accessing the Salesforce.com API, and you have all the ingredients needed. I put this together in Python using Beatbox, it makes API calls to login and to query events, and to generate an iCalendar formated response, You then subscribe to the url on your local Mac in iCal to show the data in iCal with the rest of your calendars.

• Download the code, this has the 2 files for beatbox, and the third is the iCalendar generator.
• Unzip this and drop the 3 files into your /Library/WebServer/CGI-Executables folder.
• From System preferences -> Sharing make sure that Web Sharing is turned on.
• Quickly test it in safari, goto http://localhost/cgi-bin/sfical.py?un=user@foo.bom&pwd=SomePassword if everything works, you should see something that starts like
  

  BEGIN:VCALENDAR
  VERSION:2.0
  PRODID:-//PocketSoap//pyCal 1.0//EN
  X-WR-CALNAME:Salesforce calendar : Simon Fell
  METHOD:PUBLISH
  BEGIN:VEVENT

• Goto iCal, goto the calendar menu and pick subscribe, paste the URL from safari into the URL box, and then in the resulting dialog, pick how often you want it to auto-refresh (I'd suggest no more often than once a hour).

That's it!, you're good to go, you should have all your upcoming events now showing in iCal.

SF³ Is now available, if you're on a older version, you'll get prompted to upgrade next time you restart it. This adds a new option to get a prompt before applying any changes to Salesforce.com, useful for spotting when a sync is going to change/delete more data than you were expecting.

Also included is support for multi-day all day events, a new feature added to Salesforce.com in the summer '08 release, now these will get correctly mapped between Salesforce and iCal.

Sunday, June 08, 2008

There's no shortage of bad coffee choices next to Moscone, but if you can drag yourself away from all the conference action and walk one block, (mint plaza, mission & 5th) you can avail yourself of some of the best coffee in the bay area, or indeed the west coast. The Blue Bottle cafe opened earlier this year in Mint Plaza, go check it out, you won't be sorry.

Thursday, June 05, 2008

Unless you've been living under a very large rock, you know its WWDC next week and everyone is hopped up on predictions of OSX 10.6 and 3G iPhones with GPS & espresso machines built in, and of course the release versions of iPhone 2.0 and the SDK. Besides all the iPhone news everyone is waiting for, I'd like to see Apple step up to the plate on virtualization, and let us run OSX virtualized, its a royal pain in the ass to support OSX apps because the only way to test on multiple versions of the OS is to maintain a bunch of different installs of the OS and boot between them, how 1990's. And it not even like you can get away with just a 10.4 and a 10.5 install, there's enough differences between 10.5.0, 10.5.1, 10.5.2 and 10.5.3 that you'd really want to test on at least some of them.

Thursday, March 06, 2008

About a year ago I posted about sfdcFuse, a command line utility that exposes the Document repository in Salesforce.com as a mountable volume using MacFUSE. Unfortunately this version doesn't work on Leopard, so I've been working on a Leopard version, and at the same time, getting rid of the command line interface and putting a regular cocoa front end on it. The result is SFFS (the SalesForce File System). Much like the earlier version, this exposes a read-only copy of your document repository as a mounted volume on your Mac. You get my standard UI for login, complete with keychain support, and auto-updates via Sparkle. Its available under the open source BSD license, everything is over on the Google code project.

Monday, February 18, 2008

I just released this, it fixes a problem with all day events not picking up date changes from Salesforce.com, and addresses some weirdness relating to filtering on 10.5.2 (which would manifest itself as SF³ saying it picked up local changes, but that it didn't appear to change anything in Salesforce.com). I'm working entirely out of the Google code project now, so you can see source code changes for specific issues, issues come and go in the issue tracker, and the sparkle auto-updater is now pulling builds from the google code site. Everything seems to be working just fine.

Sunday, February 17, 2008

Hot on the heals of SF3, Maildrop is now open source as well, checkout the source, log bugs, enhancement requests etc all over at the project home page @ Google code. My thanks to Ron and the ADN crew for helping organize this.

Thursday, February 14, 2008

The Core Data file truncation bug I previously mentioned is fixed in 10.5.2.

Sunday, February 10, 2008

With the 0.52 release of SF³ I made it open source under the BSD license. Rather than host everything myself, which is how I've handled previous open source projects of mine, (sourceforge looked to be on its last legs for quite a well, but is still going) I've decided to try out the Google code project hosting. Everything is over there, source code in SVN, an issue tracker that i loaded up with all the bugs and feature requests i know about, and there's a wiki that contains most of the content from my own SF³ page. Share & Enjoy.

Friday, February 08, 2008

For those folks that have ran into iCal sync problems on Leopard, try this build, let me know how you get on. (this also includes a lot of fixes for contact sync where your AB contact have more data than salesforce supports, e.g. multiple work phone numbers). I've also decided to open source SF³, as i just don't have the time to move it forward fast enough, the complexities of the sync and data mapping process/problems means you really can't work on it in little chunks of time like i can for the other apps. This should give the folks that are in need of more features and/or specific changes for their setup a chance to get what they need done.

Sunday, February 03, 2008

There's a new version of SoqlXplorer available, this version requires Leopard, it has an updated UI, support for displaying child queries (double click on the magnifying glass icon), a recent query list, and a few other bits'n'peices.

Wednesday, January 23, 2008

I seem to be collecting Office suites that don't quite do what i want. I upgraded to iWork '08 when it came out because i was looking for something better than Excel 2004, which is bloated and sluggish (even on my 4 core mac pro). However Numbers has no way as far as i can see to get external data into it, no support for AppleScript, and no equivalent to Excel's Web Query feature, so its largely sat on the sidelines gathering dust. So, my copy of Office 2008 turned up last week, I figured the new Intel native version would at least be snappier than its rosseta stone older sibling, but no, somehow it feels about as sluggish as the previous version. Now, i was expecting the loss of VBA macro's but i didn't realize that they'd completely abandoned any document integration at all, yes I can write apple script to manipulate spreadsheets, but these scripts aren't stored in the document, i can't assign an applescript to say a button in the document, there doesn't seem to be any sort of event integration, so i can run scripts on save, or load. I now have a single menu item with a (potentially) bucket-load of apple scripts and I've got to remember which one goes with which document. And just to rub salt in the wound, Web Queries seem to be broken, you can create new one's fine, but goto do a refresh and you'll get the cryptic and unhelpful message "selection can contain a single cell only", nice, you should be able to return broken software. Guess I'm stuck with Excel 2004 for a while longer, ho hum.

Tuesday, January 22, 2008

Despite all the buzz, Leopard is a fairly incremental release for users, Time Machine is nice, but still needs work, the unified UI is nice, spaces is equal parts useful and annoying. But for developers Leopard is quite the candy store, I've been tinkering with a number of the new APIs, and am starting to put it into practice with an update for SoqlXplorer. NSOperation/NSOperationQueue is particularly nice, as is the reams of code i can now delete and replace with system provided equivalents (NSGradient, HUDWindow, NSSplitView, the new style source list outline view, and of course Core Animation). Still, there's a few raw edges I've run into, this core data bug, and some of the docs still need updating (I ran into this one today, the docs for setDoubleAction on NSTableView are wrong for Leopard, I found confirmation that someone else spotted the same problem, the fix is fairly easy). Continues to be a nice change of pace from the day job.