A Google calendar with contact birthdays

It's a secret, but for some time there's been a Google Calendar with Contacts birthdays and events.

It's in Other Calendars:Add:Browse Interesting Calendars:More:Contacts birthdays and events.

No, I don't know what "events" means.

The Contacts Birthdays and Events is public by default. So if anyone knows the URL, they can add it. So you can share it with your spouse and vice-versa, in which case you'll want to give each distinct names.

Obviously it has only those birthdays you've added to Contacts information. This calendar will be more useful if I'm ever able to integrate my OS X/MobileMe address book with my Google Contacts (currently the data models are too dissimilar). So, for the moment, it's more curious than useful.

These published calendars can add up. With this one I have 20 calendars available to my account, though I display only about 5-6 at a time. The calendars I display vary by season.

--
My Google Reader Shared items (feed)

USB 3 and Gigabit ethernet: two articles on the gap between marketing and reality

Vendors lie. It's the nature of things.

Ski resorts lie about their snow coverage, and tech vendors lie about performance. Marketing, for example, convinced most geeks that USB 2 was as fast as Firewire, but that's certainly not true under OS X.

In the same vein, here are two articles that contrast real world performance with marketing claims:

Coding Horror Gigabit Ethernet and Back of the Envelope Calculations: A 2005 article that showed Gigabit ethernet is about 3 times faster than 100 mbps ethernet -- not 10 times as fast. Great discussion.

Dans Data review: USB 3 drive box and controller card kit (Jan 2010): In most available machines USB 3 is 3 times faster than USB 2. (So it's probably faster than Firewire 400 and maybe comparable to Firewire 800).

Threefold improvements are nothing to sneeze at, especially in the post-Moore's Law era. It's just not quite what marketing promises.

Mac users need not feel USB 3 envy -- we get Firewire 800.

--
My Google Reader Shared items (feed)

Relational database 101: A Microsoft gem hidden in plain sight

Colleagues sometimes ask me about where to get a basic introduction to databases. My informatics students should be asking that, but they usually don’t.

I’ve not had a very good response. It’s been eons since my first encounter with data models, ER diagrams, keys and the like. I dimly recalled the monstrous Microsoft Access manuals of old, which often included quite good tutorials.

That’s what led me to crack open the Table of Contents of Microsoft Access 2007. It took me a while to figure out that how to do that. You can either click on a tiny blue circle/question mark in the far right of the app bar, or you can type old F1. You can then click the wee blue book icon to see a Table of Contents or you can look at “Browse Access Help”. From either location you’ll see “Database design” as shown here in the Table of Contents:

Microsoft has put a lot of material behind that little Database design link:

Starting with Database design basics:

Wow. I feel like I’ve entered a dusty old library frozen in time, and opened a book untouched for decades (I did that once in rural Bangladesh – quite memorable). Microsoft’s tech writers are terribly underappreciated.

The materials include demonstrations, references to sample databases, etc. The vast majority of this material is applicable to any relational database, from poor little Access to Oracle.

Many students and tech workers have an unused copy of Microsoft Access near at hand. Even if you never intend to do anything with Microsoft Access, you might as well take advantage of the excellent interactive textbook that comes with it.

Google talk IM clients: Adium for OS and Trillian for XP – the good and the ugly

I only became interested in instant messaging after I had a portable platform that supported it – namely the iPhone OS 3 update (prior that release there were no message notifications) and BeejiveIM.

IM still doesn’t work terribly well on an iPhone, but that technology change tipped the balance enough to make IM interesting on my desktop.

So I’m late to the game, but catching up. I did make one mistake in the catch-up process. Since my peers are all old and wrinkly like me, they don’t know this stuff. I should have asked younger geeks what they did.

That’s why I only now realized there was a solution to two problems I have had:

1. There’s no Google Talk client for OS X.
2. The XP Google Talk client only supports one Google identity – I want it to support my corporate and personal GT identities.

The solution for both problems on OS X is Adium. It supports multiple identities. I even have a sneaky suspicion iChat would work too (sigh, I’ve been so disgusted with iChat Video that I’ve dismissed all aspects of it).

On XP I was hearing good things about Trillian Astra. I figured I’d install it and, if it worked, pay for Pro.

Mistake.

During the install Trillian tried to change my search service and it installed the Ask.com toolbar – without notification or permission. This isn’t a new problem …

Does Trillian have a crapware problem- - Zero Day - ZDNet.com

StopBadware.org researcher Liana Leahy has taken Cerulean Studios to task for bundling two third-party applications into the popular free Trillian IM client, arguing that users who are not careful during the Trillian installation process could end up with a crapware problem.

During the installation process, the default setting is for Trillian to bundle the Weather Channel Desktop and the Ask Toolbar, two products that could introduce security risks to PC users.

I uninstalled the ask.com toolbar and Trillian immediately after the installation completed.

So I’m still looking for an XP IM solution.

This isn’t the first time I’ve run into quality issues with the XP marketplace. XP is a very large market, but it’s a very undiscriminating market with a lot of vulnerable users. The quality of the software is often very low.

Update: A trusted (younger geek) colleague recommended Pidgin for XP – libpurple based open source like Adium. See also:

• Pidgin, the universal chat client (not to be confused with ePigeon)
• Pidgin (software) - Wikipedia, the free encyclopedia
• Five Best Instant Messengers - Instant Messaging – Lifehacker: they were gamed by Trillian, but Pidgin showed up there too.
• Configuring Pidgin for Google Talk (it's not as polished as Adium)

Update 1/13/2010: Pidgin's window didn't locate itself correctly in my two monitor setup and the app itself is pretty crude. Adium is far more polished. So I'm still looking!

Update 1/13/2010: I’d read somewhere that Windows Live Messenger would provide some interoperability with XMPP, so I tried installing it. Nope – it’s still pure Microsoft. Big install and uninstall. Surprisingly, it’s ad supported as well. First time I’ve seen Microsoft do that. I looked into AOL IM as well, but no federation there either. There’s far less interoperability that I’d expected, and the interoperable clients are disappearing. I wonder if a combination of SMS, Twitter and lack of a revenue model has killed Instant Messaging.

Update 1/14/10: Another colleague recommended meebo, but that web app doesn't support Oauth with Google -- it wants my Google credentials! I don't even give those to my mother. In any event, it only supports a single Google XMPP account.

Google Voice quality issue report form

Google seems to revise their customer feedback and problem reporting schemes monthly.

As of Jan 2010 we're to use: Contact Us - Google Voice Help to report voice quality issues.

Two weeks ago I had to stop using Google Voice to Montreal due to severe echoing, but the echoes are mild now.

--
My Google Reader Shared items (feed)

CrashPlan (or JungleDisk) instead of Retrospect 8?

I've been hoping to retire my XP machine running Retrospect Professional and switch to Retrospect 8 for OS X.

Then I discovered EMC hasn't been able to produce a manual / user guide for Retrospect 8 in the year since it was first released.

I just can't get my head past that. How can I trust a company that can't put a manual together? I mean, I know manuals are hard work, but surely in the midst of the Great Recession EMC could have found some tech writers? The simplest explanation for the lack of a manual is that EMC didn't finish the software and has since abandoned the product.

So I'm looking for alternatives to Retrospect - in addition to Time Machine. (I believe in at least two, completely unrelated, fully automated, backup systems).

Two years ago I considered CrashPlan. Back then it was designed to backup to a friend's machine, but now they offer free local backup and an offsite service. Today we'd need the family plan, which costs $100 per year.

TidBITS is fond of CrashPlan, they all use it ...

• TidBITS Home Macs: CrashPlan Central Slashes Hosted Backup Pricing
• TidBITS Safe Computing: CrashPlan Adds Direct-to-Disk Backups

Searches on "retrospect" and "crashplan" or "retrsopect vs. CrashPlan", found some good articles ...

• CrashPlan Pro vs. Retrospect 8.1 « Seek Nuance
• CrashPlan and CrashPlan Pro, Revisited « Seek Nuance
• Review: CrashPlan Backup - macosx.com
• Forget Computers :: Backup Software - Why we are leaving Retrospect for CrashPlan PRO
• CrashPlan Review – A flexible multi-platform backup solution | Blackbeagle (I like the 1 year update!)
• Online backup services (Fleishman, MacWorld, Sept 2009 - per recommendation of Seek Nuance)
• Crashplan - Wikipedia, the free encyclopedia
• CrashPlan Does Local, Remote, and Friend-Based Backup - Backup utilities - Lifehacker

The reviews are positive, but of course CrashPlan has the Cloud risk. If Code 42 dies, everyone's backups are toast. Since I will be doing local Time Machine backups this is less of a risk for me.

I'm persuaded to uninstall my trial version of Retrospect 8 and give CrashPlan a try. I'll report back on my test results starting with my new i5 (which has very little data on it so far).

Update 1/4/10: Through comments here and on Seek Nuance I'm hearing Mac geeks settling into a mixture of TimeMachine, SuperDuper (intermittent clone) and CrashPlan/JungleDisk. Seek Nuance also recommends a Sept 2009 MacWorld review.

JungleDisk is blocked by some corporate filters, perhaps because it can be used for file sharing as well as backup - it provides a standard WebDav interface and thus resembles MobileMe's costly backup service. JD can currently be used with Amazon's S3 storage service but was purchased by RackSpace - so it's unclear how long that will work well. Good JD references include:

• Jungle Disk - Wikipedia, the free encyclopedia
• The Savvy Technologist - Getting serious about backing up (Part II)
• Online backup services Review | Glenn Fleishman | Macworld

The big thing we've lost with the demise of Retrospect/Mac is a Mac server hosted cross-platform SOHO backup solution. Not surprisingly, this turned out to be a very small market! The home side of the Retrospect market is made up of about 10 geeks like me. On the other hand small businesses with a mixture of Macs and Windows machines are overwhelmingly likely to use a cheap Windows backup server -- or to drop the Windows machines altogether. It's easy to see why EMC effectively gave up on Retrospect 8.

My gut sense is that CrashPlan is more of a consumer/geek business devoted to backup, whereas JungleDisk is a geek-only business providing general cloud storage and more options (some of them shady). JD is a one-stop alternative to CrashPlan + DropBox. The big kahuna would be a Google file/backup store, but that's been on the horizon for about 8 years. It may never come.

Update 1/4/10b: Glen Fleishman was using Retrospect 8 as recently as a few months ago - and he's a pretty reputable Mac geek. Glen recommends Joe Kissell's "Mac OS X Backups" eBook (TidBITS team). That lists at $15 with a 10% off coupon for CrashPlan (discount is for CrashPlan+ for business, not for the online backup service) -- so if you're planning to get CrashPlan (online) it's only $5. In fact, however, when I clicked order it was only $7.50 because of a mysterious "coupon". So if I do pay for CrashPlan it's essentially free.

I won't regurgitate Joe's eBook, but I will update this post with what I finally decide to do after having read it.

Update 1/25/2010: I'm still evaluating CrashPlan. I did buy Joe's book and it's a bargain! Highly recommended.

Update 2/4/2010: I reject CrashPlan in the Cloud because of the security risks of their password reset policy. I may still use the free version as a complement to Time Machine backups.

Update 2/21/2010: I was having lockups on startup with my MacBook. The Console showed several errors, but none clearly pointing to CrashPlan (lots of VMWare activity seen though -- and quite a few warnings about issues with OS X itself). Since CrashPlan does have deep OS hooks and is a recent install, and since I'd given up on its Cloud function, I uninstalled it. The uninstaller is a very user-unfriendly shell script.

I feel I gave CrashPlan a good test, and it failed. At the moment I'm entirely reliant on Time Machine, which is not a lovely feeling.

Update 2/24/2010: After uninstalling CrashPlan I found bits of it remaining. There are two empty folders in the System Library that require root privileges to delete. They're not causing any trouble, but I prefer to avoid software that installs in the system Library.

Update 4/26/10: I went to the CrashPlan site to completely remove my account information. Can't figure out who to do it. Nothing like this in the FAQ. More badness.

Apple Discussions - The User Tips Library

The Apple - Support - Discussions - User Tips Library is an impressive albeit idiosyncratic collection of tips on OS X.

For example: Changes in DNS resolution in Mac OS X ... explained a few things that puzzled me (and reminded me that Apple's OS X engineers seem a bit overwhelmed these days).

I've subscribed to the feed for this library:

feed://discussions.apple.com/rss/rssthreads.jspa?forumID=599
--
My Google Reader Shared items (feed)

Choosing a DNS: What namebench showed me

I use OpenDNS for its domain blocking properties and I switch OS X Location to GoogleDNS when I want to bypass the filters [1]. I used to use my ISP's (Qwest) DNS servers.

So what did Google's free cross-platform Namebench DNS Server testing utility show me?

OpenDNS was my fastest option at 72 ms. [2]However OpenDNS is "hijacking" "google.com" and "www.thepiratebay.org". Google didn't have any good explanations of this, but (interestingly) Bing did (first time I've had Google fail and Bing succeed).

The hit Google omitted, but Bing showed, explained that OpenDNS proxies Google because of an evil trick Dell and Google have played on Dell customers for two years. Funny how Google missed that one.

I couldn't find any explanation of OpenDNS hijacking of "thepiratebay.org".

After OpenDNS came UltraDNS then General Mills-MG1 US and Google Public DNS. Google was 50% slower for us than OpenDNS.

[1] Even in Snow Leopard every machine user gets the same Location settings and, except for Simple Finder, any user can change it. Sooner or later the kids will figure out how we are getting around OpenDNS blocks and we'll have to do something else.

[2] There's a meaningless 1ms overhead because the LAN DNS is my AirPort which in turn goes through my Qwest modem.

Update 1/24/10: When I revised some DNS information at Dreamhost, OpenDNS updated quickly but Google didn't.

LogMeIn Hamachi - Free for family networks

Hamachi is a shareware VPN application. LogMeIn is marketing a free version for non-commercial use.

Alas, I think it's Windows only.

--
My Google Reader Shared items (feed)

Time Machine: Fail first, then flaw discovered

At the very end of attempting to restore a 40GB iPhoto Library named “Current” from a Time Machine / Time Capsule backup I got this message [1]:

The Library “looked” ok, so I tried to open it:

Since a backup is only as good as the restore, I pronounce Time Machine to be worthless [2].

Actually, worse than worthless. The inclusion of Time Machine with OS X has largely eliminated alternatives. It’s malign.

I’m not completely surprised. The chaotic state of Time Machine/Time Capsule documentation is a pretty good indicator that the product is troubled.

I’ll count myself lucky this time. I discovered that my main photo library backup, containing about 10,000 irreplaceable images, was worthless.

How am I lucky?

I have two other backups, including a straight file copy that I’ve verified works. So I learned I couldn’t rely on Time Machine at the cost of a couple of hours of lost time. It could have been much worse.

I’m going to next test a restore of this library from my Retrospect Professional/Windows backup.

[1] For Google: “You cannot copy “Current” to the destination because its name is the same as the name of an item on the destination, except for the case of some characters.

[2] This error message could mean anything. Don’t take these things at face value. The fact that it occurs at the very end of the restore is curious. I did try a reboot but I didn’t try rebuilding because even if that had seemed to work I wouldn’t be able to trust that my image library was truly intact

Update 12/31/09: Retrospect Professional did restore my iPhoto Library, so it won this contest. Nice to know one of my backups worked! It does, however, deserve its reputation as insanely difficult to use. It was also exquisitely slow, though it's running on an old XP box and my backups are huge.

I did, however, find a clue that might explain the Time Machine failure. After I did my restore I discovered my "Pictures" folder had incorrect permissions. My user account had read-only permissions for the folder (why? no clue.). So I wonder if Time Machine tried to write something to the containing folder when it finished its backup, that failed due to a permissions problem, and then produced a misleading error message. I may try an experiment to test that.

Update 1/1/2010: My experiment concluded; the Time Machine restore worked. The bug is that Time Machine fails to check permissions on the target folder prior to the restore. It will attempt a restore that almost works, then fails at some critical last step. This problem may only show up when a Package is being restored into a Folder for with the user (and Time Machine?) does not have write permissions.

I filed an Apple Developer bug report: 7504890.

--
My Google Reader Shared items (feed)

HoudahSpot fixes Spotlight -- for a steep price

HoudahSpot is, like the now defunct MoRU/FileSpot, a tool for extending Spotlight.

At $30 it's not cheap, most apps of this sort go for $10 to $20. On the other hand, it's not like there's much competition, and it's not like Spotlight is getting much better.

It's crazy, for example, that Spotlight doesn't have a "path" column (folder names). HoudahSpot does. HoudahSpot also plays nice with LaunchBar and PathFinder. On the other hand, HoudahSpot's Help file is pretty crummy.

I've started a two week trial. I'll update this post if I buy the app.

Google's Pages to Sites migration - train wreck

About a year ago Google announced it would sunset their old Page Creator platform in favor of Google Sites. This would have been better received if Sites were a better product, but it's been stuck on "the sick list" for years.

The migration was supposed to happen mid-2009, but our Minnesota Special Hockey site survived until this week.

So did Google use those six months to develop a brilliant migration tool coupled with extensions to Google Sites?

No. Of course not. The result of the migration is a train wreck.

For example, most of the attachment links are scrambled. I think some of our documents (attachments) may have been lost. A large collection seem to exist as "attachments" to the root directory -- but there's no mechanism to link to them.

Thanks Google. Merry Christmas to you too.

Update: When I first posted this I thought Google had merely messed up. The longer and deeper that I look into this the more the fiasco resembles staggering incompetence at a level rarely seen outside of high school and failing corporations. WTF is going on at Google?!

Update 1/6/10: Despite our support contract, Google never responded to an email inquiry. Most recently, I discovered that a bug in their update process deleted a significant page. Turns out that if you had an existing Sites page and a Page Creator page collection, the contents of an existing Site could be wiped out by the migration.

--
My Google Reader Shared items (feed)

Surprises from an old zip archive

For years my personal data was distributed between DOS/Windows/XP and Mac Classic/OS X environments. It's really only moved to a single OS X share within the past six months, and I'm still sorting out the archives.

Which is why it was only today that I discovered that OS X couldn't open MS-DOS zip files from 1990. WinZip did open them, though it complained of an unspecified security risk each time I opened a file.

The funny bit is that unzipped files came out, total, to about 2MB. Zipped they were about 1MB. So I was zipping them in 1990 to to save 1MB.

No, not 1GB. 1MB, aka a millionth of a terabyte. In those days I guess that mattered.

I've expanded them all now. Most of the documents were written in WordPerfect. I can get the gist of them from a text editor, but Word 2003 opens them pretty well. (Since they go back to DOS they don't have standard file extensions -- back then I used ".LTR" for "letters" and ".TXT" for documents.)

The take home lesson, of course, is that compressed archives are very vulnerable to data loss. At least a WordPerfect file can be read in a text editor.

--
My Google Reader Shared items (feed)

Enabling use of a large external USB drive with an older BIOS: disable legacy USB support

This is a pretty exotic fix, but I'm not the only one to run into the problem so I'll pass on what I learned (I found the link after I fixed the issue).

I have a vintage 2003 XP box Intel motherboard with an Intel P4 motherboard. It's needed periodic brain surgery but I make as few changes as possible. This is geriatric computing -- don't mess with things that work.

The most persistent annoyance I've had came when I moved to 1TB external drives for backup:

Gordon's Tech: My review: LaCie 1 TB USB 2.0 External Drive 201304U

... I discovered I couldn't start the system with the USB drive on. I have to restart with the drive off, then leave it off until startup is done. I don't think this was a LaCie problem, I suspect other causes...

I don't restart often, so I've mostly ignored this. I does cause some pain however, so recently I spent a few minutes plumbing the BIOS.

Briefly, I had to disable "legacy USB" support. Once that was done the system starts normally. I spotted this by turning on the BIOS settings to show all startup messages and do a full (slow) startup -- I could see it was hanging at a USB step just after checking the keyboard.

Since I was in the BIOS I made a few other incidental changes. I no longer use Serial or Parallel ports (yeah, old machine) so I disabled those. I also told the BIOS to use PnP (which I see I also did in 2003 so it looks like I reset the BIOS back to defaults sometime in the past six years).

See also:

• Windows startup stuck when connecting to external drive? - Yahoo! Answers
• Vista Boot Hang w/ USB Drive Connected [Archive] - MajorGeeks
• Computer won't boot with USB drive plugged in - Maxtor OneTouch Products - Seagate Community Forum

--
My Google Reader Shared items (feed)

Using OS X Spaces, Expose, Minimize and Hide - best practices

I had to take another look at Expose and Spaces when a relative asked me to review their use.

I'm again struck by a perennial mystery. Why don't we have more "I'm an expert, here's how I manage X" type documentation? I'm sure the team that developed Expose and Spaces had clear ideas on how they were to be used. No, not a list of features, but rather an explanation of how an array of possible features are should be used -- and, more importantly, what should be avoided.

For example -- I can't figure out any use for minimizing windows to the Dock. Once you do that they can't be managed by Expose or Spaces, and they can't be closed as a group. Dock minimization feels like an obsolete function that now causes confusion. Likewise, how do the Mac Classic legacy operations application operations of "Hide App", "Hide All" or "Hide Others" mesh with Expose and Spaces?

Expose, Spaces, Hide and Minimize -- we really do need a true power user to explain what they use and what they carefully neglect.

Since most of my real work is done in corporate XP I'm not a true OS X power user - but I can take a whack at the problem. This is what I do at the moment:

• The application-specific Hide functions: I no longer use them. I feel as though they've been replaced by Spaces and Expose.
• Expose: I use "All Windows" and "Desktop". I've mapped Ctrl-D to Desktop because I'm used to Windows-D on XP to show the Desktop (Cmd-D is a shortcut that works in many file menus to set the focus to the Desktop so I used Ctrl rather than Cmd). I want to start using F10 to show all Application windows, but on the newest Apple laptop-everywhere keyboards there are no dedicated Function keys. I think Apple is deprecating Expose:Application Windows.
• Minimize to Dock: I avoid this like the plague. I do find "Close All" (option click on close menubar icon) very useful to clean up a mess of browser windows.
• Spaces: This is useful on my MacBook display, less useful on a my desktop (27" i5 + 21" LCD). I'm trying to get used to using it everywhere however. I'm experimenting with using only 2 screens, and mapping the Finder to one. So one screen has my file manipulation stuff, everything else is in the other screen.

I find typing "exp" or "spa" in LaunchBar is the fastest way to invoke Expose or Spaces; it's more convenient than using a mouse or a kb shortcut.

Anyone have alternative approaches to suggest?

Update 12/30/09: Azendel, writing in comments, tells us that Apple fixed "Minimize" in 10.6. Minimized windows now appear in Expose. That's a relief since "Minimize" is fairly prominent in the OS X user interface; the Leopard Minimize/Expose incompatibility has been a frequent irritant.

Update 1/3/2011: I made a very good stab at using Spaces over the past year. I like giving Aperture its own Space for example, so it could use the secondary monitor without messing up other apps. Over time, however, I ran into more issues with app windows being split between Spaces. I also suspect, but cannot prove, that some App crashes are related to windows being split between Spaces. I now think Spaces is not quite ready for primetime. Since "Leo" (10.7) has a different Finder/Spacers model, and since Apple's newer kbs have "Expose" keys but not "Spaces" keys I think Apple knows this too. I'm going to return to using Expose (improved in 10.6) and experiment with Minimize and Hide.

Update 1/29/11: See Using OS X Spaces, Expose, Minimize and Hide - best practices 2.0

--
My Google Reader Shared items (feed)