Jump to content

Exporting data between two databases


jsoren
 Share

This topic is 5602 days old. Please don't post here. Open a new topic instead.

Recommended Posts

To pass data from one FileMaker file (or table) to another you don't have to Export from the original file (table). You Import into the receiving file (table). First you have to Find only the records in the original that you want to copy to the other, leaving the file open,* then you go to the receiving file and Import Records. All of this can be scripted. It is also possible to export to a text file, then import, but it's not necessary. Read about Import in the FileMaker Help.

*It's important to leave the original open, because FileMaker will import all records from a closed file. Sometimes convenient, but not in your case.

Link to comment
Share on other sites

Sure, script it in File CBA. I.e. Make a new script in File CBA, call it import from ABC or something. Anyway, then add the Import Records[] Script step and specify File ABC and the import settings.

Then, if you want you can either run that script in CBA, or add a file reference in ABC (define --> File References) that points to CBA (just store them in the same directory, then if you move your files anywhere its not an issue because the filepath is relative) anyway, then add a new script in ABC, add the Perform Script[] Script step, but then, where it lets you choose file, choose CBA, and choose the script you made in CBA before.

It sounds complicated, but all we're doing is:

Creating the import script in CBA

Adding a reference to CBA in ABC (so we can call scripts)

Call the script we made in CBA from ABC

Link to comment
Share on other sites

This topic is 5602 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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