Solved

FM - Auditing Feature?

Posted on 2014-01-07
8
506 Views
Last Modified: 2014-01-08
Boss wants an auditing trail in Filemaker.  A one step history is easy with the auto enter modification data and account name, but he would like to keep track for several changes.  How would you do that?  Would you create a series of set fields and copy field4 to field5, then field3 to field4 and so on?
0
Comment
Question by:rvfowler2
  • 4
  • 4
8 Comments
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
Comment Utility
I've used Nightwing's SuperLog Audit System (in various incarnations) with great success. It's been extremely helpful. The only issue I've encountered with it is if you have a very large number of fields marked for auditing, it can significantly slow down imports.

http://www.nightwing.com.au/FileMaker/demos8/demo809.html
0
 
LVL 2

Author Comment

by:rvfowler2
Comment Utility
Looks interesteing, but they provide no instructions whatsoever.  Assuming you install this on the server and that it is an AddOn, but some instructions would be nice.
0
 
LVL 24

Assisted Solution

by:Will Loving
Will Loving earned 500 total points
Comment Utility
It's really very straightforward. You simply import the three Custom Functions: SuperLog, ScriptLog and PrepLog. Then you add an Audit field (they call it "Data_Log") to each table that you want to track and populate the Auto-Enter Calculation with the SuperLog () function and any fields you want to be tracking.

To display the results, I usually create a separate layout with just the Data_Log field on it and a "Close" button. The user displays the layout via a script linked to either a button or a menu item. You can just copy the field from the demo if you want. Be aware that the nice column spacing in the demo is achieved by applying tab formatting to the field.
0
 
LVL 2

Author Comment

by:rvfowler2
Comment Utility
I'll test it.  The only problem if I understand this correctly is that it tracks per field when we are really interesed in any change someone makes on the record, though I suppose we could emphasize key fields that a mistake in which would cause the most problems.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 24

Expert Comment

by:Will Loving
Comment Utility
You can list as few or as many fields as you want. Many fields are not likely to require monitoring, but you might be able to modify the Custom Function to monitor for any change in the record. Probably easier though to just specify the key data fields.
0
 
LVL 2

Author Comment

by:rvfowler2
Comment Utility
Also, the auto-enter text is as follows.  Do I have to create a 2nd repetition for each field or is TheText[2] simply an example of a second field you would use?

SuperLog ( Data_log ; TheText & TheText[2] & TheNumber & TheDate & TheTime )
0
 
LVL 24

Expert Comment

by:Will Loving
Comment Utility
TheText is a repeating field; in the Demo it's used for First and Last name. In the Auto-Enter calculation TheText traps for changes to the first repetition, TheText[2] traps for changes to the second repetition of the field.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
Comment Utility
Thanks, Wll.  Works well in testing.  Notice that it shows results per record.  Tried using an X relationshi and putting it in a Footer or Grand Trailing Summary, but wouldn't show results.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now