Re: Advise: Keeping Track of 12,000 FMP5 Records
Re: Advise: Keeping Track of 12,000 FMP5 Records
- Subject: Re: Advise: Keeping Track of 12,000 FMP5 Records
- From: Jean-Marie Hoornaert <email@hidden>
- Date: Sat, 18 Aug 2001 16:36:36 +0200
le 18/08/01 15:44, Jason Bourque a ecrit :
>
Hello,
>
>
I need some advise.
>
>
I have a client who needs to process 12,000 + FileMaker Records over the
>
network with AppleScript. The script creates excel files from each record.
>
>
>
When triggerd for a weekend run, sometimes the server will go down and the
>
AppleScript will timeout and forget where it left off.
First thing to resolve : why the server will go down?
>
Any ideas on how to keep track of where the script left off.
>
>
My ideas.
>
>
Increase the timeout for a few days.
>
>
Create a text log with the record id in it.
I think this is the best solution. Write to a log file after every export.
And delete the log if every record has be export properly.
You can comment every export on this log, and read the record to continue
the export where it was interrupted.
>
Check for the creation of the Excel doc in the destination folder.
>
>
I think the whose statement for searching might work but I might run in to
>
the limitation of lists. I.e. Every record whose cell "cellname" is not in
>
{list of 5000 items}
Sorry, French is my first language, Dutch my second and ...
AppleScript my third.
--
Cordialement (cordially)
Jean-Marie -HOO;-)
____________________
Jean-Marie Hoornaert
email@hidden
http://www.h2o.be
AppleScripting FileMaker
French web site