1 Reply Latest reply on Dec 11, 2009 1:44 AM by comment_1

    File Maker Pro and GUIs/Templates



      File Maker Pro and GUIs/Templates


      I am a UNIX admin but have been given the job to sort out a problem with FileMaker Pro so forgive me if I

      get the terminolgy incorrect.


      My client has an instance of what was FileMaker Pro 4.1 which was setup so that the office staff

      could keep a register of office files.

      No doubt an admin account was created but the only account the staff have access to is one called guest.

      This account lets the staff create a register of office files using a GUI, which is all that

      the software was configured to do.

      Well times have changed, they have since upgraded to XP sp2 and Filemaker pro 7.0v3

      now they want to be able to query against the database but the current permissions don't allow this.


      I have tried all of the password recovery techniques I have found on this forum but haven't been able 

      to recover the admin password. As this is a govt site I haven't gone looking to buy a password

      recovery tool as this would be my last resort as there would be to much red tape to get to use it.


      I have been able to export the database into a CSV file with the intention of importing it back into

      a new db and fixing up the permissions, access and correctly recording the passwords.


      Only issue here is that they are using a GUI to populate the required fields for their 

      file regestry db.

      I can import the db back into FileMaker but cannot find out how to associate the db to the

      original GUI.


      I haven't been able to find this GUI either on the web or in their software repositry.

      From research it appears this GUI is somehow attached to the db so if I need to update or

      change servers it is just a matter of copying the db file to the new server.

      If needed I can create a new db and have the users re-enter the data manually back into 

      the db. From research I believe the GUI may have been called 'Business Template'


      My questions are:

      a) is the GUI associated with the software or database?

      b) if I reimport the data back into another database is it possible to associate the database to the GUI?

      c) if the GUI is in another location what would the file extension be so that I may find it.

      d) how do I associate the GUI to the new db?


      Once this is done they want to be able to upgrade to the latest version of FileMaker Pro


        • 1. Re: File Maker Pro and GUIs/Templates

          A Filemaker solution file (a .fp3 file, in your case) contains data, calculations, layouts, scripts, value lists, etc. all in one (somewhat similar to Excel, in this aspect). It can also contain relationships to other files, which together constitute a "solution" (each .fp3 file contains one table).


          How many files does your solution have? And what is so special about their GUI that couldn't be recreated in a couple of hours using the current version? The most important thing is the data. If you know how to export all of it, then there will no need to re-enter it manually.