Exporting data between two databases

[jsoren]

Good evening,

I want to be able to export data from file ABC.fp7 to CBA.fp7 automatically. Is there a script that allows this and how can the files run dynamically?

Thank you for your time

[Fenton]

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.

[jsoren]

Thank you for your response Fenton. I was also wondering though is it possible to make it automatic?

[Genx]

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

[Lee Smith]

Do you mean as in Every day at 3:00 pm?

If so, you're going to need a plugin (Eventscript, Activator, etc.)

HTH

Lee

[Genx]

Or VBScript and windows scheduler.