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. 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:
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:
(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: milamber@iop.kcl.ac.uk |
||||||||||||||||||||||||||||||||||||
