Lost Path in import script step

[freelancer]

I searched the posts but I it didn't seem anyone had the exact same problem as me. Here it is :

I have a script that imports data from the current found count in another Filemaker database that sits on another server. The thing that happens, is that it looses the path everytime I import. So every time I want to import data, I have to go to my import scriptstep and browse to the file I want to import from. But when I look at the import script step before I "repoint" the file, the IP address is still there...(??), but it doesn't import at all and it doesn't show me any error messages... After I repoint the database I want to import from, the extension of the file shows in capital letters...

For example :

Before : Test.fp5(100.5.4.52)

After : Test.FP5(100.5.4.52) and then it works.

I have no clue what's going on...I would really appreciate it if someone could help me with this...

Thanks!!

[Fitch]

Do your import, setting the order and options as needed. Then immediately create a separate script that has only one step, Import(Restore). Now your import settings are saved. In your original script, delete the Import step and instead use Perform Script (your new import script). This will also make future troubleshooting easier.

Another thing to note is whether the "save relative path" checkbox is on or off in the dialog where you choose the file to import. I generally favor having it on, but you could try it both ways and see which works.

[BobWeaver]

There is also a strange bug in Filemaker that causes it to change the file path stored in a script step if the file can't be found when you run the script (such as when the server is offline). This won't happen if your import sub-script starts with a "Set Error Capture [on]" step.

[freelancer]

Thank you very much for your time. I passed in all my import scripts and unchecked the bex "Save relative path only" and it seemed to solve the problem.