Planning workshop for ICIS standalone Nov 2009 IRRI

From ICISWiki

Jump to: navigation, search

Nov 10-11, 2009.

Participants: Warren Constantino, Vivay Salazar, Ching Habito, Edward Legaspi, Dec Arreza.

Contents

Minutes of the meeting (Topics covered)

Testing and Quality Assurance

1. Presentation of current standard software testing forms for ICIS "Black Box" (using ICIS Breeders' Course materials) and "White Box" testing [c/o Vivay]
2. Modification of template software testing forms (Black Box, White Box) [c/o ICIS team]
a) Naming convention for documents follows the black box id/ white box id:
Black box (example): B2009-CH3-001
Format: BYYYY-<Chapter in ICIS Breeding Course materials>-<Sequential number>
White box (example): W2009-WBK-001
Format: WYYYY-<ICIS Application>-<Sequential number>
b) In the Black Box document, the corresponding White Box document (i.e. containing bug report) ID must be specified (under "Comments") if a test step FAILED.
c) A White Box document requires a Cropforge Bug Report ID. File a Cropforge Bug first, fill up the White Box document with the system-generated Cropforge Bug ID, then upload the White Box document (PDF version) as an attachment of the Cropforge Bug.
3. Creation of new section in ICISwiki for Black Box and White Box testing documentation [c/o Vivay]

The CHANGES.txt file

Every ICIS application has its own CHANGES.txt file.
For better readability and inclusion of images/screenshots and hyperlinks, it has been proposed to release the CHANGES file as an HTML document instead.


Documentation

1. Developers' Documentation (ICISWiki)
Per application:
  • INI keys (general list)
  • Tables (general list)
  • DLL functions used
  • Functionality
1. Flowchart/pseudocode
2. INI key(s)
3. Menu / Interface
4. Table(s) & DLL(s)
5. Miscellaneous (i.e. font, SMTA templates, Delphi add-ons)
2. Users' Workflow (ICIS webpage (new: under construction))
Examples:
  • ICIS Breeders' Training Course
3. Application Help File
(per control: F1 key)
  • SetGen
  • GMSSearch
  • Workbook

GCP Phenotypic Data Input Tool

[c/o Dec]

  • By request, ICIS factors are labeled as "Trait", ICIS variates are labeled as "Variable". Initially factors were labeled as "independent variables" and variates as "dependent variables".
  • Every text box has a "data-picker button" which allows the user to click the worksheet cell(s) to be placed in particular text boxes. No copy-pasting (therefore typographical errors are minimized).
  • Dropdown lists are also available for storing discrete values for textual data.

ICIS Lite

  • Barcode generation [c/o Dec]
  • Lookup seedlot using designation [c/o Warren]
  • List of valid values made available to the user (response speed can still be improved using warehouse tables).
  • Requirement for INGER: find out which seedlots are empty or not
Suggestions for Lookup Entry form:
a) Sort by GID (i.e.to group together locations with empty/non-empty seedlots).
b) Show balance to see which non-empty seedlots can be added to.
Overview of ICIS Lite (using ICIS Breeding Course workflow) [c/o Warren]

ICIS Mobile

  • Create Worbook template first on PC: setup factors, variates
  • Uploading of workbook template to mobile/handheld device: via XML file
  • 4 buttons in System Menu
1) Initialize Database: database (MSSQL) on mobile device needs to be initialized
2) Load study: loads the study from the mobile database
  • At the moment, only supports one study-one dataset case. Needs to be extended to support multiple datasets in one study.
3) Save for download
  • Observed traits (i.e. variates) are passed from the mobile device to the PC/desktop via a text (comma delimited) file
4) Exit


Upload Tool

(component of ICIS Administrator's Tool) [c/o Edward]

  • Developed using MS Access: application acts as a middleman between the local and central database. 
  • Only supports local-MS-Access-to-central-MS-Access uploading at the moment (input parameter: MDB file).
  • Temporary tables are created
  • Maximum IDs are retrieved from the central database; data from the local are assigned positive IDs upon uploading to central
  • Data validation checks will be introduced (SQLs will be XML-based)
  • For re-development in Java (but not top priority)


Workplan Management

  • Read individual workplans (Excel: Gantt chart) with hierarchical structure (i.e. tasks with sub-tasks)
  • JavaScripts convert Excel workplan to XML format
  • Dynamic HTML page is generated via CSS (can filter by day,week,month,quarter)
  • Who can view the workplans? ICIS team only? CRIL only? CRIL + collaborators?


Setgen& GMSSearch

[c/o Ching]

  • Overview
  • Changes
Personal tools