Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Widget Connector
width900
urlhttps://www.youtube.com/watch?v=XgXJqCpVeOA&list=PLbPt6SI1Zhb8CnWh7Gvopto7D6LEwcB9A&index=19
height500

Add auditing information for data changes to your appapplication. To recap the steps in the video:

Audit

...

Manual Data Changes

  1. Open the configuration form for the Stream BusinessesTick stream Businesses and tick Audit Manual ChangesAdd attributes to the . This will add the following audit attributes and their respective expressions to your stream:
    1. UpdateAction: "INSERT". This should be changed to “IMPORT” for this exercise

    2. UpdatedByName

    3. UpdatedTime - you must make this a Datetime field
    Go into app mode, and
    1. _user.fullUsername

    2. UpdatedTime: now()

    3. UpdatedByID _NULL

  2. Go into App Mode and make some changes to your business data.
  3. Now create a new view to show all history:.
    1. First create a new dashboard Businesses dashboard Businesses All History.
    2. Drag the stream Businesses stream Businesses onto this dashboard , and add all attributes to the view.
      • Hide the UID attributethe UID attribute.
    3. Open the View view configuration form.
    4. Update the Name to Business  to Business All History.
    5. Remember to set a Default Sort Order.
    6. Tick Include History Records: tick
    7. Save your changes.
  4. In the new view, you should be able to can see full details of the changes you just made to the Businesses data.
  5. Add a menu item to the Businesses view the Businesses view to provide a link from the Businesses the Businesses dashboard to the Business the Business All History dashboardHistory dashboard.
  6. Go into App Mode to test the new configuration.

Audit analysis data changes

Add auditing of analysis data to your app. To recap the steps in the video:

  1. Open the configuration form for the stream Businesses
  2. Update stream attribute expressions for:
    1. UpdateAction: "IMPORT"
    2. UpdatedByName: _user.name
    3. UpdatedTime: now()
Note

For auditing manual changes, you must use the exact spelling for these attributes as given above.

...

 


To test the configuration, go into App Mode and import the test file: Import_Businesses_3.csv. You will see a new business, "EDQ Empire" has been imported.

...

 Apply an update to this contact.

...

 Open the

...

Business All History dashboard

...

. You will now see two entries for this business

...

, one for the import of the business and a second for the manual update you have just applied.



Panel

Next video: 18. Drag-and-drop Actions