Creating a Data Dictionary in FMP9

[david.michaels]

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. I did find a database that was a data dictionary "proof of concept" in these forums, but I am not certain how I would use that to get the data I need.

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 your time.

[Fitch]

Check out this thread.

Also you should know that with FileMaker Advanced, you can output a DDR (Database Design Report)in XML or HTML.