Kavi® Members Help
Table of Contents
The Company Activity Log tool is used to create customized views and reports of changes made to company data: who made the change, when the change occurred and which fields were changed. It provides more detailed information about data changes than the Company Activity History tool, such as the names of all changed database fields. Information displayed in the Company Activity Log results table is derived from the Full Activity Log, where all changes to the database are automatically recorded, but the Company Activity Log only includes changes made to company data.
Customized reports are created by setting search criteria, including the company and the period of time during which the data changes occurred.
Generate a detailed view of real-time changes made to company data fields in the Kavi Members database.
Generate a downloadable or print-ready report of this information.
Set any of the optional fields to refine the search criteria. To view all available company activity log information, leave the search fields set to the defaults.
Options
- Company
Select the name of the company whose activity log you want to see. The default value is All Companies.
- After This Time
Use this field to set a point in time. The report will include only those changes logged after the time specified.
- Before This Time
-
Use this field to set a point in time. The report will include only those changes logged before the time specified.
Note
The time fields can be used together to specify a bounded time range beginning at the time set in the After This Time field and ending at the time set in the Before This Time field.
A customized Company Activity Log report is displayed according to your search criteria. You may opt to get a print-ready version of the report or download it.
Frequently there will be more than one entry (or lines in the report) for an individual company created at the same time. This indicates the user data change affected more than one database table. Many Members tools change data in multiple tables simultaneously. For instance, the Edit a Company tool can change information in both the company database table and address database table.
The report displays the following columns:
- When
The date and time of the change.
- Who Changed
The username of the user who initiated the change. If this is 'Anonymous User', the change was made from a publicly accessible page, such as 'Sign Up for an Account' or 'Password Help'.
- What Was Done
Indicates the type of change that was logged. This can be 'added', 'edited' or 'deleted'.
- Which Company
The name of the company whose information was changed.
- Which Fields
The name of each field in the database that was changed in this company's record. If more than one table in the database was affected by the change, this information will be contained in multiple rows in the report.
Options available on the report are:
- Print-Ready
Removes the look and feel of the web site surrounding the report and scales the displayed report for printing.
- Download
-
Select a file format and download the data in this report to a file on your computer.
Available file formats are:
- Comma-Separated-Values (CSV)
File format used to transfer data from one application to another. Each record comprises one line, with values for that record separated by commas (e.g., first name, last name, email address).
- Excel Spreadsheet
Spreadsheet file created by, and which can be opened and manipulated by, Microsoft Excel.
- Pipe Delimited (available on most reports)
File format used to transfer data from one application to another. Each record comprises one line, with values for that record separated by pipes, (e.g., first name | last name | email address).