Archive for the ‘Windows’ Category

Script Trigger pitfalls: Get(LastError)

Wednesday, May 20th, 2009

Script Trigger Pitt Fall

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.
(more...)

PrinterSwitch and “Data Execution Prevention” on Windows

Tuesday, March 31st, 2009

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:
(more...)

Speed up your conditional formatting

Tuesday, April 29th, 2008

Conditional formatting is a great tool to enhance your layouts and add additional functionality to your solutions, e.g. for calendaring. But sometimes conditional formatting can slow down the display of your layouts, because FileMaker has to calculate all the conditions you have defined. Today we are going to look at a technique that allows you to speed up your calculations by caching some results temporarily.

(more...)

“Final call for flight …”

Thursday, February 28th, 2008

hub_001

A couple of weeks ago, we talked about the “Beam me up, Scotty” or “tele-porting” method. This technique described how you can transfer found sets from one table occurrence to another.

This week's technique will show you how you can write a re-usable script to go to a certain record or found set, independent of the current context.

We call this technique the “hub” method. It is also described in the myFMbutler/SHpartners Development Guidelines.
(more...)

FM Server 9.0v3 update recommended for AutoSender users

Tuesday, February 12th, 2008

If you haven't upgraded to FileMaker Server 9.0v3 yet, and are an AutoSender user, we strongly advise you to upgrade asap.

FileMaker Server 9.0v2 contains a bug where database sessions can't be closed properly (including disconnects) while an ODBC or JDBC session is active.

If you are using JDBC with AutoSender to connect to your mail sources, you may experience this problem.

As a workaround on 9.0v2, stop the AutoSender service/daemon first, before closing the files. Or upgrade to 9.0v3 to solve the problem altogether.

Send your birthday greetings with AutoSender 2.0 !

Tuesday, January 29th, 2008

Have you ever wanted to automatically send birthday greetings to your important friends and customers?

In today's example, we'll take a closer look at how we can combine the power of FileMaker Server 9 script scheduling with AutoSender for automatically sending mail messages from FileMaker Server at scheduled intervals.

birthday.jpg

(more...)

AutoSender 2.0 now available

Thursday, January 17th, 2008

AutoSender 2 has been released last week. We would like to thank all our beta testers for the invaluable feedback we received !

AutoSender 2 Configuration application

Existing users of AutoSender 1.x can upgrade to 2.0 for EUR 49,- or about USD 70,-. All AutoSender purchases after October 1st, 2007 are entitled to a free of charge upgrade.

More details are available on the AutoSender product page.

“Beam me up, …”

Friday, January 4th, 2008

restorefs_10

At the last "Clarify Confituur" session (a Dutch-speaking FileMaker User Group), someone asked a question about how you can restore a found set, if you lose your found set during a script.
In this article we will show you with a simple technique that demonstrates how to do this.

(more...)

FileMaker to vCal XSLT Updated to 1.2

Friday, December 21st, 2007

We just updated our FileMaker to vCal XSLT to version 1.2. The free FileMaker to vCal XSLT solution allows you to subscribe to FileMaker calendar data from vCal-compatible calendaring programs.
With this version, iCal should now update calendar events properly under Mac OS X Leopard. In this version, we changed the DTSTAMP parameter in the XSLT to use the modification date instead of the creation date of an event.

FileMaker to vCal

Check this article or more information on how to use this solution.
Download version 1.2 here.

A spotlight-like Portal Filter with DoSQL Plug-in: Part III

Tuesday, December 18th, 2007

In the previous posts about this topic, we created a spotlight-like portal filter with the DoSQL plug-in.
Last time we created a custom function to simplify the implementation.
This time we will enhance that custom function so you can implement a spotlight-like portal filter in your solution without the need of any SQL knowledge.

(more...)