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.

Export records into existing .fp7 possible?

Featured Replies

After a *lot* of climbing of the learning curve, I got my Import function to work. (thank you 360Works for ScriptMaster selectFile() ).

I figured I could write a similar procedure to 'archive'/export individual database records. So, I copied my original database (Members.fp7) and created (MembersArchive.fp7).

In my Members::Export Script, I selected MembersArchive.

When I opened MembersArchive there was all the data, but the Layouts, scripts etc have ALL been deleted. huh? It seems like Export isn't the way to go. It seems like Export is geared to sending .fp7 into spreadsheets etc. But, there is an .fp7 'type'?

Would I be better off if I would just OPEN Members.Archive and run an import script.

Is importing the only way to get a found set or a single record into MembersArchive.fp7???

Thank you

Open the MembersArchive file and IMPORT the desired records from the Members table.

  • Author

Thanks. That's what I thought. Good to have the confirmation. Thank you.

  • Author

By the way, I need to import just the found set or just a single record (and it's related records). I didn't see any Import options that would apply these restrictions on the Source. Or, am I missing something?

thanks

You will want to run a script in the archive file that goes to the source file and establish the found set before import.

Or just open the source file. Perform your find, then from the archive file, run the import. Filemaker will import based on the found set.

What Ron said, but keep in mind that the source file must be open for this to happen. If it is closed, the target file will import all records of the source.

  • Author

What Ron said, but keep in mind that the source file must be open for this to happen. If it is closed, the target file will import all records of the source.

Ah ha!. That must be why I have so much trouble importing a found set. Thanks for the tip.

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.