Welcome to the

Opcrit+

Homepage

Opcrit+ is an enhanced version of Opcrit.

OPCRIT+ is an electronic tool for researchers and clinicians designed to collect a structured psychiatric history and mental state examination and produce research level diagnoses from a number of accepted criteria. It is based on the original OPCRIT tool written by McGuffin et al in 1994, and includes new items for a range of diagnoses surrounding substance misuse, anxiety, personality, eating disorder and dementia spectra. Additional items salient to aetiology and clinical assessment are also provided. The tool is structured around the standard headings of a psychiatric history and mental state exam.

To install Opcrit+, download and execute the installer. You will need an account capable of installing software on your workstation, or in the case of domain or restricted workstations, will need a network administrator to run the installer for you.

In addition, a MySQL data connection will need to be established. See below for details.

[ Download Opcrit+ Installer ]


07.05.2013. Important Update
A new version of the executable is available. This has already been included in the installer above but existing users can download the new version of the exe here. Locate the directory you installed Opcrit+ into and rename the existing OpcritPlus.exe file in there to something like OpcritPlusOld.exe, then download the new version and save it in the same directory.

Opcrit for Windows (Original Opcrit)
The original version of Opcrit for windows can be downloaded from the Opcrit homepage.

SCAN Data Extraction for Opcrit+
A utility is available for extracting data from the SCAN program and pulling it into Opcrit+.

OpcritPlusScanExtractor.exe

MySQL Data Connection
Opcrit+ requires access to a MySQL server. This can be either a local copy installed on the workstation Opcrit+ is being run on, or a network server hosting a MySQL service.

Local Copy of MySQL
If you do not intend storing your data on a MySQL network server, download the latest version of MySQL. You want the MySQL Essential MSI installer for the MySQL Community Server (select either the 32 or 64 bit version as appropriate). You will be asked to select the mirror you wish to download from. Select an appropriate one near you.

http://dev.mysql.com/downloads/mysql/5.1.html#downloads

Please note: there is a compatibility problem with the latest version of MySQL. We recommend you download the previous version for the moment, a fix to the problem is being worked on, in the meantime, download and use version 5.1.47.

Run the installer and follow the instructions. You will be asked a series of questions one of which will ask for a root password. This is extremely important and should never be left blank. Choose a secure password and record it somewhere safe (not on a postit under your desk!). Answer the configuration questions as follows:

Setup Type:

select Typical
Configure the MySQL server:

Leave checked
Register the MySQL server:

Uncheck this
MySQL Server Instance Configuration:

Select Detailed Configuration
then....

Select Developer Machine
then....

Select Multifunctional Database
then....

Leave InnoDB Tablespace settings as defaults (C & Installation path)
then....

Select Decision Support (DSS)/OLAP
then....

Check Enable TCP/IP support and Enable Strict Mode checked
then....

Select Standard Character Set
then....

Check Install As Windows Service
Leave Service Name as MYSQL
Check Launch the MySQL Service automatically
Check Include Bin Directory in Windows Path
then....

Check Modify Security Settings and enter your chosen root password in both boxes
Uncheck Enable Root access from remote machines
Uncheck Create an Anonymous Account
That is all. When ready, hit the Execute button

Users without sufficient privileges to install new programs will need to ask their IT administrators to install these packages for them.

Creating the Opcrit+ Database
Once the installation is complete, you will need to create the database and tables that Opcrit+ will use, plus a user to access the tables. This applies both to local copies of MySQL and MySQL network servers. Those of you connecting to a MySQL network server will need to get the server administrator to create the database, tables and user for you.

You will need the CreateOpcritPlusMySQL.sql SQL command script to do this via the MySQL client:

Network server administrators will know what to do with this, for those of you installing local copies:
Save CreateOpcritPlusDatabase.sql and open a DOS (Command) prompt (Go to Start->Run and type "CMD" in the box, then hit "Run"). Once the prompt is open type:

mysql -u root -p

When prompted, enter the root password you recorded earlier.

Next you need to create the database and table for Opcrit+ to use. This can be done by either copy and pasting the SQL script into the mysql client (recommended), or by using the source command:

source c:\path to script\CreateOpcritPlusMySQL.sql

where "path to source" is the full path to the location you saved the SQL script you downloaded.

Once complete, create a user for Opcrit+ using the following commands within the mysql client:

GRANT ALL PRIVILEGES on opcritplus.* TO 'opcritplususr'@'localhost' IDENTIFIED BY 'FatherJack';
FLUSH PRIVILEGES;
QUIT

(replace "FatherJack" with a password of your choice).

This will give you the following set of MySQL connection parameters that you will need to enter when running the Opcrit+ program:

Server (host): localhost
Port : 3306
Username : opcritplususr
Password : FatherJack

(obviously, you use the password you specified in the GRANT command above)

Networked MySQL Server
If you have a network server running a MySQL service/daemon and wish to use this (useful if you want several users to enter data into Opcrit+ simultaneously), you will need to contact the administrator of your network server and ask them to create the Opcrit+ database and tables, then give you an account with SELECT,UPDATE,DELETE,INSERT privileges on all the database tables.

If you have problems installing or running the Opcrit, please contact us on: james.rucker@kcl.ac.uk