SQL Practical Guide

Search

SNOMED CT Document Library

    Loading...

Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Before importing the SNOMED CT data the import process creates a "transitive closure file". This allows this file to imported to create a transitive closure table that supports rapid subtype testing. The process that creates the transitive closure file from other release files uses the Perl language. Windows does not include a Perl language interpretter. Strawberry Perl is a widely used free Perl environment for Window and this should be installed on your computer before running the import script.

Download Strawberry Perl

Install Strawberry Perl

  • Open and run the downloaded file
    • This will have a name like "strawberry-perl-5.30.0.1-64bit.msi" (version numbers may differ).
  • Go through the installation process
    • Read and accept the license.
    • We recommend that you install in the default installation path (e.g. "C:\Strawberry)

      • You can choose a different path if preferred as the installation script will attempt to locate the file wherever it is installed on the main drive. 

        Warnings

        Do not install Strawberry Perl within the SnomedRfsMySql folder as the installation will be removed by future updates to the SnomedRfsMySql package.
        Ideally you should install Strawberry Perl on drive C.

        If Perl is installed on a network oe a secondary drive (i.e. not drive C), you need to specify that location. To do this create (or edit) a plain text file called perlPath.cfg file in the SnomedRfsMySql\win folder. This file must contain a single line of text specifying the full path of the perl.exe file (for example the file might contain the text "D:\AddedSoftware\Strawberry\perl\bin\perl.exe")

        If the import script cannot find perl.exe at the location specified in the perlPath.cfg file, that configuration file will be deleted and will need to be recreated with the correct full path to perl.exe.

Check the Installation

  • When the installation is complete, you can test the installation by running the the following command in a newly opened Command Prompt.
perl C:\SnomedRfsMySql\lib\test.pl
  • If Strawberry Perl is correctly installed the result should the following message.
Perl is correctly installed

Tip

If the message above does not appear, check the following:

  1. The command line above assumes that SnomedRfsMySql is installed in the C:\ root folder. If this is not the case, repeat the test with the correct path to SnomedRdsMySql.
  2. Ensure that you have closed all open command line windows. Then open a new command line window and run the test command again.
  3. If neither of the above steps corrects corrects the issue, it suggest a problem with the installation. Consider uninstalling and reinstalling Strawberry Perl to correct the issue.



Feedback
  • No labels