Books FileMaker Resources Web/Tech

First Available FileMaker 7 Book

SamsTeachYourselfFM7in24hrsOK. I ordered my first FileMaker 7 book tonight from Amazon: Sams Teach Yourself FIleMaker in 24 Hours by Jesse Feiler. They are saying it is available and in stock now! There’s one review at Amazon from an experienced FileMaker user and she is quite positive about the book. Kinda doesn’t matter to me. It’s a FileMaker 7 book. I want it. Damages only $16.99.

By the way, Feiler has written lots of Macintosh books and two FileMaker books including one on scripting and calculations. I take that to mean he’s a pretty good writer and knows enough FileMaker to provide value.

I plan to buy several FileMaker 7 books. And a bunch are in the works. I’ll be writing more about books soon.

Migrating to FM7 Web/Tech

How to get 6 with FileMaker 7

Little Known Fact Department

Those ordering FileMaker 7 can get a FileMaker 6 installation CD and installation codes as a free add-0n by making a request that FileMaker 6 be included so that they can gradually migrate to 7 and run FileMaker Pro 6 until they are ready to switch completely to 7.

fmp6 box smallI haven’t tried this request yet, so I don’t know all the particulars. But I’ve been assured by multiple parties that it works. Individual product purchases and upgrades may not be covered. Volume licenses are covered. It appears that the only way you get this deal is when you buy direct from FileMaker Inc.

If you have any question about your readiness for 7 and you don’t already have FileMaker Pro 6, buy yourself some extra flexibility. You don’t have to choose between 6 or 7. Get both. Purchasing 6 without 7 makes no sense and, at this point, purchasing 7 without 6 makes equally little sense.

FileMaker Pro 7.0 (please note the “.0”) is a new, complex product with immature support around it. As with any product upgrade of this magnitude, it has more bugs, limitations and rough edges than it will have once it is subjected to the scrutiny and demands of early adopters. This is not meant as criticism. FileMaker 7 is surprisingly useable and reliable – already. But, if you have a mission critical application, it’s too early in FileMaker 7’s product life-cycle to be switching over.

Anyone with a significant investment in FileMaker who is eager to gain the benefits of 7 should be working on migration preparation and planning, experimenting with FileMaker 7 development while still relying on FileMaker 6 for anything you depend on.

FileMaker Wishlist Web/Tech

FileMaker 7 Portals and Parameters

At the moment good information about FileMaker 7 real world behavior is still in short supply. One source I found recently, The Blinkerfish Logs, has a really nice post on FileMaker 7 as it pertains to portals, related records and script parameters. FileMaker heavy, Ernest Koe, has written some high quality stuff: potent, compact, important, useful information. Check it out!

FileMaker Wishlist Web/Tech

FM7 Emergency Wishlist – Part 1

FileMaker 7 Conversion Needs to be Fixed

FileMaker 7.0 bears a lot of resemblance to OS X 10.0. When you have a total rewrite like I’ve heard that FileMaker 7 is, you don’t get everything on day one. It just doesn’t happen. My Emergency Wishlist series will focus on the most striking missing features in FileMaker 7.

Without a doubt, the biggest missing is a more robust and full-featured conversion capability. I don’t really care how this is addressed as long as it is addressed.

Perhaps the biggest problem is that when you convert a group of interrelated FileMaker 6 or earlier files, you don’t have the option to put them all in a single file. When you convert 16 files, you get 16 files. Each with one table in it.

A major benefit of FileMaker 7 is that you can have multiple tables in a single file. You can work more efficiently this way for a variety of reasons that I won’t go into here.

There are many other smaller conversion issues that can present problems for you. The worst is that scripts can break or produce disastrous unexpected results like deleting records that should not be deleted. This is such a fearsome possibility, that anyone who reads the Getting Started manual or otherwise finds out that FM7 migration is something to be careful about, puts testing and cataloging possible problems at the top of their migration checklist.

Third parties are working feverishly to provide utilities that will help since there are many information and utility gaps to fill. Things will get better – soon, I hope. My guess is that FileMaker Inc. is also going to help us out at some point in the next months with perhaps a more robust conversion utility or facilities that address specific migration issues.

I’ll be writing here about every major development in terms of information, tools, techniques, tips, warnings and rumors.

My Emergency Wishlist series writing is to acknowledge what’s true. To take note of the most glaring omissions in FileMaker 7 in hopes that these issues will get the attention they deserve in a timely manner. Stay tuned.

FileMaker Wishlist Web/Tech

FM7 Migration Bible Available

The FileMaker consulting and development community has been waiting in anticipation for this promised tech brief from Danny Mack et. al. called FileMaker Pro 7: Migration Foundations and Methodologies (12.4 mb). I’ve been checking periodically at FileMaker Inc’s FileMaker 7 Upgrade Tech Briefs page for over a month – it was *due* in early April – and finally found it this morning.

It’s big. It’s 140 pages long plus an essential 56 page appendix called Conversion Issues and Resolutions. Right now, this is the bible for upgrading to FileMaker 7. If you have a FileMaker system that is important to you and you are thinking about upgrading, make sure that you or your consultant/in-house expert sets aside the time – and reads this.

The book is divided into three sections: Foundations, Methodologies and the Appendix. Foundations is a series of articles or chapters written by Danny Mack and other leading lights in the FileMaker community. Methodologies is less conceptual and more practical but also strategic. Here’s the Overview from the book:


Leveraging the Value Proposition of FileMaker Pro 7 – Michael Thompson
Michael discusses the advantages of FileMaker Pro 7 from the point of view of both developers and business owners, and addresses the strategic issues associated with migrating to this new technology, including how to recognize a return on the investment in migration.

The FileMaker 7 Relational Model – FileMaker, Inc. and Danny Mack
A fundamental article of the new relational model, including a comparison to earlier versions of FileMaker Pro, an introduction to the relationships graph, and an explanation of “context”. It illustrates the new features and the new rules with easy to follow examples.

File References in FileMaker Pro 7 – Corn Walker
File references are viewable and editable in FileMaker Pro 7 and the issues associated with them are fundamental to getting your converted solution up and running successfully.

Scripting Issues Encountered When Migrating to FileMaker Pro 7 – Darren Terry
In converted solutions, certain scripts may not function as they did previously. Darren reviews these issues in detail so that you understand how the behavior has changed, and what to do about it.

Security and Access Privilege Issues – Steven Blackwell
Passwords and groups are converted to accounts and privilege sets, but the rules have changed. Understanding the details of access privilege conversion is essential to replicating the original behavior or extending it.

“Record Ownership” in Converted Solutions: Opening and Committing Records – Ilyse Kazar
The script steps and other events that cause records to be opened (locked) and committed (unlocked) have changed signifi cantly. This has major implications for the behavior of converted solutions as well as for new solution design.

Migration and Web Publishing – Bob Bowers
This is a primer on the realm of FileMaker 7 web publishing, including both Custom Web Publishing and the entirely new Instant Web Publishing.


Conversion Basics – Danny Mack
Danny presents a step-by-step orientation to the conversion process, including preparation, testing, and the necessary fundamental tasks for getting your solution “restored” to its original functionality.

Adding a New Interface File to an Existing Solution, Later Consolidating Tables – Todd Geist
How does one migrate a solution, most reliably and economically, to an optimal FileMaker Pro 7 architecture? Todd lays out a step-by-step migration strategy, including a rationale that may leave you thinking: “why would you do it any other way?”

The Separation Model: A FileMaker Pro 7 Development Model – Colleen Hammersley & Wendy King
FileMaker Pro 7 is a dream come true for those who have long advocated the separation of data and interface. Colleen and Wendy present the new application model in all its glory.

Bridging .fp5 and .fp7 – Ernest Koe
There are many real world scenarios in that it will be necessary for FileMaker Pro 7 files to exchange data with FileMaker .fp5 files. There are several technologies that make this possible.


Conversion Issues & Resolutions – Team
This is the documentation of specific issues that can be encountered in solutions that have been converted to FileMaker Pro 7, and suggested resolutions (what you can do to replicate the original behavior). The issues are cross-referenced to the behavior changes in the application documented in the .pdf entitled “FM 7 Converting Databases”.

FileMaker Wishlist Web/Tech

Could FileMaker Talk to Google and Mapquest?


Today I was preparing a mailing to all of my FileMaker clients. I wanted to warn them about the fact that you can’t just upgrade to FileMaker 7 from previous versions without giving it a second thought. One of my customers called today and said she bought FileMaker 7 because she upgraded to OS X. I told her that she should return it because the FileMaker 6 she already had would work fine in OS X and unless she wanted to spend some money on tweeking before and after, the system I built for her was going to break in 7.

This was not the first customer doing a FileMaker 7 upgrade *on-the-fly* without consulting me first. So, to avoid further problems, I wanted to do a mailing to all my past and present FileMaker customers. Since I haven’t worked with some of my customers for few years, I don’t have all their email addresses. In many cases, their phone numbers had changed too so I couldn’t call to get their email addresses.

This is when I thought that it would be great to have a *Google* button right in my FileMaker database that could Google anyone’s full name or company name with one click. If I could do that, then the next step would be to create a script and button that could Google a set of records and return data to me on what it found. I’m guessing that I will be able to create a Google button for one person. And that’s probably as far as I’ll go for now, but if someone wanted to build a little plug-in or custom function that would Google a FileMaker Found Set and return records, I’m ready to plunk down the cash!

Later, I was looking for a great restaurant to take my Dad to for his birthday. I got a good recommendation after trying Google and not really finding what I wanted with assurance it would be good. So I wanted a map for my sister and went to Mapquest. I had already entered the restaurant into my database for future reference and actually dragged the Mapquest map right into a Map field I had available in the database.

That worked, but why couldn’t I have a Mapquest button that would go to Mapquest, get the map and put it in my database for me based on the address that was in the database already? That would be so cool. In this case, if I can do it for one contact, I can definitely run a script that would put maps into every record (thousands) in my database. Learning about web services and FileMaker is starting to seem like a great idea.

Anyone want to build something like this? It’s relatively simple if Mapquest has an open API and I’m sure tons of FileMaker users would be interested.

FileMaker Discoveries Migrating to FM7

FileMaker 7 Security is Sweet

FM7_box_120px_wide.jpgAfter screwing up my courage and reviewing my error list from MetaDataMagic today, I decided to just go ahead and convert my files and see what happens. Looking at MDM’s conversion issues report and looking at my Studio Manager database, I could see that I’ll need to check a lot of things systematically but the nature of the problems is such that it might work to make the adjustments after conversion.

This breaks the general guideline suggested by FileMaker 7 migration guru, Danny Mack, but I’m planning on multiple trial conversions of my product anyway and wanted to see what would happen when I just threw the FileMaker 7 conversion switch.

First, the good news. The conversion took less than ten minutes. Nothing blew up. I didn’t need a fire extinguisher or anything. Remember, I did clean up the file references before converting and ran MetaDataMagic on my files and reviewed the error list and recommended fixes. For each recommendation, it tells you whether you should make the changes before or after you convert or that you can do it either way.

I have 4 levels of groups and passwords in my Studio Manager files. I wondered what would happen with them. My first experience was good. I was able to use my master password to get into my files after the conversion, using the master password for both the account name and the password as I had read I should. Whoopie!

My luck didn’t last long, though. When I clicked on a script-protected tab or file navigation button, I got my self-authored “sorry, access denied” message even though I was logged in with the master password. I wasn’t surprised – I wasn’t expecting miracles. I just went in and looked at my security calculations and security checking scripts looking for a culprit and couldn’t figure it out.

Next, I changed the master-access account name (formerly the group name) to “master” to match my security calculations but that didn’t work. The calculations were actually using the privilegesetname not the account name, but I was still getting my sea legs and wasn’t crystal clear on the distinction yet.

Notice that I was focusing my attention on technologies I was familiar with. Finally, I got smart and cracked open the new Define Accounts & Privileges command. There I saw what some of you already know – the master access privilegesetname is hard-coded to be “Full Access”. So I just went around and changed my security calculation fields to use Full Access instead of master and things started working!

One other little problem occurred around this. When I opened my files for the first time in FM7, I was offered the option to remember the passwords and I said yes to all. Seemed like a good idea at the time. But then I ran into the problem that I had not entered the master password in one of the files which has a special secret password and now it was set to automatically open with a lower level password by my OS X keychain.

Not to worry, I looked up keychain in the help and found the keychain entry for the file I was having a problem with and after futzing around for a while just deleted it. That worked! This time when I tried to open the file, I got an account and password prompt and could enter the high-end account and password. Good to go!

Now that I’ve conquered these little hiccups in my security learning curve, I am really getting psyched. I know how incredibly easy the keychain stuff is. Opening my FM7 Studio Manager files will be effortless. My system password protects all these saved account names and passwords along with all the other passwords I have. Thanks, FileMaker Inc., for making your password and privileges system compatible with the OS X keychain! FileMaker Inc. is owned by Apple, so I guess it’s about time, but thanks anyway!

For years I’ve steeled myself to the fact that the password and security part of FileMaker has been convoluted and unintuitive. It was the one thing in FileMaker I hated to use. Now, even though the new FileMaker 7 security is much more powerful, it’s easy. It’s straight forward. For a FileMaker geek like me – it’s fun!

FileMaker Utilities Migrating to FM7 Web/Tech

MetaDataMagic 2 Roadtest, Part 2


MetaDataMagic 2 rocks bigtime! I did two new things with it since my last report:

  1. Fixed the File References in my product.
  2. Built a Conversion Issues report for it.

Both of these functions are excellent with the second providing more value to me than the first.

Prior to FileMaker Pro 5.5, you couldn’t specify that you only wanted relative file references which are great because if all your files reside in one folder, then you can move that folder anywhere and none of the file references break. Prior to 5.5, less robust file references like IP addresses were stored and, worse, the references weren’t directly accessible for modification. They are in FM7, but even so, the manual method can’t compete with MDM’s file reference powertools.

There’s an *auto-fixer* that will eliminate all references to files outside your solution *and* convert and set your file references to *relative path only* – all the rest go away. I ran auto-fixer without a hitch in less than 2 minutes on my complex 27-file Studio Manager product. That’s time savings!

I had tons of file references in these files and was left with the minimum I need to have things work correctly and as fast as possible. I’ll let you know when I try the performance out how much performance gain I get in FM6 and FM7.

Whoa! This thing is amazing! New Millenium has identified a total of 82 different possible issues so far. I had 23 of them applicable to my solution. Of those 23, 18 were considered high impact and 7 medium impact. You get a brief description of the element that is causing the issue and then a potentially multi-paragraph description and pointers directly to the files impacted in your solution so you can go fix them right now.

I was tempted and on the verge of converting my Studio Manager files to FM7 without doing much cleanup in the hopes everything would be OK until I ran this report. Here’s just the first 3 of 23 conversion issues found:
(42) Go to Related Record button function
(216) Go to Related Record Script step
(25) External subscript transfer focus to another file

Ack! Those numbers in parentheses beside each issue are the number of occurrences of that issue in my files. I’ve got some serious work to do. It will be easy work with this information and tool but it will be a lot of work.

Luckily, I will at least have a hope in hell of doing the fixes in an organized way and I can run the report on my files to see where I stand in handling the issues. There’s a checkbox that lets me tell it to ignore that issue for now which I bet will come in handy.

You get the Conversion Issues database free when you download the trial version of MDM2. There’s a lot of information in there. Go forth and download!

FileMaker Utilities Migrating to FM7 Web/Tech

MetaDataMagic 2 Roadtest, Part 1


I’ve run three complete FileMaker 6 databases through MetaDataMagic 2 with no problem in the last 48 hours. The biggest one so far, my Studio Manager product, took about an hour to process with its 27 files and tons of fields, layouts and scripts. I was quite pleased with the level of detail of information I got and the ease of getting it.


I love that I don’t just see a progress bar during the analysis but instead a list of records with time elapsed as each analysis task is completed on each file. There are 27 analysis tasks. Some tasks are quick and others take longer. The longest task in most situations is going to be *get layout item data* – that’s the step where every layout object is itemized and described down to it’s exact position on the layout.

One of the most interesting pieces of information I found out about my Studio Manager product was how many times files had not been closed properly. Many of these files have been around for several years and I could scan the list to see how much wear and tear they have endured. Good to know. In one file the number of improper closes was 20. Since I’m having no problems with it, I won’t do anything about it right now, but this information would go into my decision-making for whether or not I would want to rebuild it from scratch in FileMaker 7. I like this information!

The process. Here’s what I did to get started.

  1. Went to New Millenium’s website and downloaded MDM using their shopping cart
  2. Cracked open the ReadMe file for basic operating instructions.
  3. Opened the main FileMaker file.
  4. Decided which system to analyze first.
  5. Clicked the *Process a New Solution…* button
  6. Selected the folder to process, entered master passwords and clicked *Go*
  7. Immediately up came a second window with records listing progress and duration
  8. I watched most of it go because it was fun and then did something else while waiting for completion
  9. Then I jumped to looking at any error listings.
  10. Next stop was the Files Not Closed Properly list…
  11. Later, I wanted to do a 2nd analysis for files for one of my clients.
  12. To do that, I just duplicated the folder for the first analysis, renamed it and started MDM up again.
  13. Then I clicked the *Delete all Metadata* button.
  14. Then clicked *Process a New Solution…*

I needed one of my analyses for a specific purpose: to give my client a correct list of relationships in all the files so that she could double-check them to make sure they were correct. She had opened files from a remote machine when only some of the files were open on the server and some of the relationships got misdirected. I was able to go to the Relationships file for her analysis and quickly send her a pdf by email.

More soon as I use MDM 2 for helping me analyze my product’s readiness for conversion to FileMaker 7!

FileMaker Utilities Migrating to FM7 Web/Tech

Just bought MetaDataMagic 2


I just completed my purchase and download of version 2.0 of MetaDataMagic by New Millenium. Version 2, released last week on March 30th, is an essential tool in migrating your existing FileMaker files to FileMaker 7. Here’s why:

  1. It incorporates Danny Mack’s new Conversion Issues Reporting Tool and as it creates its detailed analysis of your files, it also records any conversion issues it finds (Danny is the author of a 27 page document on FM7 migration that is featured on the FileMaker, Inc site right now and the author of FileMaker 7 Migration Foundations and Methodologies that is due out any day now – he gave an excellent presentation in Santa Clara on behalf of FileMaker, Inc. regarding FM7 migration in February).
  2. It includes a File References Fixer that streamlines the process of eliminating extraneous file references in your files so they don’t slow things way down when you convert to FM7. The File References Fixer will also help you clean up FileMaker Pro 6 files to their benefit.
  3. It includes their Conversion Log Analysis Tool – which helps you analyze the conversion log for errors

Maybe you are still on the fence – trying to decide whether you want to put your money into this product. I was convinced by the essential migration features, but I’m also really looking forward to the extra system analysis documentation tools not available elsewhere such as:

  • Relationships: sort spec, with fields and value lists.
  • Layout items: text blocks, graphics, and buttons, including coordinates
  • File stats: times not closed properly, times recovered

I expect to run MetaDataMagic on at least one of my FileMaker solutions in the next 24 hours. So, stay tuned for my first person reports. 😉