Scripting Imports and Exports

[johnhmoody]

I'm trying to find the absolute best solution for scripting the export of a single record from one hosted database and importing into another. I'm trying to develop a single button solution as the majority of my co-workers aren't saavy enough to manually export and import each time. I first created a script that exported the current record to a file on the server, then ran an external script in our Closed Customers database that imported that record. However we have OS X and OS 9 on the same network and we're running into some issues, so i switched the script to simply omit all records except the current, then the Closed Customers script imported directly from the hosted database instead of using a separate file containing the single record. However, this script takes literally an entire minute to run even though both databases are already open.

Any suggestions? Thanks!

[Fitch]

I think you're right to import directly from one file to the other, there's no point in exporting first. Try a self-join based on the record's serial number (I assume each record has some kind of unique i.d. field). Go To Related Record [show only related] is generally very fast -- use it instead of the Omit procedure, that's where I'd guess the slowdown is.