Re: Filemaker and Database events
Re: Filemaker and Database events
- Subject: Re: Filemaker and Database events
- From: "Stockly, Ed" <email@hidden>
- Date: Mon, 14 Jun 2010 20:07:10 -0500
- Acceptlanguage: en-US
- Thread-topic: Filemaker and Database events
>>>> FMP's got one of the oldest and, in my opinion, best applescript
dictionaries around.
It seems to me that too much of filemaker is hidden from applescript in
favor of a different scripting model.
For example, there is no appleScript command to import a file. The only way
I could figure out how to do that was to create a filemaker script that
pointed to a dummy file in a set location, then write the data to the file
via applescript then trigger the filemaker script.
That, in my opinion, is not a sign of a good applescript dictionary.
>>> FMP and database events can work fine together
That's what I've heard, but I guess "fine" is a relative term.
>>> FMP is a scriptable app and database events is an osax.
Actually, DBE is a faceless background application.
>>> To get your data into FMP, I think what you want to do is to read your raw
text in all at once into an applescript list using either Applescript or another
text processing tool, and then in a tell app "FileMaker Pro" block iterate
through the list to create a new FMP record.
With thousands of records this would take way too long. Converting to a file
format FMP will recognize and importing that is much faster.
> set myDatabaselist to {}
> tell document "MyDatabase"
> set myDatabaselist to records of "MyDatabase" -- this will give you every
> record in your database in less than 1 second
> end
> tell
> then, once it's out of FMP and into an AppleScript list, you can drive
"Database Events"
I'll give this a look, but it's the repeat through each record indivually
that slows things down.
What I was hoping was a straight export from FMP to a file that DBE could
read.
ES
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden