FileMaker Developer 7

The new FileMaker is out! I got my shiny box last week, it came when I was in Detroit. I have been playing around and am about to post a First Look article. I want to go through the changes in ScriptMaker, then I will post it. So stay tuned. I am not going to be using FileMaker 7 for any of the solutions I have created for Student Publications. So why did I buy it? Because I need to be ahead of the curve. I need to know about all the changes. And eventually I will be moving the Unigraphics invoicing system, the KEY Yearbook purchasing database, etc, over to FMP 7, but not right this minute. They have changed too many variables. And since it is a new file format, we would need to upgrade to FileMaker Server 7 which comes out this summer. That being said, I could do a lot more with 7, and it is well worth the work, in my opinion, to port everything to 7. The one glaring omission I see is no "import file/table" feature in the Define Database dialog. FileMaker now acts like a SQL database, or day I say MS Access, you now have multiple tables in one file. Before v. 7 you had one table per file. FMI could have been nice and included a consolidation feature. That would have been great. Well leave it to the plugin community to fill a void. Both New Millennium and .com Solutions has tools out to help move a multi file solution into a single file, multi table solution. FM Robot from New Millennium is a table consolidation utility. It takes the Database Design Report (so you need Developer, not just Pro) and consolidates all your files into one multi table file. I might invest in this tool. New Millennium makes good software, so it looks like it would be worth it. Only the Windows version is available right now, so I think I will wait until they release a Mac version. Although I might just get the PC version to have it now, I do as much developing in FileMaker on Windows these days as I do on the Mac. What really makes sense about FM Robot is its ability to duplicate tables within a FileMaker 7 file. You can also build a "library" of "template tables" which you can transfer into any new solution. Very cool. FmPro Migrator from .com Solutions does not look like it as easy to use, as you need to install ActiveState Perl on Windows (although I have used ActiveState's Perl before and it is a breeze to setup). FmPro Migrator has a much broader scope then FM Robot though. FmPro Migrator will migrate FileMaker Pro databases to MySQL, Oracle, Access, SQL Server, Sybase and DB2. It now includes a FileMaker 3,4,5,6,7 to FileMaker 7 table consolidation feature, and Microsoft Access to FileMaker 7 migration feature. Both sites have detailed feature pages and screenshots available, so check them out. There is a demos to try as well. I can't say anything for the accuracy of either of these tools, but considering how much different FileMaker 7 is from v. 6, I can't see either tools being 100% accurate with regards to calculations, scripts, privileges, and relationships. I will have to buy one and see how it fairs. FM Robot looks like an easier to use tool, but FmPro Migrator has a much more robust feature set.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Warning: include(/home/meancode/public_html/breakingwindows/footer.php): failed to open stream: Permission denied in /home/breaking/public_html/2004/03/filemaker_developer_7.php on line 191

Warning: include(): Failed opening '/home/meancode/public_html/breakingwindows/footer.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/breaking/public_html/2004/03/filemaker_developer_7.php on line 191

Blogcritics Magazine

Social Networking

Mac Headlines

Read up-to-date headlines on everything Mac.

Content provided by prMac.

ESRB Search

Creative Commons License
This weblog is licensed under a Creative Commons License.
Enhanced with Snapshots