From ICISWiki

Contents 1 Setup 1.1 Installation Diagnostic Tool 5.5.1 1.2 GMS Search 5.5.1 1.2.1 Search for name "APO" 1.2.2 Expand pedigree tree (Expand All) for "APO" 1.3 Browse 5.5.1 1.3.1 Enter search string "IR8" 1.3.2 Command string: Display GMS data for GID 675472 1.3.3 Command string: List close relatives of GID 675472 1.3.4 Command string: Display all group relatives of GID 675472 1.4 ICISWorkbook 5.5.1 1.4.1 STUDY Menu 1.4.1.1 Study --> Convert Excel file 1.4.1.2 Study --> Template from database 1.4.1.3 Study --> Retrieve: Factors & Variates 1.4.1.4 Study --> Retrieve: Dataset 1.4.2 ADD-INS Menu 1.4.2.1 Add-Ins --> Import data from Setgen 1.4.3 GMS Menu 1.4.3.1 GMS --> Get Unique Sample ID 1.4.3.2 GMS --> Get Species 1.4.3.3 GMS --> Get Origin

Setup

The following items are results of ICIS application tests using an IRIS central (GMS, DMS, GEMS) database in PostgreSQL. Local databases are in MS Access.

ICIS Schema version: 5.5

Installation Diagnostic Tool 5.5.1

GMS Search 5.5.1

Search for name "APO"

Expand pedigree tree (Expand All) for "APO"

Browse 5.5.1

Enter search string "IR8"

 ENTER SEARCH OR COMMAND STRING (.HLP=HELP, ./END)
IR8

Command string: Display GMS data for GID 675472

 ENTER SEARCH OR COMMAND STRING (.HLP=HELP, ./END)
.GID 675472

Command string: List close relatives of GID 675472

 ENTER SEARCH OR COMMAND STRING (.HLP=HELP, ./END)
.REL 675472

Command string: Display all group relatives of GID 675472

 ENTER SEARCH OR COMMAND STRING (.HLP=HELP, ./END)
.GRP 675472

ICISWorkbook 5.5.1

STUDY Menu

Study --> Convert Excel file

Study --> Template from database

Settings: List studies from local AND central databases; select study "1990WS-CHA"

Study --> Retrieve: Factors & Variates

Study --> Retrieve: Dataset

ADD-INS Menu

Add-Ins --> Import data from Setgen

SetGen list name: 1980-001

GMS Menu

GMS --> Get Unique Sample ID

GMS --> Get Species

GMS --> Get Origin