1 Reply Latest reply on Apr 5, 2011 8:30 AM by philmodjunk

    Creating a Data Dictionary in FMP9

    DavidMichaels

      Title

      Creating a Data Dictionary in FMP9

      Post

      I have been tasked with analyzing approximately 50 FMP databases running on FMP Server 9 (not Advanced).  I have FMP Client 9 on my local computer.  I do not have a lot of experience with FM, but I have experience with SQL and relational databases.


      I am trying to pull the data field names, data types and comments for the databases into a spreadsheet.  I have discovered that I can print the field information, but I don't see an option to export it as a CSV for import into Excel.


      Is there a simple query that I can run against the databases to extract the information I need to compile a data dictionary in Excel?


      Thanks for any help you can give me with this task.

        • 1. Re: Creating a Data Dictionary in FMP9
          philmodjunk

          You might research 3rd party Filemaker utilities to see what they offer for this.

          You can also use FileMaker Advanced to generate a database design report that includes all field definitions in each file. The report format can be HTML or XML so that may give you a way to import from the report into your spread sheet (but I'd look into using FileMaker instead of Excel for this myself...)