FileMaker Pro 7 Description:

FileMaker Pro 7 review:
1 stars (Do NOT buy this.) - I just upgraded to version 7. Every other negative comment made by others here is true, plus they just do NOT answer e-mails. I was unable to register my upgrade copy. I sent four e-mails and not a single one was answered. I finally called and was told there was a bug in the registraion of "some" copies and not to type my name in the name field, but my company name and leave the company field blank. Yup, that worked.



Now, if the registration is that buggy, they have no e-mail customer support, and the upgrades are OUTRAGEOUSLY expensive (and see other reviews for lack of fit and finnish), why would you buy it? I'm very sorry I did.



File Maker 8 is coming out and the upgrade is $179. I'd rather use shareware.
1 stars (Do NOT buy this.) - I just upgraded to version 7. Every other negative comment made by others here is true, plus they just do NOT answer e-mails. I was unable to register my upgrade copy. I sent four e-mails and not a single one was answered. I finally called and was told there was a bug in the registraion of "some" copies and not to type my name in the name field, but my company name and leave the company field blank. Yup, that worked.



Now, if the registration is that buggy, they have no e-mail customer support, and the upgrades are OUTRAGEOUSLY expensive (and see other reviews for lack of fit and finnish), why would you buy it? I'm very sorry I did.



File Maker 8 is coming out and the upgrade is $179. I'd rather use shareware.
4 stars (The app I use most and teach others how to use...) -

A good deal of what people have written about this product simply isn't true, particularly negative observations such as not being able to import/export or that security is non-existent. Why people with only cursory knowledge speak with such authority has always puzzled me. So I offer an objective, if lengthy, review.



I've been using FileMaker since 1990. Developing FileMaker applications has been my primary source of income for almost as long. I develop in Mac OS X (Virtual PC with Windows 2000 Pro for testing). I've also tech edited an upcoming advanced book on FileMaker 7.



Version 7 is a huge upgrade over 6 (I'd call it a 'crossgrade', as in switching to similar but different product). As such, converting solutions from 6 to 7 can get really hairy, and it may be that a complete re-write is more efficient. That said, many FileMaker solutions that people have developed or inherited over the years weren't written following "correct" database rules (this is why IT types hate FileMaker), so a re-write may be a good thing. Generally, an upgrade to 7 is brought about by a need for larger file sizes, to increase the number of simultaneously open files or to consolidate data. If you've got a solution that works fine in 6 or earlier and you're not a developer, I'd think two or three times about upgrading; it's not something you want to do for the sake of it.



For users, that is people who enter data, the changes in 7 aren't apparent. It's the back end, for us developers, where the changes are significant, plentiful, and very welcome. If you're just getting started in the world of FileMaker, forget all about any earlier versions. The rules have changed in 7, and it's almost more difficult to unlearn what you know from 6 than to start fresh in 7.



FileMaker has a scalar learning curve. That is, it's easy to learn and get up and running in really no time at all (and there are plenty of free sample files to take apart and learn from). As your database becomes larger, more complex and gains a need for multiple simultaneous users or interaction with other systems, knowing the normalized rules of relational database structures becomes increasingly important, and that's where the learning curve steepens. But don't let anyone fool you, this is true of *any* database development software.



Building a database is a lot like being the architect of a building. You have to have a good idea of what it's going to look like in the end, before you start. For example, if you know your one-story house is one day going to be a 4-story mansion, you want to have a good foundation. If you know you might want the ability to relocate a bathroom to the other side of a floor, you've got to build in some room at least for plumbing, electricity, maybe some windows. It's not a realistic analogy, but it usually helps people understand the thinking involved around creating a database.



I firmly believe FileMaker is the easiest of any to learn, use and maintain, that can also handle whatever complexity you throw at it. Further, it's cross-platform and things like networking your databases and making structural changes (even remotely, without bringing down the system) are really a breeze compared to programs like Access.



Lastly, one of the neatest things about FileMaker is its developer community, which is today thriving and strong. Almost like an open-source coummunity, we seem to really enjoy helping solve each other's problems (no one person knows everything about FileMaker, even at FileMaker, Inc), so we're always learning. There's plenty of free community support available that, I've found, is often better than the company's own tech support, although the folks at FileMaker are really great and genuinely into supporting the developer community. And...there's plenty of money to be made as a FileMaker developer the world over. We're certainly in demand and have been going strong for nearly two decades.



You can read FileMaker's feature list to find out about all the new features. Here are my likes and dislikes:



What I like most about 7:



* Multiple tables in one file (with an 8 terabyte limit per file; formerly 2GB).

* Multiple windows from the same file, and the ability to manage their placement dynamically, down to the pixel.

* The ability to separate data from logic (for example, keep your data in one file, and all your scripts and interface elements in another...changes and solution upgrades to your clients are much easier to facilitate this way).

* Much improved security and account management (that supposedly plays well in authenticated corporate environments...I'm just getting started in this area).

* The ability to use PNG images with transparency, which greatly improves what you can do with your interface.





What I DON'T like about 7:



* All my complaints boil down to FileMaker's interface. I strongly believe a complete overhaul is way overdue (if it were like Omni Graffle, I'd be in heaven). There are plenty of little annoyances because I use a Mac. For example, I have a Microsoft 5-button optical mouse. The scroll wheel, which works in every single application (even on FileMaker for Windows using Virtual PC on my G5), doesn't work at all in FileMaker for OS X. This is ironic because FileMaker is wholly owned by Apple, but development for the Mac seems have been an afterthought. Much of this will change in the next version, just around the corner. I wouldn't dream of developing primarily in Windows, largely because of the way Windows OS handles windows and value lists within FileMaker; you have less room to work with.



* The relationships graph, which sort of looks like an ER (entity relationship) diagram but is not, can get messy very quickly, and they've taken away the ability to look at relationships in a straight text list (I'd like both). This can get frustrating, especially if you've inherited someone else's mess. The fact that FileMaker has implemented a certification program for developers, and is working actively on releasing development standards will help reduce confusion and frustration in this area.



* The inability to move tables, fields, script steps, etc. from one table or file to another. Improvements in this area are expected in the next version.



* The inability to see how elements are related to each other. For example, it's not possible to see all the elements that call a script (i.e. a parent script or button, etc.). There are software tools that can analyze FileMaker files and expose this information, and they work great, but it would be nice if it were integrated into the program itself.



* It's a minor complaint, but worth addressing here: A number of things don't work like you'd expect or want them to, so you have to create workarounds. This appeals to the geek in me; I usually like the challenge, but sometimes it's frustrating because you'll think it's silly that something simply doesn't work like you want. That said, over the years there is nothing, really nothing in terms of complexity that I have not been able to achieve with FileMaker by itself or with the help of a plug-in. People ask me "Is it possible in FileMaker to..." I always answer yes before they're finished. It's sometimes a "Yes, but..." answer. For the snotty programmer types, I challenge anyone to name database development software that is impervious to workarounds, OR that does not have a high learning curve. If you don't have a background in databases, FileMaker is a great path. If you do have such a background, open your mind and you'll find that no, FileMaker is not the end-all-be-all database app (such an app doesn't exist), but it really is a neat and productive tool, and if you can build good solutions that manage your client's data, they will loyally worship you.