Adobe Reader installer quits after ODBC Setup

Adobe is the most incompetent large software company on the planet Earth.

I really can't understand why they're still in business, or why anyone pays any attention to them.

I just ran into this bug -- it was well understood in August 2008 ...

Adobe Forums - AdobeReader 9 installer quits after ODBC Setup on Vista

... In my case this was caused by the presence of a MS ODBC setup.exe file programfiles\SAP\FrontEnd\SAPgui\FILC\odbc. This file was in PATH and thus triggered, I renamed the file temporarily and the install works. Probably goes for any file named setup.exe in PATH...

No other XP installer has this kind of problem.

Why is Adobe still in business? Won't someone rid me of this company?!

Applications for moving data out of OS X Address Book

After many years in which my address book more or less lived in a FileMaker database and Outlook/Palm I migrated it to OS X Address Book.

Now that Google is providing Exchange services for my iPhone it's time to move it again -- at least a part of it will live in Google.

This is a surprisingly gnarly task. I'm not sure what tools I'll use; I think I might end up doing some reconciliation work using Outlook 2007 and Microsoft Access 2007 because of the limitations of Address Book and FileMaker.

As I think this through, here's a list of tools I've come across for moving data from OS X Address Book (it exports VCF files).

• Filemaker vCard Creator: converts database records into a vCard file that OS X Address Book will import
• Address book exporter: Export as tab delimited. Fairly old, I'm not sure it works with 10.5.
• Address Book to CSV exporter
• Export Address Book: Multiple formats, about $15 or so
• A to G: Produces a CSV file suited to Gmail. Google recommended
  

Gmail contacts - now search works

It took a surprisingly long time for a search company to enable search across contacts:

Official Gmail Blog: Four changes to Gmail contacts

...Search across all contact fields
We've heard you loud and clear, and contact search now works much better: instead of just searching contact names and email addresses, it now includes phone numbers, notes fields, and mailing addresses as well. So, if you're visiting the Bay Area and looking for friends to catch up with, you could try typing '650' or '415' in the contact manager search box...

On the iPhone you can still only search by name and business, on the original PalmPilot you could search across all fields.

Google has made several changes to Contacts. In Google Apps you can now enable a "contacts" app that moves Contacts out of Gmail into their own context. Of course there's long been a secret URL to do the same thing.

I'm a bit disappointed Google has never restored the wonderful simplicity of adding email addresses in version 1 of Gmail. I recall you could post lots of addresses into a text field and Gmail would parse them.

Even so, it's good to see Contacts getting attention.

Access OS X Address Book records using OpenOffice database?

While idly browsing FileMaker forums contemplating the futility of Bento and the tragedy of FileMaker 10 and the theory that Product Managers hate me I came across a remarkable post:

Does FMP 10 have full integration with Address Book? - Using FileMaker Pro - FileMaker Forum

... I looked at addressbookmanipulator but it seems to be a development plugin. It costs $74 via credit card. It doesn't transform FMP in Bento with respect to address book integration :-( I would love to be able to select the address book as a data source in FMP.

Another promising option is OpenOffice 3.0. Its database wizard offers to connect to an existing database and lists Mac OS X Address Book as an option. When using it you get what seems a complete table for each Address Book group and includes the UID. The downside is that you can't edit the data ...

OpenOffice?

Well, yes. For example (read only, no edits):

• Omer Bar-or's Google summer of code integration project
• NeoOffice inherited this from OpenOffice
  

I'll have to give OpenOffice a try! It's sad that OO can do what FM can't. Along with the A to G Address book utility this may be another tool to use in my quest to create a unified work/home Google Contacts collection that will sync via Google's ActiveSync Exchange service to my iPhone.

Soon, victory will be mine (queue insane, evil, laughter)...

Update: Dang! OpenOffice 3 is still Intel only! If you try to download you get a "bouncer" error. On the other hand, you can download a pre-release 3.01 rc2 PPC version from a dev site (this is seriously weird, and not encouraging).

On the other hand, the Java based NeoOffice 2.x and 3.x preview both have PPC versions.

Update: Wow, OpenOffice 3.0 PPC is pretty spartan. Lots of redraw artifacts on my G5. It did open the data, but I haven't yet figured out how to export from OO Database in any format. A useful tool though.

Synchronizing iPhone and Gmail contacts: getting OS X Address Book into Gmail

Google recommends this utility for transforming an OS X Address book into the (yuch) CSV format Gmail can handle: A to G The easy way to get your Mac OS X address book into Gmail. This is one possible path on the way to using Google's ActiveSync implementation to sync contacts from iPhone to Google and gSyncIt to get them from Outlook to Google.

I'm approaching the problem of integrating my work, Gmail and OS X contacts with great care. It feels like juggling antimatter -- the data models are very different. There's a lot of potential arrow-of-time entropy risk -- data loss that can't be reversed.

One big confounder is the absurd persistence of CSV as a format for moving data around. That's was nice in 1970s. We should be using an XML transaction that ought to at least preserve line feeds in text notes. Unfortunately we should also be using object-oriented personal databases too, but the last of those died in the 1990s. (Anyone remember "Arrange" for MacOS?)

gSyncit vs Google Calendar Sync with Outlook 2007

Now that we're in the blessed era of iPhone ActiveSync to Google Calendar and Contacts I've been comparing Syncit for Outlook 2007 ($10) to Google Outlook Calendar Sync (free).

Both of these products have had serious bugs in past experiments. gSyncIt has the big advantage that it will also sync Outlook Contacts, Google's current Outlook Sync only does Calendar items. gSyncIt also has many more customization options.

On the other hand, gSyncIt does not do meeting attendees.

Neither can handle everything one can put in an Outlook meeting of course. Attachments? Puh-lease. For this reason alone all sync must be unidirectional (either way), bidirectional sync of this sort will only end in tears. (iPhone to Google Calendar, OTOH, is much simpler and mostly works.)

I'm thinking. I want to see how the Contacts goes, and I might hunt around for a third solution ...

Update 2/11/09: The gSyncIt Add-on is definitely causing Outlook 2007 outlook.exe process hangs. Not necessarily their fault; Microsoft's Add-ons have the same problem. The Outlook 2007 Add-on architecture makes DOS 3.1 TSRs look good. I've had to uninstall gSyncIt. I suspect the only safe way to get Outlook contacts to Gmail will be to periodically wipe them from Gmail, then export from Outlook and import into Gmail. Annoying!

Update 3/17/09: Google Calendar Sync was working until recently. It started giving me error code and nonsensical "connect to internet" messages. I had to delete my Google calendar data and redo the sync to make it work; nothing related to the error messages. Fortunately I only do 1 way sync!

Google saves my iPhone

Ok, so I don't know if it works, and I do feel sorry for the Nuevasync team.

Still, I'm grateful for Google's Exchange ActiveSync service service. With MobileMe hopeless and near worthless, and my iPhone love broken-hearted, things were looking pretty damned bleak -- until today.

Perhaps in honor of this launch, Google has an iPhone device page with lots of Google related topics in one place. The Sync set is towards the bottom of the page ...

iPhone Devices - Mobile Help

... Sync

• Overview
• Set Up Your iPhone or iPod Touch
• Choose Which Calendars to Sync
• Can I Still Sync with iTunes?
• Contacts Upload via iTunes (PC)
• Contacts Upload via iTunes (Mac)
• Synchronizing Contacts or Calendar
• Contact Search Feature
• Data Disappears During Re-Sync
• Known Limitations

No doubt about it. Google loves me. I ain't crawling back to Apple no more.

Update: Google licensed ActiveSync from Microsoft for this. I assumed they'd cloned it. I wonder what a ten million user license of ActiveSync costs? I don't imagine Microsoft gave Google much of a discount. It's an amazing testimony to the power of Microsoft's Exchange monopoly, and a marker for how serious Google is about making this work.

Update: It worked on our iPhone touch -- Calendar and contacts alike. I then wiped everything from the iTouch and proved I could sync just the calendar, and leave the contacts alone. That worked. Then I chose my sync calendars (config site is http://m.google.com/sync, you must visit it from an iPhone). I actually ran up against the 5 calendar limit (my work, emily calendar, my personal, MN Special Hockey and US Holidays), but that's good for now. The 5 calendar limit appers to be related to an iPhone bug.

So next I will sync and backup my iPhone and create special backups of my OS X Address Book and Calendar. Then, for now, I will turn off Spanning Sync while I do my testing -- so OS X iCal will no longer be connected to my true calendar (no loss).

Update: After backing up as above I'm on to my iPhone. It was already setup to do IMAP sync with my Gmail account; I added the Exchange server connection. I got the "invalid certificate" warning during Exchange setup -- that's a known bug. I turned Exchange Mail OFF, Contacts OFF (for now) and Calendars ON. I received the warning that existing calendars would be removed from my iphone.

After setup my Mail, Contacts, Calendar settings showed two accounts: one for Mail and one for Calendars. Although NuevaSync recommends turning Time Zone support OFF for Calendars Google didn't make any recommendations, so I left it ON.

I checked Calendar, and saw one calendar was synchronized. That was curious, since I'd configured the iTouch I'd specified 5 calendars.

Here's where things get interesting. When I visited the setup page I found configurations for two devices.

So you can sync multiple devices to a single set of Calendars, and you can configure separately which calendars each one syncs to. [or maybe not - see update]

Interesting ...

Anyway, so far it works.

Update: This is so cool. I play around with an item time on my iPhone, and moments later it's switched on my wife's BB Pearl (yech) and her Google Apps Calendar (yay). I'm holding off on Contacts for now; the Google contact model is pretty sparse. I want to give that migration a bit of thought. With Google for Calendaring and soon for Contacts I can live with Todo.App, Notebook.app and Evernote for a while longer.

Google has Gmail Tasks now. How long before they, or someone else, provides an iPhone Task app that will sync with Google Tasks? If they build out the data model I'd love to see Appigo selected for the iPhone app.

Update 2/10/09: Ok, maybe it wasn't a good idea to sync two iPhones to one account. When I go to http://m.google.com/sync I can't change which five calendars I sync to.

Update 2/14/09: It may be coincidental, but a day or two after I discontinued sync with the 2nd iPhone I was again able to edit my subscription limit (still only 5 calendars pending bug fixes). Incidentally, now that I'm getting Push Calendar updates I see why people complain about the iPhone's battery life. OS X wasn't built to be a power miser.

Update 5/22/09: Every few months the calendar seems to stop updating. I turn off "calendars" in the iPhone Exchange ActiveSync screen; that removes all calendars from the phone. Then I turn it on again. They then update normally.