Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Scripting Imports and Exports


This topic is 8184 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8184 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.