Solved

FM - Auditing Feature?

Posted on 2014-01-07
8
514 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39762608
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
ID: 39762692
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 25

Assisted Solution

by:Will Loving
Will Loving earned 500 total points
ID: 39762746
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

by:rvfowler2
ID: 39765894
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
 
LVL 25

Expert Comment

by:Will Loving
ID: 39765918
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
ID: 39765931
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 25

Expert Comment

by:Will Loving
ID: 39766264
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
ID: 39766277
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 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