In this chapter, we add auditing of changes to data in our app.
Audit manual data changes
Add auditing of manual data changes to your app. To recap the steps in the video:
- Open the configuration form for the stream
Contacts - Tick Audit Manual Changes
- Add attributes to the stream:
UpdateActionUpdatedByNameUpdatedTime- you must make this a Datetime field
Go into app mode, and make some changes to your contacts data.
Now create a new view to show all history:
- Create a new dashboard
Contacts All History - Drag the stream
Contactsonto this dashboard, add all attributes to the view - Hide the
UIDattribute - Open the view configuration form
- Update the Name to
Contacts All History - Tick Include History Records
- Save your changes
In the new view, you should be able to see full details of the changes you just made to the contacts data.
Add a menu item to the Contacts app to provide a link from the Contacts dashboard to the Contacts Full History dashboard.
- When you have updated the view configuration to add the menu item, you will need to close and re-open the
Contactsdashboard to see it
Audit analysis data changes
Add auditing of analysis data changes to your app. To recap the steps in the video:
- Open the configuration form for the stream
Contacts - Update stream attribute expressions:
UpdateAction:"IMPORT"UpdatedByName:_user.nameUpdatedTime:now()
For auditing manual changes, you must use the spelling (including capitalisation) for these attributes as given above. When auditing analysis changes, you could use any attribute names. But in this case, since we are auditing both manual and analysis changes, it makes sense to use the manual audit attributes to record the analysis audit as well.
Go into app mode. Import the test file: Contact Import 3.xlsx
You should see a new contact imported. Apply an update to this contact.
Now open the full history for contacts. You should see two records for this contact - one for the import of the contact; one for the manual update you have just applied.