Because of a lapse in government funding, the information on this website may not be up to date, transactions submitted via the website may not be processed, and the agency may not be able to respond to inquiries until appropriations are enacted. The NIH Clinical Center (the research hospital of NIH) is open. For more details about its operating status, please visit cc.nih.gov. Updates regarding government operating status and resumption of normal operations can be found at OPM.gov.

LexAccess

Update Lexicon to lexAccess.2023

LexAccess.2023 provides a new feature to access different Lexicon releases (including future releases). This page describes the detail procedures for update Lexicon database to lexAccess.2023:

I. Install LexAccess.2023

Follow the installation instructions to install lexAccess.2023 if it is not installed.

II. Download/add the latest Lexicon Database

In order to access different versions of Lexicon, the desired version of Lexicon database table need to be added to the installed lexAccess.2023 (${LA_DIR}) as follows:

  • download the HSqlDb.${YEAR}.tgz from Lexicon database download page
  • unzip the HSqlDb.${YEAR}.tgz
    shell> gtar -xzvf HSqlDb.${YEAR}.tgz
  • add HSqlDb.${YEAR} to ${LA_DIR}/data/HSqlDb.${YEAR}
  • ln -s ${LA_DIR}/data/HSqlDb.${YEAR} ${LA_DIR}/data/HSqlDb
    or
    move ${LA_DIR}/data/HSqlDb.${YEAR}/*.${YEAR} ${LA_DIR}/data/HSqlDb/.
    All HSqlDb files has to be under ${LA_DIR}/data/HSqlDb/.
    • lexAccess${YEAR}.data
    • lexAccess${YEAR}.properties
    • lexAccess${YEAR}.script

III. Update config file

Update variables for the lexAccess configuration file (${LA_DIR}/data/config/la.properties)

  • LATEST_VERSION (the latest version)
  • DB_NAME (the default version)

IV. Run LexAccess

  • Command line tool:
    shell>lexAccess -rv:${YEAR} -p
  • GUI tool:
    shell>lagt
    Select the desired Lexicon version by:
    • Top menu: Options -> Lexicon Version
    • Press "Lexicon" button
    • Key: Alt + V
  • Web tool:
    Select the desired Lexicon version by clicking Lexicon Versions link