From ICISWiki

Contents 1 DMS Uploader (Alpha Release) 1.1 Setup 1.1.1 Requirements 1.1.2 Password Login Screen 1.1.3 Forms screen 1.2 Main Menu 1.2.1 Link to Databases

DMS Uploader (Alpha Release)

DMS Uploader Tool helps ICIS administrators load studies from their local DMS to the Central DMS.  This tool is developed in MS Access, and simply allows the user to connect to their local and central DMS databaases, choose which studies they would like to upload and then executes the SQL queries to complete the task.  The only exisiting release is an alpha release however, so it takes some playing around to set it up.

Setup

Requirements

• MS Access must be installed on the Administrator's machine
• Administrator must ensure they know which local database they are linking to (DMS Uploader does not use the ICIS.ini file to connect to databases)

Password Login Screen

• the password to login is sici (icis backwards)

Forms screen

• In MS Access, navigate to the forms section, choose frmUploadDMS and open it.

Main Menu

Link to Databases

• Administrator can connect to MS Access local and central databases by clicking on the Link Access button on the main menu.
• For databases in MySQL (other types of databases have not yet been tested but may work), the Administrator will need to manually link the tables from the Local and Central DMS (instructions are for MS Access 2007; other versions may have different ways to accomplish the same tasks):
  1. Click on the External Data
  2. Choose to link the data source to the existing database
  3. Under the Machine Data Sourcetab, find the DSN name for the local DMS (may need to check the ICIS.ini file for this)
  4. On the Link Tables form, the administrator should click Select All
  5. A series of forms may now appear, asking for the administrator to Select Unique Record Identifier. The administrator should just click OK without making a choice (choosing a primary key can cause problems during the execution of the SQL queries)
• Repeat steps 1-5 to link the Central DMS