It worked, so I haven't touched it for years. Now it's one more thing I have to transition from my Palm to the iPhone.
I was hoping that FileMaker would resurrect FileMaker Mobile for the iPhone, and add encryption. That would be perfect. Alas, I don't see it.
So I'm looking at dedicated password storage apps like the list on the left, including 1Password, eWallet, SplashID, etc.
There are three criteria other than an established user base and a good reputation:
- It has to work on the iPhone (native app).
- It has to sync with my iMac
- It has to be able to import tab delimited data exported from my FileMaker database
- It has to have good export options.
- There has to be a good demo app I can test.
The above screenshot shows it can import in many formats. More importantly, it can also export as tab delimited and as 1Password Interchange File.
So how do I import data from my FMPro database? The 1Password documentation is pretty terse:
1Password User GuideProblem is, I need to know what all the possible import choices are, so I can create an export from FileMaker Pro for further testing.
... In addition to the above formats, 1Password has a Generic Importer that can import any Comma or Tab Separated Values. To use this, specify Generic Text as the Import Format.
The Generic Text importer will allow you to specify which columns in your CSV file should be used for each 1Password field...
I created an entry in 1Password then exported it as tab delimited. I found the following list, I've bolded those I can provide from my database:
So I'm not sure I'll give up on the FM database, but it looks like I can, for the moment, export it to 1Password so it's available on my iPhone.
At $35 1Password isn't cheap, but if it passes my import test I may go for it.
Update: It took over an hour to import 1400 rows, so it's pretty darned slow. That's not a big deal though, it's quite fast to search them. Turns out these are the available columns on import:
- Notes 1, Notes 2, Notes 3, Notes 4, Notes 5
Search runs against Title and Notes, so this concatenation works for my purposes.
One major limitation is that you can import into Web Form and Secure Note, but you cannot import "Wallet items". You can export Wallet items however. The inability to import a wallet item is very annoying, though I can see why that is a harder task for the developer. Wallet items use a different data model for each type of item, so a tab import is less likely to work. I will probably use "Secure Note" for another JFile database that holds that type of information.
Update 8/7/08: After the above things got messy. I couldn't get the sync to work at all. 1Password technical support pointed me to firewall instructions, and explained something that really should be documented on the web site:
... 1Password is fully functional for 30 days, with no limitations. After this time, should you wish to continue using it for free, you will need to store fewer than 20 items...This is a great demo policy, it just needs to be documented. There are other things that could use some documentation. It turns out there are firewall changes to make, but that's only documented in a support forum thread:
Firewalls can prevent the iPhone/iPod touch and Mac applications from connecting to one another. Please check if you have firewall turned on (System Preferences > Security on Leopard). Details for Leopard. Tiger is quite a bit different: Details for TigerI turned off my 10.4 firewall and was able to sync. I'll try it later with the firewall enabled and the port they recommend set up.
Update 8/14/08: I think 1Password uses the OS X Keychain. That has some nice features, but it is unbelievably slow to delete large numbers of items or add large numbers from an import. Slow, as in seconds per transaction! It feels like AppleScript speed.
Update 9/2/08: Unbelievable. I went to buy 1Password, and I learned it uses a "license token". I hate those, because they're a pain to backup and manage. I want a registration code. I'm going to contact support, but this is a real stinker of a deal killer.
Update 9/4/08: About the same time as I wrote my 9/2 post, 1Password relented. The current version supports entering a text un/registration number that they provide via email. I found out because I let them know why I wasn't going to buy 1Password, and they quickly responded that I wasn't the only person who was unhappy with the encrypted token approach -- and they were now providing both options. So I bought it.