Exporting from FM to Hosted FM File

[jrr316]

Hello All,

I am working on a system in which I will have a centrally hosted database. Let's Call It "ServerVersion.fp7."

My remote users have limited network access and in some cases no access. So there will be a client version. Let's Call it "ClientVersion.fp7."

So my Client will add records and work off site and come back to the office and want to sync their data to the server version.

So what I have setup is a Calculated Primary Key. It uses a serial number, hostname and host mac address.

So the relationships are solid and should be unique enough to not cause any Calculated PK duplication.

Now my issue:

I can import data from the Server and all the records show and all is groovy. I have a script that goes through each data table and imports them into my client version. The script is run from the client DB.

I can however not export the data to the server consistently. I basically need to run the same script but in reverse order.

Any advice?

[jrr316]

I did alot of testing with this issue,

What I did was create Table Occurances for each table on both the Hosted and local file and use utility layouts to do the importing.

-Justin