Jump 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.

Extracting Field and Record Data From a FMP

Featured Replies

  • Newbies

Hello,

This may seem like an odd request and I'm not sure where to post it.

I am a teacher and have been asked to pull data from my report cards ever term for the last 4 years.

My report cards are based on a FMPro 5 database (Ontario Report Cards) The data is the marks in English and Math. Instead of manual writing down the data, I am hoping that I can pull the data out of the assess fmp file and save it as a tab file.

I know the field information - like the English subject is subject_id 21 and the Mathematics subject is subject_23 also the information I need to move to a tab file is - gender, strand1_T1, strand2_T1 ...Strand3_T1 for both subjects.

I am just learning to use filemaker for making databases with my students, so I am a relative FMP newbie. Any help, direction to resources to help, or a possible solution. I would even be willing to pay someone to help me do it.

I will attach the file in case that helps. (Actually I had to remove the file because it contained student info sorry - I will try to find an empty file)

Thank you for your time.

Stephen, please move this thread also. smile.gif

  • Author
  • Newbies

Yes I would like to extract as a tab file.

Looking at the tutorial I will try and follow it to figure out how to extract the data into a tab file. I will let you know who it goes. I'm just concerned about running a script from another FMP file and calling the data in order to protect my original data.

Thanks,

Q

Create an account or sign in to comment

Important Information

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

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.