Last week we released Clip Manager 3.1.2 for Mac, now the Wndows version has also been updated.

This is a bug fix release:

Several smaller bug fixes

Today I implemented some script triggers in an existing project and something strange happened. My navigation scripts that have worked correctly for years, suddenly stopped working. I checked my scripts over and over again and couldn’t find any clue, until I discovered an unexpected behavior.
Read the rest of this entry »

For this week’s blog article, we want to extend a special thanks to Kevin Frank and Dave Walton who sent us the example.

When using DoSQL to create a ChangeLog of your records, you want to avoid creating log records when nothing has actually changed.

The trick is to prevent DoSQL from firing unless you want to log a change… take a look at the example and check the validation on _K in the Data table… basically, if the parent sees that nothing has changed since the last corresponding ChangeLog record was created, then doSQL won’t trigger.

Note that if you have no ChangeLog record for a given parent record, then it will be created *regardless* of which parent field you edit, but… once you have at least one change log record for a given parent, then any “don’t log” fields will be respected.

The thing I like about this technique is that ChangeLog records will be created when a Replace is performed and when parent records are imported.

DoSQL ChangeLog Example

DoSQL Plug-in download

Lately we have been getting regular reports from people experiencing a problem when trying to use PrinterSwitch on systems with Windows Server 2003/2008 or Windows Vista (and 7).

After running the installer, and starting FileMaker, the PrinterSwitch plug-in is not automatically enabled. Manually trying to enable it generates an error message “myFMbutler PrinterSwitch could not be enabled”.

This problem is caused by certain security settings of the above versions of Windows, by a feature that’s called “Data Execution Prevention”.

To correct the settings, do the following:
Read the rest of this entry »

We just released a maintenance update to AutoSender.

AutoSender is still the easiest way to automatically send e-mail from your FileMaker solutions, with integrated support for multi-part messages with both HTML and plain text alternatives, and the possibility to include enclosures from a local network path, or an FTP or HTTP path.

What’s new in 2.5.5:

[Mac OS X only] Fixed a versioning problem

Download the latest version here.

We just released version 1.2 of our DoSQL plug-in.

This new version provides a new function:

mFMb_DoSQL_QuoteField( fieldname )

The function converts “FileMaker-style” syntax like my Table::my Field to SQL syntax like “my Table.my Field” (with quotes). The nice thing about this is that it allows you to double-click a field to insert it in a calculation.

Combined with FileMaker Pro 10’s new ‘GetFieldname’ function, this allows you to make the SQL statements much more universal.

Download this example for more details on how this can be used (make sure you have version 1.2 of the DoSQL plug-in installed)

Although the use of spaces in field names is not recommended, this solution will continue to function properly if you do use spaces.

Download DoSQL 1.2

We just released version 3.1 of Clip Manager. This is mainly a bug fix update, but it also adds some new features, like support for regular expressions.

Download version 3.1 from the myFMbutler downloads page or use “Check for Update” if you are an existing user of Clip Manager.

Read the rest of this entry »

We wanted to give everyone an update on the compatibility status of our products with FileMaker 10:

Initial testing of our plug-ins (DoSQL, DoScript, PrinterSwitch), have not shown any compatibility issues with the FileMaker 10 platform.

AutoSender 2.5 also seems to work fine with FileMaker Server 10, although we’ll be providing a small update that will integrate a new JDBC driver by February.

Clip Manager 3 does have some issues for people trying to ‘Get’ or ‘Set’ a custom function with FileMaker Pro 10 Advanced. We will be releasing version 3.1 later this month. This version will also provide a number of other fixes.

We also recently found issues (unrelated to FM10) when using the ‘Copy to Clip Manager‘ function on Brian Dunning’s CF web site. Starting with a certain build of Flash 9 and all builds of Flash 10, the copying no longer works. We are currently working on a fix and hope to provide it by next week (actually, we already fixed it today).

We are pleased to announce a special myFMbutler Thanksgiving promotion: from November 26 until December 6, 2008, get any myFMbutler product at a 20% discount.

In order to claim the discount, customers should use the coupon code ‘THANKS2008′ when checking out.

We just released a maintenance update to AutoSender.

What’s new in 2.5.3:

fixed a bug that was introduced in 2.5.2 when sending plain text mail with attachments

Download the latest version here.