ICIS 5.4
From ICISWiki
Contents |
ICIS 5.4 New Features
Database change
DMS
- Study
SNAME - length increased to 50
ACCESS: ALTER TABLE STUDY ALTER SNAME TEXT(50) POSTGRESQL: ALTER TABLE STUDY ALTER SNAME TYPE VARCHAR(50) ORACLE: ALTER TABLE STUDY MODIFY SNAME VARCHAR2(50)
USERID Long - additional field
ACCESS: ALTER TABLE STUDY ADD USERID LONG POSTGRESQL: ALTER TABLE STUDY ADD COLUMN USERID BIGINT ORACLE: ALTER TABLE STUDY ADD USERID NUMBER(11)
- SCALETAB
Field called "SQL" is renamed to SSQL because "SQL" is a reserved word as of MySQL v5.0. More info here: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
GMS
- NAMES
NVAL - length increased to 255
- LISTDATA
DESIG - length increased to 255 GRPNAME - length increased to 255
- UDFLDS
FCODE - length increased to 50
IMS
For barcode generation, IMS_LABELINFO and IMS_LABEL_OTHERINFO tables should be added
Create Table IMS_LABELINFO (ID integer, LABELINFO_ID integer, GROUP_PREFIX char(50), LABELITEMCOUNT integer );
Create Table IMS_LABEL_OTHERINFO (ID integer, OTHERINFO_ID integer, LABELINFO_ID integer, GROUP_PREFIX char(50),
TABLENAME char(50), FIELDNAME char(50), FOREIGN_FIELDNAME char(50));
GEMS
- added module
ICIS32 DLL
Data structure
GMS_LISTDATA_DESIG 256 // 255 is used in the database GMS_LISTDATA_GRPNM 256 // 255 is used in the database GMS_UDFDLS_FCODE 52 // 50 is used
DMS_STUDY_NAME 52 DMS_STUDY_TITLE 256 DMS_STUDY_STYPE 4
- typedef struct {
- LONG STUDYID;
- CHAR SNAME[DMS_STUDY_NAME];
- LONG PMKEY;
- CHAR TITLE[DMS_STUDY_TITLE];
- LONG INVESTID;
- CHAR STYPE[DMS_STUDY_STYPE];
- LONG SDATE;
- LONG EDATE;
- LONG USERID;
- } DMS_STUDY;
Functions
- GMS_getMgmntNeighbor(LONG mgid, GMS_Germplasm *data, GMS_Name *name, LPSTR szName, LONG nszName, LONG fopt);
- GMS_getDerivativeNeighbor(LONG gid, LONG lngMStep,LONG lngNStep,LONG *idList,LONG *idLstSz, LONG blnDH);
- GEMS_openDatabase(LPCSTR szIniFile);
- GEMS_autoCommit(BOOL autoCommit);
- GEMS_commitData(void);
- GEMS_closeDatabase(void);
- GEMS_getGemsMID(GEMS_INFO *data, int fOpt);
- GEMS_getGemsMVID(GEMS_INFO *data, int fOpt);
- GEMS_getMaxID(CHAR *szTblName, CHAR *szFieldName);
- GEMS_addGEMSName(GEMS_NAME *recName);
- GEMS_addMD(GEMS_MARKER_DETECTOR *recTblMD );
- GEMS_getPdComp(PD_COMP_INFO *pdCompInfo, LONG fopt);
- GEMS_addPdComp(GEMS_PD_COMP *recTblPdComp );
- GEMS_getProtocolID(GEMS_INFO *recProcInfo , LONG fopt);
- GEMS_findPID(PROP_INFO *PropInfo) ;
- GEMS_findPropid(GEMS_PROP *recTblProp);
- GEMS_findMethod( GEMS_METHOD *recTblMethod);
- GEMS_addMethod(GEMS_METHOD *tblMethod) ;
- GEMS_findScale(GEMS_SCALE *tblScale);
- GEMS_addScale(GEMS_SCALE *tblScale) ;
- GEMS_findPdid(GEMS_PD *tblPd);
- GEMS_addLocus(GEMS_LOCUS *tblLocus);
- GEMS_getNameID(GEMS_INFO *data);
- GEMS_getAlleleID( GEMS_INFO *recNameInfo, LONG fopt) ;
- IMS_geLabelOtherInfo(IMS_LABEL_OTHERINFO *data, long fSearchOption );
- IMS_geLabelInfo(IMS_LABELINFO *data, long fSearchOption );
Launcher
- New skin color. Uses the image files stored in Exes\image folder
GMS Search
- Expand All Button - when click, the full pedigree tree is shown. Then it toggles to Collapse All button
- Search by Attribute
- Management Neighborhood
- Derivative Neighborhood
- Export data of selected GID to MS Word
- Close All Button on View Characteristics Window
- Missing bottom part of window on diffrent screen resolutions now solved
- Data now copy-able through Copy-Paste function
SetGen
Lists/Form Improvement
Focus on TextBoxes/Buttons in Forms and Tab-ordering are improved
Added the use of hourglass cursor during "busy" time for several functions
Improved caption of forms by including CropName specified in INI file
LIST or FOLDER name always unique.
Default width of List Selector can now be set in INI file (INI key is LIST_PANEL_WIDTH=n)
Extra possibilities for navigating in Lists
- Uniformity for both stand-alone and SetGen GMS Search windows
- Added Shortcut text/keys
- Sorts tree lists - folders first then lists in alphabetical order
- Go to end of list upon adding of new entry
Batch Processes
Made layout of Matrix Crossing tool uniform to Bx, B- forms
Extended checks for Batch (Bx, B-) "DMS VARIABLE SELECTION PARAMETERS"
Added Title information when STUDY-dropdown box in (B-, Bx, B+) forms change
Improve opening position (location) of several forms
Added leading zeros in designation names. In INI file, the key-value is STANDARDIZE=NO.
Fill Withs...
Extension of menu-options in "Fill Column with " (for EntryCode, Source, Extra columns) in the ff: Fill with GID-Female/Source Information Fill with GID-Male/Source Information Fill with Cross Information Fill with Management Group Information
MTA
InTrack
- Importing from an Excel File
- Barcode Label Printing
- Mangement Neighborhood
- Derivative Neighborhood
- Fill-up an Extra Column With DMS Variables
- Pop-up Window for Non-existent Lots
- Emailing Administrator for Seed Requests
- Show/Hide Some SetGen Lists
Workbook
ICIS Retriever
- ICIS databases that are in MS Access are now automatically linked using the information stored in the Registry
- RTV Menus are added in the MS Access main menu
- New form for retrieving the GMS information. Any table or query produced by any of the RTV queries (Main, Sub, Aggregate) can be used as input to the form provided it has GID column. The form is shown by going to the Retrieve->GMS Information
- New form for retrieving inventory information. The form is shown by going to the Retrieve->Inventory Information
- New form for retrieving environmental information. The information to retrieve is configurable and the traits are stored in RTV-LOCATION table. The form is shown by going to the Retrieve->Environmental Information
- The form for retrieving a GMS list is modified. List folder can be specified. It also has options to retrieve the management and derivative neighborhood of the entries in the list
- Any active table or query can now be saved as IRRISTAT Excel or GMS List
- The Peditree application is integrated by creating Pedigree and Traits tables that will be used by the Peditree application. Those tables are populated based on a selected GMS List.
Installation Diagnostic Tool
Go to TDM ICIS Application Programs 5.4 > Installation Diagnostic Tool: What's New in Version 5.4
Data Validation Tool
Go to TDM ICIS Application Programs 5.4 > Data Validation Tool: What's New in Version 5.4
