Saving Export orders

[martincm]

Hi there,

I have a problem with exporting to *.tab files. I'm running 3 databases on a separate filemaker server which are controlled and hosted by Filemaker Server 5. The clients which connect to it are Filemaker Pro 5.

I have several functions in one of the three DB's which make it necessary to export and import records. Every function is at least done once manually tot set up an Ex- or Import order and then the script is adjusted to disable the dialog box and make the procedure fully automatic.

Now here's the problem. When this database is hosted by a client an others connect to it, it works just as fine with the export and import functions. But when this database is hosted by Filemaker Server then every time users close the database on their clients ALL export and import orders are completely lost. Like it resets itself.

I have no clue what to do, I tried to run 2 databases on the Filemaker Server and this one hosted on a separate Filemaker Pro client but this doesn't seem to work when FM Server is hosting already.

Any help appreciated, thanks in advance.

Gr Martin

Edited August 19, 2005 by Guest

[-Queue-]

How are your import options (Restore, No dialog) set? Do you have more than one import or export step in a script or are they each in their own script, the way they should be?

[martincm]

Ofcourse every Export or Import action has his own script. although it's possible to have serveral buttons assigned to various export or import scripts within the same Database (ie. Export all records and a script for exporting only a chosen few).

I've used the export scripts this way:

Restore order -> not checked

Dialog box --> not checked

But for every script I ran it ONCE manually WITH dialog box to assign and save export orders.

Again with a FM client serving as a host for others this is no problem, it works fine and FM can handle the scripts with the appropriate orders without showing the dialog box. Though when serving this database through the FM Server to others, all the orders are lost (like a reset) after closing the database and logging in a next time. The message that returns while trying to do a export action is that "there are no fields selected to export".

[-Queue-]

Once you run a single export/import manually, open the appropriate script and select Restore and No dialog, then click OK and select Replace for the export/import order. It should then be saved. If it does not work, create a test file and see if it works. If it does, then your original file may be corrupt.