Versions Compared

Old Version 3

changes.mady.by.user Mike Kinney

Saved on

compared with

New Version 4

changes.mady.by.user Mike Kinney

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Download and configure PuTTY (provides SSL connection to AWS instance).
  2. Create ODBC connection to postgres
  3. Install the data edit tool and run it using Access.

...

Configure Putty

Download PuTTY from http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

...

The actual SELVeditor tool is an Access Database configured to connect to the open_lmis database and manipulate the data collection tables.  You only have to configure everyone once, so running it is simpler.

  1. Run PuTTY
    1. Select the correct configuration that you saved above
    .Select Open
    2. Select Load
    3. Select Open
    4. The following window will open and you can just minimize it.  It's important to NOT do anything in the window.
      Image Added
  2. Load the Access Database - SELVeditor
    1. The system will remind you to run PuTTY.  Click the initialize button.
      Image Added

You can now use the Data Edit tool to change distribution data.  Note, that information is changed immediately in the production database with no record of the change.  Be very careful with this tool.