跟踪Filemaker数据库中的修改历史记录 [英] Track Modification History in Filemaker Databases

问题描述

是否可以在Filemaker Pro 13中自动将所有时间戳和字段修改的详细信息存储在表中?即Filemaker提供的某个地方是否有一个简单的选择，还是我必须以编程方式/手动执行此操作?

Is there a way to store all timestamps and details of modifications of fields in a table automatically in Filemaker Pro 13? ie is there an easy option somewhere that Filemaker provides, or must I do this programmatically / manually?

推荐答案

FileMaker不提供现成的审核日志记录方法.但是，有一些不错的选择.线性蓝提供 fmDataGuard 和

FileMaker does not provide a ready-to-go method of audit logging. However, there are a few decent options. Linear Blue provides fmDataGuard and SyncDek just for this purpose, and does a very nice job. (SyncDek is great for [and requires] FileMaker Server; fmDataguard is great for standalone databases and small server deployments.)

Nightwing的解决方案很聪明，并且与fmDataGuard非常相似，但是我认为fmDataGuard更强大.

Nightwing's solution is clever and hooks up very similarly to fmDataGuard, but I think fmDataGuard is more robust.

所有这些审核日志记录解决方案都有一个严格的限制.您不能以[完全访问权限]用户的身份记录删除操作.如果这对您的应用程序至关重要，则SyncDek是唯一提供最新版本的变通方法的解决方案:记录更改轮询.

All of these audit logging solutions have a critical limitation. You cannot log deletions as a [Full Access] user. If this is critical for your application, SyncDek is the only solution that offers a work-around in the latest versions: record change polling.

对于某些应用程序，最后可能存在值得考虑的可能性.像MySQL这样的数据库具有审核日志插件，而没有FileMaker的权限限制.您可以将FileMaker连接到一个或多个MySQL数据库，并像使用本机FileMaker表一样使用它们的表.使用MySQL审核日志插件，您可以获取审核日志并将UI使用FileMaker.

There is a final possibility that might be worth considering for some applications. Databases like MySQL have audit log plugins without the permissions limitations of FileMaker. You can connect FileMaker to one or more MySQL databases and use their tables more-or-less like native FileMaker tables. With the MySQL audit log plugin, you can get your audit logging and use FileMaker for your UI.

这篇关于跟踪Filemaker数据库中的修改历史记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！