Re: Importing flat files into FMP
Re: Importing flat files into FMP
- Subject: Re: Importing flat files into FMP
- From: Emmanuel <email@hidden>
- Date: Tue, 26 Nov 2002 19:50:15 +0100
At 12:10 PM -0500 26/11/02, Arthur J. Knapp wrote:
> Date: Mon, 25 Nov 2002 14:16:27 +0000
> Subject: Importing flat files into FMP
> From: Eric Schult <email@hidden>
> I'm trying to import flat text files into FileMaker Pro, and so far it's
> VERY slow going. I favor use of Tanaka's OSAX over Open for Access to read
> the files. My experience over the years has been that it's faster and the
> syntax is easier.
Your experience has served you well, but I'm afraid that it is your use
of so many scripting addition calls per record that is really slowing you
down.
I would second that. I would second also building up a big
tab-delimited file, and then importing into FMP while crossing
fingers (Arthur does not mention the fingers).
Here are a few reasons why Eric may save time by choosing Smile for this job.
- Smile = text editor + script editor + in-line command runner with
persistent context, so testing would probably be facilitated and
shortened
- Smile can execute loops in the background, so the user can
interrupt the process and still be able to restart from the current
file, the user can change some parameter (set wantWindowVisibles to
false, e.g.) while the loop is running, in short the user does not
loose interactivity
- if such a job is to occur again and again, it's natural to build
progressively a handy interface to help entering the required
parameters, controlling the job, monitoring the progress etc.: Smile
is pretty convenient for that.
Emmanuel
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.