Ovid Technologies, Inc.
Ovidstat Report Program
Ovidstat is designed to produce statistical reports on many aspects of Ovid usage. The program takes raw statistics files and makes reports, using attributes like: types of full-text publications viewed; general database usage; and peak system and data base usage. Ovidstat can also create tab-delimited output that can be imported into spreadsheets and limit output by user, group, database, client types, and IP address. In addition, the Ovidstat program can create and save customized report definitions t hat can be reused.
As it is used, Ovid creates an ASCII file containing raw statistics about program and database usage. Those statistics can include: the user ID, date, time, and length of each search session; the databases searched; the number of search sets made; and other data.
To log in, go tohttp://stats.ovid.com and enter your user ID and password. If you have more then one statistics file you will be taken to a page titled Ovid Online Statistics and prompted to select the group for which you want to generate statistics reports for.
Custom Reports - Using the Report Generator
On the Report Generator screen, select and set the parameters you wish to use. (Parameters and their functions are listed below.)
The following parameters must be used in order to successfully generate a report in Ovidstat: Type of Report and Report Format. In addition, you will probably want to enter a Report Title for your report so that you can identify it in the future.
To set parameters for a report, enter text in the appropriate boxes as explained below.
Use this parameter to name the report. Enter a name in the Report Title: text box. Any characters may be used. The name will appear in the upper left hand corner of the report that is generated. For example: Ovid_Usage_Stats
Type of Report
Ovidstat can make several kinds of reports. Click on the drop-down window next to Type of Report: to choose a type of report. Report types are as follows: Fulltext: A list of types of full-text publications viewed, (su ch as article, book, report, etc.), sorted by journal name. Dbsession: Ovidstat's default output, tab-delimited for use in spreadsheets. A wide variety of usage information is presented, sorted by user and session. Dbusage: A list of cumulative average usage statistics, sorted by database. License: Counts the number of "license exceeded" messages, for both Ovid and database licenses. Peak: Displays peaks – that is, times at which the largest number of users were searchi ng – for system and database usage by month, day, and hour.
To the right of this is a second window where you choose among the options by database, by group, and by user, which allow you to create reports that are sorted by one of these criteria. The default option is < B>by database. Regardless of which is selected, however, the resulting report will contain statistics on session length, items viewed, search statements, bibliographic records used, etc.
Tab-delimited format should be selected if you wish to save report data for use in a spread sheet. Although the default format dbsession report is tabbed, the default format for other reports is ASCII. To change other report types to tab-delimited format, click the drop-down window and select tabbed.
Limiting the Report
If you are only interested in certain aspects of the statistics available, you can limit report output by one or more raw statistics fields. You can select single limits or multiple limits for each field. Multiple limits mus t be in a comma-delimited list (do not use any spaces) in the appropriate text box for each parameter. The following limits are available:
Limit to User
Limit to Group
Limit to Database
Limit to Session Type
Limit to Address
Generating, Saving, and Printing Reports
Once you have specified and set parameters, you may generate your report by using either the Generate Report or Save Report buttons. The difference is that the Save Report button will both generate the report and automatically save it (under the name you choose) for future use. When generated, the report will appear on a new page.
At this point, you may also save a report to your own hard or floppy disk by using your browser’s "save" function or print it using the "print" function. When saving, PC users should add a .txt extension to the file name so that it will be saved as a text file that can be opened in database programs. Macintosh users should just check to make sure that it is saved as a text file. (This should be the default setting.) Users of both platforms should also be sure that you ar e saving in tabbed format – see explanation of "Format" parameter above.
Accessing Existing Reports
You can retrieve reports at any future time by pressing the Saved Reports link that appears beneath the input form. When you have done this, you will see a list of all the names of the reports that you have saved. You can display the report or delete it by clicking on the appropriate link.
Saving and Reusing Report Definitions
If you want to save the parameters that you have specified in order to run an identical report without entering the parameters again, enter a name for the report definition in the text box next to the Save Report Definition button reading and then press the button.
Note:Saving report definitions allows you to run cumulative reports. These may include either the entire set of data, or data from a particular date forward. If you specify a start and end date that hav e already passed, your saved report will only generate the same information over and over again. If you save a report definition, therefore, you should either leave the date fields blank, or you should specify a starting date from which you wish to begin, and an end date which is very far in the future. (e.g. "200512312300", or 11:00 p.m. on December 31, 2005).
To access a saved report definition or execute the corresponding report, click on the Report Definitions link at the bottom of the screen. You will be presented with a list of the reports for which you have saved definitions. You can display de finitions, execute reports, or delete listings by pressing on the appropriate link.
Viewing Statistics Files
There are two types of statistics files available. The raw statistics are "master.log" (the current week only) and "master.log.archive" (a archive of all previous master.log files). There are also summary files that have the f ile the extension ".f".
You can see which statistics files are available to you by clicking on the Statistics Files link. You will see a list of files that may be displayed by clicking on the appropriate link. Viewing raw statistics files is u seful for confirming any format names you choose to enter in the database field when creating your report. The format name for the database immediately follows the designation DB in the raw data record.