NightWing Enterprises — Demo for FileMaker Pro™ 8.x, 9, 10 and 11
|
Transactional Logging of All Data Changes!
|
UltraLog
For FileMaker 10
(also works with 8.x and later)
As a courtesy to fellow developers and potential clients, the
following demonstration file is provided for free download.
|
If you are familiar with our previous demos of logging techniques you may be wondering what makes this one new and different. This logging system captures *all* changes to data, regardless of how they are made (including changes made by script, via IWP, xDBC, CWP and so on)! Moreover the UltraLog system operates transactionally - it doesn't log anything until the record is committed (or submitted in the case of web transactions) and then it logs changes since the last commit.
Equally important, UltraLog is one of the simplest audit logging systems to implement. Change logging requires one Custom Function* and one auto-enter field per table (plus a modification timestamp field that you likely already have). Additionally, this demo includes a script for periodically archiving logged changes to a separate table, where they can be searched, summarized or printed.
Although FileMaker Pro 10 (or later) is recommended for this demo (for optimal features and performance), the technique can be implemented in versions 8.x and 9 - and can operate in multi-user solutions with a mix of client versions from 8 to 10 installed. The technique is fully native, requiring no plug-ins or third party applications.
As with our previous logging systems, UltraLog allows you to specify a subset of fields to be logged (you supply a return-delimited list of the names of fields you want included in the logs, as one of the parameters of the UltraLog( ) Custom Function). This system can even log changes to calculation fields, whether stored or unstored (though the log will only capture changes that result from modification of the current record).
While UltraLog owes a share of its heritage to our previous "SuperLog" system, this new implementation is more compact, more powerful and more versatile.
This demo file is unlocked and password-free, compliments of NightWing Enterprises. The use of this technique is free for private and educational purposes. Use for business or commercial applications is subject to license (pricing on request).
|
*
|
To install Custom Functions in your solution file(s), you will require access to a copy of FileMaker Pro Advanced .
|
|
|
|
|
NB: Use of the code and techniques shown in this demo is free for private and
educational purposes and may be licensed for commercial and business applications. Should you require assistance implementing procedures such as those shown in the
example file, please consider establishing an account with us for developer support.
|
|
