FileMaker Pro

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.

Share tech news, updates, or what's on your mind.

Sign up to Post

Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5, "Upgrading or moving an existing installation" within "Filemaker Server 12 Getting Started Guide."  

1.  You may want to do a Windows Update on all client workstations before installing FM12.

2. Chapter 5 Upgrade does not say this, but if your version has it and you have FM Advanced, create a Database Design Report (DDR) and note or fix all "unknown" or "missing" notations.  The DDR opens into a web page and a Ctrl-F opens a find field to search for these notations.  After installing, create the DDR again and compare the number of these notations and fix.  We found a couple that did not seem to be there before, which means the upgrade missed a couple of references.

3. Of course, be sure to follow the Chapter 5 FM upgrade instructions step-by-step.

4. FM11 has a nice save feature for your existing schedules and groups.  Though it worked for us, don't rely on this; also make screen prints of all FM Admin Console pages.

5. After stopping Filemaker server, close the Admin Console BEFORE going to services and stopping the Filemaker Server service.  The FM instructions don't tell you to do this, but you will get an error if you don't.  The Admin Console page seems to use this service.

6. Before step 8 in Chapter 5, …
0
 
LVL 2

Author Comment

by:rvfowler2
Comment Utility
Thanks.
0
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?"

Answer: Yes you can. The attached file shows a simple method of opening a remote database via a double-clickable file.

In it's simplest form, a startup file has a single script that runs immediately upon opening. The script does two things: 1) it opens the remote database and 2) it closes itself.

Open File [ "MyFileMakerDB.fp7" ]
Close File [ "Current File" ]

You will need to select Specify your remote (or local) database in the Open File script step and make sure that Close File is set to "Current File". In order to make this run on Startup, go to File -> File Options, and under "When opening this file...", select the "Start" script under "Perform Script:"

In addition, it's helpful to have a way to stop the script before the file closes so you can edit it later. To do this, add steps that check to see if the Shift key is being held down and have it Halt the script using the Get ( ActiveModifierKeys ) calculation function. (The shift key is a 1, the Alt/Option Key is 8, the two together would be 9).

If [ Get ( ActiveModifierKeys ) = 1 ]
   Halt Script
End If

Once setup, this file can be distributed to other users and should work as a double-clickable launch file for the hosted database no matter …
5
 
LVL 2

Expert Comment

by:rvfowler2
Comment Utility
Actually, I just fixed it.  I had already opened your Start script and under the OpenFiles step, opened my first database by doing an Open Remote.  The part I was missing was in your file/db to turn on File sharing by going to File, then Sharing, then Filemaker Network.  It works fine now.

(Or did I get this wrong?)
0
 
LVL 25

Author Comment

by:Will Loving
Comment Utility
You got it.
0
Conversion Steps for merging and consolidating separate Filemaker files

The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes these files have been created separately intentionally or by someone who wasn't aware of the ability to have multiple tables within the same file, and sometimes such files originated as FileMaker Pro 6 or earlier files which were always one table per file.

This guide does not delve into the important issue of re-design and optimization of the database structure to take advantage of the consolidation, which should be an integral part of such a consolidation process. It simply addresses the how-tos of the process so as to accomplish the consolidation with as little 'breakage' as possible. The procedure list or order of steps below is my own summation of the process we worked out that would allow us to accomplish the process most quickly and spend as little time as possible doing repairs.

With regard to consolidation, in to any serious FileMaker development work in general, I strongly recommend the use of Inspector or a similar utility to assist with this process. Using the Database Design Report available in FileMaker Advanced, Inspector and similar utilities allows you to easily see where a script, field, layout, external file, etc. is referenced – or not. Which can be very helpful when you are trying to get rid of …
5
 

Expert Comment

by:David Simpson
Comment Utility
If you need help with the just the boring mechanical process of combining the files together into one single file as described in Step B, the FmPro Migrator Developer Edition software can help with this part of the project.

But the pre-consolidation and post-consolidation tasks listed in this article are very important - and cannot be automated with any software. I have read about solutions having 150 pages of scripting reduced to 2 pages as part of the merging process.  We have lots of ways to reduce code with newer FileMaker versions, like passing parameters and just basically not having to have little bits of code scattered among separate files will help a lot.
0
Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as picker selection screens, as mini information screens providing user instructions, etc.

Create a pop up window using the New Window* script step, usually followed by Go To Layout then Adjust Window (specify Resize To Fit).

The Move/ Resize Window script step can place pop up windows at a precise spot on the user’s desktop.  Instead of specifying exact positions in the Distance From Top and Distance From Left parameters of this script step, you can use calculations to make the placement of the window dynamic, responding to the current context of the user’s desktop.

A few extra script steps can position pop up windows relative to the main database window’s current position on the user’s desktop.  Wherever the main window moves, your pop up windows can be “smart” and follow suit!

The unlocked sample file attached to this article contains a script showing how to create smart pop windows. Variables are used to store a range of window measurements; Get(WindowHeight), Get(WindowWidth), Get(WindowTop) and Get(WindowLeft).  The values stored in these variables are used to perform calculations inside the Move/ Resize Window script step.  The end result is that the pop up window is positioned in the centre of the main database …
2
 
LVL 8

Author Comment

by:Tocacar
Comment Utility
Hi mark_wills

Thanks for your message.  I've just re-uploading the sample file and it looks like it's there now.  Hopefully it can be republished soon.

Kind regards

Tocacar
0
 
LVL 4

Expert Comment

by:rjplus
Comment Utility
Excellent contribution - thanks
0

FileMaker Pro

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.

Top Experts In
FileMaker Pro
<
Monthly
>