Re: FMP question -- for Shane Stanley?
Re: FMP question -- for Shane Stanley?
- Subject: Re: FMP question -- for Shane Stanley?
- From: Paul Berkowitz <email@hidden>
- Date: Wed, 01 Nov 2000 00:04:18 -0800
On 10/31/00 2:06 AM, "Shane Stanley" <email@hidden> wrote:
>
> It could be that the 'Import Records [Restore, No Dialog, "Current File"]'
>
> FM Script command requires the foreground, even without the dialog. (In
>
> AppleScript, I rename every file to be imported as "Current File" each time,
>
> then rename it back to its original after processing.) Anyway, that's one
>
> thing that can't be applescripted except as a 'do menu', which calls up a
>
> choose file window, etc. So it looks as if I'm stuck with the flash-to-front
>
>
Depending on how much data there is, and how much you're concerned about
>
time. AS is slower to do the same thing, but it also lets you build in all
>
sorts of checks.
Yes. Just for the exercise, I've done it all ("it" being importing
tab-delimited text files into an FMP database) in AS. It stays in the
background, as you said it would, but importing 2 text files with a total of
10 records (lines) to be entered into 7 fields (a few others are calculated
by FMP, which seems to take no time at all), then checking for duplicates,
takes about 15-20 seconds vs. about 1 sec running the FileMaker script and
flashing to the front. (Since the script runs from Entourage, that would be
a nuisance if you were in Entourage, since you couldn't do anything else
while the script was running. That's more of a nuisance than the
flash-to-front. But read on.) It can do a more sensible duplicate check than
the internal FMP script. It seems that this script will run on a dedicated
machine, so neither the flashing to front (FMP) nor the alternate slowness
(AS) is really a problem. I'll go with whatever does the more accurate job,
which seems to be AS, as you say.
I can't find a way to get or set field labels in AS, BTW. Suppose you were
making a new database, or adding a field, in AS. Don't you need to set the
field labels somehow?
--
Paul Berkowitz