Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Creating a Data Dictionary in FMP9

david.michaels
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

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.

Check out this thread.

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

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.