Xojo Conferences
XDCMay2019MiamiUSA

[MBS] NSAppleScript again, this time with Filemaker (MBS Xojo Plugin Mailinglist archive)

Back to the thread list
Previous thread: [MBS] userSpaceScaleFactor in class NSWindow is deprecated
Next thread: [MBS] Cocoa NSTextInputClient


Re: [MBS] PortAudio bug?   -   Garth Hjelte
  [MBS] NSAppleScript again, this time with Filemaker   -   Beatrix Willius
   Re: [MBS] NSAppleScript again, this time with Filemaker   -   Christian Schmitz

[MBS] NSAppleScript again, this time with Filemaker
Date: 06.01.13 10:14 (Sun, 6 Jan 2013 10:14:52 +0100)
From: Beatrix Willius
This AppleScript stuff gets on my nerves.

Have been transferring data to Filemaker with AppleScript for ages. But Filemaker 11 makes problems.

The main script still is very simple

set myNewRecord to (create new record with data {OriginatorFrom, OriginatorSender, OriginatorReplyTo, ….
set data cell "MessageRawData" of myNewRecord to MessageRawData

After 1.000 to 2.000 the second row fails with an error message "-10001, Object or property is the wrong type.". The memory of Filemaker is about 1.7 GB when this occurs. The error occurs at different mails so that I don't think that this is a problem of the data. The memory is NOT reclaimed after the data export/import is finished.

I have already added the autorelease pool stuff to my code. But this doesn't help with Filemaker.

Do you have any idea what could cause this problem? Is this on my side or on Filemaker's side?

Is there any other possibility to transfer data to Filemaker via a different method? ODBC doesn't count because installing ODBC and making it work with Filemaker is much too complicated for the average user.



Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals

_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Re: [MBS] NSAppleScript again, this time with Filemaker
Date: 06.01.13 12:52 (Sun, 6 Jan 2013 12:52:56 +0100)
From: Christian Schmitz

Am 06.01.2013 um 10:14 schrieb Beatrix Willius <<email address removed>>:

> Do you have any idea what could cause this problem? Is this on my side or on Filemaker's side?

If FM's memory increases, it's probably a leak on their side.
As FM is also written in Cocoa, you may make a delay somewhere for maybe 2 seconds after 1000 records, so the auto release can do it's work in FM, too?

> Is there any other possibility to transfer data to Filemaker via a different method? ODBC doesn't count because installing ODBC and making it work with Filemaker is much too complicated for the average user.

We have a MBS Filemaker Plugin to do SQL stuff there. So you could run a script in Fileamker to write data directly in a SQLite database (=REALSQLDatabase)

Greetings
Christian