Adam's Apple

Use Your FileMaker Pro Databases on Your iPhone

Adam Rosen - 2008.10.06 - Tip Jar

Popularity: LEMLEMLEM

del.icio.us Bookmark in del.icio.us Slashdot Suggest to Slashdot

Low End Mac Reader Specials

Memory To Go Special: MacPro 8 Core 8GB kit $232 / 4GB kit $116 / 2GB kit $72. New Macbook 2GB DDR3-$65. HARD DRIVES available -- Free shipping / LIfetime warranty.

Download Typestyler, still the Ultimate Styling Tool for Internet, Print and Video Graphics. Works great in Classic with a Native OS X Version on the way. Free Tryout: www.typestyler.com

LA Computer Company: Specials on AppleCare, iMac's, Apple Batteries and Apple A/C Adapters. Also Great prices on Used Apple Computers. Call 1-800-941-7654 Click Here.

Mac users can finally play Party Poker for Mac. Not only that, they can also learn how to play PokerStars for Mac.

Laptop Hardware Provided by TechRestore - Overnight Mac & iPod Repairs.

Compare products like desktop computers, laptops, and LCD TVs side by side! All the information and reviews to make the best purchasing decision for a new cell phone GPS products or MP3 players. The Ciao network makes searching products easy for you.

I recently joined the ranks of the iPhone enabled and am having a generally marvelous time with my new iToy. One of the best features is how seamlessly the iPhone works with my Mac's Address Book and Calendar data, directly via Apple's Sync Services. No third party data conduit is needed - unlike Treo or BlackBerry handhelds, a frequent source of headaches for many of my clients.

However, on my Mac I use Apple's Address Book only for email addresses and instead keep my personal and business addresses in FileMaker Pro. I've used FileMaker for many years and have a set of linked databases that manage my business contacts and invoices. I need a way to get this contact info on my iPhone.

Unfortunately there's no iPhone app from FileMaker to address this need. An older product, FileMaker Mobile, has been discontinued, and the company has made no announcement as to whether they intend to support the platform or not. FileMaker only suggests using the program's web publishing feature and accessing your data via the iPhone Safari web browser. This can be useful in some instances, but it requires effort to create and host the database - and it's not the same as having a local copy of your data on your iPhone

FMTouch

Fortunately an enterprising third party has stepped up to fill the void: FMTouch is a $70 iPhone app available from the iTunes App Store. With this application on your iPhone, a bit of data massaging on your computer, and some trial and error, you can now have full working FileMaker databases right on your handheld.

You will need FileMaker v8 or v9 on your Mac (or PC) to start. You will also need to install a synch plugin for FileMaker on your computer, which talks to the FMTouch app running on your iPhone. After installing the plugin, relaunch FileMaker, then launch FMTouch on the iPhone. On initial setup there is a one-time pairing (similar to Bluetooth devices) you will first be asked to do, via entering a code on the handheld to synch with the computer.

All layouts in your FileMaker databases will be available on your handheld. For best results it's recommended you create one or more layouts specifically designed for the iPhone. The iPhone screen size is 320 pixels wide by 375 pixels high. A good online design guide has been provided by the developer. I have found it helpful to create a 320 x 375 pixel background for my layout in a graphics program, import that as a JPEG into my FileMaker layout, then overlay fields and text to stay within these boundaries.

Once your database is ready you need to generate a DDR file, which the FMTouch application uses to access your database on the phone. FM Web School has provided an online DDR creation service to create the necessary .xml file. To use this service, make an empty copy of your database by using File > Export > Clone (No Records). Save the file with a .fp7 extension and use only letters and numbers in the filename, no special characters. Then use the Finder to make a .zip archive of this file and upload the archive. In a few minutes you should get a link to download your DDR file.

Note: If you have a copy of FileMaker Advanced on your computer, you can export the DDR file directly using the Tools menu. See the FMTouch user guide for full documentation.

Now you're ready to synch your database to the handheld. Open your database again in FileMaker on the computer. On the iPhone, launch FMTouch and create a new database. Hit the button to upload a DDR file, and (on your Mac) choose the DDR file you just created. Once that's loaded, initialize the database, then click Sync to transfer data from your computer. Congratulations, you now have your FileMaker database on your iPhone or iPod touch!

Usage and Limitations

This solution is welcome and useful. Email addresses and phone numbers in your database act as links for sending emails or making calls on the iPhone, as they do with Apple's Address Book. Data synch is a two way process, so any changes you make on the handheld will be transferred back to the computer at next synch. It took a few rounds of trial and error to get my layout tweaked appropriately, but all I do now is synch the database every few days as needed.

Implementation is fair but not yet ideal; there are some bugs and rough edges. Database scripts on the computer are not currently supported on the handheld, though the developer notes they are working on this for a future release. Layouts larger than a single iPhone screen often don't scroll or resize correctly. Each time you make changes to a layout, you need to create a new DDR file and send this to the phone.

For best results I've found it best to completely delete, then recreate, my database on the phone when updating the DDR file, rather than updating an existing database. Also, synching must be initiated manually via several button presses - not really very hard, but not as convenient as the auto-push service happening with email and calendar data via MobileMe. The app has also crashed a few times, requiring reboots of the iPhone. Hopefully these issues will get addressed in future releases.

The creation and layout updating processes can be somewhat labor intensive and are not for the technically faint of heart. But the developer is a young company and responsive to feedback.

As of this writing (Oct 2008) this is the only way I know to interact with local Filemaker data on your iPhone. It's a solution I use daily, and has been worth the effort to get it working. LEM

This article was originally published on Adam's Oakbog website. It has been adapted and reprinted here with his permission.

If you find Adam's articles helpful, please consider making a donation to his tip jar.

Recent Adam's Apple Columns

Links for the Day

Recent Content on Low End Mac

Recent Deals

About LEM | Support | Usage | Privacy | Contacts

Entire Low End Mac website copyright ©1997-2008 by Cobweb Publishing, Inc., unless otherwise noted. All rights reserved. Advice presented in good faith, but what works for one may not work for all. Please report errors to .
  LINKS: We allow and encourage links to any public page as long as the linked page does not appear within a frame that prevents bookmarking it.
  Access our RSS news feed at http://lowendmac.com/feed.xml.
  Email may be published at our discretion; email addresses will not be published without permission, and we will encrypt them in hopes of avoiding spammers. If you prefer your message not be published, mark it "not for publication." Letters may be edited for length, context, and to match house style.
  PRIVACY: We don't collect personal information unless you explicitly provide it. For more details, see our Terms of Use.
  Low End Mac is an independent publication and has not been authorized, sponsored, or otherwise approved by Apple Inc. Apple, the Apple logo, Macintosh, iBook, iMac, eMac, iPod, iPhone, PowerBook, MacBook, MagSafe, Mac Pro, Apple TV, and AirPort are registered trademarks of Apple Inc. Additional company and product names may be trademarks or registered trademarks and are hereby acknowledged.


Have a question?
Ask an expert!

Navigation

Used Mac Dealers
Apple History
Best Used Macs
Video Cards
Email Lists
InfoMac's Low
End Mac Forum

Favorite Sites

MacSurfer
MacMinute
MacInTouch
MyAppleMenu
InfoMac
Macs Only!
The Mac Observer
Accelerate Your Mac
RetroMacCast
PB Central
MacWindows
The Vintage Mac
   Museum
DealMac
DealsOnTheWeb
Mac2Sell
ramseeker
Mac Driver Museum
JAG's House
System 6 Heaven
System 7 Today
the pickle's Low-End
   Mac FAQ
Abandonware
   Petition
Mac vs. PC Info

Affiliates

The Apple Store
Mac Connection
MacMall
TechRestore
MacResQ
ExperCom
Crucial Memory
batteries.com

Advertise

All of our advertising is handled by BackBeat Media. For price quotes and advertising information, please contact at BackBeat Media (646-546-5194). This number is for advertising only.

Open Link

Problems viewing this page with Internet Explorer 5.5 or 6? It works fine in other browsers, including IE 7. We recommend Firefox for those using Windows, as it is standards based and more secure than IE 6 (and earlier). More LEM visitors use Firefox than any other browser.