Import From One Table to Another

[Salesman0Gil]

Hello All,

I have a annoyance that I've been dealing with for a year or more.

If you script an import from one table into another table in the same file. It does not work smoothly if you use server. It always ask you where the file is. If you open the file on the client side, it works fine.

Any Ideas?

[Breezer]

i actually have a lot of scripted imports from the same file but I havent encountered any problems.

Could it be you haven't specified (and saved) the path to your host?

From the Import Records script step, click on the drop down list, select "File...", then place a check mark on "Specify data Source". A specify window will pop-up, click on "Add File..." and locate your host (using "Remote...") to specify the path of your file (and this will be the saved path that Filemaker will check first, and if there's no path specified, will produce the dialog even if you have "Perform without Dialog" specified, sometimes)

[Salesman0Gil]

Yes I've tried that

I've even been through the whole defining file references thing. I actually wasted a great deal of time on it.

Currently, I just manually locate the file.

Like I said before, it works great if you open the file as a client, but if you open it remotely it gets hosed. And this happens on every file...

[Breezer]

Have you tried using the Filemaker Network Path?

fmnet:/hostIPAddress/filemname

If yes, I would go ahead and include the "Relative path", the "Full path" and the "FileMaker Network path" just to be sure that Filemaker will ALWAYS find the path.

[davidtraveller]

I'm having the same problem. I have a machine in th office running FileMaker Pro 8.5 (not Server) and sharing it. I have a remote user coming in through VPN and using Open Remote to run the app.

When my script does an Export Records, it creates the CSV file on the user's Desktop, so I would assume that's the current file path. However, the Import Records step won't find it and opens the File Open dialog box, even when Desktop is the current file path.

Very annoying. Anyone know of another way to copy a record from one table to another?